Random Error


Author
Message
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Will do!  Thanks for your patience while we figured that one out, Larry Smile

Glad we got it working.
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
Hi Ben,

That fixed it! I ran a few tests and the save on transaction is slightly faster. Thank you for your help. When you get a chance please post the 1.7.7.1 source code installer to the download area.

-Larry
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
OK, Larry, I wasn't able to make your test program fail on this end.  So, thinking that your test program was pretty definitive, I rolled back my ES debug version to the 1.7.7.0 version and tried it.  It failed just like you said.  I didn't think I had made a change, but apparently I did.  Looking through our TFS logs, I found where the SqlDataReader wasn't being properly closed (which closes the connection, because the command is executed with CommandBehavior.CloseConnection since we no longer have a reference to the connection to close it).  Those connections were left open and had to be garbage collected just like the other situation.  

So, I have posted the ES from the build 1.7.7.1 to the My Account area as both the .zip and the complete install.  Let me know how that works.
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Thanks Larry.  I'll start looking at it.
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
Attached are the files. The application is a PKWare self extracting file. It's a simple program that creates some data records then allows you to save them with or without a transaction. It allows a parent child relationship to be defined but so far I can get it to consistently fail with just a parent record count > 120 and no child records.

-Larry

Edit: bchase (deleted attachments)
Edited 10 Years Ago by Ben Chase
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Can you zip up your test database and test project and send them to me so I can debug it?  That way I know we'll be looking at the same thing...
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
I replaced the Base and Enterprise dl's on the ES server and restarted IIS. Save on transaction with >120 records still fails.

-Larry
Attachments
ES dll.png (152 views, 18.00 KB)
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Sorry, we changed the version to 1.7.7.1 instead of 1.7.8 before it was built.  That 1.7.7.1 is the right version.  There were no changes to the ES.  The fix was in MicroFour StrataFrame Base.  You'll need to put that new Base assembly (and the others) with your ES and try it again.  You'll probably need to recycle the app pool after you swap out the assemblies.  We may end up needing to rebuild the ES for you, too, but I don't believe any signatures changed, so you shouldn't have any issues with MissingMethodExceptions or anything like that.
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
I didn't see a v 1.7.8 in the download area, but I did see v 1.7.7.1 for the framework. I didn't see any changes to the ES server. I download the new framework version and ran my test program. I still get the error when saving on a transaction. With no transaction everything works fine no matter how many records I throw at it.

-Larry
Attachments
dll version.png (142 views, 44.00 KB)
StrataFrame Team
S
StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)StrataFrame Developer (4.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Larry,

We got it fixed.  The issue has existed since the beginning.  Looking through our exception logs from PracticeStudio, several of our customers end up getting the issue on a routine basis.  There was never any method to the madness of when the exception would occur, though.  The problem was exactly like you said, we were creating a new connection and opening it in the DbDataSourceItem.ExecuteReader() method that was a local variable so it would simply go out of scope.  That made it rather hard to track.  The connection was used when you weren't on a transaction.  It would be properly cleaned up at the end of the execution.  But if you were using a transaction, the variable would go out of scope and would have to rely on the garbage collection to clean it up.  That made the error rather random.  If your .NET environment was GC'ing regularly, then the connections would be removed and returned to the pool without issue.  But, if your application wasn't needing GCs then the pool would be consumed.  We did finally find a scenario that allowed us to chew up the pool and reproduce the problem consistently, so we know that the issue is resolved.

We build v1.7.8.0 and posted it on the downloads section of the My Account area.  Let me know if it doesn't fix your issue.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search