StrataFrame Forum » Enterprise Server - V1 » Issues » FillMultipleDataTables Not working

FillMultipleDataTables Not working

Greg McGuffey — Mon, 02 Jun 2008 11:34:35 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.

RE: FillMultipleDataTables Not working

Greg McGuffey — Mon, 02 Jun 2008 11:34:35 GMT

[quote][b]Trent L. Taylor (05/30/2008)[/b][hr]...she has been waiting for me to finish the bathroom remodel I started for a year...so to her credit...she is WAY patient!!![/quote]

LOL. I'm finishing up a little remodel that I started the weekend of New Years (this last one ;) ). I moved a door in my wife's office. Got a hare up my butt the Friday before New Years (Dec 29, the day after "Dress up Dad like a Girl Day"....sigh...that story will required some lubrication...er...beer), bought a saws-all (those things are cool) and started cutting into a wall :w00t:

Finally finished painting it on Saturday. Not bad, only 5 months. :cool:

And it was bugging me way more than my wife...mostly she just wants me to clean up after I make a mess...it's a miracle that I found a woman that'd put up with me! Gotta go and move some furniture now...one thing leads to the next!

RE: FillMultipleDataTables Not working

Trent L. Taylor — Sat, 31 May 2008 11:19:21 GMT

[quote]Trust me, you better finish that bathroom remodeling soon at least for the sake of all of us here
[/quote]

LOL...Actually I think it is bugging me more than her at this point...but definitely good advice!

RE: FillMultipleDataTables Not working

Edhy Rijo — Sat, 31 May 2008 09:52:24 GMT

[quote][b]Trent L. Taylor (05/30/2008)[/b][hr]LOL...some day we hope to welcome you into this complicated world of balancing work and keeping the wife happy[/quote]

Humm, I guess this is a developer thingy, not an easy task. Been there, done that and still married :hehe:.

Trust me, you better finish that bathroom remodeling soon :D at least for the sake of all of us here ;)

RE: FillMultipleDataTables Not working

Ivan George Borges — Sat, 31 May 2008 08:31:37 GMT

[quote][b]Greg McGuffey (05/30/2008)[/b][hr]Spoken like a bachelor...sigh...Gotta go paint something...[/quote]

ROFL

I could almost see your face over here, Greg!

Well, now I know the theory. When I get myself in this situation, I will always be able to say: "Look, Trent is just like the same... go talk to his wife and learn how she puts up with it! :D

RE: FillMultipleDataTables Not working

Trent L. Taylor — Fri, 30 May 2008 22:28:59 GMT

LOL...some day we hope to welcome you into this complicated world of balancing work and keeping the wife happy :D In all fairness, my wife really is great...she has been waiting for me to finish the bathroom remodel I started for a year...so to her credit...she is WAY patient!!! And anyone who knows me understands why we get along so well...it is definitely going to take a patient woman to put up with me :D

RE: FillMultipleDataTables Not working

Greg McGuffey — Fri, 30 May 2008 18:44:50 GMT

Spoken like a bachelor...sigh...Gotta go paint something...

RE: FillMultipleDataTables Not working

Ivan George Borges — Fri, 30 May 2008 15:14:43 GMT

I didn't know this "honey do's" expression. After I found out over here I was laughing a lot!!! :D

RE: FillMultipleDataTables Not working

Greg McGuffey — Fri, 30 May 2008 14:18:32 GMT

Thanks Trent. I've a few honey dos myself this weekend plus some out of town guests...

RE: FillMultipleDataTables Not working

Trent L. Taylor — Fri, 30 May 2008 09:41:30 GMT

Greg,

I will look into this over the weekend...in between a wedding and a lot of "honey-dos." :) I have built a new beta install that I am going to release in the next few days and once this is done we can look at this issue and get you a fix (or a change to prevent this from happening).

RE: FillMultipleDataTables Not working

Greg McGuffey — Thu, 29 May 2008 18:42:07 GMT

The issue is that this error occurs with installs of my app but not on my development machine.

Since the SF client dll is the one throwing the error, I checked it on my machine (in common and in the GAC) and had my users check it also. We all had the same version.

Assembly version: 1.6.0.0
File/product version: 1.6.5.1

Were to go from here?

RE: FillMultipleDataTables Not working

Greg McGuffey — Wed, 21 May 2008 13:04:57 GMT

I pulled the ES assemblies from the Download area of my account. If there is newer, I'm not sure were they are. I'll post versions in a bit. I did restart IIS when I installed the updated. I try another restart (but can't until tonight).

RE: FillMultipleDataTables Not working

Trent L. Taylor — Wed, 21 May 2008 09:28:47 GMT

I am having a hard time reproducing this as it is working on my side...(that is usually how it works, right :)). We actually use the ES in our medical app and this is the only way that we connect to the data internally, so I am like 99.9% confident that it is right since this is such a critical piece of our application. Reverify that you have the latest ES assemblies on your ES server, then restart the application pool (or restart IIS) and see if the problem persists. If so, I will setup an isolated test environment with the same assemblies you are using to see if I can figure our where the issue is.