Issue Regarding Add-on Objects

[former_member609283]

Hey EveryOne,

     I came accross a situation that I have DB of a client, in which when I run Add-on and add anything it gives me an error. while when I am running the same on other DB it runs fine.

The Error is Following

"[Microsoft][SQL Server Native Client 11.0][SQL Server] Conversion Failed when converting the nvarchar value [MyObjectName] to data type int. (CINF)".

[ANKIT_CHAUHAN · Accepted solution]

Hi Idrees,

Please check the SBO_SP_TransactionNotification in the affected database.

When modifying this stored procedure always keep in mind that the object type may be a string value.

Example:

• DO NOT USE: If @object_type = 1
• USE: If @object_type = '1'

Refer to SAP Note 1298609 for the same.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[Johan_H]

Hi,

Most likely the problem DB has an empty or null value in a field that is used by [MyObjectName]

Check your addon code, and see where it is expecting a numerical value to have been entered in an nvarchar field. You may need to build in a check for this.

Regards,

Johan