Copyright © 2012 Kaltura Inc.
All Rights Reserved. Designated trademarks and brands are the property of their respective owners.
Use of this web site constitutes acceptance of the Terms of Use and Privacy Policy.
EduVideo.org
dvh_fact_events empty (Analytics not working)
Tue, 10/16/2012 - 12:43
Hi
I think I've pretty much read everything on these forums about analytics and reasons why it doesnt work.
Ive been digging through scripts and log files, and I can't find any errors in the etl and apache logs.
One of the posts in this thread drew my attention to the dwh_fact_events table.
http://www.kaltura.org/kaltura-ce-500-etl-analytics-not-working-still
The post in question has not been answered, and I have the same question.
THe dwh_facts_event table seem to be empty at all times, so if analytics uses this table, this is the reason why analytics isn't working.
My first question is, where is events inserted?
If this script has nothing to do with analytics, I would like someone to point me in the right direction (more places to look for errors).
I've been checking etl scripts and logs, crontab, kaltura_apache_access- and error log.
I've also been checking the /app/api_v3/services/StatServe.php scripts for clues.
Im running Kaltura CE 5.0 on Ubuntu 12.04.
Thanks
Wed, 12/12/2012 - 11:04
#2
I have the dwh_aggr_partner table but it's empty.
Its in my kalturadw database.
I'm not quite sure about how the stats are soposed to be inserted, but I've been looking into the www_logs_insert.sh script for clues.
This script seem to generate .sh files to insert the stats, but that's as far as I can get. I don't really know what happens next, why it isn't working, or even what executes this script does.
The script is located in kaltura/app/scripts
It might be that it doesnt find the log files but it doesnt generate any errors.
Hello Fredrik,
I am quite new with Kaltura, and I am setting up this solution for a customer demo/trial.
I am also facing a lot of issues with the statistics and the "analytics" tab on Kaltura. I am running CE 5.0. on Ubuntu 12.04 as well & I have also read the same threads than you have, and I have checked for every possible issues described in Ronileco blog (here http://blog.ronileco.com/kaltura-ce5-analytics-13/), as you did, I guess.
In my system logs under /opt/kaltura/dwh/logs (etl_hourly-*.log ; etl_daily-*.log), I have no particular errors (at least none of the one described in the above blog). I do not know where to look next to try to find a solution ...
I have noticed the following :
In the kaltura crontable (/opt/kaltura/crontab/kaltura_crontab), when i manually start the following script:
# /usr/bin/php /opt/kaltura/app/plugins/onprem/scripts/reportUsageTrackingIfOptIn.php
I get this error :
Failed to execute query: SELECT sum(count_loads) as player_loads, sum(count_plays) as plays FROM dwh_aggr_partner
Failed to execute query: SELECT sum(count_storage)/1024 as storage_gb, sum(count_bandwidth)/1024/1024 as bandwidth_gb FROM dwh_aggr_partner
So I was wondering whether this "dwh_aggr_partner" table, which is missing in my mysql table was the source of my problem. So I have downloaded the VMware CE 5.0 image, and stick it into my virtual box. In this already installed kaltura system, this table is also missing. So I am not sure whether it is needed or not ... (BTW, stats do not work either with the VM image, I have quickly checked)
I have also checked the /opt/kaltura/dwh/crontab/dwh_crontab/ file, which I guess is the one kicking the hourly/daily statistics calculations, but they seem ok. I would be nice to know the path the statistics information is following from the player up to the hourly/daily stats log files ...
Do you have any ideas where or in which direction I could search for potential issues/misconfigurations ?
Thanks
F.
PS: I also had some issues for installing the system in the first place, I basically had to install it twice on each system before being able to log correctly into the admin console ...