Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in IDoc AAE (Receiver) PI 7.3

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question