Dear
we were running consolidation with elimination and got the below error , any idea how to resolve it
Cannot edit a record in General journal account entry (LedgerEliminationTmpJournalLine). Reference: 0.
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:182286; actual 0:0). It occurred during a read of page (1:182286) in database ID 7 at offset 0x0000005901c000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MicrosoftDynamicsAX.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
SQL statement: UPDATE T1 SET DISPLAYVALUE=T2.DISPLAYVALUE,RECVERSION=? FROM LEDGERELIMINATIONTMPJOURNALLINE T1 CROSS JOIN
DIMENSIONATTRIBUTELEVELVALUE T2 CROSS JOIN DIMENSIONATTRIBUTEVALUE T3 CROSS JOIN DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION T4 WHERE (T1.PARTITION=?) AND (T2.PARTITION=?) AND ((T3.PARTITION=?) AND ((T3.RECID=T2.DIMENSIONATTRIBUTEVALUE) AND (T3.DIMENSIONATTRIBUTE=T1.DIMENSIONATTRIBUTE))) AND ((T4.PARTITION=?) AND (((T4.DIMENSIONATTRIBUTEVALUEGROUP=T2.DIMENSIONATTRIBUTEVALUEGROUP) AND (T4.DIMENSIONATTRIBUTEVALUECOMBINATION=T1.LEDGERDIMENSION)) AND (T1.UNIQUEIDENTIFIER=?)))
The elimination rule DXB-000001 failed during processing.
*This post is locked for comments
I have the same question (0)
