cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping Error due to insert count return structure

former_member6134
Participant
0 Kudos

Hello Experts,

    I am working on a scenario Client Proxy-> PI--> MSSQL Database. When we are executing the scenario at the ECC end and sending the data from ECC to MSSQL Database. The Data is going fine , but in the response it is sending the following return structure from the MSSQL side.

- <STATEMENT_response>

<insert_count>10</insert_count>

</STATEMENT_response>

</ns0:MT_TIL_CREDIT_NOTE_response>

Since it is an asynchronous scenario I am not expecting anything in return, but because it is receiving the above insert count value from the MSSQL side, it is not able to find the mapping structure in PI. Therefore it is throwing an error :

NO_MAPPINGPROGRAM_FOUND

Mapping program is not available in runtime cache: Object ID FD22F649D9FE3413BBF4ADAA544F56BC Software Component 382D9200DE4011E2C7F7F0C40A64D96A

How do I overcome such errors in this case?

Pls help.

Thanking You

With Best Regards

Suk4023

Accepted Solutions (0)

Answers (2)

Answers (2)

zameerf
Contributor
0 Kudos

Are you sure your inbound message interface for JDBC is set as async?

ambrish_mishra
Active Contributor
0 Kudos
former_member6134
Participant
0 Kudos

Hi Ambrish,

   Thx for your reply , but in my case it is purely asynchronous scenario. The response structure I haven't configured in either of the interfaces..

Thanks

Regards

Suk4023

ambrish_mishra
Active Contributor
0 Kudos

Hi Suk4023,

this is how I would handle this.

create a dummy file receiver, map the response to a dummy file structure and dump the file on PI application server in NFS mode. Ignore the file...

Hope it answers your question.

Ambrish