Skip to Content
avatar image
Former Member

SAP PI: Message error: ORA-00917: missing comma error.

Hi Experts,

We are getting ORA-00917: missing comma error in PI.

Message failed in adapter engine.

Also there are many successful messages processed for this interface.

ONly one message failed due to this eror.

I checked for the both Comma and missing closing parenthesis.

But i am not able to find the both in the payload.

How to fix this..

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 31, 2017 at 11:09 AM

    What is the scenario and can you share the file/xml or screenshots.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the response Raghuram!

      Issue has been fixed now.

      Issue- Sender was sending invalid values for the field "LOCATION"

      it has special characters instead of only string. (Ex- 001-A)

      Thus, system was considering the special character "-" as comma and throwed missing comma issue.

      But there was no issue with the comma actually.



  • avatar image
    Former Member
    Jul 31, 2017 at 12:20 PM


    Message failed in Adapter Engine.


    Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MG_STG_SAP_ITEM_LOC' (structure 'Statement'): java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

    I am not able to attach the file as the xml size is 4mb.. PFB


    capture.png (183.2 kB)
    Add comment
    10|10000 characters needed characters exceeded