error 1190 in module 19

Amaraa

Hello,

I got this error when I try to backup my database.
When go to the error caused table it shows empty table which is making error.
What should I do?
](*,)

kapil4dynamics

U can check here, may give u some idea

http://wiki.dynamicsbook.com/index.php? ... _Module_19

Amaraa

Hi there,

I just wanted to have a clear solution for this. Since there are many potential developers who can solve this :roll: .

ara3n

Are you on SQL? If Yes, run a test on each table from file->database->information-Table->Test
Once you found the table, open enterprise manager.
And write a SQL Query to would change the code field to uppercase.


Modify Yourtable name
set Yourfieldname = upper(Yourfildname);

garak

error 1190 in module 19 means --> #Err_DB_AlphaTypeIncorrect DB_Err(1190)

This problem can occur during the backupprocess, if there are some character in your system outside of ascii.
Or, what also possible: U use SQL and with a 3rd app or a sqlscript u wrote datas in the NAV tables. And, for example, in a codefield (uppercase) u wrote the characters in lowercase or a NULL. So check this first. Did you see during the backupprocess where the error pops up (if you take a look to the window with the indicator)

Regards

Amaraa

ara3n wrote:

Are you on SQL?

Hi there,

I use nav database and the table causing the error is empty. Because of this I don't know what to do.
And I have this message on both testing and back-uping the database.