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 APRIL 30, 2018
Applies to:Hyperion BI+ - Version 126.96.36.199.000 to 188.8.131.52.300 [Release 11.1]
Information in this document applies to any platform.
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#184.108.40.206] No buffer space available (maximum connections reached?): connect[[ java.net.SocketException: No buffer space available (maximum connections reached?): connect
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!