Value Mapping Cache Issue

[Former Member]

Hello Experts,

We are facing a specular issue in our Production System. Some of the PI messages are getting failed due to not finding values for value mappings from PI runtime value mapping cache. We are able to see the values exist in cache but PI messages are unable to retreive them at runtime and fails.

Strange if i reprocess some of the messages are getting success but some of them are not....

com.sap.aii.mappingtool.tf7.MessageMappingException: Runtime exception when processing target-field mapping /CRMXIF_PRODUCT_MATERIAL_SAVE02/IDOC/E101COMXIF_PRODUCT_MATERIAL/LOGSYS; root message: No value found for 'APPLICATION_SYSTEM_R3_SP1' at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:443) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:395) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:395) at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode

1. com.sap.aii.mapping.value.api.ValueMappingException: An error occurred during the value mapping of context = http://sap.com/xi/XI, agency = SAP_R3, scheme = SALES_R3, and value = SDUS to context http://sap.com/xi/XI, agency = SAP_CRM, and scheme = SALES_CRM (data inconsistent) at com.sap.aii.ibrun.server.valueMapping.ValueMappingService.execute(ValueMappingService.java:157) at com.sap.aii.ibrun.server.valueMapping.ValueMappingService.executeMapping(ValueMappingService.java:67) at com.sap.aii.mapping.value.api.XIVMService.executeMapping(XIVMService.java:30) at com.sap.aii.mappingtool.flib7.ValueMapping.getValue

We are receiving the above error message in Moni of PI.

Please let us know if any one of you have already faced this kind of issues?

thanks-

Ramesh.

[zameerf · Accepted solution]

Hi Ramesh,

Recently we faced a similar behavior of one of the interface, but our issue was with RFC Lookup response, some times it was getting back correct response and some times an incorrect value. A cache refresh solved the issue. May be you can try to do a cache refresh of PI system and see if that helps.

You can refer below blog to get some idea about cache refresh, the blog has lost its formatting, but still you can search for the text 'value mapping group cache' to see what can be done.

http://scn.sap.com/people/sylvia.xiong/blog/2010/03/09/hints-about-pi-runtime-cache-refresh

Regards,

Zameer

[Former Member]

Dear Ramesh,

I am facing the exact same problem in my PI. Did you find a solution?

Regards

Jenny

[Former Member]

Hi Ramesh,

As this is a temporary issue, there may be some cache issue. Just refresh the cache and reprocess the message again.

Step:

On the Runtime tab page, choose Cache overview under the heading Administration of Locks and Caches.

Select the value:

•Value Mapping Group Cache or

•Value Mapping Value Cache

If you choose Refresh Cache, the cache is refreshed immediately.

The Partial Cache Refresh refreshes change lists with the status new, in work or failed.

The Single Repository Object Cache Refresh can refresh: Mapping, XI_TRAFO, TRAFO_JAR, RepBProcess and AdapterMetaData.

Regards,

Sagarika