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 (255 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
??????
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
Sorry for the delay, Larry.  I was out on vacation when you posted your first question and Trent was holding down the fort.  Then, I was up-chucking all Thanksgiving week.

You're not the first person to get this error.  We have seen it ourselves.  It's a bug in the ES that we have resolved in the past.  When you save on a transaction, the connection never gets disposed/cleaned up properly, so the connection never gets returned to the pool.  After you've used 100 SqlConnection objects to save on transactions, the next time the ES tries to get a connection from the pool when it creates the SqlConnection, you get that exception.

I don't remember specifically which assembly the fix was in.  It might have been in Base or Enterprise.  I will setup a test tomorrow and go through the old versions to reproduce it and figure out which assembly you need for the fix.
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