This discussion is archived
0 Replies Latest reply: Mar 30, 2013 6:37 AM by ADFBeginer RSS

OBIEE with Mysql and Tree

ADFBeginer Newbie
Currently Being Moderated
Hi,

I am using obiee 11g, with MySql db. I have a rpd with tree structure table.
When i use analystic to display data i get the below error.

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: S1000 code: 2003 message: [MySQL][ODBC 5.2(a) Driver]Can't connect to MySQL server on '192.196.1.23' (10060). (HY000)
SQL Issued: SELECT 0 s_0, "db"."cat_category_db"."db" s_1 FROM "db"

If i use any table with row data structure, it works. But it never work for hierarchical table.

Please Help

Legend

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