3 Replies Latest reply: Jul 8, 2013 1:33 AM by Fesenko_Roman RSS

    Oracle BI Error

    Fesenko_Roman

      Hi2All!

      I've installed Oracle BIEE and Oracle BI APPS 7.9.6.4. with the OeBS database as an OLTP data.

      But when I try to go to the information panel (Inventory), I have such error (Sorry for some text in Russian, I don't know yet how to switch to the Englifh interface):

       

      Драйвер Odbc возвратил ошибку (SQLExecDirectW).

       

        Сведения об ошибке

      Коды ошибок: OPR4ONWY:U9IM8TAC:OI2DL65P

       

       

      Состояние: HY000. Код: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] Возникла общая ошибка. [nQSError: 43113] Из OBIS возвращено сообщение. [nQSError: 17001] Код ошибки Oracle: 1017, сообщение: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin. [nQSError: 17014] Невозможно установить соединение с базой данных Oracle. (HY000)

       

       

      Выдан SQL: SELECT 0 s_0, "Inventory - Balances"."Facts - Inventory Balance"."# of Products Requiring Reorder" s_1, "Inventory - Balances"."Facts - Inventory Balance"."Available Consignment Amount" s_2, "Inventory - Balances"."Facts - Inventory Balance"."Block Consignment Amount" s_3, "Inventory - Balances"."Facts - Inventory Balance"."Blocked Amount" s_4, "Inventory - Balances"."Facts - Inventory Balance"."Days Inventory Outstanding" s_5, "Inventory - Balances"."Facts - Inventory Balance"."Inventory Turn" s_6, "Inventory - Balances"."Facts - Inventory Balance"."Standard Cost Amount" s_7, "Inventory - Balances"."Facts - Inventory Balance"."Value Transfer Amount" s_8 FROM "Inventory - Balances" WHERE ((Time."Year" = '2009')) FETCH FIRST 65001 ROWS ONLY

       

      Is there anybody who knows how to and WHERE to fix this connection error? Am I making mistake, thinking that this should be fix somewhere in RPD file settings and reDeployed?

      Thank a lot for any help or information.

      Best regards, Roman.