@orly.lampert
When I attempt running /opt/kaltura/dwh/etlsource/execute/etl_update_dims.sh and then still have no entries, I check the update log, and the errors I see in there are with lock files
INFO 17-10 11:46:17,483 - Kitchen - Start of run.
INFO 17-10 11:46:17,639 - Update Dimensions - Start of job execution
INFO 17-10 11:46:18,123 - Update Dimensions - Starting entry [Check if daily_lock is seized]
INFO 17-10 11:46:18,147 - Update Dimensions - Starting entry [Seize update dims lock]
INFO 17-10 11:46:18,148 - Seize update dims lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/seize_lock_by_name.ktr]
INFO 17-10 11:46:18,287 - seize_lock_by_name - Dispatching started for transformation [seize_lock_by_name]
INFO 17-10 11:46:18,378 - get_update_dims_lock_name - Dispatching started for transformation [get_update_dims_lock_name]
INFO 17-10 11:46:18,389 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
INFO 17-10 11:46:18,392 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,394 - Set lock name = dims_lock - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,395 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,396 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,397 - Create lock states - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,403 - Register lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
ERROR 17-10 11:46:18,406 - Lock is already seized - Row nr 1 causing abort : [update_dims_lock], [1], [0], [null]
ERROR 17-10 11:46:18,406 - Lock is already seized - Aborting after having seen 1 rows.
ERROR 17-10 11:46:18,407 - seize_lock_by_name - Errors detected!
ERROR 17-10 11:46:18,407 - seize_lock_by_name - Errors detected!
INFO 17-10 11:46:18,407 - Lock is already seized - Finished processing (I=0, O=0, R=1, W=1, U=0, E=1)
INFO 17-10 11:46:18,408 - seize_lock_by_name - seize_lock_by_name
INFO 17-10 11:46:18,408 - Lock is free - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,408 - seize_lock_by_name - seize_lock_by_name
INFO 17-10 11:46:18,409 - Get free lock - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 17-10 11:46:18,592 - Update Dimensions - Starting entry [Success 1]
INFO 17-10 11:46:18,593 - Update Dimensions - Finished job entry [Success 1] (result=[true])
INFO 17-10 11:46:18,593 - Update Dimensions - Finished job entry [Seize update dims lock] (result=[true])
INFO 17-10 11:46:18,593 - Update Dimensions - Finished job entry [Check if daily_lock is seized] (result=[true])
INFO 17-10 11:46:18,594 - Update Dimensions - Job execution finished
INFO 17-10 11:46:18,655 - Kitchen - Finished!
INFO 17-10 11:46:18,656 - Kitchen - Start=2013/10/17 11:46:17.484, Stop=2013/10/17 11:46:18.656
INFO 17-10 11:46:18,656 - Kitchen - Processing ended after 1 seconds.