I have problem making internal NF backup (db located on MSSQL). NF version is 2.60A. Can anyone help me?
Hi Alexey, We had the same problem here in Bulgaria. The problem with our bakcup was that trere was some cyrillic characters in fields of type CODE. After removing them the backup passed.
19 1190 #Err_DB_AlphaTypeIncorrect DB_Err(1190) Straight from the error list, your guess tio its meaning is a s good as mine thought! “Alpha Type” maybe a odd character in your system outside of ascii, how I dont know but just maybe.
According to US support this can from lowercase values being stored in a CODE field, which was populated via SQL Server. Since I am not sure how many tables that this has happened to, is there an easy way to Identify a Code Field in the SQL Version, so that I can get the DBA to convert all data in that column to Uppercase? Darren Bezzant Development Specialist dbezzant@csbsystems.com CSB Systems 1560 - 333 11th Avenue SW Calgary, Alberta T2R 1L9 Tel: (403) 233-2955 Fax: (403) 233-2957
The lower-case characters can also be entered through C/FRONT clients as well as external SQL tools (they cannot be entered from Financials). Currently there is no way, with T-SQL to determine of a given VARCHAR column is an NF Code or Text field, so you will have to approach it as a trial-and-error.
I know this is a very old post, but I would like to know if there now is a way to determine if a VARCHART is a NF Code?
We are using SQL Server 2005 and NAV 4.0 SP3, and are getting this error when trying to take a NAV backup after we have restored a backup with companies containing Thai Characters.