AAE_IDOC ERROR

[former_member190284]

Hi Experts,

I am trying to test idoc to file scenerio but facing with issue.

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 ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )<VARCHAR<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 ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )<VARCHAR<IDoc: Error while processing the received messagecom.sap.aii.af.idoc.exception.IDOCAdapterException: com.sap.sql.log.OpenSQLException: Failed to set the parameter 14 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 a blank-padded string to a parameter with JDBC type >>VARCHAR<<.

I have inserted all the values in the ESR as in port, and all control fields. Morover mapping looks fine in ESR test tab

Can anyone help me in rectifying the issue?

Thanks

[iaki_vila]

Hi Nunu,

Check also this note  1688780 - IDoc AAE Adapter fails to insert empty strings in database

Regards

[former_member182412]

Hi Nunu,

Check this note is applicable to your system 1752729 - Cannot assign a blank-padded string

Regards,

Praveen.

[former_member186851]

Helo Nunu,

Have you maintained correct partner profile/Port in the ECC system?