on 08-04-2008 7:42 AM
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.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
kindly post your receive JBDC Payload here..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.