PM74002: SQL FAILURE ON COMPARE FILES

Rational Test Virtualization Server Fix Pack 1 (8.5.1.1) for 8.5.1
Rational Performance Test Server Fix Pack 1 (8.5.1.1) for 8.5.1
Rational Test Virtualization Server Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Performance Test Server Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Integration Tester Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Test Virtualization Server Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Integration Tester Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Integration Tester Fix Pack 4 (8.5.1.4) for 8.5.1
Rational Test Virtualization Server Fix Pack 4 (8.5.1.4) for 8.5.1
Rational Performance Test Server Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Test Virtualization Server Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Integration Tester Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Performance Test Server Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Performance Test Server Fix Pack 4 (8.5.1.4) for 8.5.1

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