Database structure error

tinik

Hi to anyone,

I have encountered a msg 'there is an error in the database structure.' I already identified the corrupted data in the G/L entry table. Everytime this particular entry is accessed even just by 'find', the msg always appears. So i have come up with a codeunit to identify the exact entry and a dataport to filter the good data. Then deleting all data in the G/L table but in a back-up database, then restoring it. My question is.. what could have caused this data corruption? :-k

Regards,

Tinik

Timo_Lässer

There could be many reasons that could cause such an error, e. g. if you write from outside into the database (C/ODBC, C/FRONT).
Do you have a error message like "Internal error xxx in module yyy"?

tinik

Great to here from you Timo!

Actually the message is.. 'The error (1213 in module 19) may have been caused by the computer or program.'

Table: G/L Entry
Company:
Key Fields: Entry No.

According to our other technical guy, the entry may have been a 'Credit Memo' posted. But here are other tables affected.. G/L Register (No.)
Ledger Entry Dimension (Table ID, Entry No., Dimension Code)
Purchase Line (Document Type, Document No., Line No.)
Purch. Inv. Line, Document Dimension (Table ID, Document Type, Document No., Line No., Dimension Code)
Detailed Vendor Ledg. Entry (Entry No.)
Would appreciate your input.
Thanks again.

Tinik

Timo_Lässer

Internal Error 1213 in Modul 19
Modul 19 means Database Error
Description: #Err_DB_RecSizeError

One reason could be aborting building keys while restoring a database backup.
Other possibilities are:
- hardware problems
- network problems
- corrupted *.zup

air_wolf

how did you solved this ?

Timo_Lässer

air_wolf wrote:

how did you solved this ?

I've only this information about this error:

Open the database with parameter "dbreadonly" and create a backup.
Restore this backup into a new database.