Skip to Content

Issue Regarding Add-on Objects

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)".

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 17, 2016 at 10:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 17, 2016 at 10:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.