ORA-00917:missing comma exception

[Former Member]

Hi All,

I am working on JDBC to JDBC scenario. when i am testing my scenario i am getting following exception

"Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SUB_RMS_AA_MODEL_SELL_REG' (structure 'Statement_SUB_RMS_AA_MODEL_SELL_REG'): java.sql.SQLException: ORA-00917: missing comma "

And my mapping is working fine when i have given same input in my message mapping.

Kindly suggest me what can be done now.

Thanks in Advance,

sudha.

[Former Member]

hi,

Following is my receive payload.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns1:mt_ModelSellingRegion xmlns:ns1="urn:agrp:acs">

- <Statement_SUB_RMS_AA_MODEL_SELL_REG>

- <SUB_RMS_AA_MODEL_SELL_REG action="INSERT">

<Table>SUB_RMS_AA_MODEL_SELL_REG</Table>

- <access>

<BRAND>11</BRAND>

<DIVISION>2</DIVISION>

<RMS_RANGE>0802</RMS_RANGE>

<WORKING_NO>BJ570Q</WORKING_NO>

<SELLING_REGION_ID>1</SELLING_REGION_ID>

<XI_DT hasQuot="NO">04.08.2008 08:13:659.01</XI_DT>

<XI_STATUS>'N'</XI_STATUS>

</access>

</SUB_RMS_AA_MODEL_SELL_REG>

</Statement_SUB_RMS_AA_MODEL_SELL_REG>

- </ns1:mt_ModelSellingRegion>

[Former Member]

Hi,

For JDBC scenario u shd have a particular Source & Target structure.

Are us ure u r using proper Structure.

If not it will not give any error when u test mapping in IR......... but it will give error at runtime.

Plz check this link for JDBC to JDBC scenario.

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

Thanks,

Mahi

[Former Member]

kindly post your receive JBDC Payload here..