Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 22, 2012 at 03:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I am experiencing the same issue.

      Turning off Idoc monitoring made it disapeared.

      Could you confirm that it is the same issue that SAP is working on ?

      Regards,

      JB.

      Edited by: JB CABIRO on Feb 24, 2012 4:33 PM

  • Feb 28, 2012 at 11:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2012 at 12:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Feb 22, 2012 at 01:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mark,

      Currently we are on SP level5.

      Version

      Service Pack:05

      Release:NW730EXT_05_REL

      Could you please give me more information on this.

      Thanks.

      Best Regards,

      Sugeet.