PI43492: FUNCTION "ERO/OPTIMISE2" FAILS WHEN NAME OF SHEETS CONTAINS SCANDINAVIAN CHARACTERS.

APAR status

• Closed as program error.

Error description

• ERO/Optimise2 not working when the name of sheets in Excel
  contains Scandinavian letters (öäåøæ).
  Created a simple Excel file with a single fgetval and configured
  ERO/Optmise2.
  With the default Sheet1, I was able to retrieve the numbers.
  I then renamed the Sheet1 to Shööt1, and tried to refresh, I now
  no longer get any numbers.
  Now I disabled ERO/Optmise2 and refreshed, and I again got the
  numbers from the database.
  

Local fix

• Remove the Scandinavian characters from the worksheet names.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Controller  10.2.1 Fix Pack 2          *
  ****************************************************************
  

Problem conclusion

• Code fix
  

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

  COG CONTROLLER

• Fixed component ID

  5724W24CO

Applicable component levels