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 11.1.2.4.031 and laterInformation in this document applies to any platform.
Symptoms
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.
Changes
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 |