IBM Support

PM74002: SQL FAILURE ON COMPARE FILES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL failure on file comparison
    
    Error Message:
    [Error] Failed to find differences due to an SQL failure:
    Caused by: Failed to bind source to table:
    SET TABLE LHS SOURCE
    "C:\DOCUME~1\NBKZTBD\LOCALS~1\temp\cdbfile-1332494731639-11;
    fs=;" DESC (SQLException) Caused by: bad TEXT table source file
    - line number: 0 no value specified for field in statement [SET
    TABLE LHS SOURCE
    "C:\DOCUME~1\NBKZTBD\LOCALS~1\temp\cdbfile-1332494731639-11;
    fs=;" DESC]
    (SQLException) Caused by: bad TEXT table source file - line
    number: 0 no value specified for field
    (HsqlException) Caused by: no value specified for field
    (HsqlException)
    [14:55:32.264 2012/03/23] [Error] Compare Files:TRICE Source
    against TRICE Source An error occurred whilst
    performing the comparison.
    Exception : Failed to compare files
    [14:55:32.264 2012/03/23] [Failed] 1 iteration completed, 1
    iteration failed (1)
    Logging summary: Info (0), Warnings (0),Errors (0)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Rational Integration Tester users using the Compare File     *
    * action.                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The Compare File action fails if one of the files is         *
    * semi-colon (;) delimited.                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Rational Integration Tester version 8.5.1.1 or    *
    * above.                                                       *
    ****************************************************************
    

Problem conclusion

  • A fix for this issue was included in Rational Integration Tester
    version 8.5.1.1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM74002

  • Reported component name

    GREEN HAT TESTE

  • Reported component ID

    5725G79GT

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-28

  • Closed date

    2014-01-08

  • Last modified date

    2014-01-08

  • 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

    GREEN HAT TESTE

  • Fixed component ID

    5725G79GT

Applicable component levels

  • R540 PSN

       UP



Document information

More support for: Green Hat Tester

Software version: 5.4

Reference #: PM74002

Modified date: 08 January 2014