IBM Support

PI48368: COMPARATOR WINDOW LAUNCHED FROM RESULTS GALLERY SHOWS NULL FOR ACTUAL DATA OF DATE TYPE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • STEPS TO REPRODUCE:
    
    1. Create a test with SQL Query action.
    
    2. Add query to retrieve Date type data from DB table.
    
    3. Create Assertion rule at Assert tab to verify the data.
    
    4. Run the test.
    
    5. Launch comparator window from Results Gallery.
    
    
    EXPECTED RESULTS:
    Expected value and actual value are identical.
    
    
    ACTUAL RESULTS:
    
    Actual data is null.
    
    WORKAROUND:
    Modify query for Date type data like below.
    Please look at "HIREDATE" and "BIRTHDATE" which are Date type.
    
    select
      "EMPNO", "FIRSTNME", "MIDINIT","LASTNAME", "WORKDEPT",
    "PHONENO",
      VARCHAR_FORMAT( "HIREDATE" , 'YYYY-MM-DD' ) AS "HIREDATE",
      "JOB", "EDLEVEL", "SEX", VARCHAR_FORMAT( "BIRTHDATE" ,
    'YYYY-MM-DD' ) AS "BIRTHDATE", "SALARY",
      "BONUS", "COMM" from EMP
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester working with dates  *
    * in the comparator window from Results Gallery                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A comparitor window launched from results gallery shows      *
    * 'null' instead of the real value when displaying contents of *
    * fields whose type is 'date'                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix for this issue was provided in version 9.0.0.1 of Rational
    Integration Tester.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI48368

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    860

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-09-08

  • Closed date

    2016-05-31

  • Last modified date

    2016-05-31

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    RATL INTEGRA TE

  • Fixed component ID

    5725G79IT

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSN

       UP

  • R870 PSN

       UP

  • R871 PSN

       UP

  • R900 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 8.6

Reference #: PI48368

Modified date: 31 May 2016