Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Error in results tab when create analyse with sample data

Received Response
11
Views
1
Comments
bma66
bma66 Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

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

  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
pastedImage_0.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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