StrataFrame Forum / Enterprise Server / Issues

Independent Security Audits

Deen Core — Wed, 24 Feb 2010 14:45:01 GMT

I would like to know if there have been any independent third-party security audits of the Enterprise Server. If so, can you point me to the results?

Thanks!
Deen

Parameterized Store Procedures Failing

Jeff Pagley — Fri, 29 Jan 2010 07:21:12 GMT

Hi SF Team,

I have just setup ES on a server and I began to do some testing. The code (below) has been running for a couple of years on a local production server with a SQLExpress database, but when this same code (below) runs connecting through ES, I am getting an error (see below). This piece of code is using a BO to run a parameterized stored procedure. I am getting the same error when running other BOs using parameterized stored procredures. It seems this error is associated with the BO.FillByStoredProcedure method. What is going on?

Thanks,

Jeff

Public Sub FillByCallBackTop1ByCampaignIDAndUserIDAndDateRange(ByVal campaignID As Integer, ByVal userID As Integer, _

ByVal startDate As Date, ByVal endDate As Date, ByVal campaignMaximumCallTries As Integer)

Dim parms(4) As SqlParameter

parms(0) = New SqlParameter("@CampaignID", SqlDbType.Int)

parms(0).Value = campaignID

parms(1) = New SqlParameter("@UserID", SqlDbType.Int)

parms(1).Value = userID

parms(2) = New SqlParameter("@StartDate", SqlDbType.SmallDateTime)

parms(2).Value = startDate

parms(3) = New SqlParameter("@EndDate", SqlDbType.SmallDateTime)

parms(3).Value = endDate

parms(4) = New SqlParameter("@CampaignMaximumCallTries", SqlDbType.SmallInt)

parms(4).Value = campaignMaximumCallTries

Me.FillByStoredProcedure("CampaignContactsView_CallBack_Top_ByCampaignIDUserIDStartEndDate_Select", parms)

End Sub

=========================================================================================

Exception (EnterpriseDataSourceException)

Message = "An error occurred while executing the command on the remote data source. See the inner exception for more details."

InnerException (SqlException): Source=".Net SqlClient Data Provider"; Target=null; Tag=null; Class=16; LineNumber=0; Number=201; Server="TESTSERVER\SQLEXPRESS"; State=4; ErrorCode=-2146232060;

Message = "Procedure or Function 'CampaignContactsView_CallBack_Top1_ByCampaignIDUserIDStartEndDate_Select' expects parameter '@CampaignID', which was not supplied."

StackTrace =

" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior ... (truncated) ...xecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.Enterprise.RequestProcessor.ExecuteDataTable(ExecuteDataTableParams params)"

Errors (SqlErrorCollection): Count=1;

#0 = {System.Data.SqlClient.SqlError: Procedure or Function 'CampaignContactsView_CallBack_Top1_ByCampaignIDUserIDStartEndDate_Select' expects parameter '@CampaignID', which was not supplied.}

Procedure = "CampaignContactsView_CallBack_Top1_ByCampaignIDUserIDStartEndDate_Select"

Environment: ThreadIdentity="" DateTime=["2010-01-29 07:53:48.537"] ThreadName=null WindowsIdentity="STRUSS\JPagley" ThreadId="10" DomainName="ProspectHelper.vshost.exe" OSVersion=["Microsoft Windows NT 5.1.2600 Service Pack 3"]

MachineName="1LPJPAGLEY" UserName="JPagley"

The remote server returned an error: (500) Internal Server Error.

Jeff Pagley — Sat, 16 Jan 2010 14:01:43 GMT

Hi SF Team,

I know it is Saturday, but I am trying to setup Enterprise Server to test. I have taken the time to read several posts on the forum to resolve this error, but to no avail and I am lost. One thing is I can successfully load the test website's default.htm page to make sure the site is up and running. One of the posts suggest to test to see if ES is running by trying to access the status.aspx page. I attempted to do this and I get this Server Error page:

Server Error in '/ES' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'InstantASP.Common' or one of its dependencies. The system cannot find the file specified. (C:\Inetpub\wwwroot\web.config line 80)

Source Error:

Line 78: <httpModules> Line 79: <!-- HttpModule used to manage user authentication -->Line 80: <add type="InstantASP.Common.HttpModule.SecurityModule, InstantASP.Common" name="SecurityModule"/>Line 81: <!-- HttpModule used to perform dynamic URL rewriting -->Line 82: <add type="InstantASP.Common.HttpModule.RewriterModule, InstantASP.Common" name="RewriterModule"/>

Source File: C:\Inetpub\wwwroot\web.config Line: 80

Version Information: Microsoft .NET Framework Version:2.0.50727.1873; ASP.NET Version:2.0.50727.1433

Before I go into anymore detail, I figure I need to make sure I can successfully load this page before anything else will start to work. What is the problem?

Thanks,

Jeff

ES Server and RemoteDatasourceKey Questions

Richard Keller — Thu, 07 Jan 2010 17:29:41 GMT

Hi guys,

Let me know if this would work. I have a single application that wants to switch databases on the ES Server side. If I have Multiplae DataSourceConnections like the sample below, should I just be able to change the RemoteDataSourceKey in the call without any other modifactions? Second if I'm adding ConnectionStrings does this read in real time or is it populated on the start of the server. Basically I would need to know if the Server is caching this configure or I could add Databases on the fly.

I ask the first question because I get an error if I use the DEV2 sample otherwise the MultiShip works fine. The second would be for administration and deployment.

Thanks,

Rich

Sample:

<?xml version="1.0" encoding="utf-8" ?>

<DataSources>
<DataSource DataSourceKey="MultiShip">
<ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip;</ConnectionString>
<TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
<TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
<TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
<TypeAssemblyCulture>neutral</TypeAssemblyCulture>
<TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
<IsEncrypted>True</IsEncrypted>
<IsCompressed>True</IsCompressed>
<EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
<EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
<TransactionTimeout>3600</TransactionTimeout>
</DataSource>
<DataSource DataSourceKey="">
<ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip3;</ConnectionString>
<TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
<TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
<TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
<TypeAssemblyCulture>neutral</TypeAssemblyCulture>
<TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
<IsEncrypted>True</IsEncrypted>
<IsCompressed>True</IsCompressed>
<EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
<EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
<TransactionTimeout>3600</TransactionTimeout>
</DataSource>
<DataSource DataSourceKey="Dev2">
<ConnectionString>server=localhost;Integrated Security=SSPI;Database=RZMultiShip2;</ConnectionString>
<TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>
<TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>
<TypeAssemblyVersion>1.7.0.0</TypeAssemblyVersion>
<TypeAssemblyCulture>neutral</TypeAssemblyCulture>
<TypeAssemblyPublicToken>99fe9917f71608a7</TypeAssemblyPublicToken>
<IsEncrypted>True</IsEncrypted>
<IsCompressed>True</IsCompressed>
<EncryptionKey>151, 123, 237, 154, 69, 13, 132, 130, 233, 174, 208, 232, 85, 162, 40, 169, 161, 0, 140, 40, 47, 163, 98, 73</EncryptionKey>
<EncryptionVector>133, 78, 229, 207, 101, 227, 102, 225</EncryptionVector>
<TransactionTimeout>3600</TransactionTimeout>
</DataSource>
</DataSources>

Why in God's name is the focus on the priority spin button when you run edit a script in the DDT?????????

William John Tello — Thu, 24 Sep 2009 14:49:06 GMT

Why in God's name is the focus on the priority spin button when you run edit a script in the DDT?????????

For those of us with mouse wheels, we change the priority of a script without even realizing we have done so, which leads to other potential errors when running the DDT to update our database. More than one of us where I work has been bitten by this and in my opinion, this is something you guys should jump on fixing. :Wow:

Best Regards,
Bill T.

ChildFormDialog and BO translations

Sean P Kelly — Fri, 04 Sep 2009 13:46:48 GMT

Here is the short version of my problem:

I have several maintenance screens in my project.
I have a set of BOs where there is a parent child relationship.
For ease of reading. I have BudgetBO (parent), ItemBO (child), and AmountBO (grandchild). On the parent maintenance form I have a parent BO and child BO.
If the user attempts to edit a child record, a ChildFormDialog passes the childBO to the Item (child) maintenance form. On that form, I have a child BO and a grandchild BO with the parent/child relationship defined at design time. However, unless I have a grandchild BO on the parent form, and use the BO translator to pass both the child and grandchild BOs, the grandchild's ParentBusinessObject property is always Nothing.

More drawn out version:

Parent-child relationship:
BudgetBO.budget_pk <-> ItemBO.item_budget_pk

Child-grandchild relationship:
ItemBO.item_pk <-> AmountBO.amt_item_pk

On my budget maintenance screen, I have instances of BudgetBO and ItemBO.
On my item maintenance screen, I have instances of ItemBO and AmountBO.

The parent/child relationships are set at design time in both the BOs themselves and in their particular instances on the forms.

In the budget maintenance screen (parent BO), if the user edits an Item, I have a ChildFormDialog that uses the BO Translator to pass ItemBO to the child maintenance form. However, the parentbusinessobject property of the grandchild BO instance, AmountBO1, is not being set to ItemBO1 at Form_Load of the child form.

If I put parent, child, and grandchild BOs on the parent maintenance form, and use the BO translator to pass the child and grandchildBOs to the child maintenance form, it appears that the relationship between child and grandchild is in tact at Form_Load.

Question:

Is this a problem with the BO translator? Is it expected that I would put all three BOs on the parent form? Should I set the ParentBusinessObject property in code at the Form_Load of the child form?

Thanks for your time.

Sean Kelly
County of Santa Cruz

Error after 1.7 upgrade on ES server.

Scott Bressette — Tue, 04 Aug 2009 15:17:06 GMT

I upgraded the server both using the .zip file and reinstalling using the setup package and when I check the Status.aspx I get the error below. It seems something is still using the 1.6 version.

Server Error in '/' Application.
--------------------------------------------------------------------------------

The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.TypeLoadException: The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[TypeLoadException: The type [MicroFour.StrataFrame.Data.SqlDataSourceItem, MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7] could not be resolved.]
MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource..cctor() +1235

[TypeInitializationException: The type initializer for 'MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource' threw an exception.]
MicroFour.StrataFrame.Enterprise.Server.Status.Status_PreInit(Object sender, EventArgs e) +51
System.Web.UI.Page.OnPreInit(EventArgs e) +8694814
System.Web.UI.Page.PerformPreInit() +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

ES error: EndOfStreamException

Greg McGuffey — Thu, 23 Jul 2009 11:47:46 GMT

I received an ES error (via email) of an [quote]EndOfStreamException: Unable to read beyond end of stream.[/quote]

There must be some field that I haven't configured correctly...any ideas?

Error after updating server.

Keith Chisarik — Mon, 06 Jul 2009 09:28:57 GMT

I get this error after updating the server via the zip file, I preserved my config files and users can connect and read data, but this error occurs on any attempt to update. I can reproduce in house and I have the latest SF build installed, the version of Enterprise Client.dll I have is 1.6.6.9

An error occurred while rebuilding the command on the remote data source.

xxx.xxx.xxx.xxx

EnterpriseDataSourceException
An error occurred while rebuilding the command on the remote data source.
FormatException
String was not recognized as a valid DateTime.

Source : MicroFour StrataFrame Enterprise

Stack Trace:
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at MicroFour.StrataFrame.Data.Enterprise.DbParameterDescriptor.ᜀ(BinaryReader A_0)
at MicroFour.StrataFrame.Data.Enterprise.DbCommandDescriptor.ᜀ(BinaryReader A_0)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteNonQueryParams.ReadDataFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteNonQueryParams.CreateFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ProcessRequest(HttpContext context)

Click Once SQL 2008 SMO objects

Robert Green — Mon, 18 May 2009 05:11:32 GMT

We have recently moved to VS2008 and SQL 2008 from VS2005 and SQL 2005.

I have a problem when we deploy our click once application, the following message is displayed

Unable to install or run the application. The application requires that assembly Microsoft.SqlServer.Dmf Version 10.0.0.0 be installed in the Global Assembly Cache (GAC) first.

The assembly is included in the deployment files, but as far as I am aware Click Once cannot deploy directly to the GAC. The issue seems to stem from the Microsoft.SqlServer.Smo assembly which is referenced in the Strataframe DBEngine and UI assemblies. Our application does not reference any SQLServer assemblies directly.

Do you have any ideas on how we can deploy these assemblies through click once?

404 Error

Larry Caylor — Tue, 10 Mar 2009 13:19:18 GMT

I've has to set up a new ES server since our current server failed. I've installed ES, created and download an new license file, set up the datasource and web config fiels but when I try to access the ES Status page from the ES server I get "The page cannot be found Error". Any idea of what could be causing the problem. The ES server is also not sending any error emails.

-Larry

StrataFrame Betas: To Install, or Not To Install. That is the Question!

Alex Luyando — Wed, 04 Feb 2009 07:38:56 GMT

Hi all -

I've read many postings about how stable the StrataFrame betas are and how MicroFour uses the betas when working on their production medical software before the betas even get posted for the rest of us. From the little experience I've had thus far with the betas they certainly do appear stable and perform as advertised.

Still, I'd like to see some comments from folks both in and out of MF regarding how quickly or slowly everyone installs the betas. Among the questions/thoughts I have are the following, although please do not limit the discussion to just these topics.

- For those in a multi-developer shop supporting internal applications, what are the benefits and risks of early use of SF betas?

- In the above environment, how do people handle situations where you've updated to a SF beta, and then need to get a production patch out? Do you maintain a separate development environment with the prior (perhaps production) StrataFrame release to handle production bug fixes?

- For the early adapters among us, has there been "gotchas" from time-to-time that made the early installation of the betas less than ideal.

- For the early adapters among us, has there been times where it turned out to be significantly better to have installed the beta as it resolved some prior bug or provided improved functionality that significantly reduced development time?

I think our shop needs to determine a policy for all StrataFrame developers to either upgrade to the latest beta pretty much as they come out, or just stick to "production" StrataFrame releases. This has been sparked by what I believe to be the well-documented change to the BOs FieldPropertyDescriptors which seems to cause an application we have to work on one developer's workstation but not the other. Either way, we need to pretty much march to the beat of the same drummer so comments on the above will be helpful, I'm sure.

Thanks.
________________
_____/ Regards,
____/ al

Issue with Time Zones

Scott Bressette — Thu, 29 Jan 2009 14:57:29 GMT

My Enterprise Server is sitting in Florida (Eastern Standard Time) and my QA team is in California (Pacific Time). They found if they make an appointment at noon, reload, it shows up at 9am. I checked the database in Florida and it believes the appointment as saved at noon Eastern Standard Time. Somehow, the point of saving and the point of loading the data is missing the time zones.

I’m very surprised no one else has had this problem or anything about it being mentioned in the manual. That usually makes me think I’ve missed something incredibly obvious. My fields are just standard SQL Server date/time fields. I think my issue comes from the fact that I use Stored Procedures to insert/update/delete rows. I suspect the values are beings set in California, shipped to Florida across the time zones and then saved there as if it happened in Florida. When it loads them back up, seems aware that it loaded them in Florida so it should change the values to Califorina time.

I could create some sort of off-set, time zone difference function for date fields way down in the guts of my app before it saves but there must be an easier way. Shouldn’t ES know that the client is in a different time zone and handle this in both directions? I would think the enterprise client would be able to help out too. Any ideas?

Slow display of default login screen via ES

Keith Chisarik — Tue, 20 Jan 2009 20:47:42 GMT

The initial login screen is taking about 10 seconds to display when connecting to the SQL Server via ES (over internet), after login the application is very responsive. Anything I can check?

Switching to local SQL displays the login almost instantly. I can see a small lag time but 10 seconds seems wrong. I have ES running under its own app pool and I have recycled and restarted it.

Thanks.

Some questions on ES Custom Serialization

Keith Chisarik — Sat, 20 Sep 2008 21:10:21 GMT

I have an application under development that will use ES. I have it up and running and everything is fine, great product. Beta and release wont be long now.

Now, part of this application includes storing scanned images as multi-page Tiff files. I have a varbinary field set up to store them, and I have decided to use the byte array method and simply translate the images as needed, my BO field property reflects this and returns byte() only. Out of this two questions if I may.

1) since the image data is not being serialized (or is ES doing it behind the scenes anyhow?), thus having the additional overhead, would I still benefit from turning on custom serialization versus the default? I am just worried about the image data, the rest of the app runs fine without it. Even the images are acceptable coming down from ES, but who wouldnt want 90% less coming down the wire (from help docs), right?

2) Does turning on custom serialization in any way effect how the data is stored and the ability to "flip the switch" to use ES or local access within the application? Right now I develop locally, and at the end of each day test what I have done by restoring the local SQL database to the ES server and running the new features/code. This product will also need to run run both locally and via ES depending on the client. My admittedly limited understanding of ES is that the data is transmitted as binary data and then reconstructed upon reaching the ES for commit to the ES database, having no actually effect on the stored data at all, correct?

If you think I might benefit from customized serialization... I am getting an error when I add this line to my appmain as described in the help file.

Code: MicroFour.StrataFrame.Data.Enterprise.RequestProcessor.UseCustomDataSerializer = True

Error: "RequestProcessor is not a member of Enterprise"

Thanks

Missing Method Exception

Douglas Riley — Wed, 01 Oct 2008 10:10:07 GMT

When I install my application on a client machine and attempt to run the program, I receive an error message:

Method Not Found: "Void MicroFour.StratFrame.Data.ConnectionManager.set_ConnectionFolderDataFolder(system,string)"

I am setting the ConnectionDataFolder location in the Program.cs file to my executable's directory just before calling the SetConnections method. Of course everything works fine on the development machine. Am I missing a reference or step in using the ConnectionDataFolder property?

Any help would be great! Thanks!

Doug

VFPOLEDB

Hugo R. Figueroa — Thu, 18 Sep 2008 11:08:14 GMT

Because other issues , I have reinstalled Strataframe (Twice)

After each reinstall, I have to Reinstall VFPOLEDB 9.2 because it stops working with stored procedures.

This server is not licensed to run on the requested hostname.

Keith Chisarik — Thu, 21 Aug 2008 00:28:42 GMT

I am trying to get ES up and runing under the developer SDK license, we have two projects that I think are a great fit for ES. The error I get (via email from the ES server) when trying to connect is below. The hostname listed in the account section matches the name in my EnterpriseDataSourceItem so I am not sure what is next. Can you see if there is a licensing problem? I downloaded the license file twice and installed it. Status.ASPX works and shows the client connected. One odd thing is the status page shows the server hostname as "Unknown", maybe that is the problem but I sure dont know how to fix. Thoughts appreciated.

Enterprise Server Error

Message:	This server is not licensed to run on the requested hostname.
Client IP:	71.230.148.15
Details:	Exception This server is not licensed to run on the requested hostname. Source : MicroFour StrataFrame Enterprise Server Stack Trace: at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ᜀ(String A_0) at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ProcessRequest(HttpContext context)

If System.IO.File.Exists("C:\EnableES.txt") Then

'-- Create the ES data source

Dim ds As New EnterpriseDataSourceItem("", _

"es.sigmaxxxx.com", 80, "ILA", _

New SqlDataSourceItem(""))

'-- Configure the compression and encryption (optional)

ds.IsCompressed = True

ds.IsEncrypted = True

ds.EncryptionKey = New Byte() {1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4}

ds.EncryptionVector = New Byte() {1, 2, 3, 4, 5, 6, 7, 8}

'simple error display for testing

Try

'-- Add the EnterpriseDataSourceItem

DataLayer.DataSources.Add(ds)

Catch ex As Exception

MsgBox(ex.ToString)

End Try

Else

The remote server returned an error: (404) Not Found.

Brian M O'neil — Fri, 22 Aug 2008 14:55:26 GMT

I'm posting a support issue that is already in progress via support@strataframe.net.

Hi. I'm evaluating a trial and going through the documentation to get the first WinForm VB.NET example working with ES. I'm getting the following exception:

The remote server returned an error: (404) Not Found.

on the following code:

Public Sub FillTop100()

Me.FillDataTable("SELECT TOP 100 * FROM Customers")

End Sub

The exception is as follows:

System.Net.WebException was unhandled by user code

Message="The remote server returned an error: (404) Not Found."

Source="System"

StackTrace:

at System.Net.HttpWebRequest.GetResponse() at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.SendRequestCore(BaseParams Params, RemoteDataSourceCommand Command) at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.ᜀ(DbCommand A_0, Boolean A_1, String A_2) at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification) at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement) at Tutorial_WinVB_1.CustomerBO.FillTop100() in C:\Projects\Strataframe\Tutorial_WinVB_1\Tutorial_WinVB_1\CustomerBO.vb:line 70 at Tutorial_WinVB_1.CustomerMaintenance.CustomerBO1_ParentFormLoading() in C:\Projects\Strataframe\Tutorial_WinVB_1\Tutorial_WinVB_1\CustomerMaintenance.vb:line 4 at MicroFour.StrataFrame.Business.BusinessLayer.raise_ParentFormLoading() at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects() at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.OnLoad(EventArgs e) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m) at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

InnerException:

Here is my SetDataSources() method:

Private Shared Sub SetDataSources()

'-- Create the data source

Dim ds As New EnterpriseDataSourceItem("", _

"titan-001v.titanconsultinggroup.com", 80, "MyDataSource", _

New SqlDataSourceItem("MyDataSource"))

''-- Configure the compression and encryption (optional)

ds.IsCompressed = True

ds.IsEncrypted = True

ds.EncryptionKey = New Byte() {1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2, 3, 4}

ds.EncryptionVector = New Byte() {1, 2, 3, 4, 5, 6, 7, 8}

''-- Add the EnterpriseDataSourceItem

DataLayer.DataSources.Add(ds)

End Sub

Here is my datasources.config:

<?xml version="1.0" encoding="utf-8" ?>

<ConnectionString>server=localhost;Integrated Security=SSPI;Database=StrataFrameSample;</ConnectionString>

<TypeFullName>MicroFour.StrataFrame.Data.SqlDataSourceItem</TypeFullName>

<TypeAssemblyName>MicroFour StrataFrame Base</TypeAssemblyName>

<TypeAssemblyCulture>neutral</TypeAssemblyCulture>

</DataSource>

</DataSources>

And attached is a screenshot of the ES Status page. I'm running VS 2008, Vista 64-bit, IIS 6.0 SP1, SQL Server 9.0.1399 64-bit (with StrataFrame and StrataFrameSample databases) all running on the same machine with plenty of memory. I've set the folder permissions to Everyone, Full Control and I'm allowing All Users to access the web service.

Any help would be appreciated.

Thanks,

Brian O'Neil

ES Server was down

Greg McGuffey — Thu, 22 May 2008 23:14:41 GMT

My companies ES server went down tonight at around 5pm PST. The error was related to the being unable to contact the 'activate.micro4.com' server.

This doesn't seem like it should happen, that if you licensing server goes down, my server goes down as well. Please advise if there was some configuration I should have done or if there was some other issue I could address. My ES server was attempting to contact 'activate.micro4.com' whenever a user attempted to login (maybe other times as well, but we never got past login).

FillMultipleDataTables Not working

Greg McGuffey — Mon, 19 May 2008 13:18:11 GMT

I'm not quite sure what's going on, but I'm getting an error with the FillMultipleDataTable() method. I'm running the latest beta and updated ES server from the My accounts area. This occurs on the line that first calls the FillMultipleDataTables() method. Here is the error:

[quote]NullReferenceException
Object reference not set to an instance of an object.

Source : MicroFour StrataFrame Enterprise Client

Stack Trace:
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.ᜁ(DbCommand A_0, Boolean A_1, String A_2)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.GetDataSet(DbCommand Command)
at MicroFour.StrataFrame.Business.BusinessLayer.FillMultipleDataTables(String dataSourceKey, DbCommand command, BusinessLayer[] businessObjects)
at MicroFour.StrataFrame.Business.BusinessLayer.FillMultipleDataTables(DbCommand command, BusinessLayer[] businessObjects)
at FOXSystems.RAMS.BusinessObjects.Summary.PESummaryBO.GetProjectSummary(Int32 projectID)
at FOXSystems.RAMS.ProposalEval.VendorSelectionForm.LoadProjectSummary()
at FOXSystems.RAMS.ProposalEval.VendorSelectionForm.LoadPageData()
at FOXSystems.RAMS.ProposalEval.VendorSelectionForm.pmVendorSelection_PageActivated(PanelPageEventArgs e)
...etc and so forth..[/quote]

There is no error if I make a direct connection.

FillDataTable Method support

Ertan Deniz — Wed, 09 Apr 2008 02:20:16 GMT

I 'm using this method as the center of my design. (Generated Queries And Custom Queries from XML)

I want to be sure that FillDataTable method is supported with Enterprise server solution.

ES licensing / CALS

Larry Tucker — Sat, 08 Mar 2008 11:01:12 GMT

Hi,

I see you price ES as follows:

Enterprise Server - 25 CALs (per hostname / per server / per year)	1+	$995.00
Enterprise Server - 100 CALs (per hostname / per server / per year)	1+	$2,495.00
Enterprise Server - Unlimited (per hostname / per server / per year)	1+	$4,995.00

Just confirming a "CAL" is a "Client Access License" on a per-user concurrent basis (not per-device and not total user count).

So with the smallest package, MyApp could have 100 total users, but only a maximum of 25 could be logged in at any time from any machine.

Thanks,

Larry

ES and MS-SQL user Licenses question

Edhy Rijo — Tue, 16 Oct 2007 08:08:09 GMT

Hi,

Let's say I have 50 users that will connect to MS-SQL server with the ES, how many MS-SQL user licenses will I need to have?

ES CryptographicException

Larry Caylor — Sun, 16 Dec 2007 14:00:18 GMT

When trying to launch an application that uses the Enterprise Server I was receiving an error (see attachment). The error started when our organization lost Internet connectivity Saturday morning due to a power outage in our main data center. It's now Sunday, power has been restored, and everything is working normally. This leads me to assume that the ES has a "phone home" feature that checks to see if the license is current. While I can understand the need to protect your intellectual property, I'm not feeling good about building business critical applications that otherwise do not need the Internet that cannot survive a few days without it. Does ES require constant communication home or is there something else going on?

-Larry

ES status page doesn't report any user ever having connnected

Greg McGuffey — Thu, 13 Dec 2007 14:05:51 GMT

I was trying to use the ES status page to see if any users had connected to ES...which I know many have, but it shows that 0 users have ever connected. This doesn't seem right or very useful :blink:

Dealing with proxies

Greg McGuffey — Mon, 10 Dec 2007 14:31:10 GMT

Could the ES client be modified to deal with proxy issues? I.e. have a prompt to enter proxy info if a 407 is returned by the HttpWebRequest.GetResponse() and also deal with storing proxy info, perferably in an encrypted xml file?

Thanks for considering this! :D

Oh...and could you have it done by tommorrow! :w00t: g,d,r*

*g,d,r = grin, duck and run!:arrow:

Error when calling sproc with varchar OUTPUT parameter

Greg McGuffey — Sun, 04 Nov 2007 19:33:11 GMT

I'm getting an error when I attempt to call a stored procedure that has an output parameter that is a varchar. It reports that the size is invalid with a value of 0. However, the size is clearly set in code and the code runs fine when connected directly.

I've attached a sample solution that highlights this problem. Just read the Readme.txt for details on how to run the tests.

This is a show stopper for my project, which I'm attempting to release for beta testing.

Thanks!

Error related to missing reference

Greg McGuffey — Mon, 05 Nov 2007 12:33:27 GMT

I getting errors when I install my application on a machine that doesn't have strataframe installed. It is reporting that:

[quote]FileNotFoundException
Could not load file or assembly 'MicroFour StrataFrame Enterprise, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7' or one of its dependencies. The system cannot find the file specified.

Source : MicroFour StrataFrame Enterprise Client[/quote]

I have the enterprise client included in the install and I've verified that it is getting installed. Is there some other dll needed? Is this a version issue? I'm really under the gun to get this thing installed, so some immediate help would be really appreciated.

Thanks!

Installer missing files

Greg McGuffey — Fri, 02 Nov 2007 18:25:11 GMT

I just installed ES on a brand new server (finally), and the installation seems to be missing two files:

Microfour License Base.dll
Microfour StrataFrame Base.dll

I had them from another install, so I was able to get it working. It is possible that I'm using an older installer, but just in case I thought I'd mention it.

Status.aspx response

Alex M. Lana — Wed, 17 Oct 2007 16:12:06 GMT

Greetings,
I'm starting with ES and could not get the Status.aspx after ES setup.
It simply shows the following message:
[b]This is a marker file generated by the precompilation tool, and should not be deleted[/b]
The XML Datasources and web config files are already configured.
Can you help?
Thanks.

[b]Alex Lana[/b]

ES installation doesn't seem to be complete

Greg McGuffey — Wed, 25 Jul 2007 18:25:57 GMT

I'm just getting around to updating my test ES server. I uninstalled the old version and then installed the new version. The new version seems to be missing some files. I get an error that 'Microfour Strataframe Base.dll' is missing and looking at my previous install, it seems that 'Microfour License Base.dll' is also missing.

I know you made changes to SF base, because I was getting error related to those changes (er...getting errors related my base not having those changes) before the release.

Do I have an outdated setup? Or am I just continuing to loose my mind? :crazy:

Can't load CaseInsensitiveDictionary from base

Greg McGuffey — Fri, 08 Jun 2007 08:24:28 GMT

I get the exception shown below when I try to save a new user using the security dialog (and some other places). Since I don't find the CaseInsensitiveDictionary in 1.6, I'm guessing this is new to 1.6.1. This correct? Is updating the base dll now safe or do I have to wait for 1.6.1 to release?

Exception:
[quote]BusinessLayerException
An error occurred while saving an the data to the server.
DataLayerSavingException
Could not load type 'MicroFour.StrataFrame.CaseInsensitiveDictionary`1' from assembly 'MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7'.
TypeLoadException
Could not load type 'MicroFour.StrataFrame.CaseInsensitiveDictionary`1' from assembly 'MicroFour StrataFrame Base, Version=1.6.0.0, Culture=neutral, PublicKeyToken=99fe9917f71608a7'.

Source : MicroFour StrataFrame Business

Stack Trace:
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataReader.a(BinaryReader A_0)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteReaderResults.ReadDataFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteReaderResults.CreateFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.SendRequestCore(BaseParams Params, RemoteDataSourceCommand Command)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.c(DbCommand A_0, Boolean A_1, String A_2)
at MicroFour.StrataFrame.Data.DbDataSourceItem.InternalExecuteReader(DbCommand Command, Boolean IsTransactional, String TransactionKey)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler, Boolean RecreateCommand)
at MicroFour.StrataFrame.Data.DbDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.UpdateRow(QueryInformation QueryInfo, DataRow RowToUpdate, ConcurrencyExceptionHandler ConcurrencyHandler, AddRowErrorHandler RowErrorHandler, Boolean RecreateCommand)
at MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(Object ThreadParams)
at MicroFour.StrataFrame.Data.DataLayer.SaveByForm(DataTable TableToSave, Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.Business.BusinessLayer.SaveByForm(Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save(Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save()
at MicroFour.StrataFrame.Security.UserEditor.cmdSave_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
[/quote]

ES SerializationException

Greg McGuffey — Fri, 25 May 2007 14:40:39 GMT

I'm now getting this error when I attempt to use ES with the application. This occurs at the first connection to the database, getting the security preferences.

[quote]SerializationException
The input stream is not a valid binary format. The starting contents (in bytes) are: 01-00-01-00-00-00-FF-FF-FF-FF-01-00-00-00-00-00-00 ...

Source : mscorlib

Stack Trace:
at System.Runtime.Serialization.Formatters.Binary.SerializationHeaderRecord.Read(__BinaryParser input)
at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadSerializationHeaderRecord()
at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteScalarResults.ReadDataFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteScalarResults.CreateFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.?(BaseParams A_0, RemoteDataSourceCommand A_1)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.?(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)
at FOXSystems.RAMS.BusinessObjects.Security.SecUserProjectDefaultBO.GetUsersDefaultProject(Int32 userID) in E:\FoxSystems\RAMS\RAMS.NET\BusinessObjects\Security\SecUserProjectDefaultBO.vb:line 92
at FOXSystems.RAMS.Base.UserContext.SetUserContext(ISecurityUser secUser) in E:\FoxSystems\RAMS\RAMS.NET\RamsBase\UserContext.vb:line 267
at FOXSystems.RAMS.RAMSLoginForm.btnOk_Click(Object sender, EventArgs e) in E:\FoxSystems\RAMS\RAMS.NET\RAMS.NET\RAMSLoginForm.vb:line 314
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.PerformClick()
at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.TextBoxBase.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.Control.PreProcessMessage(Message& msg)
at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)
at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)
[/quote]

Error access data via ES

Greg McGuffey — Tue, 15 May 2007 13:22:09 GMT

I getting a very reproducible (on my side anyway) error side when attempting to access some data via ES. Other data is accessed fine. Here is the error reported to the client:

[quote]BusinessLayerException
An error occurred while refreshing the data from field 'ProjectOrganizationBO.Owner' to property 'Text' on control 'txtOwner.'
BusinessLayerException
An error occurred while refreshing property 'Text' to control 'txtOwner'
TargetInvocationException
Exception has been thrown by the target of an invocation.
CryptographicException
Bad Data.

Source : MicroFour StrataFrame Business

Stack Trace:
at System.Security.Cryptography.CryptographicException.ThrowCryptogaphicException(Int32 hr)
at System.Security.Cryptography.Utils._DecryptData(SafeKeyHandle hKey, Byte[] data, Int32 ib, Int32 cb, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode PaddingMode, Boolean fDone)
at System.Security.Cryptography.CryptoAPITransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)
at System.Security.Cryptography.CryptoStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.Compression.DeflateStream.Read(Byte[] array, Int32 offset, Int32 count)
at System.IO.Stream.ReadByte()
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadBoolean()
at MicroFour.StrataFrame.Data.Enterprise.BaseResults.ReadDataFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteScalarResults.ReadDataFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteScalarResults.CreateFromStream(BinaryReader Reader)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.?(BaseParams A_0, RemoteDataSourceCommand A_1)
at MicroFour.StrataFrame.Data.Enterprise.EnterpriseDataSourceItem.?(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)
at FOXSystems.RAMS.BusinessObjects.Project.ProjectOrganizationBO.get_Owner() in E:\FoxSystems\RAMS\RAMS.NET\BusinessObjects\Project\ProjectOrganizationBO.vb:line 387
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.RuntimePropertyInfo.GetValue(Object obj, BindingFlags invokeAttr, Binder binder, Object[] index, CultureInfo culture)
at System.Reflection.RuntimePropertyInfo.GetValue(Object obj, Object[] index)
at MicroFour.StrataFrame.Business.ReflectionPropertyDescriptor.GetValue(Object component)
at System.Windows.Forms.BindToObject.GetValue()
at System.Windows.Forms.Binding.PushData(Boolean force)
at System.Windows.Forms.Binding.ReadValue()
at MicroFour.StrataFrame.Business.BusinessLayer.RefreshValue(Control ControlToRefresh, String PropertyName)
at MicroFour.StrataFrame.Business.BusinessLayer.RefreshControl(IBusinessBindable ControlToRefresh, Boolean DataPresent)
at MicroFour.StrataFrame.Business.BusinessLayer.RefreshBoundControls()
at MicroFour.StrataFrame.Business.BusinessLayer.raise_Navigated(NavigatedEventArgs e)
at MicroFour.StrataFrame.Business.BusinessLayer.OnNavigated(NavigatedEventArgs e)
at MicroFour.StrataFrame.Business.BusinessLayer.Navigate(BusinessNavigationDirection Direction, Int32 AbsoluteIndex, Object[] PrimaryKeyValues, Boolean AttemptToCheckRules, Boolean IsRefill)
at MicroFour.StrataFrame.Business.BusinessLayer.NavigateToPrimaryKey(Object[] PrimaryKeyValues)
at FOXSystems.RAMS.MitaAnalysis.OrgTools.SynchBoToTree(TreeView anyTree, BusinessLayer anyBO) in E:\FoxSystems\RAMS\RAMS.NET\MitaAnalysis\OrgTools.vb:line 421
at FOXSystems.RAMS.MitaAnalysis.MITAWizardPages.OrgDefinePage.tvwOrg_AfterSelect(Object sender, TreeViewEventArgs e) in E:\FoxSystems\RAMS\RAMS.NET\MitaAnalysis\MITAWizardPages\OrgDefinePage.vb:line 303
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
[/quote]

Here is the error reported via ES:

[quote]ArgumentNullException
Object Graph cannot be null.
Parameter name: graph

Source : mscorlib

Stack Trace:
at System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph)
at MicroFour.StrataFrame.Data.Enterprise.ExecuteScalarResults.WriteDataToStream(BinaryWriter Writer)
at MicroFour.StrataFrame.Enterprise.Server.RemoteDataSource.ProcessRequest(HttpContext context)[/quote]

Some info about what is going on:

- This error does not happen if I connect directly.
- If I step through the code, the error occurs on the line that fills the data table of the BO.
- The Owner property is actually a custom property that is doing a separate ExecuteScalar command to get that value.
- txtOwner is bound to the Owner property.

Any ideas why this isn't working with ES?

Database Deployment Tookit

Bruce King — Wed, 09 May 2007 16:27:24 GMT

TargetInvocationException
Exception has been thrown by the target of an invocation.
SqlException
Invalid object name 'DBEProfile'.

Source : mscorlib

Stack Trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)
at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)
at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)
at MicroFour.StrataFrame.Business.DBEProfileBO.FillWithDistinctCategories()
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateComboFromBusinessObject(IListControl lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateCombo(Control lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.PopulateCombo(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.Requery()
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.InitializeObject()
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects()
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Unhandled Exception

Larry Caylor — Thu, 15 Mar 2007 12:08:02 GMT

I’ve got the ES server set up on Windows Server 2003 Web Edition with SP1. I’m able to access the ES status page but when it try to run a client application I get the following exception. Any suggestions on what I may have missed?

-Larry

ES Sample strange behavior

Ben Hayat — Tue, 20 Feb 2007 20:22:29 GMT

Ok, I just got installing the new version and I'm running the sample console program. I run the ES sample program and I can switch between local and remote.
But, let's say I'm in local and I edit a record and save it. Then If I switch to either mode, I see the same record with the same edited data. However, if I exit out completely and then start the program with another mode, it will then show the correct data.

So, somehow the data that gets cached on the computer, does not get clear when switching mode while in the program.