Error : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P — Oracle Analytics

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 : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

Received Response
121
Views
12
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

Hi everyone ,

I just finished my modelisation in Oracle administration tool , i uploaded the .Rpd on the server

But when i try to drag and drop the measure with a dimension i got this error message :

Erreur
Erreur d'affichage de la vue

Codes d'erreur : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

Etat : HY000. Code : 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] Une erreur générale s'est produite. (HY000)

Etat : HY000. Code : 59059. [nQSError: 59059] Unsupported Usage Tracking Database Type. (HY000)

Etat : HY000. Code : 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

Requête SQL émise : SELECT 0 s_0, "Vue métier"."Mesure"."Délai de validation du manifeste" s_1 FROM "Vue métier" FETCH FIRST 5000001 ROWS ONLY
I did some research and i understood that i should check my Join in the metadata model , but i think that my joins are okey .
pastedImage_0.png
«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    [nQSError: 59059] Unsupported Usage Tracking Database Type.

    ^--- What DB do you use? Especially what do you use for the schema of the RCU?

  • Gianni Ceresa
    Gianni Ceresa Mod

    In addition to what Christian said: is UT enabled on your server? As you uploaded a new RPD, did you add in your RPD the right database and connection pool for your UT?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Probably not. You spoil-sport

  • John305
    John305 Rank 5 - Community Champion

    i use Oracle 12c  as my DWH db , i do not understand the RCU part sorry .

  • John305
    John305 Rank 5 - Community Champion

    i uploaded my new RPD with the same command

    /app/oracle/biee/user_projects/domains/bi/bitools/bin/data-model-cmd.sh uploadrpd -I  Projet_bi.rpd -W Admin123 -U    weblogic -P Admin123 -SI ssi

    I see the new .RPD in my OBIEE ,  should i enable something ?

    I was working with IBM cognos , i am new in this technology . Thank you for your help !

  • Gianni Ceresa
    Gianni Ceresa Mod 
    John305 wrote:i uploaded my new RPD

    Again: does your "new RPD" has the UT settings? Are they correct? Does the database / connection pool for UT have the right names and types based on the configuration?

    Was the system working before you uploaded your "new RPD" ? If yes => fix the UT config in your RPD, if no => make the full UT config or disable UT completely (not what I would do as UT is really useful).

  • John305
    John305 Rank 5 - Community Champion

    Excuse me if i am not well understanding ,

    the .Rpd never works , even before the update . now about the UT . the only thing i am giving to the pool connexion  ( image below )  is the path of the datawarehouse base ( which is on another server / not the same as OBIEE database ) . do i have to give the rpd the pool to the OBIEE database ?

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    Ok, UT = Usage Tracking, it's a log collecting all the executed queries.

    Your RPD doesn't have any UT database or connection pool but apparently UT is enabled and that's why you get errors about UT.

    Look at Configuring Usage Tracking  (no idea which version of OBIEE you use as you didn't posted it, this is for 12c, for other versions just look in the documentation).

  • John305
    John305 Rank 5 - Community Champion

    And if i want to disable the UT , how can i proceed ?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Actually the real doc is: Managing Usage Tracking  (the other one was during a migration from 11g).

    To disable it you set ENABLE to NO and it's disabled.

    But it takes the same time to enable it and configure it properly...