JDBC to Idoc Mapping error

[Former Member]

Hi all,

i need help for my JDBC to IDoc-scenario.

I Select some data from the db and everything is fine.

Before the mapping I can see all in the payload, but after mapping only the constants were mapped.

Hope someone can help me.

Regards,

Jörg

[Former Member · Accepted solution]

Hi ,

<i>Before the mapping I can see all in the payload, but after mapping only the constants were mapped.</i>

Make sure that all the manadatory fields of your target IDOC and the root elements are correctly mapped.Check the test mapping with payload of SXMB_MONI in message mapping.

/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Sekhar

[Former Member]

Thank you all for your help.

I had copied the data Type and forgot to change the XML namespace for the DataType.

Silly Error, but bothered me an nearly an hour.

Thanks again, it is solved.

Greetings

Jörg

[Former Member]

Hi ,

Please provide the mapping details in src mode.

Please check these points -

1) each row of the DB is set to one recursive segment of IDOC .

2)Check wether you have set all the Mandatory fields of IDOC .

Test the mapping in test Tab of mappiung using payload message in MONI ...

Regards,

Nanda

[Former Member]

Hi Jörg,

make sure that the parent nodes of the elements, that re mapped to constants, are also mapped.

Regards Mario

[bhavesh_kantilal]

Hi,

Check the incoming payload in MONI if all rows of the DB are available and then test your mapping program with the same payload.

Make sure you have given a valid Document Name and Document Namespace in your Sender JDBC adapter.

Regards,

Bhavesh

[Former Member]

Hi,

Have you tried testing your map using the payload as input ?

Does this work or is an error thrown ?

Also, check the correct map is configured in your interface determination.

Cheers

Colin.