Financial Reporting (FR) Reports Fail With "Error Executing query: Error: Failed to get member property [null(Member Property)]"
Last updated on AUGUST 08, 2016
Applies to:Hyperion BI+ - Version 22.214.171.124.000 to 126.96.36.199.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#188.8.131.52] 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