My Oracle Support Banner

After Applying Essbase 11.1.2.4.031 Patch Set Update Opening an Essbase SQL Load Rule Error "Failed to get the list of available SQL data sources. See server log for more information" (Doc ID 2570081.1)

Last updated on JULY 30, 2019

Applies to:

Hyperion Essbase - Version 11.1.2.4.031 to 11.1.2.4.031 [Release 11.1]
Information in this document applies to any platform.

Symptoms

After applying Essbase 11.1.2.4.031 Patch Set Update, when opening, editing or running a SQL load rule, it immediately fails with the error:

Failed to get the list of available SQL data sources. See server log for more information"

The application log has the following:

[Mon May 13 15:39:24 2019]Local/<appname>/<dbname>/<username>@Native Directory/13111/Info(1013091)
Received Command [SQLListDsn] from user [<username>@Native Directory]

[Mon May 13 15:39:24 2019]Local/<appname>/<dbname>/<username>@Native Directory/13111/Info(1021013)
ODBC Layer Error: [] ==> []

[Mon May 13 15:39:24 2019]Local/<appname>/<dbname>/<username>@Native Directory/13111/Info(1021014)
ODBC Layer Error: Native Error code [0]

[Mon May 13 15:39:24 2019]Local/<appname>/<dbname>/<username>@Native Directory/13111/Error(1021024)
Failed to get the list of available SQL data sources. See server log for more information

[Mon May 13 15:39:24 2019]Local/<appname>/<dbname>/<username>@Native Directory/13111/Warning(1080014)
Transaction [ 0x10013( 0x5cd9d5fc.0x3a168 ) ] aborted due to status [1021024]

 

If applying the patch is not feasible at this time, roll back the Essbase 11.1.2.4.031 Patch Set Update and re-apply a previous patch.



Changes

 Applied Essbase 11.1.2.4.031 Patch Set Update on an AIX Server.

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.