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.
SAP Knowledge Base Article - Preview