My Oracle Support Banner

PCMCS - Error Running Ledger Calculation: "Warning: The formula length may be too long for essbase for Rule ''<RuleName>." (Doc ID 2729099.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Oracle Hyperion Profitability and Cost Management Cloud Service - Version 20.10.52 and later
Information in this document applies to any platform.

Symptoms



The custom rule, when filters are selected in the source or destination, for a dimension, runs with a warning. The rule runs successfully and validates, but this warning is displayed in the error report.

Warnings:

The formula length may be too long for essbase for Rule ''<RuleName>''.


HPCM LOG:

2020-11-15T09:32:23.000+00:00] [EPMServer0] [NOTIFICATION] [] [oracle.EPMPCM.business] [tid: 184] [userId: <anonymous>] [ecid: 27227fcd4634d594:-723ebc9d:175cb3bdfe0:-8000-0000000000000002,0:1] [APP: PROFITABILITY#11.1.2.0] [SRC_CLASS: com.hyperion.profitability.business.service.ExportDiagnostics] [SRC_METHOD: exportDiagnose] Dim Build Error File Exported Successfully
[2020-11-15T15:15:07.012+00:00] [EPMServer0] [ERROR] [] [oracle.EPMPCM.mdb] [tid: 350] [userId: epm_default_cloud_admin] [ecid: 0000NNC3ty1Fs1H6yvqYMG1VgFKN00001o,0:1] [APP: PROFITABILITY#11.1.2.0] [SRC_CLASS: com.hyperion.profitability.data.mdb.essbase.EssbaseAPI] [SRC_METHOD: mergeCube] Getting Exception while running Maxl Script : alter database <APPNAME>.<DBNAME> merge all data Exception Message : com.essbase.api.base.EssException: Cannot execute maxl statement. Essbase Error(1270099): There's no incremental data or it is already merged. Specified merge is not necessary

Essbase Application log test pod:
[Sun Nov 15 09:27:54 2020]Local/<APPNAME>///140708899035328/Error(1350001)
Attempt to initialize ODBC failed. Please check ODBC configuration and try again

[Sun Nov 15 15:15:07 2020]Local/<APPNAME>/<DBNAMEB>/epm_default_cloud_admin@Native Directory/140708756317952/Error(1270099)
There's no incremental data or it is already merged. Specified merge is not necessary

Changes

 Using individual filters on a custom rule.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.