SBO_SP_TransactionNotification issue with registered UDO's

[Former Member]

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

[Former Member]

Hi all,

The solution was simple - very simple!

Instead of:

IF (@object_type = 17)

I did this:

IF (@object_type = '17')

And that was it! Problem Solved.

Regards,

[Former Member]

What version of SAP are you using?

If I remember correctly, in older versions of SAP the object_id had INT as the data type for the Stored Procedure. Newer versions of SAP has varchar as the data type. I think if you upgrade to a more recent version of SAP, this issue will be solved

Krishnan

[Former Member]

Hi Krishnan,

We are running 8.8 PL 11.

This was also a clean installation on 8.8 and not an upgrade from 2007.

Regards,

Rikard