PM97988: "STANDARD ERROR ... 5 ... ORA-01741: ILLEGAL ZERO-LENGTH IDENTIFIER" WHEN RUNNING EXCEL REPORT USING OPTIMISE2

APAR status

• Closed as program error.

Error description

• User opens Excel spreadsheet (XLS/XLSX file). User clicks F9 (to
  run the report). ??The message (at the bottom-left corner) says
  "Analysing Sheet". Soon afterwards, this changes to "Calling
  RunReport". Immediately the user receives an error message.
  

Local fix

• Either:
  (a) Disable the use of Optimise2 (ERO)
  or (preferred) (b) create missing database table "GXLI$CALCPER$3
  TEMPTAB".
  
  See Technote for details: http://www-01.ibm.com/support/docview.
  wss?uid=swg21650092
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Controller 10.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