cancel
Showing results for 
Search instead for 
Did you mean: 

Exception in Message mapping for JDBC -> XI-> file

Former Member
0 Kudos

Hi,

In the above scenario, Sender JDBC adapter has processed the message but when i checked the processed XML messages, its giving an error message with details

<i>During the application mapping

com/sap/xi/tf/_MM_XXXX_a

com.sap.aii.utilxi.misc.api.BaseRuntimeException

was thrown: RuntimeException in Message-Mapping

transformatio~</i>

how to make the source structure so that it gets correctly populated with the result set of sender JDBC adapter? Are there any constraints while making the Data type for the source structure?

Regards,

Nitin Aggarwal.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

The problem is solved...

Actually, the runtime system was not able to map the result set generated by the Sender JDBC adapter to the source structure of message mapping. This was because the result set has a particular structure and its like

<resultset>

<row>

<column1>value1</column1>

<column2>value2<column2>

</row>

</resultset>

To map this kind of structure to the source structure, a <b>row</b> element should always be there below the root node and the structure fields should be placed as sub elements to row. One more thing the root node of the source structure should be same as the document name specified in the sender JDBC adapter config.

Anyways, Thanks to all for the valuable efforts.

Regards,

Nitin.

Former Member
0 Kudos

Hi nitin,

Which mode are you using for this adapter e.g. XMB2DB_XML or XMB2DB, etc...?

And Can you please post a sample of the source structure?

Thanks.

peter_jarsunek
Participant
0 Kudos

Hi,

I have the same problem. I treid to create various Data Types, but i get always mapping error.

I tried simple string -> string conversion and also complex type (resultset-row-string -> row-string(since i know, that outbound File Adapter must receive the complex type of ROW (and it must be called "row"!)) conversion, but it doesn't work.

If someone knows the solutions of this issue, please let me know!

Thanx, Peter

Message was edited by: Peter Jarsunek

Former Member
0 Kudos

Hi,

Message Mapping BaseRuntime exception occurs in the following cases,

1. When the required Mandatory fields are not coming in the input file.

2. When required mandatory fields are NULL.

3. When executing message map with large data files.

etc etc etc..

I faced this problem with message mapping. With small data files it will work fine. But with large file it will throw baseruntime exception. Now we are using XSLT map now.

Thanks,

Sasi

MichalKrawczyk
Active Contributor
0 Kudos