Skip to Content

Issue with Fixed value mapping

Dear Experts,

I am stuck in a mapping situation as explained below and need your help for resolution.

Mapping in contention is as shown below :

posting issue1.png

As per this mapping the Substring should throw 3 character word and in fix value mapping it is getting displayed correctly. The fix value mapping is as shown below:

posting issue2.png

queue result of Substring function in mapping :

posting issue3.png

Queue Result for Fix Value mapping :

posting issue4.png

Till this point every thing looks fine but when I clicked on the Queue of the Target field it throws out the error as:

posting issue5.png

Here it clearly shows that output of the key in fix value mapping is null, which contradicts the result of fix value mapping queue.

Please let me know if any one else has faced this issue before or if you have any idea for the resolution of this issue.

Thanks and Regards,

Sudhir Kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jun 06, 2012 at 02:18 PM

    You can easilyu find the issue, PR_ not maintained in the Fix value list hence it is thowring an error.

    this kind os situation you have 3 options

    1)Throwing an exception

    2)sending default value.

    3)Maintain key and value for PR_

    decision is up to you.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2012 at 02:11 PM

    Hi Sudhir,

    Hope i have understand the requirement correctly/

    As shown above in the screen shots of Fixed value mapping

    there are only three keys

    1) SA_

    2) FA_

    3) IT_

    but the output of the sub string function resulting PR_

    which is not present in the Fixed value mapping as a key

    try to maintain the key value pair in fixed value mapping for

    key = PR_

    value = Procurement

    so when ever the sub string results the output as PR_ then Procurement will be passed to the Target element.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2012 at 02:12 PM


    When you check the Fix Values settings, what is your setting for Behaviour if Lookup Fails? If you are using Throw Exception, try changing it to one of the other options and see what happens.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2012 at 02:28 PM

    Just Few cents... This is mere data discrepancy issue. I would recommend to sync/update the fix value records always. This problem could populate always with different values that comes from sender side... You might get a different string in the future like this. Go with atleast default value to take care this issue.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.