In rare cases where Financial Reporting retrieves member information from the data source, the returned information may be too large to retrieve. This may cause error messages and/or a Financial Reporting server to shut down. example(s) of large retrievals:
Hyperion Financial Management Cell Text
Hyperion Essbase outline member formulas
The error message that is received is the following, where “xxxx” is the size in kilobytes of the information that is being retrieved.
“Property value is too long “xxxx” > 4,096, please consider increasing MAX_PROPERTY_VALUE_LENGTH in ADM.Properties” error message.
To remedy this situation, the ADM.properties file needs to be adjusted to accommodate the larger information retrievals.
To adjust the ADM.properties fileOpen the ADM.properties file in a text editor. The file is typically located in the following location:
<HYPERION HOME>\common\ADM\<BI+ VERSION>\lib\ADM.properties
Locate the line “MAX_PROPERTY_VALUE_LENGTH”.
Increase the default setting of 4 (as in 4K). For example, if the error message is as follows: “Property value is too long 9503 > 4096, increasing the value to 10 resolved the issue.
Note:
The default value of 4K and the above error message indicating the property size of 9503 is greater than the default value of 4096, by increasing to 10K, the new property value size is large enough to accommodate the formula.