Guten Tag and hello Community, hello @jess ,
we have the problem, that some videos are not shown in analytics. The most videos are there.
For example the video with id 0_csiqhh7l.
In the apache logfiles we see the stats entries:
172.31.22.193 - - [28/Nov/2019:05:59:50 +0000] “GET /api_v3/index.php?service=stats&apiVersion=3.1&expiry=86400&clientTag=kwidget%3Av2.79&format=1&ignoreNull=1&action=collect&event:eventType=3&event:clientVer=2.79&event:currentPoint=0&event:duration=84&event:eventTimestamp=1574920789990&event:isFirstInSession=false&event:objectType=KalturaStatsEvent&event:partnerId=106&event:sessionId=a6a7fe02-913f-c608-a3d6-05b03d092c34&event:uiconfId=23464665&event:seek=false&event:entryId=0_csiqhh7l&event:historyEvents=111000000000000000000000-3-3&event:widgetId=_106&event:referrer=https%253A%252F%252Fwww.derwesten.de%252Fpanorama%252Fpromi-tv%252Fflorian-silbereisen-helene-fischer-zdf-traumschiff-thomas-seitel-id227687941.html&hasKanalony=false&kalsig=84ac7e8f2190149239053d3986119609 HTTP/1.1” 200 530 0/16856 “http://www.derwesten.de/panorama/promi-tv/florian-silbereisen-helene-fischer-zdf-traumschiff-thomas-seitel-id227687941.html” “Mozilla/5.0 (Linux; Android 6.0; MYA-L11) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36”
In the dwh_fact_events entries are there:
MySQL [kalturadw]> select count(*) from dwh_fact_events where entry_id=‘0_csiqhh7l’;
count
3876323
1 row in set (1.40 sec)
In the dwh_fact_plays are also entries:
mysql> select count(*) from dwh_fact_plays where entry_id=‘0_csiqhh7l’;
count
2100795
1 row in set (1.06 sec)
But there is no entry in dwh_dim_entries
MySQL [kalturadw]> select * from dwh_dim_entries where entry_id =‘0_csiqhh7l’;
Empty set (0.00 sec)
So we tried to set dim_sync_last_update back to server setup date and restartet etl_update_dims.sh.
su kaltura -c “/opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh”
mysql> select * from parameters;
±—±-----------±----------------------------------±----------±--------------------+
| id | process_id | parameter_name | int_value | date_value |
±—±-----------±----------------------------------±----------±--------------------+
| 2 | 0 | dim_sync_last_update | -1 | 2019-11-29 11:00:05 |
| 3 | 2 | fms_stale_session_days_limit | 3 | NULL |
| 8 | 0 | referencial_integrity_last_update | 0 | 2019-11-29 10:39:11 |
| 10 | 0 | convert_job_fact_last_update | 0 | 2019-11-14 13:08:45 |
| 4 | 0 | sync_last_execution_plays_views | 0 | NULL |
| 5 | 0 | sync_start_time_plays_views | 0 | NULL |
| 6 | 0 | sync_last_execution_kuser_storage | 0 | NULL |
| 7 | 0 | sync_start_time_kuser_storage | 0 | NULL |
| 9 | 9 | transcoding_errors_last_update | 0 | 2010-01-01 00:00:00 |
±—±-----------±----------------------------------±----------±--------------------+
9 rows in set (0.00 sec)
But nothing happens with the video. No errors in the logs.
Anyone an idea?
Thanks,
Kind regards
Werner
Kaltura Video Platform (15.9.0) CE
