Financial Reporting (FR) Reports Fail With "Error Executing query: Error: Failed to get member property [null(Member Property)]"

(Doc ID 1510838.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.2.000 to 11.1.2.2.300 [Release 11.1]
Information in this document applies to any platform.
1.5.16

Symptoms

You're trying to run a large Financial Reporting report.  Essbase is the data source and the report has a very large query which includes attribute dimensions.  When the report runs, users get the following error message:

Error executing query: Error: Failed to get member property [null(Contract Type)].

The error occurs from both Financial Reporting Studio and Workspace.  The FRLogging.log shows the following error:

[2012-10-12T03:29:17.460+01:00] [FinancialReporting0] [ERROR] [] [oracle.EPMOHPS] [tid: 27] [userId: <anonymous>] [ecid: 0000JdImxZi6ATMpUKL6ic1GTrpo00000v,0] [SID: D0A79ED81FDA2EA6F8F7AEFB72A096] [APP: FINANCIALREPORTING#11.1.2.0] No buffer space available (maximum connections reached?): connect[[ java.net.SocketException: No buffer space available (maximum connections reached?): connect

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