IBM Sterling Transformation Extender

 View Only

  • 1.  Issue using DateTime Function in ISTX 10.1.1.1

    Posted Tue March 26, 2024 03:06 AM

    We have mismatch in the output while using datetime conversion function for the below mentioned logic.

    If the time is between 12:00 PM to 12:59 PM and if we use any function such as addhours, convert etc in ISTX it generates as 00:00 and 00:59.

    Map Rule:

    FROMDATETIME(TODATETIME(IN_DATE+SUBSTITUTE(IN_TIME,"*",""),"MM/DD/CCYYHH12:MMAM/PM"),"{MM/DD/CCYYHH24MM}")

     

    If the input is

    IN_DATE : 3/4/2024
    IN_TIME : 12:57PM

    Then the

    ITX Output:

    03/04/20241257

    ISTX Output:

    03/04/20240057

     

    If the input is

    IN_DATE : 3/4/2024
    IN_TIME : 03:15PM

    Then the

    ITX Output:

    03/04/20241515

    ISTX Output:

    03/04/20241515

     

    If the input is

    IN_DATE : 3/4/2024
    IN_TIME : 08:30AM

    Then the

    ITX Output:

    03/04/20240830

    ISTX Output:

    03/04/20240830

     

    The issue is whenever the time 12PM ISTX process it as 00.

    We have been using ISTX Version 10.1.1.1



    ------------------------------
    Suriya Prakash
    ------------------------------


  • 2.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    IBM Champion
    Posted Wed April 03, 2024 04:48 AM
    Edited by Paul Brett Wed April 03, 2024 05:13 AM

    I think this is either a duplicate of IBM APAR PH44835:

    https://www.ibm.com/support/pages/apar/PH44835

    ...or at the very least, linked to it.  It should have been fixed by ITX 10.1.1.1.

    I recommend you open a new Case with IBM Support.  Please include a testcase.



    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message


  • 3.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    IBM Champion
    Posted Wed April 03, 2024 05:08 AM

    I made a quick testcase, and it looks like it is fixed in the latest 'tip' version of ITX 10.1.1.1.

    Open a Case and request a tip-of-tree core engine fix to resolve this issue.



    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message


  • 4.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    IBM Champion
    Posted Wed April 03, 2024 05:13 AM
    Edited by Paul Brett Wed April 03, 2024 05:13 AM

    Issue was actually fixed by this APAR:

    https://www.ibm.com/support/pages/apar/PH48118



    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message


  • 5.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    Posted Thu April 04, 2024 07:57 AM

    Thanks Paul Brett.

    We opened up a case and got it resolved. Thanks for your kind response.



    ------------------------------
    Suriya Prakash
    ------------------------------

    Original Message


  • 6.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    Posted Thu April 04, 2024 08:01 AM

    Hi Paul Brett,

    We have been using 10.1.1.1 is there any fix packs available to upgrade it to 11.0.0 or else we need to do a fresh complete installation.

    Thanks & Regards,

    Suriya Prakash



    ------------------------------
    Suriya Prakash
    ------------------------------

    Original Message


  • 7.  RE: Issue using DateTime Function in ISTX 10.1.1.1

    IBM Champion
    Posted Thu April 04, 2024 08:08 AM

    ITX 11.0.0.0 is a complete install, there is no upgrade option.



    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Original Message