OAC-Essbase: DBX Utility Errors When Exporting with Data "Invalid DataExport option [DATAEXPORTCSVFORMAT]"

(Doc ID 2313627.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Analytics Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

Using the DBX Utility to export an on-premise Essbase 11.1.2.4.x application with data fails with the error:

Oct 02, 2017 9:17:29 AM oracle.essbase.platform.util.PlatformLogger logException
SEVERE: Cannot calculate. Essbase Error(1012861): Invalid DataExport option [DATAEXPORTCSVFORMAT]. Refer to the DataExport documentation for valid options.
com.essbase.api.base.EssException: Cannot calculate. Essbase Error(1012861): Invalid DataExport option [DATAEXPORTCSVFORMAT]. Refer to the DataExport documentation for valid options.
at com.essbase.server.framework.EssOrbPluginDirect.ex_olap(Unknown Source)
at com.essbase.server.framework.EssOrbPluginDirect.essMainCalc(Unknown Source)
at com.essbase.api.session.EssOrbPlugin._invokeMainMethod(Unknown Source)
at com.essbase.api.session.EssOrbPlugin._invokeMethod2(Unknown Source)
at com.essbase.api.session.EssOrbPlugin._invokeMethod(Unknown Source)
at com.essbase.server.framework.EssOrbPluginDirect._invokeProtected(Unknown Source)
at com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
at com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
at com.essbase.api.session.EssOrbPlugin.essMainCalc(Unknown Source)
at com.essbase.api.datasource.EssCube.getCalcInfoWithoutRtVals(Unknown Source)
at com.essbase.api.datasource.EssCube.calculate(Unknown Source)
at oracle.essbase.excel.structured.export.OutlineProcessor.exceuteCalcScript(Unknown Source)
at oracle.essbase.excel.structured.export.OutlineProcessor.exportData(Unknown Source)
at oracle.essbase.excel.structured.export.OutlineProcessor.exportOutline(Unknown Source)
at oracle.essbase.excel.cli.ExportCommand.exportEssbaseApplication(Unknown Source)
at oracle.essbase.excel.cli.ExportCommand.execute(Unknown Source)
at oracle.essbase.excel.cli.DBXTool.main(Unknown Source)

Encountered errors while executing command
com.essbase.api.base.EssException: Cannot calculate. Essbase Error(1012861): Invalid DataExport option [DATAEXPORTCSVFORMAT]. Refer to the DataExport documentation for valid options.

 

Cause

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