Announcements
No record found.
Hi All,
Anytime the hq client tries to synchronise with HQ I get this error message" not enough storage available to complete this operation (Unhandled error, state=9)
Please help
*This post is locked for comments
Check to see if your database has grown beyond the size limit:
MSDE - 2gb, SQL Express 2005 - 4gb, SQL Express 2008 - 8gb
No it hasn't ,the mdf file is 4gb, and log 20mb, the sql version is even SQL 2005 Enterprise
Thanks
mdf file is 4gb - then yes you have exceded the size limit. You will need to upgrade to 2008, or reduce the size of the file. If less qualified than a DBA, then get your MS support rep to help.
Thanks for the responds, but I thought SQL 2005 Enterprise can grow beyond 4gb because we have other files that are even 50gb
Sorry, misread: Express 4gb limit, Enterprise no limit. You may have a problem with network connectivity, database timeout, or trying to push too much data through the connection. I have had this problem happen when a transaction gets entered as the wrong date and then HQ client tries to upload years worth of info from that point forward.
I think it has to do with the volume of data being uploaded from the store to HQ, because I run the HQ client in debug mode to see the details of the data being uploaded, and one from the PurchaseOrderEntryDetail table has 7045826 records to be pushed to HQ, over 6000000 records from the serial table, before other records from other tables,may be that could be the reason. The store is a warehouse.
Any suggestions as to solve the error?
This still sounds like a bad date in a transaction is setting the upload back to some previous date. Check the FromDate on the worksheet that is trying to process to see how far back it is trying to upload. My guess is that if that date is something like 1/1/2000 then some new transactions have been entered on that date and now everything from that time forward is trying to upload again.
I have seen this when the store computer battery dies, cmos gets reset to original values and the time and date goes back to some default old date. The solution involves changing the battery, reset the date, fixing the date on the bad transactions, changing the FromDate and EffectiveDate of the hq worksheet trying to process.
Thank for the idea, I limited the FromDate and it was able to upload to HQ but it couldnt update the respective tables in HQ, the error is Error-2147217871 Time Out expired and the origin is from HQ not the store, can the time out duration be increase, if yes how
Thanks for taking time to help me out
Make sure your timeout are all set to around 60 seconds or more, especially for HQ Client and Server as operations can take a while. This is likely a larger issue, but for troubleshooting sake, is there enough storage on the hard drive fro the database to grow? Also if you go into RMS Administrator (either one) and connect to the database, then go to Database -> Properties, what is the usage %? Have you tried re-indexing the HQ database?
Thanks,
For HQ the size is 89gb and usage is 92%
For Store the database size is 4gb and the usage is 80%
What is the effect of reindexing
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
