Error: "We found a problem with some content in 'XXXX.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes"

(Doc ID 2379113.1)

Last updated on APRIL 18, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to export a BI Publisher report with more than 65536 rows to excel the following error occurs and only 65536 rows are present in the file.

ERROR
"We found a problem with some content in 'filename.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

Clicking yes then opens the document in a protected view and only contains 65536 rows

STEPS
The issue can be reproduced at will with the following steps:

  1. Log into BI Publisher
  2. Execute the report
  3. Open the excel output

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot view the full report.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms