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

Rational Integration Tester Fix Pack 1 (9.0.0.1) for 9.0.0
Rational Performance Test Server Fix Pack 1 (9.0.0.1) for 9.0.0
Rational Test Virtualization Server Fix Pack 1 (9.0.0.1) for 9.0.0

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 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