on 04-14-2016 12:37 PM
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
Hi Nunu,
Check also this note 1688780 - IDoc AAE Adapter fails to insert empty strings in database
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nunu,
Check this note is applicable to your system 1752729 - Cannot assign a blank-padded string
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Helo Nunu,
Have you maintained correct partner profile/Port in the ECC system?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.