JDBC to IDoc Mapping Problem

[Former Member]

Hello,

I have a connection going from a SQL (via a JDBC connection), mapping into an IDOC. Connections all work, but for some reason when I turn on the communication channel to pull from the database through a SELECT statement, I only get the header of the Idoc (below). I have tried many different things and cannot see why the mapping does not seem to be working. When I load the test data as a test instance in the mapping, it works. Any help would be appreciated.

Thank you.

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

<CRMXIF_PRODUCT_MATERIAL_SAVE01 />

[Former Member · Accepted solution]

Hi Carley...

Could you check the structure of the message type that you are ussing in your outbound interface? This happends to me once because the structure of the resultset that the JDBC driver gave to XI wasn't the same that was using the Outbound interface.

I hope that this will help with your problem

Hector

[Former Member · Accepted solution]

Hi Hector,

Yes, the result set has the correct same structure as in the outbound interface...

[Former Member · Accepted solution]

the Document Name should be "resultset" in the configuraiton, correct? Does the document namespace need to be filled in? I have <TEST> in the Update field. Is that correct?

Thank you very much!

[ranjit_deshmukh · Accepted solution]

Hi Carley,

didi u try copying this message in the mapping and tested it?

please see whether u are getting a proper xml when u hit grid button.

and then please run the test.

the problem is in your mapping i guess.

moreover please see to it that if you are including the namespace in the message type it is must to mention it in the adapter(JDBC) also there is nothing wrong in the name "resultset".

Ranjit

[bhavesh_kantilal · Accepted solution]

Carley,

In your Sender JDBC adapter, the Document Name should be the Name of the Message Type you have created in the Integration Repository.

Document Namespace should be the namespace ion which the message type is available.

Make this change in the Sender JDBC adapter and it willwork fine.

Regards

Bhavesh

[Former Member · Accepted solution]

Carley,

plese fill the Document name and Document namespace as speicifed by bhavesh