PM21752: ?EXCEL FOUND UNREADABLE CONTENT IN..? WHEN OPENING A MULTI-LIST REPORT WITH ONE EMPTY LIST ENCLOSED IN A BLOCK.

APAR status

• Closed as program error.

Error description

• Users receive an error ?Excel found unreadable content in <>.
  Do you want to recover?.? when opening an excel 2007 report.
  The end users only get this excel error when one of the lists in
  the report does not contain data (empty).  The series of lists
  must be contained within a block element for the error to be
  thrown.??????Workarounds:??-move lists out of block
  element??-add a ?no data? property with an empty text object??
  

Local fix

• Workarounds:
  -move lists out of block element
  -add a ￢ﾀﾘno data￢ﾀﾙ property with an empty text object
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos BI Server 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

  COG8 BI COG VIE

• Fixed component ID

  5724W12CV

Applicable component levels

• RA20 PSN

     UP