My Oracle Support Banner

Troubleshooting Problems with Essbase SQL Interface and SQL / ODBC Data Sources (Doc ID 1268756.1)

Last updated on JULY 26, 2022

Applies to:

Hyperion Essbase Administration Services - Version and later
Hyperion Essbase - Version and later
Hyperion Essbase Integration Services - Version and later
Information in this document applies to any platform.
This knowledge document is a replacement for 1189552.1, 599037.1, 599038.1, 797774.1, 1277488.1, 1083787.1, 1078273.1, 949004.1, 943414.1, 787625.1, 1097843.1, 976146.1, 1083768.1, 1095154.1, 1072034.1, 1476846.1 which have been deleted.


To enable the user to troubleshoot the most common SQL Problems in conjuction with Hyperion Essbase , Essbase SQL Interface and Essbase Integration Services that all use the Merant ODBC drivers.

Troubleshooting Steps

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
Troubleshooting Steps
 Common Error Messages
 Common Windows 32 bit cause (installation was done without Administrator privileges)
 Correcting installation on Windows (32-bit)
 Incorrect version of ODBCADMIN32.EXE used
 How to Correctly Create a data source on Windows (32-bit)
 Creating a data source on Windows (64-bit)
 Common UNIX cause for errors with SQL interface
 How to create the softlink to the odbc.ini file (UNIX / Linux)
 Resolve incorrect Installation on UNIX
 EPM 11.1.2 non-default installation
 Correcting Non-default EPM 11.1.2 installation
 How to create a Data Load Rule or Dimension Build Rule with an OCI connection
 Supported platform matrices (compatibility Matrix)
 Merant version compatibility matrix
 Additional information about the Merant (DataDirect) Drivers
 Which products use the DataDirect Merant ODBC Drivers?
 Where to find more information in case an Error occurs?
 Choosing the correct ODBC driver
 Further Common SQL/ ODBC Errors
 Still Have Questions?

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