Solved: ERROR IN MAPPING

Hi,

we are trying to send sap-hr details to third party database (oracle)tool.Actually we have one function module.we ever excute this it sendes the data to third party tool.but we try to send the data throw sap-xi.In side the function module they write sourcode also.When excute this function module it sends the data to third party.Actually ,i'm not use directly the function module in xi.So i write one own function module and assign same database table can assign in my function module.I called this function module in abap editor and i write some code and execute it.It send the data from sap to xi.BUt In mapping it shows EXCEPTION_DURING_EXECUTE.java.lang.NullPointerException.And data has comming suppress and some field have no data.some fields are empty.How it happend pls help me.ANY other way to access same function module in xi,because sender side i'm using RFC adapter.

It follws in background task destions.

any other way to access function module in xi.pls help me.

<?xml version="1.0" encoding="UTF-8" ?>

- <rfc:ZHR_SAP_INTRA xmlns:rfc="urn:sap-com:document:sap:rfc:functions">

- <SAPTOINTRA>

- <item>

<EMP_DOJ>02734001Mr</EMP_DOJ>

<EMP_FIRST_NAME>131.10.</EMP_FIRST_NAME>

<EMP_MIDDLE_NAME>V Sri04</EMP_MIDDLE_NAME>

<EMP_LAST_NAME />

<EMP_SEX />

<EMP_DOB />

<EMP_MARITAL_STAT />

<P_NAMEINPASSPORT />

<FSM_TYPE />

<EMP_BANK_ID />

<EMP_BANK_AC_CODE />

<ADD_BANK_NAME />

<ADD_BANK_ACNO />

<ADD_BANK_SORTCOD />

<APPR_DOJ />

<EMAILID>00100038 0000000000.0% INR Consultant 0400000142</EMAILID>

<EMRG_TEL_ONSITE />

<EMRG_TEL_OFSHORE />

<MOBILE_NUMBER />

<P_PASSPORTNO />

<P_NATIONALITY />

<P_PLACEOFISSUE />

<P_DATEOFISSUE />

<P_DATEOFEXPIRY />

<PAN_NUMBER />

<LAST_COMPANY />

<LAST_EMPID>00000000</LAST_EMPID>

<REL_SKILL_EXP />

<YEARLY_CTC>0</YEARLY_CTC>

<SAL_VERSION />

<DATE_RESIGN />

<DATE_RELIEV />

</item>

- <item>

<REASON>er applicant data 514.11</REASON>

<EMP_DOJ>02731001Mr</EMP_DOJ>

<EMP_FIRST_NAME>108.02.</EMP_FIRST_NAME>

<EMP_MIDDLE_NAME>Test</EMP_MIDDLE_NAME>

<EMP_LAST_NAME />

<EMP_SEX />

<EMP_DOB />

<EMP_MARITAL_STAT />

<P_NAMEINPASSPORT />

<FSM_TYPE />

<EMP_BANK_ID />

<EMP_BANK_AC_CODE />

<ADD_BANK_NAME />

<ADD_BANK_ACNO />

<ADD_BANK_SORTCOD />

<APPR_DOJ />

<EMRG_TEL_ONSITE />

<EMRG_TEL_OFSHORE />

<MOBILE_NUMBER />

<P_PASSPORTNO />

<P_NATIONALITY />

<P_PLACEOFISSUE />

<P_DATEOFISSUE />

<P_DATEOFEXPIRY />

<PAN_NUMBER />

<LAST_COMPANY />

<LAST_EMPID>00000000</LAST_EMPID>

<REL_SKILL_EXP />

<YEARLY_CTC>0</YEARLY_CTC>

<SAL_VERSION />

<DATE_RESIGN />

<DATE_RELIEV />

</item>

- <item>

<REASON>er applicant data 114.11</REASON>

<EMP_DOJ>02731001Mr</EMP_DOJ>

<EMP_FIRST_NAME>112.03.</EMP_FIRST_NAME>

<EMP_MIDDLE_NAME>Test 01</EMP_MIDDLE_NAME>

<EMP_LAST_NAME />

<EMP_SEX />

<EMP_DOB />

<EMP_MARITAL_STAT />

<P_NAMEINPASSPORT />

<FSM_TYPE />

<EMP_BANK_ID />

<EMP_BANK_AC_CODE />

<ADD_BANK_NAME />

<ADD_BANK_ACNO />

<ADD_BANK_SORTCOD />

<APPR_DOJ />

<EMRG_TEL_ONSITE />

<EMRG_TEL_OFSHORE />

<MOBILE_NUMBER />

<P_PASSPORTNO />

<P_NATIONALITY />

<P_PLACEOFISSUE />

<P_DATEOFISSUE />

<P_DATEOFEXPIRY />

<PAN_NUMBER />

<LAST_COMPANY />

<LAST_EMPID>00000000</LAST_EMPID>

<REL_SKILL_EXP />

<YEARLY_CTC>0</YEARLY_CTC>

<SAL_VERSION />

<DATE_RESIGN />

<DATE_RELIEV />

</item>

- <item>

<REASON>er applicant data 114.11</REASON>

<EMP_DOJ>02731001Mr</EMP_DOJ>

<EMP_FIRST_NAME>112.03.</EMP_FIRST_NAME>

<EMP_MIDDLE_NAME>Test</EMP_MIDDLE_NAME>

<EMP_LAST_NAME />

<EMP_SEX />

<EMP_DOB />

<EMP_MARITAL_STAT />

<P_NAMEINPASSPORT />

<FSM_TYPE />

<EMP_BANK_ID />

<EMP_BANK_AC_CODE />

<ADD_BANK_NAME />

<ADD_BANK_ACNO />

<ADD_BANK_SORTCOD />

<APPR_DOJ />

<EMRG_TEL_ONSITE />

<EMRG_TEL_OFSHORE />

<MOBILE_NUMBER />

<P_PASSPORTNO />

<P_NATIONALITY />

<P_PLACEOFISSUE />

<P_DATEOFISSUE />

<P_DATEOFEXPIRY />

<PAN_NUMBER />

<LAST_COMPANY />

<LAST_EMPID>00000000</LAST_EMPID>

<REL_SKILL_EXP />

<YEARLY_CTC>0</YEARLY_CTC>

<SAL_VERSION />

<DATE_RESIGN />

<DATE_RELIEV />

</item>

- <item>

<REASON>er applicant data 114.11</REASON>

<EMP_DOJ>02504001Mr</EMP_DOJ>

<EMP_FIRST_NAME>108.02.</EMP_FIRST_NAME>

<EMP_MIDDLE_NAME>US 1 04</EMP_MIDDLE_NAME>

<EMP_LAST_NAME />

<EMP_SEX />

<EMP_DOB />

<EMP_MARITAL_STAT />

<P_NAMEINPASSPORT />

<FSM_TYPE />

<EMP_BANK_ID />

<EMP_BANK_AC_CODE />

<ADD_BANK_NAME />

<ADD_BANK_ACNO />

<ADD_BANK_SORTCOD />

<APPR_DOJ />

<EMRG_TEL_ONSITE />

<EMRG_TEL_OFSHORE />

<MOBILE_NUMBER />

<P_PASSPORTNO />

<P_NATIONALITY />

<P_PLACEOFISSUE />

<P_DATEOFISSUE />

<P_DATEOFEXPIRY />

<PAN_NUMBER />

<LAST_COMPANY />

<LAST_EMPID>00000000</LAST_EMPID>

<REL_SKILL_EXP />

<YEARLY_CTC>0</YEARLY_CTC>

<SAL_VERSION />

<DATE_RESIGN />

<DATE_RELIEV />

</item>

</SAPTOINTRA>

</rfc:ZHR_SAP_INTRA>

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Ravi,

If I copy and paste your posted XML document into an XML editor, I can see a weird character in one of the EMAILID field, that may cause your not well formed XML exception ... Can you try to manually remove this char and retry the mapping ?

Rgds

Chris

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Answers (3)

Hi,

I think in SXMB_MONI you copied message directly from that message window, it will also copy '-' at the starting of each tag. I would suggest you to copy message as follows:

Right click on your message --> View Source ---> Now copy message from that.

And now put this message in IR mapping test tab.

Regards,

Sami.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Check the mapping and test the mapping in XI system using the same payload from SXMB_MONI.

Have you made the occurrence of fields as 1:1. If so then this error will come.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Ravi,

Did you tried copying the data from the SXMB_MONI input and test it in the mapping directly inside the Repository.

If not that would be the start step for you. If it fails then check your mapping in the IR. It can be either way that the mapping is not correct or the data coming in is not in the form that mapping expects.

This will resolve your issue.

I hope you are aware of how to do this.

Go to SXMB_MONI and select the failed message. Copy the payload from the inbound message and put it in the mapping in the IR. noe run test

-Kulwant

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hi,

I import the error message in to the message mapping,but it shows ,XML not well-formed.

when ever excute the mapping it shows

java.lang.NullPointerException

#74 01:38:20 [AWT-EventQueue-0] ERROR com.sap.aii.utilxi.swing.toolkit.ExceptionDialog: Throwable

Thrown:

MESSAGE ID: com.sap.aii.ib.core.mapping.exec.ExecuteException

com.sap.aii.ib.core.mapping.exec.ExecuteException: java.lang.NullPointerException

at com.sap.aii.ibrep.server.mapping.ServerMapService.transformInternal(ServerMapService.java:477)

at com.sap.aii.ibrep.server.mapping.ServerMapService.execute(ServerMapService.java:169)

at com.sap.aii.ibrep.sbeans.mapping.MapServiceBean.execute(MapServiceBean.java:52)

at com.sap.aii.ibrep.sbeans.mapping.MapServiceRemoteObjectImpl0.execute(MapServiceRemoteObjectImpl0.java:301)

at com.sap.aii.ibrep.sbeans.mapping.MapServiceRemoteObjectImpl0p4_Skel.dispatch(MapServiceRemoteObjectImpl0p4_Skel.java:146)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:320)

at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:198)

at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:129)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

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:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Serialized server exceptions:

MESSAGE ID: java.lang.NullPointerException (serialized)

java.lang.NullPointerException: java.lang.NullPointerException

at com.sap.aii.mappingtool.tf3.AMappingProgram.exceptionCaught$(AMappingProgram.java:59)

at com.sap.aii.mappingtool.tf3.Transformer.checkParserException(Transformer.java:182)

at com.sap.aii.mappingtool.tf3.Transformer.start(Transformer.java:170)

at com.sap.aii.mappingtool.tf3.AMappingProgram.execute(AMappingProgram.java:102)

at com.sap.aii.ibrep.server.mapping.ServerMapService.transformInternal(ServerMapService.java:431)