Backup error

Business Central/NAV Technical Forum
1

Hello experts. When I backup a database below error results.What is it?

0523.backupError.png
0523.backupError.png498×620 33.9 KB

2

See in the error only solution given

Go to File -->Database–Test

It will test the keys

Then do the Backup

Or

Complie the object and try it

3

Error 1190 in Mod 19

This says to me that you have a lowercase character in a Nav Code Field.

Code fields have to to all uppercase. This can’t be done from Nav you it was probably written to the SQL database by some outside program.

First check all Customer No’s for something odd.

4

Hi,

This error comes due to data fetched from external component to Navision Tables.

You can find the solution for issue resolution http://www.mibuso.com/forum/viewtopic.php?t=21295.

Search in the post for the text 'As the code is now in tips&tricks, I have to confirm you that i tested the code (used for a dozen tables) '.

There is a codeunit provided by Belias which you can copy and save as text file and then import in the Database.

After that Compile the codeunit and replace the TBField.SETRANGE(TableNo,3); with TBField.SETRANGE(TableNo,18); as for you the error is in the customer table.

Let me know if any issues.

Thanks & Regards,

Saurav Dhyani

http://saurav-nav.blogspot.in/