Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.



Go to last post Go to first unread
judy at Web2Market  
#1 Posted : Tuesday, June 25, 2024 11:41:34 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 293

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
We have a site that shows this error any time anything in the maintenance routine runs, for each step in the routine.
ExecuteReader requires an open and available Connection. The connection's current state is closed

I put in code to log the open connections before it runs and it displays one open connection, as it always does in admin system reports.
I have looked through the code for ExecuteReader in custom code and all custom code uses NHibernate.
I looked in Sql Server settings, comparing all the properties with another database and they were the same.
Have you seen this before? Can you give any help? All the Google results I find refer to custom sql using sql data commands, etc, not nHibernate.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Katie S  
#2 Posted : Wednesday, June 26, 2024 7:46:40 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 451

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hi Judy,

This will need to be answered by a developer. Our lead dev is out of the office until next week. I will ask him to update then.
Thanks for your support!

Secure eCommerce Software and Hosting
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.