Financial Reporting (FR) Reports Fail With "Error Executing query: Error: Failed to get member property [null(Member Property)]"
Last updated on APRIL 30, 2018
Applies to:Hyperion BI+ - Version 184.108.40.206.000 to 220.127.116.11.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#18.104.22.168] No buffer space available (maximum connections reached?): connect[[ java.net.SocketException: No buffer space available (maximum connections reached?): connect
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