Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

View Entire Topic
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.