cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping Errors in XI

Former Member
0 Kudos

Hello,

I have got the following errors in SXMB_MONI tcode.

The details of the error messages which I found from Trace of XML messages given below:

+Trace level="1" type="T">Interface Mapping http://capgemini.com/bc/SRM/OA/Receipts Imap_BAPI_CONFEC_XML_INTERNAL_SEND_2_XMLSQLInsert</Trace>+

<Trace level="1" type="T">** APPLICATION TRACE TRUNCATED (for more details see LogViewer)**</Trace>

<Trace level="1" type="T">Java mapping com/capgemini/bc/mappings/receipt/BAPI_CONFEC_XML_INTERNAL_SEND_2_XMLSQLInsert has thrown a StreamTransformationException.</Trace>

<Trace level="1" type="T">com.sap.aii.mapping.api.StreamTransformationException: execute(): BAPI_CONFEC_XML_INTERNAL_SEND to MT_XMLSQL_RECEIPT_INSERT java mapping failed : getShipmentReferences(): no record found for SELECT RSL.SHIPMENT_HEADER_ID,RSL.SHIPMENT_LINE_ID,RSL.ATTRIBUTE10,RSL.PO_LINE_LOCATION_ID,RSL.QUANTITY_RECEIVED FROM RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND RSL.PO_HEADER_ID = 17421 AND RSL.PO_LINE_ID = 22068 AND RSH.RECEIPT_NUM = 4000319210 AND (RSL.ATTRIBUTE10 = '0000000001' OR RSL.ATTRIBUTE10 = LTRIM('0000000001', '0')) in NPROD at com.capgemini.bc.mappings.receipt.BAPI_CONFEC_XML_INTERNAL_SEND_2_XMLSQLInsert.execute(BAPI_CONFEC_XML_INTERNAL_SEND_2_XMLSQLInsert.java:471) at com.sap.aii.ibrun.server.mapping.JavaMapping.executeStep(JavaMapping.java:64) at com.sap.aii.ibrun.server.mapping.Mapping.execute(Mapping.java:92) at com.sap.aii.ibrun.server.mapping.MappingHandler.run(MappingHandler.java:90) at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleMappingRequest(MappingRequestHandler.java:95) at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleRequest(MappingRequestHandler.java:68) at com.sap.aii.ibrun.sbeans.mapping.MappingServiceImpl.processFunction(MappingServiceImpl.java:79) at com.sap.aii.ibrun.sbeans.mapping.MappingServiceObjectImpl0_0.processFunction(MappingServiceObjectImpl0_0.java:131) at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187) at $Proxy151.processFunction(Unknown Source) at sun.reflect.GeneratedMethodAccessor598.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:107) at com.sap.engine.services.rfcengine.RFCJCOServer.handleRequestInternal(RFCJCOServer.java:113) at com.sap.engine.services.rfcengine.RFCJCOServer$ApplicationRunnable.run(RFCJCOServer.java:157) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172) Root Cause: java.lang.RuntimeException:

Repeatedly the above errors are persist in the trace section.

Please help me out.

Thanks in advance,

Sandip Adhikary.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello Sandeep,

One can figure out the error while going thro' the trace. SQL Exception has occured because no record has been found in the lookup in the method getShipmentReferences().

Check, what is going wrong there in the method.

Regards,

Shri

former_member859847
Active Contributor
0 Kudos

Hi,

It was clearly saying java mapping error.

it was unable to reerive data using that 'BAPI'

if you check the log,clearly saying that

no record found for SELECT RSL.SHIPMENT_HEADER_ID,RSL.SHIPMENT_LINE_ID,RSL.ATTRIBUTE10,RSL.PO_LINE_LOCATION_ID,RSL.QUANTITY_RECEIVED FROM RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND RSL.PO_HEADER_ID = 17421 AND RSL.PO_LINE_ID = 22068 AND RSH.RECEIPT_NUM = 4000319210 AND (RSL.ATTRIBUTE10 = '0000000001' OR RSL.ATTRIBUTE10 = LTRIM('0000000001', '0')) in NPROD

i request you to test the BAPI in ECC at se37 t.code

by providing inputs as -PO_HEADER_ID = 17421, RSL.PO_LINE_ID = 22068 , RSH.RECEIPT_NUM = 4000319210 , (RSL.ATTRIBUTE10 = '0000000001' OR RSL.ATTRIBUTE10 = LTRIM

warm regards

mahesh.

Former Member
0 Kudos

Dear Sandip,

Based on my understanding, It is throwing Java mapping error, I hope you are using the same in your Scenraio.

Please check the your Java mapping in your sceanrio.

And also it is throwing the error at StreamTransformation.

check whether u have imported necessary library files in to your Java code. If it is loaded correctly, then check you have imported the same or not. if it is imported check whether it is used as per the standards.

Best Regards

Praveen K

santhosh_kumarv
Active Contributor
0 Kudos

Hi,

Was your Java Mapping executed sucessfully when it was tested either in NWDS or in IR...?

This issue might be because of the Data..

Thanks

SaNv...

Former Member
0 Kudos

HI,

Check with this link.

- File to File Part 1

- File to File Part 2

- Using ABAP XSLT Extensions for XI Mapping

Thanks,

Sendil