Backup Problem

jlsabio

hi and happy new year,

when i do a backup of one of my databases the system says "error 1204 in module 19" when it is backing-up the table 32.

i tried to copy the file of the database and make a new backup, i tried pass the exam process too, but i had the same answer "error 1204 in module 19" when the backup process is over the "item ledger entry" table.

Can you help me please?

thanks a lot.

amunozsu

Searching in our errors database I have found that:

The error has to do with Code fields, when a Code field is saved in the database it is saved with an information byte.
If the Code field only contains numbers (123..) then the information byte contains the length of the numbers, if there is saved 5 numbers in a field then the information byte will be 5. If alphanumerically signs are in the field then the information byte will always be 255. The error occurs when the information byte for alphanumerically fields not is 255. The error
can be due to harddisk error or other programs that have changed the database.

You already know the table with the error so you just need to locate the field so make a report with the following code for all Code
fields in table with the error.

1. Make a report with the variable NEWCODE (type Code, length 132)
2. For all Code fields in table with the error, the following lines must be run.

EVALUATE(NEWCODE,FORMAT(Code field));
IF NEWCODE <> Code field then (print 'here is an error' ) 

How to correct the error.

When knowing the fields with the error, then just retype the information in the fields. If there is a lot of
fields then make a report that will modify the field with NEWCODE, but remember to print out what
will be modified in the field, because the new contents might not be understandable.

-- Alejandro --

jlsabio

[Inappropriate/Offensive text removed by Moderator.]
[Non-English text (besides in the forums where it is allowed) is not allowed.]
Please see Forum Rule #9: Forum Rules.

amunozsu wrote:

Searching in our errors database I have found that:

The error has to do with Code fields, when a Code field is saved in the database it is saved with an information byte.
If the Code field only contains numbers (123..) then the information byte contains the length of the numbers, if there is saved 5 numbers in a field then the information byte will be 5. If alphanumerically signs are in the field then the information byte will always be 255. The error occurs when the information byte for alphanumerically fields not is 255. The error
can be due to harddisk error or other programs that have changed the database.

You already know the table with the error so you just need to locate the field so make a report with the following code for all Code
fields in table with the error.

1. Make a report with the variable NEWCODE (type Code, length 132)
2. For all Code fields in table with the error, the following lines must be run.

EVALUATE(NEWCODE,FORMAT(Code field));
IF NEWCODE <> Code field then (print 'here is an error' ) 

How to correct the error.

When knowing the fields with the error, then just retype the information in the fields. If there is a lot of
fields then make a report that will modify the field with NEWCODE, but remember to print out what
will be modified in the field, because the new contents might not be understandable.

-- Alejandro --