My Oracle Support Banner

Failed to Call Batch File via ODBC : ODBC Layer Error [IM014] (Doc ID 2878770.1)

Last updated on AUGUST 11, 2023

Applies to:

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


The Oracle Call Interface(OCI) Connection can work to retrieve data from DB to Business Rules on EAS. But it fails to execute batch file base on rule via ODBC DataDirect 7.1 Oracle Wire Protocol.

Batch call Rule File via MAXL, but error occurred.

MAXL>Login admin manager1 on <SERVER>;

WARNING - 1040156 - SSL initialization failed with error code [1008165]..
OK/INFO - 1051034 - Logging in user [<USER>].
OK/INFO - 1241001 - Logged in to Essbase

MAXL> alter application '[<APP_NAME>]' load database '[<DB_NAME>]';

OK/INFO - 1056013 - Application [APP_NAME] altered.

MAXL> import database [<APP_NAME>].[<DB.NAME>] data

2> connect as '<USER>' identified by '<PASSWORD>'
3> using server rules file '[<FILE>]'
4> on error write to '[<PATH>]\******.err';

OK/INFO - 1019061 - Reading Rule SQL Information For Database [<DB_NAME>].
OK/INFO - 1019025 - Reading Rules From Rule Object For Database [<DB_NAME>].
OK/INFO - 1021004 - Connection String is generated.
OK/INFO - 1021041 - Connecting String is [DSN=<NAME>;UID=<UID>;PWD=<PASSWORD>;].
OK/INFO - 1021006 - SELECT statement [SELECT * FROM [RULES_PLAN_NAME] is generated.
OK/INFO - 1021013 - ODBC Layer Error : [<NAME>] ==> [[Microsoft][ODBC ???...
OK/INFO - 1021014 - ODBC Layer Error : Native Error code [0].
ERROR - 1021001 - Failed to Establish Connection With SQL Database Server. See log for more information.
ERROR - 1241101 - Unexpected Essbase error 1021001.





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

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