Hey Guys i am getting a error while posting a Recurring Job Jrnl which is hitting value entries along with job ledger entries The error is as follows… Plz suggest as soons as possible what could be the problem n how do i correct it. The Following error occured while accessing The value Entry Table q:\SPHINX\NTDBMS\storeng\drs\include\record.incl:1447 EXPRESSION: m_SizeRec >0 && m_SizeRec <=MAXDATAROW SPID:70 PROCESS ID: 812
This is an assert in the SQL Server source code and should absolutely never happen. It implies, though, a corruption in this table. Do you get any errors when running a database test (or a Query Analyzer DBCC checkdb) ?
Hi, Yesterday i got rid off the problem by Re-building the keys of Value Entry Table. But today it is giving same error with Item ledger entry table. Should I now re-build keys for this table? We r using Navision Financial 3.00 on Sql Server 2000. plz suggest me some concrete solution to this problem I cannot think of loosing any data as it is my Db size is 7 Gb. Regards, Vishal