Value mapping doesn working for some record.

[Former Member]

Hi All,

We have implemented mass value mapping replication...

which was working fine

but recently we are facing a strange issue ... in Q environment....

value mapping is not executing for some messages....

in runtime cache value exist....

for same source value... most of the time.... PI is picking target value....

but suddenly it misses the target value .. and gives same value as source .. ...

when we test in message mapping..... value mapping is executing....

it seems... for a moment cache.. is disapperaing...

Have anyone faced this issue...

Pleas egive some input....

[Former Member · Accepted solution]

Hi,

There could be 3 things for this problem in my opinion.

1. In your Message Mapping check if you have given the correct Agency & Schema.

2. Make sure data is proper, even a single space (which is not visible) can also lead to wrong results.

3. Clear the SLD Data Cache from Environment in your Integration directory.

Regards,

Sarvesh

[Former Member · Accepted solution]

Hi Sarvesh,

+1. In your Message Mapping check if you have given the correct Agency & Schema. +

its correct, otherwise how .. for some files its providing the target value

2. Make sure data is proper, even a single space (which is not visible) can also lead to wrong results.

space is not coming... even we have used trim function ...before executing the VM...

3. Clear the SLD Data Cache from Environment in your Integration directory.

done

[Former Member · Accepted solution]

Give a try after refreshing CPACache.

[abhay_rajhans2 · Accepted solution]

Hi Biplab,

space is not coming... even we have used trim function ...before executing the VM...

Please check the value mapping entries maintained. If that value's having space may result in to same problem

[Former Member]

Are you sure that there is a mapping provided for the incoming values for the messages which you mentioned as 'missed value mapping' ?

Value mapping will pass out the source values to target if there is no mapping found for the value. Whereas the 'FixValues' function in message mapping will pass the 'default' value to target.

[Former Member]

Hi All,

Today evening we found that... this issue... is only in Q environment......

in D environment we are not facing any issue......

We tested like below...

in D
20 Idocs sent... with same source Value for all Idoc..
value mapping worked properly for all records....

in q

20 SAME As above docs sent... with same source Value for all Idoc..
value mapping worked for 10 IDoc... 

again same 20 record sent....
and this time value mapping worked only for 7 idocs

again same 20 record sent....
and this time value mapping worked only for 9 idocs

when we seen the Java engine log.. its .. saying.... data incosistency found for the source value ____ ...

[Former Member]

Also... it seems... its working correctly for old values.............i mean that are uploaded in VM table long before...

but.. its giving issue particularly... with new va;ues uploaded...

[Former Member]

If you have added the new value in the same group then please check again carefully there will be something inconsistant, may be you added the same entry again which is quite possible.

[Former Member]

Hi Sarvesh and all,

Thanks for your thinking.... but we have double checked everything...

and we can't upload same entry again... the report which uploads entry into ECC table will not allow to have double entry...

moreover , in runtime cache its having only 1 value...

we noticed the following recently:-

For some interface we are using the VM-standerd function. and some interface we have used UDF to perform the value mapping and

1) observation 1.

in Q.. interfaces which have used UDF.. are working fine for both new and old values ( uploaded long back).

2) observation 2.

in Q.. interfaces which have used VM-standerd function.. are working fine old values ( uploaded long back) only.. and not for

new values( mean to say.... some time s work and sometime not)....

3) Q is a cluster system wheareas D is on single instance...

Experts.. any thought......

Regrdas

Biplab..

[Former Member]

Hi All,

The issue has been solved.

Our Quality system is a cluster system and it has 2 node. Basis found out for 1 of the node profile parameters were not maintained correctly.So whenever control went to 2nd node. vaue mapping falied.....

Now all are working fine.

Thanks all !

[monicabhosale]

Hi,

I am also facing same issue .value mapping working on Q but not on P.

Can you please tell me where did u cheked that cluster node and what i need to do to resolve this issue.

Thanks in advance

Regards

Monica

[Former Member]

FYI... the trace is saying...

Key mapping from [context,source Agency,Source Sceme] to [context,Target Scheme,Target Agency] 
has not been performed