Analytics data not showing/visible

Hi @nabil_naim1,

0 10 should work the same as 00 10 does but I agree that for consistency’s sake it should be corrected. You should still see an entry like:

10:00:01 ce-front0 CROND[9729]: (kaltura) CMD (/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log)

in /var/log/cron, if you don’t, then we have a problem but I imagine you will:)

Another thing to look at is /opt/kaltura/log/cron.log, anything there to indicate a problem?

You are right, this means cron job can’t update play number automatically

less /var/log/cron | grep -i “dwh_plays_views_sync.sh” -B2 -A2

Jan 22 10:00:01 KaltureServer CROND[19590]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_hourly.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 22 10:00:01 KaltureServer CROND[19591]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Jan 22 10:00:01 KaltureServer CROND[19593]: (kaltura) CMD (/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log)
Jan 22 10:00:01 KaltureServer CROND[19594]: (apache) CMD (/opt/kaltura/app/alpha/crond/kaltura/clear_cache.sh 2>&1 >> /opt/kaltura/log/cron.log)
Jan 22 10:00:01 KaltureServer CROND[19592]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)

Jan 23 09:45:01 KaltureServer CROND[15319]: (apache) CMD (/opt/kaltura/app/alpha/crond/kaltura/clear_cache.sh 2>&1 >> /opt/kaltura/log/cron.log)
Jan 23 09:50:01 KaltureServer CROND[15813]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Jan 23 10:00:01 KaltureServer CROND[17936]: (kaltura) CMD (/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log)
Jan 23 10:00:01 KaltureServer CROND[17937]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_hourly.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)
Jan 23 10:00:01 KaltureServer CROND[17939]: (kaltura) CMD (/opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh)

cat /opt/kaltura/log/cron.log only contains
Mon Jan 23 04:00:01 EET 2017
Mon Jan 23 04:15:01 EET 2017
Mon Jan 23 04:30:01 EET 2017
Mon Jan 23 04:45:01 EET 2017
Mon Jan 23 05:00:01 EET 2017
Mon Jan 23 05:15:01 EET 2017
Mon Jan 23 05:30:01 EET 2017
Mon Jan 23 05:45:01 EET 2017

Still i have the same issue running “/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh” from cron job doesn’t update the content video plays although when i run it from script it works fine
#less /var/log/cron | grep -i "dwh_plays_views_sync.sh"
shows
Jan 26 10:00:01 KaltureServer CROND[4005]: (kaltura) CMD (/opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log)

cat /opt/kaltura/log/cron.log
shows
Thu Jan 26 14:30:01 EET 2017
Thu Jan 26 14:45:01 EET 2017
Thu Jan 26 15:00:02 EET 2017
Thu Jan 26 15:15:01 EET 2017
Thu Jan 26 15:30:01 EET 2017
Thu Jan 26 15:45:01 EET 2017
Thu Jan 26 16:00:01 EET 2017
Thu Jan 26 16:15:01 EET 2017
Thu Jan 26 16:30:01 EET 2017
Thu Jan 26 16:45:01 EET 2017
(Only time Stamp)

cron job
00 10 * * * kaltura /opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log

script run from bash
[root@KaltureServer log]# su kaltura
[kaltura@KaltureServer log]$ /opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh
after this i find all media plays in content tab update

Also below command shows nothing

grep ERROR /opt/kaltura/dwh/logs/*

Can you change:

00 10 * * * kaltura /opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log

to read:

00 10 * * * kaltura /opt/kaltura/app/alpha/scripts/dwh/dwh_plays_views_sync.sh >> /opt/kaltura/log/cron.log 2>&1
``
? 
this would also redirect output sent to STDERR to /opt/kaltura/log/cron.log. Perhaps there are errors during the execution when it's done by crond