0 Replies Latest reply on Feb 14, 2011 7:00 PM by Merlin128

    ODBC works for some tables where OCI wont

    Merlin128
      OCI is the recommended method for connection to Oracle via BI Admin tool... and 98% of the time, that is great..

      but I have a few tables that wont work on OCI.. but work fine on ODBC... I need to know why..

      here is the error that two different ones give in BI if I change them to OCI instead of ODBC..



      EXAMPLE 1:
      View Display Error
      Odbc driver returned an error (SQLExecDirectW).
      Error Details
      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: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "T197809"."SYSTEM_NAME": invalid identifier at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
      SQL Issued: SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7 FROM ( SELECT 0 s_0, "Tivoli Assets"."Exav Asset Software Scan"."Software Display Name" s_1, "Tivoli Assets"."Exav Asset Software Scan"."Software Key Name" s_2, "Tivoli Assets"."Exav Asset Software Scan"."Software Version" s_3, "Tivoli Assets"."Exav Asset Software Scan"."System Comment" s_4, "Tivoli Assets"."Exav Asset Software Scan"."System Name" s_5, "Tivoli Assets"."Exav Assets"."Asset Tag" s_6, CONCAT(CONCAT("Tivoli Assets"."Exav Asset Software Scan"."Software Display Name",' '),"Tivoli Assets"."Exav Asset Software Scan"."Software Key Name") s_7 FROM "Tivoli Assets" WHERE ("Exav Assets"."Asset Tag" LIKE 'CPU%') ) djm




      EXAMPLE 2:
      View Display Error
      Odbc driver returned an error (SQLExecDirectW).
      Error Details
      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: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM004 code: 0 message: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. (HY000)
      SQL Issued: SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12, s_13, s_14, s_15, s_16, s_17, s_18 FROM ( SELECT 0 s_0, "ARRA T&I Report"."House T & I Reporting Data"."1201 Certified Funds" s_1, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds Allocated" s_2, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds Obligated" s_3, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds on Completed Projects" s_4, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds on Projects Bid" s_5, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds on Projects with Work Started" s_6, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds Outlayed" s_7, "ARRA T&I Report"."House T & I Reporting Data"."ARRA Funds Under Contract" s_8, "ARRA T&I Report"."House T & I Reporting Data"."Number of Hours Reported" s_9, "ARRA T&I Report"."House T & I Reporting Data"."Number of Jobs Reported" s_10, "ARRA T&I Report"."House T & I Reporting Data"."Number of Projects Bid" s_11, "ARRA T&I Report"."House T & I Reporting Data"."Number of Projects Completed" s_12, "ARRA T&I Report"."House T & I Reporting Data"."Number of Projects Under Contract" s_13, "ARRA T&I Report"."House T & I Reporting Data"."Number of Projects with Work Started" s_14, "ARRA T&I Report"."House T & I Reporting Data"."Report Date" s_15, "ARRA T&I Report"."House T & I Reporting Data"."State Funds Disbursed for 1201 Cert" s_16, "ARRA T&I Report"."House T & I Reporting Data"."Status" s_17, "ARRA T&I Report"."House T & I Reporting Data"."Total Payroll Amount Reported" s_18 FROM "ARRA T&I Report" ) djm