0 Replies Latest reply: Mar 30, 2013 8:37 AM by ADFBeginer RSS

    OBIEE with Mysql and Tree

    ADFBeginer
      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