Error : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

John305

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 .

[Deleted User]

[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

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]

Probably not. You spoil-sport

John305

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

John305

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

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

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 ?

Gianni Ceresa

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

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

Gianni Ceresa

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