Random Error


Author
Message
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K

I’m getting a random error when saving via the Enterpriseserver. I have a form with 5 business objects and there are parent childrelationships. I’m saving these objects using the form save method on a transactionand every so often the transaction fails (see attached screen shot). If Iremove the transaction and simply save by form, it works 100% of the time. If Ibypass the Enterprise server and use a direct connection, both save by formwith and without a transaction works 100% of the time. There is something aboutsaving on a transaction via the Enterprise server that is randomly failing. TheSQL box is the same system for both the direct and Enterprise connections andthe number of pools is set to the default of 100. And suggestions?


Attachments
SFESError.png (270 views, 124.00 KB)
Replies
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
Trent,

Thanks for the update. I'll wait to see what you find out.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
The whole issue pertains to the transaction, I think that much as been established.  But we will try and come up with a solid scenario so we can really prove it out.
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K 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...




Threaded View
Threaded View
Larry Caylor - 12 Years Ago
Trent L. Taylor - 12 Years Ago
Larry Caylor - 12 Years Ago
Larry Caylor - 12 Years Ago
Larry Caylor - 12 Years Ago
Larry Caylor - 12 Years Ago
     ??????
Larry Caylor - 12 Years Ago
StrataFrame Team - 12 Years Ago
Larry Caylor - 12 Years Ago
Larry Caylor - 11 Years Ago
Trent L. Taylor - 11 Years Ago
Trent L. Taylor - 11 Years Ago
Larry Caylor - 11 Years Ago
Trent L. Taylor - 11 Years Ago
StrataFrame Team - 11 Years Ago
Larry Caylor - 11 Years Ago
StrataFrame Team - 11 Years Ago
Larry Caylor - 11 Years Ago
StrataFrame Team - 11 Years Ago
Larry Caylor - 11 Years Ago
             Thanks Larry. I'll start looking at it.
StrataFrame Team - 11 Years Ago
StrataFrame Team - 11 Years Ago
Larry Caylor - 11 Years Ago
StrataFrame Team - 11 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search