topic Re: hibernate operation:could not execute query using scroll? in Alfresco Archive

hibernate operation:could not execute query using scroll?

dynamolalit — Thu, 07 Oct 2010 05:45:21 GMT

Hi,I am using alfresco 3.2r on windows 2003 server with Tomcat 6 & jdk 1.6.At odd times, i am getting this strange error on my explorer web client:A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select c

Re: hibernate operation:could not execute query using scroll?

mrogers — Thu, 07 Oct 2010 08:32:42 GMT

exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)
Caused by: java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)

Has your temp folder run out of space?

Re: hibernate operation:could not execute query using scroll?

dynamolalit — Thu, 07 Oct 2010 09:33:10 GMT

Hi Mrogers,

Thanks for your reply.'C:\WINDOWS\TEMP' folder occupies only 60 MB but my C drive is almost full leaving only ~40 MB free out of ~50 GB of space.

Can this be an issue?

Re: hibernate operation:could not execute query using scroll?

mrogers — Thu, 07 Oct 2010 10:47:28 GMT

Yes that will be an issue for lots of software, including windows, mysql and alfresco.

The "rule of thumb" I use is to keep 10 to 20% of disk free.