Navion HOTCOPY BACKUP ERROR

smmurugan

Dear All,

We using HOTCOPy for our NAV native database at each stores.

We got the following error :


Backup started at 2011/12/11 16:03:07.


Starting database test with option: minimum.


There is an error in the database structure. The error (1194 in module 19) may have been caused by the computer or a program.

Table: Trans. Sales Entry
Company:
Key Fields: Store No.,POS Terminal No.,Transaction No.,Line 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.

Backup ended with an error at 2011/12/11 19:34:26.


Can any suggest what could be the reason ?

rhpnt

smmurugan wrote:

Can any suggest what could be the reason ?

The answer is on hand, you just have to read it.

smmurugan wrote:

There is an error in the database structure. The error (1194 in module 19) may have been caused by the computer or a program.
Table: Trans. Sales Entry
Company:
Key Fields: Store No.,POS Terminal No.,Transaction No.,Line No.

I presume we're talking LSRetail, if so, you should contact your partner company.