This discussion is archived
1 Reply Latest reply: May 5, 2012 3:01 AM by JohnGoodwin RSS

ODBC Layer Error: [37000] when Connecting to Oracle via SQL Conct in Essbas

779430 Newbie
Currently Being Moderated
Essbase 11.1.2.1

ODBC set up using DataDirect 6.0 Wire Protocol 6.00.00.140

I can connect to database and run a query no problem. However when I go through Essbase SQL Load I get the following errors:

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021041)
Connection String is [DSN=bmrme;UID=...;PWD=...;]

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021006)
SELECT Statement [SELECT *  FROM from bmr_hyp_gl_load_v
] is generated

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021043)
Connection has been established

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021044)
Starting to execute query

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021013)
**ODBC Layer Error: [37000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00903: invalid table name]**

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Info(1021014)
ODBC Layer Error: Native Error code [903]

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Error(1021001)
Failed to Establish Connection With SQL Database Server. See log for more information

[Fri May 04 11:01:03 2012]Local/PlanTst1/Plan1/admin@Native Directory/296/Warning(1080014)
Transaction [ 0x610001( 0x4fa4195f.0xa0280 ) ] aborted due to status [1021001].

Of particular note is the ODBC Layer Error [37000] and "Invalid table name" The view does exist so not sure why its not seeing it.

Any thoughts?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points