OBIEE Usage Tracking Stopped Working 2016 - 11.1.1.7.140225 (Build 140209.2017

chillychin

Hi all

We noticed that as of 2016 our usage tracking logs seem to have "stopped working"

We were able to trace our issue back to the S_ETL_DAY table.

It looks like there are two scripts used to populate this table when initially made

Oracle_create_nQ_Calendar.sql and Oracle_create_nQ_Clock.sql

When checking these scripts we noticed that they only go up to 2016.

Has Oracle released a new version of this script to populate post 2016?

Would hate to have to manually type out all the insert statements......

rmoff

Do you actually have data in S_NQ_ACCT and S_NQ_DB_ACCT? These are the Usage Tracking tables that OBIEE writes to.

It might use S_ETL_DAY when reporting the data (and an inner join to it with no 2016 rows could give the illusion of "no Usage Tracking data")

Gianni Ceresa

Did you try searching in the forum?

How can i update S_ETL_DAY after 2016

Ian Bristow-Oracle wrote:

... there is bug 21835891 - USAGE TRACKING ONLY HAS DATE DATA UNTIL 2016 

Regards,
Ian Bristow

And as @rmoff says your usage tracking perfectly works, it's only your reports not showing data for 2016, but your DB is still collecting all the info.

[Deleted User]

+1 Oracle may provide a script at some time but since it's basically nothing different from what was done at the initial loading of S_ETL_DAY you can also just take the script from OBIA and rewrite it to your needs. I.e. have it start when your S_ETL_DAY stops and continue until the year 2100 or something.

Lamin J

Hi Chillychin

I have open Sr for this!

Ill you send the updated insert script (Oracle DB) we got from support.

Send me your email and you have will have it shortly.

Best regards Lamin

1034454

Found an updated script in one of the oracle support post's. Here is the link...

Oracle Support Document 2073512.1 (OBIEE 11g: How To Extend Usage Tracking  Tables S_ETL_DAY And S_ETL_TIME_DAY Past Jan 2016)

[Deleted User]

Heh 4 more years...great fix X-D

1ef16aa5-f5ac-4271-96c2-bc6b90f3a808

Hello, Can u please send me script to update S_ETL_DAY after 2016?

*****************

Moderator action (Timo); removed private contact data. User, don't post private data in this public forum, please!

As the solution is from a MOS document (My Oracle Support)  it can't be discloded here. You need a valid support contract (payable)and get the document yourself.

*****************

Thank you

dcb9a72e-f3dd-40b1-b716-19c122b9bee3

Hello, did anyone find a way to download the script ? I can't find it anywhere

Best regards !

Gianni Ceresa

Hi,

Do you have access to MOS ?

If yes you can download it from there, if no then nobody can post it as it would be illegal ...

If you have access to MOS, 1034454 posted the links few answers ago.

dcb9a72e-f3dd-40b1-b716-19c122b9bee3

No I don't have access to it, thank you for your answer !