SAP Knowledge Base Article - Preview

3345848 - EDI separator Receiver channel process error due to GS05 field with blank/null value

Symptom

  • In the production EDI file with blank/null value in GS05 (time) field cause EDI Separator receiver channel process error.
  • It can't parse EDI version from the file and therefore can't find corresponding EDI sender for downstream process.
  • This issue occurs in all EDI type set, limited to 821 V04010.
  • In XPI Example 50 you see below error

[EXCEPTION]
javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sap.com/converter~x12~x122xmlapp) Exception raised from invocation of public void com.sap.aii.converter.x12.x122xml.X12ToXMLBean.process(java.io.InputStream,java.io.OutputStream,com.sap.aii.b2b.edi.common.IInterfaceConfiguration,com.sap.aii.converter.x12.x122xml.interfaces.IX122XMLLogger,java.lang.String,boolean,java.lang.String,boolean,long,long,long,boolean,boolean,int,char,char,char,char) method on bean instance com.sap.aii.converter.x12.x122xml.X12ToXMLBean@3db9c6ac for bean sap.com/converter~x12~x122xmlapp*annotation|sap.com~converter~x12~x122xml.jar*annotation|X12ToXMLBean in application sap.com/converter~x12~x122xmlapp.; nested exception is: com.sap.aii.converter.x12.x122xml.X122XMLException: Table data may not confirm with incoming X12 document:Error while trying to check the existence of version and type combination/997.Failed to set the parameter 2 of the statement >>SELECT DISTINCT VERSION, SET_NAME FROM B2B_X12_DEF_MSG WHERE CTRL_KEY = ? AND VERSION = ? AND SET_NAME = ?<<: Cannot assign an empty string to a parameter with JDBC type >>VARCHAR<<.

Caused by: com.sap.sql.check.ValueCheckerException: Cannot assign an empty string to a parameter with JDBC type >>VARCHAR<<.


Read more...

Environment

Process Integration

SAP NetWeaver

Process Orchestration

Keywords

Error while trying to check the existence of version and type combination/997.Failed to set the parameter 2 of the statement, Process Integration, SAP NetWeaver, Process Orchestration , KBA , BC-XI-CON-B2B-MOD , EDI Modules - Plain Text, Archiving, etc. , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.