Publishing Hyperion Interactive Reporting BQY File Results In Error: "Database Server error: 1000165"
Last updated on JANUARY 09, 2018
Applies to:Hyperion Intelligence - Version 220.127.116.11.00 and later
Hyperion BI+ - Version 18.104.22.168.00 to 22.214.171.124.502 [Release 9.0 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Mar-2013***
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)
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;
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