1 Reply Latest reply on Dec 25, 2017 2:08 PM by Gianni Ceresa

    Error in results tab when create analyse with sample data

    bma66

      hi,

      i am reading this tutorial:

      http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/cad/cad12c.html#overview

      i download bisample.rdp and open it with oracle bi administration tool.

      how can change database connection string to connect to my database and read bisample schema (imported before)?

      because when import rdp file into obiee 12 and create analyse this error show me:

      Odbc driver returned an error (SQLExecDirectW).

      http://192.168.1.121:9502/analytics/res/v-RS96Z2oBs2o/sk_blafp/common/errorminus.gif  Error Details

       

      Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

       

       

      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. (HY000)

       

       

      State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

       

       

      State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12541, message: ORA-12541: TNS:no listener at OCI call OCIServerAttach. (HY000)

       

       

      State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)

       

       

      SQL Issued: SELECT 0 s_0, "A - Sample Sales"."Products"."P1 Product" s_1 FROM "A - Sample Sales" FETCH FIRST 65001 ROWS ONLY

       

        • 1. Re: Error in results tab when create analyse with sample data
          Gianni Ceresa

          Hi,

          You need to open the RPD with the Admintool in online or offline mode, on the right side of the screen you will see the physical layer and there you need to edit the connection pool to point to your database (so database connection string or TNS, username and password).

          If you do that offline you also need to re-upload the RPD on OBIEE.

           

          The "bisample.rpd" file you took actually uses variables for these things, but as you see in the description of the connection pool you can get rid of it and just enter values directly.

          Capture.PNG