StrataFrame Forum / Enterprise Server / How do I?

Enterprise Server in OLTP environments, high loads

Emre Ozer — Thu, 17 Apr 2008 02:28:00 GMT

Hi,

Can anyone share their experiences with Enterprise Server in OLTP environments?

How does ES behave under high loads, heavy use of transactions?

Does ES forward transactions accurately with hardware NLBs?

Thanks already for any feedback.

Regards,

Emre

Any ideas on cause of this error?

Greg McGuffey — Fri, 11 Jan 2008 10:04:41 GMT

I have a user that is intermittently getting this error. The error occurs when doing various tasks. I'm pretty sure there is a problem with his machine or connection (though others within the same network are not having this problem). I just have no idea what could be causing it... :blush: Any help would be appreciated.

Here is the exception:
[quote]IOException
Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
SocketException
An established connection was aborted by the software in your host machine

Source : System

Stack Trace:
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.ConnectStream.InternalWrite(Boolean async, Byte[] buffer, Int32 offset, Int32 size, AsyncCallback callback, Object state)
at System.Net.ConnectStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.SendRequestCore(BaseParams Params, RemoteDataSourceCommand Command)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.b(DbCommand A_0, Boolean A_1, String A_2)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.ExecuteScalar(DbCommand Command)
at MicroFour.StrataFrame.Business.BusinessLayer.ExecuteScalar(DbCommand CommandToExecute)

[gpm] from here up is common in all cases...the lines below depend on what he was trying to do...

at FOXSystems.RAMS.BusinessObjects.Project.AlternateOutlineBO.GetProjectIDByID(Int32 altOutlineID)
at FOXSystems.RAMS.Shared.DataTreeProviders.AlternateOutlineProvider.set_AlternateOutlineID(Int32 value)
at FOXSystems.RAMS.Testing.TestFunctionForm..ctor(Int32 projectID)
...etc.[/quote]

How to ensure that install uses the latest .net redistributable

Greg McGuffey — Thu, 13 Dec 2007 09:52:12 GMT

I'm fighting a proxy issue and in investigating that, I realized that the .net framework I'm distributing with the app isn't even close to being the same I'm developing against. Searched the web to attempt to get the latest and that was...er...more confusing.

-My ClickOnce install is using 2.0.50727.42, from september 23, 2005 (build off the machine with a much newer version).
-The redistributable on the web is dated 1/22/2006 ([url]http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en[/url])
-The dlls on my machine are 2.0.50727.832, dated april 13 2007, I'm assuming updated with VS sp1.

Anyone have any ideas about this?

How does ES handle proxy servers?

Greg McGuffey — Wed, 07 Nov 2007 18:53:58 GMT

What happens, if the user of an application that is using ES, has a proxy server between them and the ES server? How is this handled?

I have a user who can't connect and thought (give his situation) this would be the first thing to look into.

Question on ES Server machine configuration

Stephen M. Klump — Tue, 02 Oct 2007 07:50:28 GMT

We are recommending the purchase of Enterprise Server (2 licenses) to one of our customers for use with their StrataFrame-based .Net application.

Our question pertains to hardware resources required for the Enterprise Server box.

This customer typically has about 200 concurrent connections for the application at any given time.

I understand that Micro4 supports thousands of connections with Enterprise Server for their own customers, so I would think you would have some good metrics on machine resources required.

I would like to get on a phone call with a technical rep. to discuss this. Could you please give me a phone number to call and a time so that I can discuss this with you?

Thank you.

Steve

Does ES support DB2?

Keith Chisarik — Tue, 25 Sep 2007 22:55:53 GMT

I have a new project that will need to run at my clients multiple office locations, currently they use thin clients via a VPN, but I don't think I want to rely on it. Will ES work here for a Winform application using DB2 on OS/400 on the backend?

Thanks.

Some questions that relate to ES

Ben Hayat — Thu, 24 May 2007 19:00:49 GMT

After the training class, I met with a client and told him about the ES in more detail and we have decided to split the project into two sections: a) WinForm b) WebForm.

a) The winform is responsible to allow the employees in different cities to create new records. These employees will be connected to the main Database via ES. The employee will be entering text data and taking images of objects and maybe, small videos per record.

b) The Webform is responsible to show those data and pictures and videos from the server to public who serf the web via bowser.

Questions:
a) Since the images are ultimately going to be consumed by webserver, should each image be stored as a single file or should it be stored in database as BLOB field?
a1) If stored as BLOB field, at the time of showing it on the web, does it need to be converted into a single image file for Webserver to use it?
a2) If the images is stored as single file to begin with, will ES stream the image from the client to the server and store it for me?

b) The second part is, if the user with Winform, records a video clip, can the video clip get transfered to the server via ES?

I guess my main question here is, can ES provide service to get images and videos from client to the server with WinForm?

Once you answer, then I'll follow a few more questions depending on the answer.
Thanks!

How do you tell if ES is running?

Greg McGuffey — Wed, 04 Apr 2007 18:34:50 GMT

I've got ES installed (I think). I have the data sources set. Web.config is set. I've restarted IIS. How do I tell if the derned thing is working? I tried updating my client to use it, but it says that is can't find the server. I'm thinking I need to see if it is running first. Do I have to turn it on (I wouldn't think so...but...)?

References to ES

Greg McGuffey — Wed, 04 Apr 2007 18:17:07 GMT

My app is broken into several assemblies. I'm sure I need to set a reference to the Enterprise (ES) namespace in my main EXE (were AppMain is and were the ES data source will be set). I'm pretty sure I'll need to set it in the assembly that contains my BOs. Any were else?

Clarification of which MAC address, and about domain for ES 2 CAL SDK license

Greg McGuffey — Wed, 04 Apr 2007 14:54:49 GMT

I'm about to install ES and give it a try. I'm hopeful this will solve a lot of issues. However, I have some questions! :hehe:

1. The MAC address is for which nic specifically. I.e. The computer I'm going to use it on has two nics and it sits behind a firewall, so there is also the firewall nic that the rest of the world interacts with. Which one?

2. So, the domain required is just the domain right (or the computer name or an IP), not the full path to were ES is installed, right? I.e. I install it at www.myapp.com/tools/es, then the domain I need is www.myapp.com, right?

3. I might have to install ES to a temporary server, then move it to another one (dedicated just to my app). How big of a pain is it going to be to invalidate the old license file and get a new license file? (I'm trying to just get the decidated machine now, but...)

Thanks!

ES Documentation

Larry Caylor — Tue, 13 Mar 2007 13:02:41 GMT

Looking at the SF help file, I find that it doesn’t really contain any information installing ES or configuring an application to use it. I’ve got as far as installing the ES server on at test machine and activating a development license. However when I go to download the license file, I receive an error (see attached). Is there some more detailed documentation of ES?

-Larry

How can I evaluate ES?

Greg McGuffey — Mon, 12 Mar 2007 13:17:14 GMT

I'm thinking that ES will solve a bunch of problems I'm facing. Many of them are related to the use of a VPN to access the database over all sorts of interesting (read slow and unreliable) connections.

However, before I recommend this to the execs, I need to actually test it. I need to install it and access it remotely and compare the access times to those of using the VPN.

I know the SDK is included with SF, but I'm not clear how to test it.

- Can I do initial testing all locally as it stands now (i.e. single user testing locally, just to see if the code works)
- Do you have a special trial license available?

Thanks!

Synchronization from remote client

Larry Tucker — Wed, 21 Feb 2007 06:19:21 GMT

ES apparently allows a remote client to access data via HTTP, then run disconnected from the central database. So, I assume a salesperson could pull down a customer list on his or her laptop and work on it without further internet connection.

My question is what kind of support does ES offer for synchronizing any changes made to the data once an internet connection is re-established?

For example, if the salesperson changes a customer's phone number while working disconnected, how does this new phone number get applied to the main database when the salesperson reconnects to the internet?

Are the synchronization tools built in to ES, or would I have to write it all by hand? At reconnection, is there an opportunity to open both the local and the central (ES) tables simultaneously and do the needed comparison and updates?

TIA,

Larry