Back Up issue

vikram7_dabas

Dear All
I m using the Native DB4.0 SP3.When I m going to take Backup then I m facing the following Error:

There is an error in the database structure. The error (1190 in module 19) may have been caused by the computer or a program.
Table: Item
Company:
Key Fields: No.
First check the database by clicking File, Database, Test and then click Maximum. If you still get the same error, you should:
1) Make a backup of the database by copying the database file(s).
2) Use the built-in function to make a backup.
3) If this works, create a new database WITHOUT deleting the database that contains the error(s). Restore the backup (made with the built-in backup function) into the new database, and test it by clicking File, Database, Test and then click Maximum. If this procedure does not work, any changes to the database done after the most recent backup are lost. Restore the most recent backup (made with the built-in backup function) and test it. For security reasons, you should save the old database until you have used the new one for a period of time. Warning! This error MUST be corrected before you can continue. Contact your system manager if you need assistance.

Please tell me the solution ASAP

bbrown

This error is caused by having an invalid character in a record. Is the item table being updated by an external applications?

To resolve (native database)

1. Create a dataport and export the Item table records to a text file.

2. Review each record of the text file and correct any data issues.

3. Impor the text file to update the Item table records.

4. Make your backup.

Savatage

Belias has a codeunit that corrects code fields - see here:
http://www.mibuso.com/forum/viewtopic.php?t=21295

vikram7_dabas

My problem not solved.I have created dataport export data of Item(ID 27) table and delete all records in Item Table.Then again I m inserting records through Dataport I m facing lot of Problems

bbrown

vikram7_dabas wrote:

My problem not solved.I have created dataport export data of Item(ID 27) table and delete all records in Item Table.Then again I m inserting records through Dataport I m facing lot of Problems

Can you be more specific?