on 02-22-2012 1:00 PM
Dear Experts,
I have a SOAP - IDoc scenario where I am using IDoc AAE reciver adapter for posting IDoc to SAP ECC system.
Message is successful in SXMB_MONI,however getting an error as below in receiver IDoc adapter.
Message processing failed. Cause: com.sap.aii.af.idoc.exception.IDOCAdapterException: com.sap.sql.log.OpenSQLException: Failed to set the parameter 9 of the statement >>INSERT INTO XI_IDOC_OUT_MSG ( IDOC_NUMBER , XI_MSG_NO , REF_NUMBER , ORIGINAL_IDOC_NO , IN_TIME , MESSAGING_TYPE , IDOC_TYPE , CIM_TYPE , SEND_PORT , SEND_PRTNR_NO , SEND_PRTNR_TYPE , CLIENT , STATUS , CONTROL_RECORD , CHANNEL_ID , ACK_NEEDED , ACK_RECEIVED , ARCHIVE ) values ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) <<: Cannot assign an empty string to a parameter with JDBC type >>VARCHAR<<.
My payload for this message is --
<HU_CREATE01>
<IDOC BEGIN='1'>
<EDI_DC40 SEGMENT='1'>
<TABNAM>EDI_DC40</TABNAM>
<MANDT>120</MANDT>
<IDOCTYP>HU_CREATE01</IDOCTYP>
<MESTYP>HU_CREATE</MESTYP>
<SNDPOR>SAPPID</SNDPOR>
<SNDPRT>LS</SNDPRT>
<SNDPRN>BS_ORIWIN</SNDPRN>
<RCVPOR>SAPD3S</RCVPOR>
<RCVPRT>LS</RCVPRT>
<RCVPRN>D3SCLNT300</RCVPRN>
</EDI_DC40>
<E1BPHUHDRPROPOSAL SEGMENT='1'>
<HU_STATUS_INIT>A</HU_STATUS_INIT>
<PACK_MAT>000000000002001755</PACK_MAT>
<HU_EXID>00340042312419076037</HU_EXID>
<TOTAL_WGHT>11.123</TOTAL_WGHT>
<UNIT_OF_WT_ISO>KGM</UNIT_OF_WT_ISO>
<CONTENT>00002059911110071031</CONTENT>
<PLANT>9610</PLANT>
<STGE_LOC>2000</STGE_LOC>
</E1BPHUHDRPROPOSAL>
<E1BPHUITMPROPOSAL SEGMENT='1'>
<HU_ITEM_TYPE>1</HU_ITEM_TYPE>
<LOWER_LEVEL_EXID>00000000000000000000_Test</LOWER_LEVEL_EXID>
<PACK_QTY>12</PACK_QTY>
<BASE_UNIT_QTY_ISO>ZCP</BASE_UNIT_QTY_ISO>
<BASE_UNIT_QTY>ZCP</BASE_UNIT_QTY>
<MATERIAL>000000000000205991</MATERIAL>
</E1BPHUITMPROPOSAL>
</IDOC>
</HU_CREATE01>
Could you please give me your valuable input for the same.
Waiting for a reply.
Thanks in advance.
Best Regards,
Sugeet.
Hi Sugeet
The SAP developers are currently creating a fix for this issue. The fix should be available in the next week (2 weeks max). I will let you know when the fix is released.
Regards
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Note #1688780 IDoc AAE Adapter fails to insert empty strings in database, has been created to resolve this error. The fix is still being tested, so the note is not available for download just yet. Once the fix is released, the note will be available for download.
Here are some further details on the cause of the error:
The issue occurs if the persistency of the IDoc_AAE adapter is enabled
via the 'Persistance' property for the 'JavaIdocAdapter' resource
adapter and one or more of the IDoc relevant properties (for example
sender/receiver port, partner number or type) of the XI message is/are
empty strings. As empty string insertion into database is not supported
by the persictency framework the above OpenSQLException exception is
thrown and the XI message processing fails.
Regards
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,,
I had faced this issue a few days ago. It was caused when a channel on AAE was used in a normal config ie sender agreement etc. instead of an ICO which must be used when you are using IDoc_AAE adapter. If your IDoc AAE channel is being used in a config other than ICO, you will get this error
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
Thanks a lot for your valubale suggestions.
We have manged to resolved this issue.We did two things -
1.In IDoc CC SAP release 730 by defualt but this should be the release of the receiving system. So we have changed it to 701.
2.The error message was generated because no default sender port was defined in NWA.
I added a default port (SAPX8D and SAPX8Q) in NWA and this fixed the issue.
Thnaks.
Best Regards,
Sugeet Patinge
Hi Sugeet
We are currently creating a patch fix for this error. I will let you know when the fix is released. Can you confirm the SP level you are on?
Regards
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.