Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE Usage Tracking Stopped Working 2016 - 11.1.1.7.140225 (Build 140209.2017
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......
Answers
-
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")
0 -
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.
0 -
+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.
0 -
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
0 -
Found an updated script in one of the oracle support post's. Here is the link...
0 -
Heh 4 more years...great fix X-D
0 -
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
0 -
Hello, did anyone find a way to download the script ? I can't find it anywhere
Best regards !
0 -
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.
0 -
No I don't have access to it, thank you for your answer !
0
