cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
944

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186851
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Regards,

NADEEM

Answers (1)

Answers (1)

Former Member
0 Kudos

RFC- JDBC

Message failed in Adapter Engine.

Error:

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

XML: