Skip to Content
0
Former Member
Aug 30, 2010 at 03:45 PM

SBO_SP_TransactionNotification issue with registered UDO's

31 Views

Hi All,

I have a scenario where I have to perform some checks on a sales order before it is added.

My stored procedure works fine, but when I try to add or update a User Defined Object, I get the following error:

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

FC_ADDR is the Object ID.

All object ID fields are nvarchar. I do not understand why the stored procedure is trying to convert the Object ID to int.

Nevertheless, I have tried to give the UDO a numeric Object ID, but I then get an error that the Object ID is invalid.

Is this a bug that needs to be reported, or is there a logical explanation?

Any assistance would be greatly appreciated.

Regards,

Rikard Korff