Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Advance Analytic

Received Response
21
Views
5
Comments
Ahmad Al-Baik
Ahmad Al-Baik Rank 3 - Community Apprentice

Dears;

I have a problem in using OBIEE advanced analytics, when I'm using one of the advanced analytics functions in OBIEE like Forecast, REG..., I get the below error :

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

(HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

Error(s): Error in doTryCatch(return(expr), name, parentenv, handler): could not find function "read.csv" (HY000),

Many Thanks,

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Have you installed R and related packages in the server?

    IIRC those were additional steps you need to do on top of a basic installation

  • Ahmad Al-Baik
    Ahmad Al-Baik Rank 3 - Community Apprentice

    Dear FTisiot;

    Someone in our team installed them, but i don't know about IIRC, but how i can check if the installation is correct,

    Many Thanks,

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    IIRC=If I remember correctly....

    You need to install R and all the required packages... the message clearly states

    Error(s): Error in doTryCatch(return(expr), name, parentenv, handler): could not find function "read.csv" (HY000),

    So it can't possibly find the related package

  • Ahmad Al-Baik
    Ahmad Al-Baik Rank 3 - Community Apprentice

    Dear Sir;

    I'm very sorry for bothering you, but this issue make me a big trouble, is there any statement that i can execute to check if the packages are installed correctly,

    Many Thanks,

    Ahmad...

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    you can simply re-execute the steps as written in

    https://www.peakindicators.com/blog/enabling-r-in-oracle-bi-12c

    check no errors arise during the installation