0 Replies Latest reply on Mar 30, 2013 1:37 PM by ADFBeginer

    OBIEE with Mysql and Tree


      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 '' (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