API tools faq
paste
Guest User

Untitled

a guest
Dec 10th, 2017
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.28 KB | None | 0 0
raw download clone embed print report
  1. RAILS_ENV=production PAN=/usr/local/bin/data-integration/pan.sh GEM_PATH=/usr/local/rvm/gems/ruby-1.9.2-p0@ballista BUNDLE_GEMFILE=/srv/ballista/current/Gemfile BUNDLE_PATH=/usr/local/rvm/gems/ruby-1.9.2-p0@ballista /usr/local/rvm/gems/ruby-1.9.2-p0@ballista/bin/bundle exec /usr/local/rvm/rubies/ruby-1.9.2-p0/bin/ruby /srv/ballista/current/lib/crons/populate_warehouse.rb
  2. [INFO] Using pan at /usr/local/bin/data-integration/pan.sh
  3. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  4. -file:/srv/ballista/current/data/update_dimensions.ktr
  5. -param:ballista_dw_dev_host=db.moneydesktop.com
  6. -param:ballista_dw_dev_database=ballista_dw_production
  7. -param:ballista_dw_dev_username=postgres
  8. -param:ballista_dw_dev_password=IceQu33n^
  9. -param:ballista_host=db.moneydesktop.com
  10. -param:ballista_database=ballista_dw_production
  11. -param:ballista_username=postgres
  12. -param:ballista_password=IceQu33n^
  13. -param:persona_host=db.moneydesktop.com
  14. -param:persona_database=persona_production
  15. -param:persona_username=postgres
  16. -param:persona_password=IceQu33n^
  17. -param:amigo_host=db.moneydesktop.com
  18. -param:amigo_database=amigo_production
  19. -param:amigo_username=postgres
  20. -param:amigo_password=IceQu33n^
  21. [DEBUG]
  22. [DEBUG] INFO 13-05 16:14:56,199 - Using "/tmp/vfs_cache" as temporary files store.
  23. INFO 13-05 16:14:56,630 - Pan - Start of run.
  24. INFO 13-05 16:14:56,863 - Update Ballista Warehouse - Dispatching started for transformation [Update Ballista Warehouse]
  25. INFO 13-05 16:14:56,878 - Update Ballista Warehouse - This transformation can be replayed with replay date: 2011/05/13 16:14:56
  26. INFO 13-05 16:14:57,150 - read clients - Finished reading query, closing connection.
  27. INFO 13-05 16:14:57,210 - read clients - Finished processing (I=142, O=0, R=0, W=142, U=0, E=0)
  28. INFO 13-05 16:14:57,214 - read user login events - Finished reading query, closing connection.
  29. INFO 13-05 16:14:57,217 - read user login events - Finished processing (I=162, O=0, R=0, W=162, U=0, E=0)
  30. INFO 13-05 16:14:57,438 - Insert / Update Clients - Finished processing (I=142, O=0, R=142, W=142, U=0, E=0)
  31. INFO 13-05 16:14:57,630 - Insert / Update User Login Events - Finished processing (I=162, O=6, R=162, W=162, U=0, E=0)
  32. INFO 13-05 16:14:59,583 - Read Institutions - Finished reading query, closing connection.
  33. INFO 13-05 16:14:59,597 - Read Institutions - Finished processing (I=10070, O=0, R=0, W=10070, U=0, E=0)
  34. INFO 13-05 16:15:01,278 - Read Users - Finished reading query, closing connection.
  35. INFO 13-05 16:15:01,286 - Read Users - Finished processing (I=6995, O=0, R=0, W=6995, U=0, E=0)
  36. INFO 13-05 16:15:05,086 - Insert / Update Users - Finished processing (I=6995, O=2, R=6995, W=6995, U=0, E=0)
  37. INFO 13-05 16:15:05,732 - Insert / Update Institutions - Finished processing (I=10070, O=0, R=10070, W=10070, U=0, E=0)
  38. INFO 13-05 16:15:17,735 - Read Jobs - linenr 50000
  39. INFO 13-05 16:15:21,632 - Insert / Update Jobs - linenr 50000
  40. INFO 13-05 16:15:37,683 - Read Jobs - linenr 100000
  41. INFO 13-05 16:15:41,583 - Insert / Update Jobs - linenr 100000
  42. INFO 13-05 16:15:45,203 - Read Jobs - Finished reading query, closing connection.
  43. INFO 13-05 16:15:45,205 - Read Jobs - Finished processing (I=119369, O=0, R=0, W=119369, U=0, E=0)
  44. INFO 13-05 16:15:48,992 - Insert / Update Jobs - Finished processing (I=119369, O=9, R=119369, W=119369, U=0, E=0)
  45. INFO 13-05 16:15:48,993 - Pan - Finished!
  46. INFO 13-05 16:15:48,993 - Pan - Start=2011/05/13 16:14:56.635, Stop=2011/05/13 16:15:48.993
  47. INFO 13-05 16:15:48,993 - Pan - Processing ended after 52 seconds.
  48. INFO 13-05 16:15:48,996 - Update Ballista Warehouse -
  49. INFO 13-05 16:15:48,996 - Update Ballista Warehouse - Step Read Institutions.0 ended successfully, processed 10070 lines. ( 193 lines/s)
  50. INFO 13-05 16:15:48,996 - Update Ballista Warehouse - Step Insert / Update Institutions.0 ended successfully, processed 10070 lines. ( 193 lines/s)
  51. INFO 13-05 16:15:48,996 - Update Ballista Warehouse - Step Read Jobs.0 ended successfully, processed 119369 lines. ( 2295 lines/s)
  52. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step Insert / Update Jobs.0 ended successfully, processed 119369 lines. ( 2295 lines/s)
  53. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step Read Users.0 ended successfully, processed 6995 lines. ( 134 lines/s)
  54. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step Insert / Update Users.0 ended successfully, processed 6995 lines. ( 134 lines/s)
  55. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step read clients.0 ended successfully, processed 142 lines. ( 2 lines/s)
  56. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step Insert / Update Clients.0 ended successfully, processed 142 lines. ( 2 lines/s)
  57. INFO 13-05 16:15:48,997 - Update Ballista Warehouse - Step read user login events.0 ended successfully, processed 162 lines. ( 3 lines/s)
  58. INFO 13-05 16:15:48,998 - Update Ballista Warehouse - Step Insert / Update User Login Events.0 ended successfully, processed 162 lines. ( 3 lines/s)
  59. [DEBUG] [EXITSTATUS] 0
  60. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  61. -file:/srv/ballista/current/data/update_job_fact.ktr
  62. -param:ballista_dw_dev_host=db.moneydesktop.com
  63. -param:ballista_dw_dev_database=ballista_dw_production
  64. -param:ballista_dw_dev_username=postgres
  65. -param:ballista_dw_dev_password=IceQu33n^
  66. -param:ballista_host=db.moneydesktop.com
  67. -param:ballista_database=ballista_dw_production
  68. -param:ballista_username=postgres
  69. -param:ballista_password=IceQu33n^
  70. -param:persona_host=db.moneydesktop.com
  71. -param:persona_database=persona_production
  72. -param:persona_username=postgres
  73. -param:persona_password=IceQu33n^
  74. -param:amigo_host=db.moneydesktop.com
  75. -param:amigo_database=amigo_production
  76. -param:amigo_username=postgres
  77. -param:amigo_password=IceQu33n^
  78. [DEBUG]
  79. [DEBUG] INFO 13-05 16:15:50,745 - Using "/tmp/vfs_cache" as temporary files store.
  80. INFO 13-05 16:15:51,179 - Pan - Start of run.
  81. INFO 13-05 16:15:51,403 - Update Ballista Warehouse - Dispatching started for transformation [Update Ballista Warehouse]
  82. INFO 13-05 16:15:51,422 - Update Ballista Warehouse - This transformation can be replayed with replay date: 2011/05/13 16:15:51
  83. INFO 13-05 16:16:20,116 - Get Job Facts - linenr 50000
  84. INFO 13-05 16:16:25,594 - Institution Dim lookup - linenr 50000
  85. INFO 13-05 16:16:26,698 - Job Dim lookup - linenr 50000
  86. INFO 13-05 16:16:26,752 - Calculate Date/Time Dim Indexes - linenr 50000
  87. INFO 13-05 16:16:29,188 - Insert / Update - linenr 50000
  88. INFO 13-05 16:16:32,819 - Insert / Update job statistics - linenr 50000
  89. INFO 13-05 16:16:41,519 - Get Job Facts - Finished reading query, closing connection.
  90. INFO 13-05 16:16:41,525 - Get Job Facts - Finished processing (I=89552, O=0, R=0, W=89552, U=0, E=0)
  91. INFO 13-05 16:16:46,284 - Institution Dim lookup - Finished processing (I=89552, O=0, R=89552, W=89552, U=0, E=0)
  92. INFO 13-05 16:16:47,207 - Job Dim lookup - Finished processing (I=89552, O=0, R=89552, W=89552, U=0, E=0)
  93. INFO 13-05 16:16:48,709 - Calculate Date/Time Dim Indexes - Finished processing (I=0, O=0, R=89552, W=179104, U=0, E=0)
  94. INFO 13-05 16:16:49,309 - Insert / Update - Finished processing (I=89552, O=10, R=89552, W=89552, U=0, E=0)
  95. INFO 13-05 16:16:53,613 - Insert / Update job statistics - Finished processing (I=89552, O=482, R=89552, W=89552, U=9287, E=0)
  96. INFO 13-05 16:16:53,615 - Pan - Finished!
  97. INFO 13-05 16:16:53,615 - Pan - Start=2011/05/13 16:15:51.180, Stop=2011/05/13 16:16:53.615
  98. INFO 13-05 16:16:53,615 - Pan - Processing ended after 1 minutes and 2 seconds (62 seconds total).
  99. INFO 13-05 16:16:53,618 - Update Ballista Warehouse -
  100. INFO 13-05 16:16:53,618 - Update Ballista Warehouse - Step Get Job Facts.0 ended successfully, processed 89552 lines. ( 1444 lines/s)
  101. INFO 13-05 16:16:53,618 - Update Ballista Warehouse - Step Institution Dim lookup.0 ended successfully, processed 89552 lines. ( 1444 lines/s)
  102. INFO 13-05 16:16:53,618 - Update Ballista Warehouse - Step Job Dim lookup.0 ended successfully, processed 89552 lines. ( 1444 lines/s)
  103. INFO 13-05 16:16:53,618 - Update Ballista Warehouse - Step Calculate Date/Time Dim Indexes.0 ended successfully, processed 179104 lines. ( 2888 lines/s)
  104. INFO 13-05 16:16:53,619 - Update Ballista Warehouse - Step Insert / Update.0 ended successfully, processed 89552 lines. ( 1444 lines/s)
  105. INFO 13-05 16:16:53,619 - Update Ballista Warehouse - Step Insert / Update job statistics.0 ended successfully, processed 89552 lines. ( 1444 lines/s)
  106. [DEBUG] [EXITSTATUS] 0
  107. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  108. -file:/srv/ballista/current/data/update_user_growth_fact.ktr
  109. -param:ballista_dw_dev_host=db.moneydesktop.com
  110. -param:ballista_dw_dev_database=ballista_dw_production
  111. -param:ballista_dw_dev_username=postgres
  112. -param:ballista_dw_dev_password=IceQu33n^
  113. -param:ballista_host=db.moneydesktop.com
  114. -param:ballista_database=ballista_dw_production
  115. -param:ballista_username=postgres
  116. -param:ballista_password=IceQu33n^
  117. -param:persona_host=db.moneydesktop.com
  118. -param:persona_database=persona_production
  119. -param:persona_username=postgres
  120. -param:persona_password=IceQu33n^
  121. -param:amigo_host=db.moneydesktop.com
  122. -param:amigo_database=amigo_production
  123. -param:amigo_username=postgres
  124. -param:amigo_password=IceQu33n^
  125. [DEBUG]
  126. [DEBUG] INFO 13-05 16:16:55,305 - Using "/tmp/vfs_cache" as temporary files store.
  127. INFO 13-05 16:16:55,738 - Pan - Start of run.
  128. INFO 13-05 16:16:55,966 - update_user_growth_fact - Dispatching started for transformation [update_user_growth_fact]
  129. INFO 13-05 16:16:55,984 - update_user_growth_fact - This transformation can be replayed with replay date: 2011/05/13 16:16:55
  130. INFO 13-05 16:16:56,603 - Get User Data - Finished reading query, closing connection.
  131. INFO 13-05 16:16:56,619 - Get User Data - Finished processing (I=2083, O=0, R=0, W=2083, U=0, E=0)
  132. INFO 13-05 16:16:58,188 - Client Dim Lookup - Finished processing (I=2083, O=0, R=2083, W=2083, U=0, E=0)
  133. INFO 13-05 16:16:58,214 - Modified Java Script Value - Finished processing (I=0, O=0, R=2083, W=2083, U=0, E=0)
  134. INFO 13-05 16:16:58,605 - Insert / Update - Finished processing (I=2083, O=2, R=2083, W=2083, U=16, E=0)
  135. INFO 13-05 16:16:58,606 - Pan - Finished!
  136. INFO 13-05 16:16:58,606 - Pan - Start=2011/05/13 16:16:55.745, Stop=2011/05/13 16:16:58.606
  137. INFO 13-05 16:16:58,606 - Pan - Processing ended after 2 seconds.
  138. INFO 13-05 16:16:58,608 - update_user_growth_fact -
  139. INFO 13-05 16:16:58,608 - update_user_growth_fact - Step Get User Data.0 ended successfully, processed 2083 lines. ( 1041 lines/s)
  140. INFO 13-05 16:16:58,608 - update_user_growth_fact - Step Client Dim Lookup.0 ended successfully, processed 2083 lines. ( 1041 lines/s)
  141. INFO 13-05 16:16:58,608 - update_user_growth_fact - Step Modified Java Script Value.0 ended successfully, processed 2083 lines. ( 1041 lines/s)
  142. INFO 13-05 16:16:58,608 - update_user_growth_fact - Step Insert / Update.0 ended successfully, processed 2083 lines. ( 1041 lines/s)
  143. [DEBUG] [EXITSTATUS] 0
  144. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  145. -file:/srv/ballista/current/data/update_user_logins_fact.ktr
  146. -param:ballista_dw_dev_host=db.moneydesktop.com
  147. -param:ballista_dw_dev_database=ballista_dw_production
  148. -param:ballista_dw_dev_username=postgres
  149. -param:ballista_dw_dev_password=IceQu33n^
  150. -param:ballista_host=db.moneydesktop.com
  151. -param:ballista_database=ballista_dw_production
  152. -param:ballista_username=postgres
  153. -param:ballista_password=IceQu33n^
  154. -param:persona_host=db.moneydesktop.com
  155. -param:persona_database=persona_production
  156. -param:persona_username=postgres
  157. -param:persona_password=IceQu33n^
  158. -param:amigo_host=db.moneydesktop.com
  159. -param:amigo_database=amigo_production
  160. -param:amigo_username=postgres
  161. -param:amigo_password=IceQu33n^
  162. [DEBUG]
  163. [DEBUG] INFO 13-05 16:17:00,271 - Using "/tmp/vfs_cache" as temporary files store.
  164. INFO 13-05 16:17:00,701 - Pan - Start of run.
  165. INFO 13-05 16:17:00,937 - update_user_logins_fact - Dispatching started for transformation [update_user_logins_fact]
  166. INFO 13-05 16:17:00,956 - update_user_logins_fact - This transformation can be replayed with replay date: 2011/05/13 16:17:00
  167. INFO 13-05 16:17:01,217 - Get Login Data - Finished reading query, closing connection.
  168. INFO 13-05 16:17:01,240 - Get Login Data - Finished processing (I=162, O=0, R=0, W=162, U=0, E=0)
  169. INFO 13-05 16:17:01,353 - lookup user dim - Finished processing (I=162, O=0, R=162, W=162, U=0, E=0)
  170. INFO 13-05 16:17:01,687 - Modified Java Script Value - Finished processing (I=0, O=0, R=162, W=162, U=0, E=0)
  171. INFO 13-05 16:17:01,786 - lookup user login events - Finished processing (I=162, O=0, R=162, W=162, U=0, E=0)
  172. INFO 13-05 16:17:01,824 - client dim lookup - Finished processing (I=162, O=0, R=162, W=162, U=0, E=0)
  173. INFO 13-05 16:17:01,874 - insert/update client user activity - Finished processing (I=162, O=6, R=162, W=162, U=0, E=0)
  174. INFO 13-05 16:17:01,874 - Pan - Finished!
  175. INFO 13-05 16:17:01,874 - Pan - Start=2011/05/13 16:17:00.705, Stop=2011/05/13 16:17:01.874
  176. INFO 13-05 16:17:01,874 - Pan - Processing ended after 1 seconds.
  177. INFO 13-05 16:17:01,876 - update_user_logins_fact -
  178. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step Get Login Data.0 ended successfully, processed 162 lines. ( 162 lines/s)
  179. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step lookup user dim.0 ended successfully, processed 162 lines. ( 162 lines/s)
  180. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step Modified Java Script Value.0 ended successfully, processed 162 lines. ( 162 lines/s)
  181. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step lookup user login events.0 ended successfully, processed 162 lines. ( 162 lines/s)
  182. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step client dim lookup.0 ended successfully, processed 162 lines. ( 162 lines/s)
  183. INFO 13-05 16:17:01,876 - update_user_logins_fact - Step insert/update client user activity.0 ended successfully, processed 162 lines. ( 162 lines/s)
  184. [DEBUG] [EXITSTATUS] 0
  185. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  186. -file:/srv/ballista/current/data/update_institution_user_growth_fact.ktr
  187. -param:ballista_dw_dev_host=db.moneydesktop.com
  188. -param:ballista_dw_dev_database=ballista_dw_production
  189. -param:ballista_dw_dev_username=postgres
  190. -param:ballista_dw_dev_password=IceQu33n^
  191. -param:ballista_host=db.moneydesktop.com
  192. -param:ballista_database=ballista_dw_production
  193. -param:ballista_username=postgres
  194. -param:ballista_password=IceQu33n^
  195. -param:persona_host=db.moneydesktop.com
  196. -param:persona_database=persona_production
  197. -param:persona_username=postgres
  198. -param:persona_password=IceQu33n^
  199. -param:amigo_host=db.moneydesktop.com
  200. -param:amigo_database=amigo_production
  201. -param:amigo_username=postgres
  202. -param:amigo_password=IceQu33n^
  203. [DEBUG]
  204. [DEBUG] INFO 13-05 16:17:04,204 - Using "/tmp/vfs_cache" as temporary files store.
  205. INFO 13-05 16:17:04,809 - Pan - Start of run.
  206. INFO 13-05 16:17:05,203 - institution_user_growth_fact - Dispatching started for transformation [institution_user_growth_fact]
  207. INFO 13-05 16:17:05,240 - institution_user_growth_fact - This transformation can be replayed with replay date: 2011/05/13 16:17:05
  208. INFO 13-05 16:17:06,595 - grab member data - Finished reading query, closing connection.
  209. INFO 13-05 16:17:06,611 - grab member data - Finished processing (I=3165, O=0, R=0, W=3165, U=0, E=0)
  210. INFO 13-05 16:17:08,435 - institution dim id lookup - Finished processing (I=3165, O=0, R=3165, W=3165, U=0, E=0)
  211. INFO 13-05 16:17:08,460 - Modified Java Script Value - Finished processing (I=0, O=0, R=3165, W=3165, U=0, E=0)
  212. INFO 13-05 16:17:12,035 - Insert / Update institution user growth fact - Finished processing (I=3165, O=0, R=3165, W=3165, U=2990, E=0)
  213. INFO 13-05 16:17:12,036 - Pan - Finished!
  214. INFO 13-05 16:17:12,036 - Pan - Start=2011/05/13 16:17:04.825, Stop=2011/05/13 16:17:12.036
  215. INFO 13-05 16:17:12,036 - Pan - Processing ended after 7 seconds.
  216. INFO 13-05 16:17:12,038 - institution_user_growth_fact -
  217. INFO 13-05 16:17:12,038 - institution_user_growth_fact - Step grab member data.0 ended successfully, processed 3165 lines. ( 452 lines/s)
  218. INFO 13-05 16:17:12,038 - institution_user_growth_fact - Step institution dim id lookup.0 ended successfully, processed 3165 lines. ( 452 lines/s)
  219. INFO 13-05 16:17:12,038 - institution_user_growth_fact - Step Modified Java Script Value.0 ended successfully, processed 3165 lines. ( 452 lines/s)
  220. INFO 13-05 16:17:12,038 - institution_user_growth_fact - Step Insert / Update institution user growth fact.0 ended successfully, processed 3165 lines. ( 452 lines/s)
  221. [DEBUG] [EXITSTATUS] 0
  222. [INFO] [COMMAND] /usr/local/bin/data-integration/pan.sh
  223. -file:/srv/ballista/current/data/update_member_fact.ktr
  224. -param:ballista_dw_dev_host=db.moneydesktop.com
  225. -param:ballista_dw_dev_database=ballista_dw_production
  226. -param:ballista_dw_dev_username=postgres
  227. -param:ballista_dw_dev_password=IceQu33n^
  228. -param:ballista_host=db.moneydesktop.com
  229. -param:ballista_database=ballista_dw_production
  230. -param:ballista_username=postgres
  231. -param:ballista_password=IceQu33n^
  232. -param:persona_host=db.moneydesktop.com
  233. -param:persona_database=persona_production
  234. -param:persona_username=postgres
  235. -param:persona_password=IceQu33n^
  236. -param:amigo_host=db.moneydesktop.com
  237. -param:amigo_database=amigo_production
  238. -param:amigo_username=postgres
  239. -param:amigo_password=IceQu33n^
  240. [DEBUG]
  241. [DEBUG] INFO 13-05 16:17:14,919 - Using "/tmp/vfs_cache" as temporary files store.
  242. INFO 13-05 16:17:15,837 - Pan - Start of run.
  243. INFO 13-05 16:17:16,374 - update_member_fact - Dispatching started for transformation [update_member_fact]
  244. INFO 13-05 16:17:16,406 - update_member_fact - This transformation can be replayed with replay date: 2011/05/13 16:17:16
  245. ERROR 13-05 16:17:16,567 - user id lookup - An error cause this step to stop: org.pentaho.di.core.exception.KettleDatabaseException:
  246. Error occured while trying to connect to the database
  247.  
  248. Error connecting to database: (using class org.postgresql.Driver)
  249. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  250.  
  251.  
  252. ERROR 13-05 16:17:16,567 - institution id lookup - An error cause this step to stop: org.pentaho.di.core.exception.KettleDatabaseException:
  253. Error occured while trying to connect to the database
  254.  
  255. Error connecting to database: (using class org.postgresql.Driver)
  256. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  257.  
  258.  
  259. ERROR 13-05 16:17:16,567 - grab_member_data - An error occurred, processing will be stopped:
  260. Error occured while trying to connect to the database
  261.  
  262. Error connecting to database: (using class org.postgresql.Driver)
  263. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  264.  
  265.  
  266. ERROR 13-05 16:17:16,567 - Insert / Update Member Fact - An error occurred during initialization, processing will be stopped:
  267. Error occured while trying to connect to the database
  268.  
  269. Error connecting to database: (using class org.postgresql.Driver)
  270. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  271.  
  272.  
  273. ERROR 13-05 16:17:16,568 - Insert / Update Member Fact - Error initializing step [Insert / Update Member Fact]
  274. ERROR 13-05 16:17:16,568 - grab_member_data - Error initializing step [grab_member_data]
  275. ERROR 13-05 16:17:16,568 - institution id lookup - Error initializing step [institution id lookup]
  276. ERROR 13-05 16:17:16,569 - user id lookup - Error initializing step [user id lookup]
  277. ERROR 13-05 16:17:16,569 - update_member_fact - Step [grab_member_data.0] failed to initialize!
  278. ERROR 13-05 16:17:16,569 - update_member_fact - Step [institution id lookup.0] failed to initialize!
  279. ERROR 13-05 16:17:16,569 - update_member_fact - Step [user id lookup.0] failed to initialize!
  280. ERROR 13-05 16:17:16,569 - update_member_fact - Step [Insert / Update Member Fact.0] failed to initialize!
  281. INFO 13-05 16:17:16,569 - grab_member_data - Finished reading query, closing connection.
  282. Unable to prepare and initialize this transformation
  283. [DEBUG] [EXITSTATUS] 3
  284. [ERROR] Updating Warehouse failed! /srv/ballista/current/data/update_member_fact.ktr exited with status 3
  285. INFO 13-05 16:17:14,919 - Using "/tmp/vfs_cache" as temporary files store.
  286. INFO 13-05 16:17:15,837 - Pan - Start of run.
  287. INFO 13-05 16:17:16,374 - update_member_fact - Dispatching started for transformation [update_member_fact]
  288. INFO 13-05 16:17:16,406 - update_member_fact - This transformation can be replayed with replay date: 2011/05/13 16:17:16
  289. ERROR 13-05 16:17:16,567 - user id lookup - An error cause this step to stop: org.pentaho.di.core.exception.KettleDatabaseException:
  290. Error occured while trying to connect to the database
  291.  
  292. Error connecting to database: (using class org.postgresql.Driver)
  293. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  294.  
  295.  
  296. ERROR 13-05 16:17:16,567 - institution id lookup - An error cause this step to stop: org.pentaho.di.core.exception.KettleDatabaseException:
  297. Error occured while trying to connect to the database
  298.  
  299. Error connecting to database: (using class org.postgresql.Driver)
  300. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  301.  
  302.  
  303. ERROR 13-05 16:17:16,567 - grab_member_data - An error occurred, processing will be stopped:
  304. Error occured while trying to connect to the database
  305.  
  306. Error connecting to database: (using class org.postgresql.Driver)
  307. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  308.  
  309.  
  310. ERROR 13-05 16:17:16,567 - Insert / Update Member Fact - An error occurred during initialization, processing will be stopped:
  311. Error occured while trying to connect to the database
  312.  
  313. Error connecting to database: (using class org.postgresql.Driver)
  314. Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
  315.  
  316.  
  317. ERROR 13-05 16:17:16,568 - Insert / Update Member Fact - Error initializing step [Insert / Update Member Fact]
  318. ERROR 13-05 16:17:16,568 - grab_member_data - Error initializing step [grab_member_data]
  319. ERROR 13-05 16:17:16,568 - institution id lookup - Error initializing step [institution id lookup]
  320. ERROR 13-05 16:17:16,569 - user id lookup - Error initializing step [user id lookup]
  321. ERROR 13-05 16:17:16,569 - update_member_fact - Step [grab_member_data.0] failed to initialize!
  322. ERROR 13-05 16:17:16,569 - update_member_fact - Step [institution id lookup.0] failed to initialize!
  323. ERROR 13-05 16:17:16,569 - update_member_fact - Step [user id lookup.0] failed to initialize!
  324. ERROR 13-05 16:17:16,569 - update_member_fact - Step [Insert / Update Member Fact.0] failed to initialize!
  325. INFO 13-05 16:17:16,569 - grab_member_data - Finished reading query, closing connection.
  326. Unable to prepare and initialize this transformation
  327. [ERROR] /srv/ballista/current/lib/crons/populate_warehouse.rb:84:in `block (2 levels) in <main>'
  328. /srv/ballista/current/lib/crons/populate_warehouse.rb:72:in `each'
  329. /srv/ballista/current/lib/crons/populate_warehouse.rb:72:in `block in <main>'
  330. /usr/local/rvm/rubies/ruby-1.9.2-p0/lib/ruby/1.9.1/benchmark.rb:294:in `measure'
  331. /srv/ballista/current/lib/crons/populate_warehouse.rb:27:in `<main>'
  332. [INFO] 0.060000 0.030000 70.560000 (141.865567)
  333. [DEBUG] Exiting with status 1
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!