7 Replies Latest reply: Feb 28, 2012 12:59 PM by Mark Smyth RSS

Error in IDoc AAE (Receiver) PI 7.3

SUGEET PATINGE
Currently Being Moderated

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.

  • Re: Error in IDoc AAE (Receiver) PI 7.3
    Mark Smyth
    Currently Being Moderated

    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

  • Re: Error in IDoc AAE (Receiver) PI 7.3
    Mark Smyth
    Currently Being Moderated

    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

  • Re: Error in IDoc AAE (Receiver) PI 7.3
    Currently Being Moderated

    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

    • Re: Error in IDoc AAE (Receiver) PI 7.3
      SUGEET PATINGE
      Currently Being Moderated

      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

  • Re: Error in IDoc AAE (Receiver) PI 7.3
    Mark Smyth
    Currently Being Moderated

    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

Actions