"Error (1012085) Unable to export data to SQL table" When Exporting DATE Type Data to Relational Table (Doc ID 1516791.1)

Last updated on MARCH 27, 2015

Applies to:

Hyperion Essbase - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

Exporting DATE type data to a relational table in an Essbase calculation script is failing with the error:

Error(1012085) Unable to export data to SQL table [...]. Check the Essbase server log and the system console to determine the cause of the problem.

The same calc script is able to export all data, including DATE data, to flat file but when exported to relational table all data is exported except DATE data.

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