Mapping Problem

[Former Member]

Hi All..

Iam working on a scenario file to R/3. iam getting error message in sxmb_moni as "mapping exception dueing execute"..i checked the mapping in IR-->>Mapping test..the result message is:

Messages:

13:16:40 Start of test

Unparseable date: "06.04."

com.sap.aii.utilxi.misc.api.BaseRuntimeException: Unparseable date:

"06.04."

at

com.sap.aii.mappingtool.flib3.DateTransformer.convertDate(DateTransformer.ja

va:39)

at

com.sap.aii.mappingtool.flib3.DateTransformer.getValue(DateTransformer.java:

27)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:369)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.start(AMappingProgram.java:287)

at

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

at

com.sap.aii.mappingtool.tf3.AMappingProgram.execute(AMappingProgram.java:232

)

at

com.sap.aii.ibrep.server.mapping.ServerMapService.transformInternal(ServerMa

pService.java:432)

at

com.sap.aii.ibrep.server.mapping.ServerMapService.execute(ServerMapService.j

ava:170)

at

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

52)

at

com.sap.aii.ibrep.sbeans.mapping.MapServiceRemoteObjectImpl0.execute(MapServ

iceRemoteObjectImpl0.java:259)

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:2

94)

at

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

at

com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionPr

ocessor.java:119)

at

com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMes

sageListener.process(ApplicationSessionMessageListener.java:37)

at

com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run

(UnorderedChannel.java:71)

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

at

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

Root Cause:

java.text.ParseException: Unparseable date: "06.04."

at java.text.DateFormat.parse(DateFormat.java:335)

at

com.sap.aii.mappingtool.flib3.DateTransformer.convertDate(DateTransformer.ja

va:35)

at

com.sap.aii.mappingtool.flib3.DateTransformer.getValue(DateTransformer.java:

27)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:369)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.processNode(AMappingProgram.java

:387)

at

com.sap.aii.mappingtool.tf3.AMappingProgram.start(AMappingProgram.java:287)

at

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

at

com.sap.aii.mappingtool.tf3.AMappingProgram.execute(AMappingProgram.java:232

)

at

com.sap.aii.ibrep.server.mapping.ServerMapService.transformInternal(ServerMa

pService.java:432)

at

com.sap.aii.ibrep.server.mapping.ServerMapService.execute(ServerMapService.j

ava:170)

at

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

52)

at

com.sap.aii.ibrep.sbeans.mapping.MapServiceRemoteObjectImpl0.execute(MapServ

iceRemoteObjectImpl0.java:259)

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:2

94)

at

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

at

com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionPr

ocessor.java:119)

at

com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMes

sageListener.process(ApplicationSessionMessageListener.java:37)

at

com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run

(UnorderedChannel.java:71)

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

at

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

13:16:40 End of test

can anyone please help me out...

thanks in advance..

smith.

[moorthy · Accepted solution]

HI,

As it tells that there is a date value which is not able parse .So there is some problem with date value format. check this Are you using any user defined functions ?

For better debugging, you can check the Display Queue option the Message Mapping in the IR. So that you can check each input values

Check the input xml . Is this is a valid xml ? this you can check by saving into notepad with .xml and open in the browser .. Also you can make use of XML editors.

REgards,

Moorthy

[Former Member · Accepted solution]

Hi,

Does ur input file reach the XI server? What is ur receiver adapter type?

Try giving the date in format yyyy-mm-dd ie 2006-07-20.

Regards,

Jai Shankar

Message was edited by: Jai Shankar

[Former Member]

Thanks to all of you guys.

My Problem has been solved.

Regards,

Smith.

[Former Member]

Hi All,

Thanks for your prompt response.

After changing the time..it is working properly..still iam getting the message like:

13:54:27 Start of test

Cannot produce target element /ns29:MT_xxxxx. Check xml instance

is valid for source xsd and target-field mapping fulfills requirements of

target xsd

13:54:27 End of test

[moorthy]

Hi,

As I mentioned in my earlier reply, have a look into xml is valid or not ?

And check all the nodes/segments are mapped correctly .

Check this.. Compare this with Source xml and target xml.

Regards,

moorthy

[Former Member]

Hi All,

Thanks for your prompt response.

After changing the time..it is working properly..still iam getting the message like:

13:54:27 Start of test

Cannot produce target element /ns29:MT_xxxxx. Check xml instance

is valid for source xsd and target-field mapping fulfills requirements of

target xsd

13:54:27 End of test

[Former Member]

Hi paul,

This is the problem with mapping fields on the target side. Did you map the header field with source message type ? Just check your mapping .

Sekhar

[Shabarish_Nair]

some checks u can do;

1. check if your Source XML is well formed

2. set for Trace level and check where exactly it is failing.

3.Check the target's root node to see if it is mapped correctly

4. try checking with the display queue option too ..

[Former Member]

Hi ,

<i>Unparseable date:

"06.04."</i>

this is due to some date transormations problem.Try with correct format dd.mm.yyyy or mm.dd.yyyy

Thanks,

sekhar