Topic
3 replies Latest Post - ‏2012-02-03T07:23:08Z by SudhanshuSawlani
SudhanshuSawlani
SudhanshuSawlani
8 Posts
ACCEPTED ANSWER

Pinned topic Map failing and no trace generated on Mainframe

‏2012-01-31T09:10:36Z |
Hello

We are facing a strange issue in which a map after amendment, when ran on PC is working fine and generating the Trace file; however, the same map (.mvs) when ported on Mainframe(Zos) fails and no Trace is generated.

This is very clear that before these changes the map (.mvs) ran fine on mainframe as well. That means, issue is with the new change. But, what exactly? cant figure out, because no trace is generated.

Map change details:

Before:
=EITHER(
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "AMNT" , "Amount") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "VCHR" , "Voucher Total") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NARR" , "Narration/Inv No") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DCDT" , "Details") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DESC" , "Description") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DATE" , "Date") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "TDSA" , "TDS/Deduction Amount") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NAMT" , "Net Amount"),
"Reference Type")

After:
=EITHER(
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "AMNT" , "Amount") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "VCHR" , "Voucher Total") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NARR" , "Narration/Inv No") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DCDT" , "Details") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DESC" , "Description") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DATE" , "Date") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "TDSA" , "TDS/Deduction Amount") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NAMT" , "Net Amount") ,
IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) "IAMT" , "Invoice Amount") ,
"Reference Type" )

Version of WTX: IBM WTX v 8.1 Build 22; we also tried Build 144.

Please let me know if any more information is needed.

Kind regards
Sudhanshu.
Updated on 2012-02-03T07:23:08Z at 2012-02-03T07:23:08Z by SudhanshuSawlani
  • FormerBuckeye
    FormerBuckeye
    25 Posts
    ACCEPTED ANSWER

    Re: Map failing and no trace generated on Mainframe

    ‏2012-01-31T14:54:45Z  in response to SudhanshuSawlani
    I don't know if this is causing your problem, but format wise, in the highlighted after statement, you are missing an equal sign before "IAMT".
    • SudhanshuSawlani
      SudhanshuSawlani
      8 Posts
      ACCEPTED ANSWER

      Re: Map failing and no trace generated on Mainframe

      ‏2012-02-01T12:14:01Z  in response to FormerBuckeye
      Hello mate

      Thank you for the reply.

      That's just a typo here.

      Before:
      =EITHER(
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "AMNT" , "Amount") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "VCHR" , "Voucher Total") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NARR" , "Narration/Inv No") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DCDT" , "Details") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DESC" , "Description") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DATE" , "Date") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "TDSA" , "TDS/Deduction Amount") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NAMT" , "Net Amount"),
      "Reference Type")

      After:
      =EITHER(
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "AMNT" , "Amount") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "VCHR" , "Voucher Total") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NARR" , "Narration/Inv No") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DCDT" , "Details") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DESC" , "Description") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DATE" , "Date") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "TDSA" , "TDS/Deduction Amount") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NAMT" , "Net Amount") ,
      IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "IAMT" , "Invoice Amount") ,
      "Reference Type" )

      Also, I would like to know, if there is any limit on number of functional maps or any item in the map, which could cause such problem. I know, this is a wierd question, but my concern is because this map is very huge and the size of MVS is also larger than the normal ones.

      Is there any kind of limitation on the map or mvs?

      Kind regards
      Sudhanshu.
      • SudhanshuSawlani
        SudhanshuSawlani
        8 Posts
        ACCEPTED ANSWER

        Re: Map failing and no trace generated on Mainframe

        ‏2012-02-03T07:23:08Z  in response to SudhanshuSawlani
        A Big Thank you to Aashish Pasktanti.

        Changed the rule to cater bold part (new amendment) in between somewhere in the rule, instead of appending at the end. Sounds wierd, but it worked!!

        This issue was because of some kinda interdependancy of the functions.

        =EITHER(
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "AMNT" , "Amount"),
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "IAMT" , "Invoice Amount"),
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "VCHR" , "Voucher Total") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NARR" , "Narration/Inv No") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DCDT" , "Details") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DESC" , "Description") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "DATE" , "Date") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "TDSA" , "TDS/Deduction Amount") ,
        IF(WORD(EITHER(Value_NLS_35:Value_NLSIn1 , Value_ORIG:Value_ORIGIn1) , "/" , 2) = "NAMT" , "Net Amount") ,
        "Reference Type" )

        Cheers
        Sudhanshu.