06-14-2016 03:38 AM
My remote database (laptop) will no longer sync with the "master"database on my desktop, giving the above error.
Also it fails to backup with teh same error.
"Internal Query Processor Error: The query processor encountered an unexpected error during execution. Failed to flush the commit table to disk in dbid 7 due to error 8630. Check the errorlog for more information."
I know that there is a similiar posting "Failed to flush the commit table to disk in dbid 7 due to error 2601" which has an alleged fix in Sage Act forums (28141) but this Sage Forum posting now seems now to be inaccessible so far as I can see - I just get a login page.
Has anyone cme across this? Hope someone can help....
06-14-2016 05:14 AM
06-14-2016 05:23 AM
06-14-2016 06:02 AM
Dear Gary, Mike, thanks for teh reference to the kb article.
However, your suspicions that this is not the solution, Gary, are correct! - I previously implented the SQL update listed there (SP3 for SQL Server 2008 R2) for a previous fault, so I know I have the latest (Microsoft SQL Server 2008 - Express Edition (64-bit) SP3, Build 10.50.6220.0)
Any other ideas as to what might be the cause?
Many thanks for your help.
06-15-2016 03:32 AM
06-15-2016 04:59 AM
Thanks Gary. Alas the repair fell at the first hurdle - trying to detach the Remote database.
It had the same basic error "Failed to flush the commit table to disk in dbid 7 due to error 8630" but here is the full error message.....
System.Data.SqlClient.SqlException (0x80131904): Internal Query Processor Error: The query processor encountered an unexpected error during execution.
Failed to flush the commit table to disk in dbid 7 due to error 8630. Check the errorlog for more information.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at ActDiag.DatabaseCollection.ٟ(String ٓ, Boolean ٗ)
06-15-2016 05:09 AM - edited 06-15-2016 05:11 AM
This would really have to be looked into in more detail, with some further environmental troubleshooting by an Act technician.
If you have an active support contract or a subscription, I would suggest calling us on 0845 268 0220 and speaking with one of our support technicians. Alternatively, you could reach out to one of our Act Certified Consultants to help with this issue.
Be sure to reference this thread, so the technician can understand what steps have already been taken.