Error: 'Essbase Error(1012004): Invalid member name [null] ' While Exporting the Data to PBCS Application (Doc ID 2689067.1)

Last updated on JULY 10, 2020

Applies to:

Symptoms

Export to PBCS Application in REPLACE mode fails with error:

Error

=====

INFO  [AIF]: cloudServiceType: Planning, Resolved user: epm_default_cloud_admin, planningUserName: XXXXXX
INFO  [AIF]: Starting executeDataRuleFile...
INFO  [AIF]: Building and executing replace data script...
INFO  [AIF]: Replace data script: 
FIX (<fixMbrs>,"Dec","FY19")
CLEARDATA "null";
ENDFIX
ERROR [AIF]: Cannot calculate. Essbase Error(1012004): Invalid member name [null]
INFO  [AIF]: EssbaseService.loadData - END (false)
FATAL [AIF]: Error in CommData.loadData
Traceback (most recent call last):
  File "<string>", line 4011, in loadData
RuntimeError: false

Changes

Issue started happening after the 20.06 update, verifying the log file shows that it is executing a fix statement with clear data script.  20.06 onwards replace will work for all data types, it adds the fix statement with CLEARDATA.
It is based on the export mode chosen during the rule execution.

Cause

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