IBM Support

PI95277: CELL ASSERTION HAS HIGHER PRIORITY THAN COLUMN ASSERTION IN SQL QUERY ACTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • STEPS TO REPRODUCE :
    - Add SQL Query action in a test
     - Add SQL Select statement like select * from <database table>
     - Populate data to validate in Assert tab by clicking Test
    button in Config tab
     - Open Assert tab
     - Right-click the column heading which does not need to be
    validated and select Edit Column
     - Disable column assertion by unselecting Equality action type
     - Run SQL Query action in a test
    
    EXPECTED RESULTS :
    Test should pass even though the above column has a different
    value in a cell from the actual value
    
    ACTUAL RESULTS :
    Test fails due to validation failure
    
    WORKAROUND :
    Change SQL Statement to have only columns which need to be
    validated
    But it's not acceptable because the client has too many columns
    in each table
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of SQL Query actions in Rational Integration Tester    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The SQL Query action editor does not allow you to enable and *
    * disable assert and store cell actions on a column by column  *
    * basis.                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in release 9.2.0.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI95277

  • Reported component name

    RATL TEST WORKB

  • Reported component ID

    5725G7900

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-15

  • Closed date

    2018-07-17

  • Last modified date

    2018-07-17

  • 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 TEST WORKB

  • Fixed component ID

    5725G7900

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 PSN

       UP

  • R901 PSN

       UP

  • R910 PSN

       UP

  • R920 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 910

Reference #: PI95277

Modified date: 17 July 2018