Advertisement
Guest User

Untitled

a guest
Nov 14th, 2015
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 42.85 KB | None | 0 0
  1. cat etl_hourly-20151114-12.log
  2. INFO 14-11 12:00:11,819 - Kitchen - Start of run.
  3. INFO 14-11 12:00:12,135 - hourly - Start of job execution
  4. INFO 14-11 12:00:12,142 - hourly - Starting entry [Register etl_server]
  5. INFO 14-11 12:00:12,158 - Register etl_server - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/register_etl_server.ktr]
  6. INFO 14-11 12:00:12,294 - register_etl_server - Dispatching started for transformation [register_etl_server]
  7. INFO 14-11 12:00:12,505 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  8. INFO 14-11 12:00:12,777 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  9. INFO 14-11 12:00:12,788 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  10. INFO 14-11 12:00:12,846 - Set hostname command - Optimization level not specified. Using default of 9.
  11. INFO 14-11 12:00:12,965 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  12. INFO 14-11 12:00:12,981 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  13. INFO 14-11 12:00:12,982 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  14. INFO 14-11 12:00:12,983 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  15. INFO 14-11 12:00:12,984 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  16. INFO 14-11 12:00:13,015 - Register server - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  17. INFO 14-11 12:00:13,016 - Copy rows to result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  18. INFO 14-11 12:00:13,018 - hourly - Starting entry [Seize hourly etl server lock]
  19. INFO 14-11 12:00:13,019 - Seize hourly etl server lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/seize_lock_by_name.ktr]
  20. INFO 14-11 12:00:13,108 - seize_lock_by_name - Dispatching started for transformation [seize_lock_by_name]
  21. INFO 14-11 12:00:13,300 - get_etl_server_hourly_lock_name - Dispatching started for transformation [get_etl_server_hourly_lock_name]
  22. INFO 14-11 12:00:13,380 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  23. INFO 14-11 12:00:13,405 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  24. INFO 14-11 12:00:13,420 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  25. INFO 14-11 12:00:13,421 - Set hostname command - Optimization level not specified. Using default of 9.
  26. INFO 14-11 12:00:13,424 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  27. INFO 14-11 12:00:13,439 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  28. INFO 14-11 12:00:13,443 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  29. INFO 14-11 12:00:13,446 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  30. INFO 14-11 12:00:13,457 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  31. INFO 14-11 12:00:13,458 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  32. INFO 14-11 12:00:13,459 - Add hourly lock prefix - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  33. INFO 14-11 12:00:13,461 - Create hourly lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  34. INFO 14-11 12:00:13,462 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  35. INFO 14-11 12:00:13,463 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  36. INFO 14-11 12:00:13,464 - Create lock states - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  37. INFO 14-11 12:00:13,467 - Register lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  38. INFO 14-11 12:00:13,469 - Get free lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  39. INFO 14-11 12:00:13,470 - Lock is free - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  40. INFO 14-11 12:00:13,472 - Get Now - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  41. INFO 14-11 12:00:13,475 - Seize lock - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
  42. INFO 14-11 12:00:13,478 - hourly - Starting entry [Set jobs sequence file name]
  43. INFO 14-11 12:00:13,480 - hourly - Starting entry [Execute hourly sequence]
  44. INFO 14-11 12:00:13,516 - Sequence executioner - Starting entry [get jobs]
  45. INFO 14-11 12:00:13,516 - get jobs - Loading transformation from XML file [file:///opt/kaltura/dwh/etlsource/execute/get_jobs.ktr]
  46. INFO 14-11 12:00:13,561 - get_jobs - Dispatching started for transformation [get_jobs]
  47. INFO 14-11 12:00:13,615 - get etls - Opening file: /opt/kaltura/dwh/etlsource/execute/hourly_etl_execution_sequence.txt
  48. INFO 14-11 12:00:13,633 - get etls - Finished processing (I=1, O=0, R=0, W=1, U=1, E=0)
  49. INFO 14-11 12:00:13,636 - Filter # - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  50. INFO 14-11 12:00:13,638 - Copy rows to result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  51. INFO 14-11 12:00:13,643 - Sequence executioner - Starting entry [execute kettle-job file]
  52. INFO 14-11 12:00:13,673 - execute kjb file - Starting entry [set kjb and log path into vars]
  53. INFO 14-11 12:00:13,673 - set kjb and log path into vars - Loading transformation from XML file [file:///opt/kaltura/dwh/etlsource/execute/set_file_var.ktr]
  54. INFO 14-11 12:00:13,688 - set_file_var - Dispatching started for transformation [set_file_var]
  55. INFO 14-11 12:00:13,692 - Get rows from result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  56. INFO 14-11 12:00:13,692 - jobName from fileName - Optimization level not specified. Using default of 9.
  57. INFO 14-11 12:00:13,701 - Set Variables - Setting environment variables...
  58. INFO 14-11 12:00:13,701 - Set Variables - Set variable fileVar to value [events/events.kjb]
  59. INFO 14-11 12:00:13,701 - Set Variables - Set variable jobVar to value [events_events]
  60. INFO 14-11 12:00:13,703 - jobName from fileName - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  61. INFO 14-11 12:00:13,705 - Set Variables - Finished after 1 rows.
  62. INFO 14-11 12:00:13,705 - Set Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  63. INFO 14-11 12:00:13,707 - execute kjb file - Starting entry [Write To Log - start job]
  64. INFO 14-11 12:00:13,708 - Status - Executing events/events.kjb
  65. Etl base path: /opt/kaltura/dwh/etlsource/
  66. Writing to log [/opt/kaltura/dwh/logs/log_events_events]
  67.  
  68. INFO 14-11 12:00:13,709 - execute kjb file - Starting entry [Run kjbVar job]
  69. INFO 14-11 12:00:13,754 - events cycle process - Starting entry [Set Main Variables]
  70. INFO 14-11 12:00:13,755 - events cycle process - Starting entry [generate_cycle]
  71. INFO 14-11 12:00:13,769 - Get files and generate cycle - Starting entry [Validate process exists in DB]
  72. INFO 14-11 12:00:13,769 - Validate process exists in DB - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/validate_process_in_DB.ktr]
  73. INFO 14-11 12:00:13,782 - Validate process in DB - Dispatching started for transformation [Validate process in DB]
  74. INFO 14-11 12:00:13,793 - Get Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  75. INFO 14-11 12:00:13,797 - Set Variables - Setting environment variables...
  76. INFO 14-11 12:00:13,797 - Set Variables - Set variable ProcessName to value [events]
  77. INFO 14-11 12:00:13,798 - Find process in DB - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  78. INFO 14-11 12:00:13,800 - Filter rows - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  79. INFO 14-11 12:00:13,802 - Set Variables - Finished after 1 rows.
  80. INFO 14-11 12:00:13,802 - Set Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  81. INFO 14-11 12:00:13,804 - Get files and generate cycle - Starting entry [List files from dir (Dynamic ktr load)]
  82. INFO 14-11 12:00:13,805 - List files from dir (Dynamic ktr load) - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/list_files_from_local_dir.ktr]
  83. INFO 14-11 12:00:13,823 - list_files_from_local_dir - Dispatching started for transformation [list_files_from_local_dir]
  84. INFO 14-11 12:00:13,851 - Get File Names - Finished processing (I=0, O=0, R=0, W=17, U=0, E=0)
  85. INFO 14-11 12:00:13,870 - Copy rows to result - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  86. INFO 14-11 12:00:13,873 - Get files and generate cycle - Starting entry [FetchMethod = "remote"]
  87. INFO 14-11 12:00:13,875 - Get files and generate cycle - Starting entry [Register files]
  88. INFO 14-11 12:00:13,876 - Register files - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/register_files.ktr]
  89. INFO 14-11 12:00:13,898 - register_files - Dispatching started for transformation [register_files]
  90. INFO 14-11 12:00:13,984 - Get rows from result - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  91. INFO 14-11 12:00:13,992 - Get input folder - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  92. INFO 14-11 12:00:14,002 - Prep file attributes (compression_suffix, file_size, sub_dir) - Optimization level not specified. Using default of 9.
  93. INFO 14-11 12:00:14,034 - Prep file attributes (compression_suffix, file_size, sub_dir) - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  94. INFO 14-11 12:00:14,045 - Register file - Finished reading query, closing connection.
  95. INFO 14-11 12:00:14,046 - Register file - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  96. INFO 14-11 12:00:14,050 - Get files and generate cycle - Starting entry [Get registered cycles]
  97. INFO 14-11 12:00:14,050 - Get registered cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/read_assigned_cycles_by_status.ktr]
  98. INFO 14-11 12:00:14,064 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  99. INFO 14-11 12:00:14,090 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  100. INFO 14-11 12:00:14,097 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  101. INFO 14-11 12:00:14,100 - Set hostname command - Optimization level not specified. Using default of 9.
  102. INFO 14-11 12:00:14,101 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  103. INFO 14-11 12:00:14,109 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  104. INFO 14-11 12:00:14,112 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  105. INFO 14-11 12:00:14,114 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  106. INFO 14-11 12:00:14,116 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  107. INFO 14-11 12:00:14,116 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  108. INFO 14-11 12:00:14,262 - Get cycle id - Finished reading query, closing connection.
  109. INFO 14-11 12:00:14,263 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  110. INFO 14-11 12:00:14,268 - Get files and generate cycle - Starting entry [Get files for registered cycles]
  111. INFO 14-11 12:00:14,268 - Get files for registered cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/get_files_for_registered_cycles.ktr]
  112. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Get files for registered cycles] (result=[true])
  113. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Get registered cycles] (result=[true])
  114. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Register files] (result=[true])
  115. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [FetchMethod = "remote"] (result=[true])
  116. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [List files from dir (Dynamic ktr load)] (result=[true])
  117. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Validate process exists in DB] (result=[true])
  118. INFO 14-11 12:00:14,291 - events cycle process - Starting entry [process cycle]
  119. INFO 14-11 12:00:14,314 - Process cycle - Starting entry [Get generated cycles]
  120. INFO 14-11 12:00:14,315 - Get generated cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  121. INFO 14-11 12:00:14,322 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  122. INFO 14-11 12:00:14,334 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  123. INFO 14-11 12:00:14,623 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  124. INFO 14-11 12:00:14,660 - Set hostname command - Optimization level not specified. Using default of 9.
  125. INFO 14-11 12:00:14,662 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  126. INFO 14-11 12:00:14,667 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  127. INFO 14-11 12:00:14,669 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  128. INFO 14-11 12:00:14,671 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  129. INFO 14-11 12:00:14,672 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  130. INFO 14-11 12:00:14,673 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  131. INFO 14-11 12:00:14,818 - Get cycle id - Finished reading query, closing connection.
  132. INFO 14-11 12:00:14,819 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  133. INFO 14-11 12:00:14,826 - Process cycle - Starting entry [Process single cycle]
  134. INFO 14-11 12:00:14,853 - Process cycle - Starting entry [Get processed cycles]
  135. INFO 14-11 12:00:14,855 - Get generated cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  136. INFO 14-11 12:00:14,891 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  137. INFO 14-11 12:00:14,968 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  138. INFO 14-11 12:00:14,976 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  139. INFO 14-11 12:00:14,978 - Set hostname command - Optimization level not specified. Using default of 9.
  140. INFO 14-11 12:00:14,982 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  141. INFO 14-11 12:00:14,994 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  142. INFO 14-11 12:00:14,998 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  143. INFO 14-11 12:00:15,001 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  144. INFO 14-11 12:00:15,003 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  145. INFO 14-11 12:00:15,003 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  146. INFO 14-11 12:00:15,152 - Get cycle id - Finished reading query, closing connection.
  147. INFO 14-11 12:00:15,153 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  148. INFO 14-11 12:00:15,156 - Process cycle - Starting entry [load single cycle]
  149. INFO 14-11 12:00:15,178 - Process cycle - Finished job entry [load single cycle] (result=[true])
  150. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Get processed cycles] (result=[true])
  151. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Process single cycle] (result=[true])
  152. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Get generated cycles] (result=[true])
  153. INFO 14-11 12:00:15,182 - events cycle process - Starting entry [transfer cycle]
  154. INFO 14-11 12:00:15,209 - transfer cycle - Starting entry [Get processed cycle]
  155. INFO 14-11 12:00:15,213 - Get processed cycle - Loading transformation from XML file [file:////opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  156. INFO 14-11 12:00:15,234 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  157. INFO 14-11 12:00:15,263 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  158. INFO 14-11 12:00:15,279 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  159. INFO 14-11 12:00:15,289 - Set hostname command - Optimization level not specified. Using default of 9.
  160. INFO 14-11 12:00:15,291 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  161. INFO 14-11 12:00:15,297 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  162. INFO 14-11 12:00:15,300 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  163. INFO 14-11 12:00:15,301 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  164. INFO 14-11 12:00:15,303 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  165. INFO 14-11 12:00:15,304 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  166. INFO 14-11 12:00:15,450 - Get cycle id - Finished reading query, closing connection.
  167. INFO 14-11 12:00:15,451 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  168. INFO 14-11 12:00:15,456 - transfer cycle - Starting entry [transfer cycle]
  169. INFO 14-11 12:00:15,457 - transfer cycle - Loading transformation from XML file [file:////opt/kaltura/dwh/etlsource/cycles/transfer_cycle.ktr]
  170. INFO 14-11 12:00:15,491 - transfer cycle - Finished job entry [transfer cycle] (result=[true])
  171. INFO 14-11 12:00:15,491 - transfer cycle - Finished job entry [Get processed cycle] (result=[true])
  172. INFO 14-11 12:00:15,493 - events cycle process - Finished job entry [transfer cycle] (result=[true])
  173. INFO 14-11 12:00:15,493 - events cycle process - Finished job entry [process cycle] (result=[true])
  174. INFO 14-11 12:00:15,494 - events cycle process - Finished job entry [generate_cycle] (result=[true])
  175. INFO 14-11 12:00:15,494 - events cycle process - Finished job entry [Set Main Variables] (result=[true])
  176. INFO 14-11 12:00:15,521 - execute kjb file - Starting entry [Write To Log on success]
  177. INFO 14-11 12:00:15,522 - Status - Success events/events.kjb
  178.  
  179. INFO 14-11 12:00:15,522 - execute kjb file - Finished job entry [Write To Log on success] (result=[true])
  180. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [Run kjbVar job] (result=[true])
  181. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [Write To Log - start job] (result=[true])
  182. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [set kjb and log path into vars] (result=[true])
  183. INFO 14-11 12:00:15,533 - Sequence executioner - Finished job entry [execute kettle-job file] (result=[true])
  184. INFO 14-11 12:00:15,533 - Sequence executioner - Finished job entry [get jobs] (result=[true])
  185. INFO 14-11 12:00:15,544 - hourly - Starting entry [Release hourly etl server lock ]
  186. INFO 14-11 12:00:15,544 - Release hourly etl server lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/release_lock_by_name.ktr]
  187. INFO 14-11 12:00:15,576 - release_lock_by_name - Dispatching started for transformation [release_lock_by_name]
  188. INFO 14-11 12:00:15,613 - get_etl_server_hourly_lock_name - Dispatching started for transformation [get_etl_server_hourly_lock_name]
  189. INFO 14-11 12:00:15,680 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  190. INFO 14-11 12:00:15,687 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  191. INFO 14-11 12:00:15,711 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  192. INFO 14-11 12:00:15,712 - Set hostname command - Optimization level not specified. Using default of 9.
  193. INFO 14-11 12:00:15,715 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  194. INFO 14-11 12:00:15,731 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  195. INFO 14-11 12:00:15,747 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  196. INFO 14-11 12:00:15,748 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  197. INFO 14-11 12:00:15,750 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  198. INFO 14-11 12:00:15,750 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  199. INFO 14-11 12:00:15,752 - Add hourly lock prefix - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  200. INFO 14-11 12:00:15,754 - Create hourly lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  201. INFO 14-11 12:00:15,756 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  202. INFO 14-11 12:00:15,756 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  203. INFO 14-11 12:00:15,758 - Set lock free state - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  204. INFO 14-11 12:00:15,761 - Get Now - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  205. INFO 14-11 12:00:15,764 - Free lock - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
  206. INFO 14-11 12:00:15,766 - hourly - Starting entry [Success 1]
  207. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Success 1] (result=[true])
  208. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Release hourly etl server lock ] (result=[true])
  209. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Execute hourly sequence] (result=[true])
  210. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Set jobs sequence file name] (result=[true])
  211. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Seize hourly etl server lock] (result=[true])
  212. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Register etl_server] (result=[true])
  213. INFO 14-11 12:00:15,769 - hourly - Job execution finished
  214. INFO 14-11 12:00:15,773 - Kitchen - Finished!
  215. INFO 14-11 12:00:15,773 - Kitchen - Start=2015/11/14 12:00:11.823, Stop=2015/11/14 12:00:15.773
  216. INFO 14-11 12:00:15,773 - Kitchen - Processing ended after 3 seconds.
  217. sh: /opt/kaltura/bin/pentaho/kitchen.sh: No such file or directory
  218. [root@centos logs]# clear
  219. [root@centos logs]# cat etl_hourly-20151114-12.log
  220. INFO 14-11 12:00:11,819 - Kitchen - Start of run.
  221. INFO 14-11 12:00:12,135 - hourly - Start of job execution
  222. INFO 14-11 12:00:12,142 - hourly - Starting entry [Register etl_server]
  223. INFO 14-11 12:00:12,158 - Register etl_server - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/register_etl_server.ktr]
  224. INFO 14-11 12:00:12,294 - register_etl_server - Dispatching started for transformation [register_etl_server]
  225. INFO 14-11 12:00:12,505 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  226. INFO 14-11 12:00:12,777 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  227. INFO 14-11 12:00:12,788 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  228. INFO 14-11 12:00:12,846 - Set hostname command - Optimization level not specified. Using default of 9.
  229. INFO 14-11 12:00:12,965 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  230. INFO 14-11 12:00:12,981 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  231. INFO 14-11 12:00:12,982 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  232. INFO 14-11 12:00:12,983 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  233. INFO 14-11 12:00:12,984 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  234. INFO 14-11 12:00:13,015 - Register server - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  235. INFO 14-11 12:00:13,016 - Copy rows to result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  236. INFO 14-11 12:00:13,018 - hourly - Starting entry [Seize hourly etl server lock]
  237. INFO 14-11 12:00:13,019 - Seize hourly etl server lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/seize_lock_by_name.ktr]
  238. INFO 14-11 12:00:13,108 - seize_lock_by_name - Dispatching started for transformation [seize_lock_by_name]
  239. INFO 14-11 12:00:13,300 - get_etl_server_hourly_lock_name - Dispatching started for transformation [get_etl_server_hourly_lock_name]
  240. INFO 14-11 12:00:13,380 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  241. INFO 14-11 12:00:13,405 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  242. INFO 14-11 12:00:13,420 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  243. INFO 14-11 12:00:13,421 - Set hostname command - Optimization level not specified. Using default of 9.
  244. INFO 14-11 12:00:13,424 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  245. INFO 14-11 12:00:13,439 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  246. INFO 14-11 12:00:13,443 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  247. INFO 14-11 12:00:13,446 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  248. INFO 14-11 12:00:13,457 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  249. INFO 14-11 12:00:13,458 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  250. INFO 14-11 12:00:13,459 - Add hourly lock prefix - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  251. INFO 14-11 12:00:13,461 - Create hourly lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  252. INFO 14-11 12:00:13,462 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  253. INFO 14-11 12:00:13,463 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  254. INFO 14-11 12:00:13,464 - Create lock states - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  255. INFO 14-11 12:00:13,467 - Register lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  256. INFO 14-11 12:00:13,469 - Get free lock - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  257. INFO 14-11 12:00:13,470 - Lock is free - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  258. INFO 14-11 12:00:13,472 - Get Now - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  259. INFO 14-11 12:00:13,475 - Seize lock - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
  260. INFO 14-11 12:00:13,478 - hourly - Starting entry [Set jobs sequence file name]
  261. INFO 14-11 12:00:13,480 - hourly - Starting entry [Execute hourly sequence]
  262. INFO 14-11 12:00:13,516 - Sequence executioner - Starting entry [get jobs]
  263. INFO 14-11 12:00:13,516 - get jobs - Loading transformation from XML file [file:///opt/kaltura/dwh/etlsource/execute/get_jobs.ktr]
  264. INFO 14-11 12:00:13,561 - get_jobs - Dispatching started for transformation [get_jobs]
  265. INFO 14-11 12:00:13,615 - get etls - Opening file: /opt/kaltura/dwh/etlsource/execute/hourly_etl_execution_sequence.txt
  266. INFO 14-11 12:00:13,633 - get etls - Finished processing (I=1, O=0, R=0, W=1, U=1, E=0)
  267. INFO 14-11 12:00:13,636 - Filter # - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  268. INFO 14-11 12:00:13,638 - Copy rows to result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  269. INFO 14-11 12:00:13,643 - Sequence executioner - Starting entry [execute kettle-job file]
  270. INFO 14-11 12:00:13,673 - execute kjb file - Starting entry [set kjb and log path into vars]
  271. INFO 14-11 12:00:13,673 - set kjb and log path into vars - Loading transformation from XML file [file:///opt/kaltura/dwh/etlsource/execute/set_file_var.ktr]
  272. INFO 14-11 12:00:13,688 - set_file_var - Dispatching started for transformation [set_file_var]
  273. INFO 14-11 12:00:13,692 - Get rows from result - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  274. INFO 14-11 12:00:13,692 - jobName from fileName - Optimization level not specified. Using default of 9.
  275. INFO 14-11 12:00:13,701 - Set Variables - Setting environment variables...
  276. INFO 14-11 12:00:13,701 - Set Variables - Set variable fileVar to value [events/events.kjb]
  277. INFO 14-11 12:00:13,701 - Set Variables - Set variable jobVar to value [events_events]
  278. INFO 14-11 12:00:13,703 - jobName from fileName - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  279. INFO 14-11 12:00:13,705 - Set Variables - Finished after 1 rows.
  280. INFO 14-11 12:00:13,705 - Set Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  281. INFO 14-11 12:00:13,707 - execute kjb file - Starting entry [Write To Log - start job]
  282. INFO 14-11 12:00:13,708 - Status - Executing events/events.kjb
  283. Etl base path: /opt/kaltura/dwh/etlsource/
  284. Writing to log [/opt/kaltura/dwh/logs/log_events_events]
  285.  
  286. INFO 14-11 12:00:13,709 - execute kjb file - Starting entry [Run kjbVar job]
  287. INFO 14-11 12:00:13,754 - events cycle process - Starting entry [Set Main Variables]
  288. INFO 14-11 12:00:13,755 - events cycle process - Starting entry [generate_cycle]
  289. INFO 14-11 12:00:13,769 - Get files and generate cycle - Starting entry [Validate process exists in DB]
  290. INFO 14-11 12:00:13,769 - Validate process exists in DB - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/validate_process_in_DB.ktr]
  291. INFO 14-11 12:00:13,782 - Validate process in DB - Dispatching started for transformation [Validate process in DB]
  292. INFO 14-11 12:00:13,793 - Get Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  293. INFO 14-11 12:00:13,797 - Set Variables - Setting environment variables...
  294. INFO 14-11 12:00:13,797 - Set Variables - Set variable ProcessName to value [events]
  295. INFO 14-11 12:00:13,798 - Find process in DB - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  296. INFO 14-11 12:00:13,800 - Filter rows - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  297. INFO 14-11 12:00:13,802 - Set Variables - Finished after 1 rows.
  298. INFO 14-11 12:00:13,802 - Set Variables - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  299. INFO 14-11 12:00:13,804 - Get files and generate cycle - Starting entry [List files from dir (Dynamic ktr load)]
  300. INFO 14-11 12:00:13,805 - List files from dir (Dynamic ktr load) - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/list_files_from_local_dir.ktr]
  301. INFO 14-11 12:00:13,823 - list_files_from_local_dir - Dispatching started for transformation [list_files_from_local_dir]
  302. INFO 14-11 12:00:13,851 - Get File Names - Finished processing (I=0, O=0, R=0, W=17, U=0, E=0)
  303. INFO 14-11 12:00:13,870 - Copy rows to result - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  304. INFO 14-11 12:00:13,873 - Get files and generate cycle - Starting entry [FetchMethod = "remote"]
  305. INFO 14-11 12:00:13,875 - Get files and generate cycle - Starting entry [Register files]
  306. INFO 14-11 12:00:13,876 - Register files - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/register_files.ktr]
  307. INFO 14-11 12:00:13,898 - register_files - Dispatching started for transformation [register_files]
  308. INFO 14-11 12:00:13,984 - Get rows from result - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  309. INFO 14-11 12:00:13,992 - Get input folder - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  310. INFO 14-11 12:00:14,002 - Prep file attributes (compression_suffix, file_size, sub_dir) - Optimization level not specified. Using default of 9.
  311. INFO 14-11 12:00:14,034 - Prep file attributes (compression_suffix, file_size, sub_dir) - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  312. INFO 14-11 12:00:14,045 - Register file - Finished reading query, closing connection.
  313. INFO 14-11 12:00:14,046 - Register file - Finished processing (I=0, O=0, R=17, W=17, U=0, E=0)
  314. INFO 14-11 12:00:14,050 - Get files and generate cycle - Starting entry [Get registered cycles]
  315. INFO 14-11 12:00:14,050 - Get registered cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/read_assigned_cycles_by_status.ktr]
  316. INFO 14-11 12:00:14,064 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  317. INFO 14-11 12:00:14,090 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  318. INFO 14-11 12:00:14,097 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  319. INFO 14-11 12:00:14,100 - Set hostname command - Optimization level not specified. Using default of 9.
  320. INFO 14-11 12:00:14,101 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  321. INFO 14-11 12:00:14,109 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  322. INFO 14-11 12:00:14,112 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  323. INFO 14-11 12:00:14,114 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  324. INFO 14-11 12:00:14,116 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  325. INFO 14-11 12:00:14,116 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  326. INFO 14-11 12:00:14,262 - Get cycle id - Finished reading query, closing connection.
  327. INFO 14-11 12:00:14,263 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  328. INFO 14-11 12:00:14,268 - Get files and generate cycle - Starting entry [Get files for registered cycles]
  329. INFO 14-11 12:00:14,268 - Get files for registered cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//cycles/get_files_for_registered_cycles.ktr]
  330. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Get files for registered cycles] (result=[true])
  331. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Get registered cycles] (result=[true])
  332. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Register files] (result=[true])
  333. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [FetchMethod = "remote"] (result=[true])
  334. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [List files from dir (Dynamic ktr load)] (result=[true])
  335. INFO 14-11 12:00:14,286 - Get files and generate cycle - Finished job entry [Validate process exists in DB] (result=[true])
  336. INFO 14-11 12:00:14,291 - events cycle process - Starting entry [process cycle]
  337. INFO 14-11 12:00:14,314 - Process cycle - Starting entry [Get generated cycles]
  338. INFO 14-11 12:00:14,315 - Get generated cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  339. INFO 14-11 12:00:14,322 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  340. INFO 14-11 12:00:14,334 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  341. INFO 14-11 12:00:14,623 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  342. INFO 14-11 12:00:14,660 - Set hostname command - Optimization level not specified. Using default of 9.
  343. INFO 14-11 12:00:14,662 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  344. INFO 14-11 12:00:14,667 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  345. INFO 14-11 12:00:14,669 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  346. INFO 14-11 12:00:14,671 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  347. INFO 14-11 12:00:14,672 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  348. INFO 14-11 12:00:14,673 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  349. INFO 14-11 12:00:14,818 - Get cycle id - Finished reading query, closing connection.
  350. INFO 14-11 12:00:14,819 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  351. INFO 14-11 12:00:14,826 - Process cycle - Starting entry [Process single cycle]
  352. INFO 14-11 12:00:14,853 - Process cycle - Starting entry [Get processed cycles]
  353. INFO 14-11 12:00:14,855 - Get generated cycles - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  354. INFO 14-11 12:00:14,891 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  355. INFO 14-11 12:00:14,968 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  356. INFO 14-11 12:00:14,976 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  357. INFO 14-11 12:00:14,978 - Set hostname command - Optimization level not specified. Using default of 9.
  358. INFO 14-11 12:00:14,982 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  359. INFO 14-11 12:00:14,994 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  360. INFO 14-11 12:00:14,998 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  361. INFO 14-11 12:00:15,001 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  362. INFO 14-11 12:00:15,003 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  363. INFO 14-11 12:00:15,003 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  364. INFO 14-11 12:00:15,152 - Get cycle id - Finished reading query, closing connection.
  365. INFO 14-11 12:00:15,153 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  366. INFO 14-11 12:00:15,156 - Process cycle - Starting entry [load single cycle]
  367. INFO 14-11 12:00:15,178 - Process cycle - Finished job entry [load single cycle] (result=[true])
  368. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Get processed cycles] (result=[true])
  369. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Process single cycle] (result=[true])
  370. INFO 14-11 12:00:15,180 - Process cycle - Finished job entry [Get generated cycles] (result=[true])
  371. INFO 14-11 12:00:15,182 - events cycle process - Starting entry [transfer cycle]
  372. INFO 14-11 12:00:15,209 - transfer cycle - Starting entry [Get processed cycle]
  373. INFO 14-11 12:00:15,213 - Get processed cycle - Loading transformation from XML file [file:////opt/kaltura/dwh/etlsource/cycles/read_assigned_cycles_by_status.ktr]
  374. INFO 14-11 12:00:15,234 - Read assigned cycles by status - Dispatching started for transformation [Read assigned cycles by status]
  375. INFO 14-11 12:00:15,263 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  376. INFO 14-11 12:00:15,279 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  377. INFO 14-11 12:00:15,289 - Set hostname command - Optimization level not specified. Using default of 9.
  378. INFO 14-11 12:00:15,291 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  379. INFO 14-11 12:00:15,297 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  380. INFO 14-11 12:00:15,300 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  381. INFO 14-11 12:00:15,301 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  382. INFO 14-11 12:00:15,303 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  383. INFO 14-11 12:00:15,304 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  384. INFO 14-11 12:00:15,450 - Get cycle id - Finished reading query, closing connection.
  385. INFO 14-11 12:00:15,451 - Get cycle id - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  386. INFO 14-11 12:00:15,456 - transfer cycle - Starting entry [transfer cycle]
  387. INFO 14-11 12:00:15,457 - transfer cycle - Loading transformation from XML file [file:////opt/kaltura/dwh/etlsource/cycles/transfer_cycle.ktr]
  388. INFO 14-11 12:00:15,491 - transfer cycle - Finished job entry [transfer cycle] (result=[true])
  389. INFO 14-11 12:00:15,491 - transfer cycle - Finished job entry [Get processed cycle] (result=[true])
  390. INFO 14-11 12:00:15,493 - events cycle process - Finished job entry [transfer cycle] (result=[true])
  391. INFO 14-11 12:00:15,493 - events cycle process - Finished job entry [process cycle] (result=[true])
  392. INFO 14-11 12:00:15,494 - events cycle process - Finished job entry [generate_cycle] (result=[true])
  393. INFO 14-11 12:00:15,494 - events cycle process - Finished job entry [Set Main Variables] (result=[true])
  394. INFO 14-11 12:00:15,521 - execute kjb file - Starting entry [Write To Log on success]
  395. INFO 14-11 12:00:15,522 - Status - Success events/events.kjb
  396.  
  397. INFO 14-11 12:00:15,522 - execute kjb file - Finished job entry [Write To Log on success] (result=[true])
  398. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [Run kjbVar job] (result=[true])
  399. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [Write To Log - start job] (result=[true])
  400. INFO 14-11 12:00:15,523 - execute kjb file - Finished job entry [set kjb and log path into vars] (result=[true])
  401. INFO 14-11 12:00:15,533 - Sequence executioner - Finished job entry [execute kettle-job file] (result=[true])
  402. INFO 14-11 12:00:15,533 - Sequence executioner - Finished job entry [get jobs] (result=[true])
  403. INFO 14-11 12:00:15,544 - hourly - Starting entry [Release hourly etl server lock ]
  404. INFO 14-11 12:00:15,544 - Release hourly etl server lock - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/release_lock_by_name.ktr]
  405. INFO 14-11 12:00:15,576 - release_lock_by_name - Dispatching started for transformation [release_lock_by_name]
  406. INFO 14-11 12:00:15,613 - get_etl_server_hourly_lock_name - Dispatching started for transformation [get_etl_server_hourly_lock_name]
  407. INFO 14-11 12:00:15,680 - print_hostname_to_stream - Dispatching started for transformation [print_hostname_to_stream]
  408. INFO 14-11 12:00:15,687 - Generate Row - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
  409. INFO 14-11 12:00:15,711 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  410. INFO 14-11 12:00:15,712 - Set hostname command - Optimization level not specified. Using default of 9.
  411. INFO 14-11 12:00:15,715 - Mapping input specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  412. INFO 14-11 12:00:15,731 - Set hostname command - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  413. INFO 14-11 12:00:15,747 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  414. INFO 14-11 12:00:15,748 - Select hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  415. INFO 14-11 12:00:15,750 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  416. INFO 14-11 12:00:15,750 - Get hostname - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  417. INFO 14-11 12:00:15,752 - Add hourly lock prefix - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  418. INFO 14-11 12:00:15,754 - Create hourly lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  419. INFO 14-11 12:00:15,756 - Mapping output specification - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  420. INFO 14-11 12:00:15,756 - Get lock name - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  421. INFO 14-11 12:00:15,758 - Set lock free state - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  422. INFO 14-11 12:00:15,761 - Get Now - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  423. INFO 14-11 12:00:15,764 - Free lock - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
  424. INFO 14-11 12:00:15,766 - hourly - Starting entry [Success 1]
  425. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Success 1] (result=[true])
  426. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Release hourly etl server lock ] (result=[true])
  427. INFO 14-11 12:00:15,768 - hourly - Finished job entry [Execute hourly sequence] (result=[true])
  428. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Set jobs sequence file name] (result=[true])
  429. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Seize hourly etl server lock] (result=[true])
  430. INFO 14-11 12:00:15,769 - hourly - Finished job entry [Register etl_server] (result=[true])
  431. INFO 14-11 12:00:15,769 - hourly - Job execution finished
  432. INFO 14-11 12:00:15,773 - Kitchen - Finished!
  433. INFO 14-11 12:00:15,773 - Kitchen - Start=2015/11/14 12:00:11.823, Stop=2015/11/14 12:00:15.773
  434. INFO 14-11 12:00:15,773 - Kitchen - Processing ended after 3 seconds.
  435. sh: /opt/kaltura/bin/pentaho/kitchen.sh: No such file or directory
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement