Error in IDoc AAE (Receiver) PI 7.3

[Former Member]

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.

[marksmyth · Accepted solution]

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

[Former Member · Accepted solution]

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

[marksmyth]

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

[Former Member]

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

[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

[marksmyth]

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

[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.