Publishing Hyperion Interactive Reporting BQY File Results In Error: "Database Server error: 1000165" (Doc ID 850922.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Intelligence - Version 8.5.0.0.00 and later
Hyperion BI+ - Version 9.0.0.0.00 to 11.1.1.3.502 [Release 9.0 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Mar-2013***

Symptoms

Within Hyperion System 9/Enterprise Performance Management (EPM) 11.1.x, the following error occurs at the final stage of publishing:

Hyperion Workspace - Error Unable to create object. Detailed Message: Database Server error: 1000165 Recommended Action: Check the name to make sure it's unique and try again.


When the error has occurred and Cancel button pressed, the BQY file publishing completes.  The following error is then seen when trying to open the Pivot of the BQY document in iHTML format:

Hyperion Workspace - Error; An Interactive Reporting Service error has occurred. Runtime Error (2001)

Changes

The BQY file has a script entry added similar to:

ActiveDocument.Sections["SectionName"].DHTMLExportBreakRowCount = #####

where ##### is a value higher than 200,000

This large number assigned to "DHTMLExportBreakRowCount" allows a higher number of rows to display on one page of a pivot table when viewing in iHTML client.

For Example: ActiveDocument.Sections["PivotSectionName"].DHTMLExportBreakRowCount = 2147483647;

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