PM73839: REFRESHING AN EXCEL TEST DATA SOURCE RESULTS IN "ERROR LOADING SELECTED FILE"

APAR status

• Closed as unreproducible in next release.

Error description

• Some spreadsheets cannot be "refreshed" as test data
  source. <br/><br/>STEPS TO REPRODUCE:<br/>1) Attach the
  spreadsheet to a data source<br/>2) Click
  'refresh'<br/><br/>EXPECTED RESULTS:<br/>Data source is
  refreshed.<br/><br/>ACtUAL RESULTS:<br/>The following error is
  thrown:<br/>----<br/>Error loading the selected file
  'C:\Users\IBM\gh\YPKZBQBIOH_ExcelUnopenable/External/SampleTestD
  ataSheet.xls'. Duplicate PageSettingsBlock record
  (sid=0x89c)<br/>----<br/><br/><br/>HISTORICAL
  INFORMATION:<br/>This issue was previously logged under
  GHT5-22947.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Green Hat Tester creating test data sets using      *
  * Excel spreadsheets.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Refreshing an Excel-based Test Data Set results in an        *
  * "Error Loading Selected File" message.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * None                                                         *
  ****************************************************************
  

Problem conclusion

• This problem could not be replicated in version 8.0.1.1 of
  Rational Integration Tester and is believed to be specific to
  the original environment and spreadsheet.
  

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:

Modules/Macros

• GH       Tester
  

Fix information

• Fixed component name

  GREEN HAT TESTE

• Fixed component ID

  5725G79GT

Applicable component levels

• R540 PSN

     UP