Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AP Payment Batch error

Status
Not open for further replies.

Zak2009

Programmer
Sep 4, 2009
325
KE
Hi All,

The server holding accpac and the DB crashed,after restoration the users are getting the following error when posting past AP batches

"Description: Document. Database error (operation=UPDATE, error=824). [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0xaaaa5555). It occurred during a read of page (1:7581108) in database ID 7 at offset 0x0 Please refer this error to your database administrator or see your database documentation for further assistance.
Source: 08:59:56"

What could be the issue.
Version 6.1
sp 1
DB msql 2008

Thanks
 
You have corrupted data. Run a data integrity check on AP and see if it reports any errors.
You will have to run SQL db utilities to check the db for errors and inconsistencies.
 
Hop over to the sql server forum - you may be able to save the DB as it is ... if not you will have to recover from a DB backup.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top