NVARCHAR SQL Error

[Former Member]

Hey all,

I am using RetailOne by Navigator and while upgrading and copying databases somehow I believe it has become corrupted.

We get the following SQL error when trying to add information to the R1 Registers user-defined table, in fact we get the following error when trying to input data into ANY UDT:

[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the nvarchar value '-3 @NBS_R1REG' to data type int. (CINF)

Not sure if anyone has heard of this error or knows what I could do to avoid having to start over with a new database.

I'm downloading another patch level up, but I'm not sure if that is a smart thing to do. I'm wondering if it might fix some of the tables during the upgrade.

Any thoughts would help,

Mike

PS. I have tried all sorts of different numeric and alphanumeric strings in all of the fields and it doesn't seem to help the problem at all.

[Former Member · Accepted solution]

Hi Mike,

Please check these threads to see if you can find anything in common:

/message/5952315#5952315 [original link is broken]

Thanks,

Gordon

[Former Member]

Dear Mike,

The issue you have reported is already fixed as per the CM : 772069 2008

that you have reported to SAP Support.

Please always open a message for SAP Support if you will find a corruption in the

database.

Regards,

Rakesh Pati

SAP Business One Forum Team