Analytics - Player Views

Community Forums Backend Server Support
1

I’m currently experiencing issues with Analytics, in specific the ‘Plays’ and ‘Minutes watched’ of the video’s. The ‘data usage’ and ‘contributor’ are working just fine.

I’ve allready checked that my system timezone, DB timezone en PHP timezone are equal. Also i’ve followed the steps in the thread: http://forum.kaltura.org/discussion/56/analytics-strange-problem#Item_14

I do receive an error message in my ETL_Daily log:

INFO 10-12 13:23:59,436 - perform aggregations - Finished job entry [Perform aggregations] (result=[true])
ERROR 10-12 13:23:59,738 - perform aggregations - Unable to write to logging table KalturaLogs-etl_log
ERROR 10-12 13:23:59,739 - perform aggregations - org.pentaho.di.core.exception.KettleJobException:
org.pentaho.di.core.exception.KettleJobException:
Unable to end processing by writing log record to table etl_log
Unable to write log record to log table etl_log
Couldn’t execute SQL: UPDATE etl_log SET JOBNAME=? , STATUS=? , LINES_READ=? , LINES_WRITTEN=? , LINES_UPDATED=? , LINES_INPUT=? , LINES_OUTPUT=? , ERRORS=? , STARTDATE=? , ENDDATE=? , LOGDATE=? , DEPDATE=? , REPLAYDATE=? , LOG_FIELD=? $
Parameter of prepared statement which is set through mysql_send_long_data() is longer than ‘max_long_data_size’ bytes

It’s probably a trivial problem (database missing ‘etl_log’), but I dunno where to begin.

Thanks in advanced,
Danny

2

Small update:
After doing the routine in thread: http://forum.kaltura.org/discussion/56/analytics-strange-problem#Item_14, the analytics have been filling up. The only issue atm is that the older data (past 4 months) isn’t being displayed and/or aggegrated.

Probably the timezone change from ‘+02:00’ to ‘+01:00’ has fixed the issue. How can this be prevented with DST, since I think DST is the culprit here.