cancel
Showing results for 
Search instead for 
Did you mean: 

mapping issue

Former Member
0 Kudos

Hi Experts,

in message mapping, one field  (transdate-->datetransformation-->mapwithdefauld-->transactiondate), it shows successfull message in definition tab but it shows error in test tab.

Thanks,

thiru

Accepted Solutions (1)

Accepted Solutions (1)

anupam_ghosh2
Active Contributor
0 Kudos

Hi Thiru,

               Try this approach to pin point the exact cause of error

remove map with default from mapping. Check the error is still there or not.

If the error is still there then the format of input to the function datetrans function is not correct.

you need to correct it. If the error is removed then put mapwithdefault function before datetrans. In this case also you need to becareful with the format of default value being supplied to datetrans function.

Regards

Anupam

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Pls Check , if the value entered satisfies the expected format, probably this should be the problem here .......again its a guess

As Greg suggested, share more explanation abt your error, so that we can help you

Thanks,

Suji

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi Thiru,

You input data field transdate should have valid date with expected format , if formwat not correct obiously it throws error.

If souce field not mandatory then change mapping logic

transdate----->mapwithdefualt(00000000)---->DateTrans--->TRANSDATE.

Regards,

Raj

former_member184681
Active Contributor
0 Kudos

Hi Thiru,

When posting a question, always try to explain your problem in many details, otherwise it is very difficult for others to help you. Based on what you posted, I can only assume that the error can be caused by some incorrect or empty source field value, because of which the whole mappings fails (since DateTrans requires date as an input). But this is a guess...

Regards,

Greg

zameerf
Contributor
0 Kudos

what is the error in Test tab? can you share the screenshot?