API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2018
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.99 KB | None | 0 0
raw download clone embed print report
  1. OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
  2. 15:01:14,645 INFO [KarafInstance]
  3. *******************************************************************************
  4. *** Karaf Instance Number: 3 at /home/nyoman.gunawan/inventory/pentaho/pdi6 ***
  5. *** .1/./system/karaf/caches/pan/data-1 ***
  6. *** Karaf Port:8804 ***
  7. *** OSGI Service Port:9053 ***
  8. *******************************************************************************
  9. 15:01:14,645 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
  10. May 25, 2018 3:01:15 PM org.apache.karaf.main.Main$KarafLockCallback lockAquired
  11. INFO: Lock acquired. Setting startlevel to 100
  12. 2018/05/25 15:01:15 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
  13. May 25, 2018 3:01:17 PM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
  14. INFO: New Caching Service registered
  15. SLF4J: Class path contains multiple SLF4J bindings.
  16. SLF4J: Found binding in [jar:file:/home/nyoman.gunawan/inventory/pentaho/pdi6.1/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  17. SLF4J: Found binding in [jar:file:/home/nyoman.gunawan/inventory/pentaho/pdi6.1/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  18. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  19. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  20. 2018/05/25 15:01:19 - Pan - Logging is at level : Detailed
  21. 2018/05/25 15:01:19 - Pan - Start of run.
  22. 2018/05/25 15:01:19 - Pan - Loading transformation from XML file [/home/nyoman.gunawan/inventory/datamartloading/closure.ktr]
  23. 2018/05/25 15:01:19 - load closure - Dispatching started for transformation [load closure]
  24. 2018/05/25 15:01:19 - load closure - Nr of arguments detected:0
  25. 2018/05/25 15:01:19 - load closure - This is not a replay transformation
  26. 2018/05/25 15:01:19 - load closure - I found 30 different steps to launch.
  27. 2018/05/25 15:01:19 - load closure - Allocating rowsets...
  28. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 0 --> Closure organization
  29. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  30. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure organization.0 - load closure org.0]
  31. 2018/05/25 15:01:19 - load closure - Allocated 1 rowsets for step 0 --> Closure organization
  32. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 1 --> load closure org
  33. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  34. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure org.0 - Write to log org.0]
  35. 2018/05/25 15:01:19 - load closure - Allocated 2 rowsets for step 1 --> load closure org
  36. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 2 --> Write to log org
  37. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  38. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log org.0 - Abort org.0]
  39. 2018/05/25 15:01:19 - load closure - Allocated 3 rowsets for step 2 --> Write to log org
  40. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 3 --> Abort org
  41. 2018/05/25 15:01:19 - load closure - Allocated 3 rowsets for step 3 --> Abort org
  42. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 4 --> Write to log acccount
  43. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  44. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log acccount.0 - Abort account.0]
  45. 2018/05/25 15:01:19 - load closure - Allocated 4 rowsets for step 4 --> Write to log acccount
  46. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 5 --> Abort account
  47. 2018/05/25 15:01:19 - load closure - Allocated 4 rowsets for step 5 --> Abort account
  48. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 6 --> Closure salesregion
  49. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  50. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure salesregion.0 - load closure salesregion.0]
  51. 2018/05/25 15:01:19 - load closure - Allocated 5 rowsets for step 6 --> Closure salesregion
  52. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 7 --> load closure salesregion
  53. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  54. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure salesregion.0 - Write to log salesregion.0]
  55. 2018/05/25 15:01:19 - load closure - Allocated 6 rowsets for step 7 --> load closure salesregion
  56. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 8 --> Write to log salesregion
  57. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  58. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log salesregion.0 - Abort salesregion.0]
  59. 2018/05/25 15:01:19 - load closure - Allocated 7 rowsets for step 8 --> Write to log salesregion
  60. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 9 --> Abort salesregion
  61. 2018/05/25 15:01:19 - load closure - Allocated 7 rowsets for step 9 --> Abort salesregion
  62. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 10 --> Closure project
  63. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  64. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure project.0 - load closure project.0]
  65. 2018/05/25 15:01:19 - load closure - Allocated 8 rowsets for step 10 --> Closure project
  66. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 11 --> load closure project
  67. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  68. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure project.0 - Write to log project.0]
  69. 2018/05/25 15:01:19 - load closure - Allocated 9 rowsets for step 11 --> load closure project
  70. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 12 --> Write to log project
  71. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  72. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log project.0 - Abort project.0]
  73. 2018/05/25 15:01:19 - load closure - Allocated 10 rowsets for step 12 --> Write to log project
  74. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 13 --> Abort project
  75. 2018/05/25 15:01:19 - load closure - Allocated 10 rowsets for step 13 --> Abort project
  76. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 14 --> load closure account
  77. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  78. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure account.0 - Write to log acccount.0]
  79. 2018/05/25 15:01:19 - load closure - Allocated 11 rowsets for step 14 --> load closure account
  80. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 15 --> get dim_salesregion
  81. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  82. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_salesregion.0 - Closure salesregion.0]
  83. 2018/05/25 15:01:19 - load closure - Allocated 12 rowsets for step 15 --> get dim_salesregion
  84. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 16 --> get dim_organization
  85. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  86. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_organization.0 - Closure organization.0]
  87. 2018/05/25 15:01:19 - load closure - Allocated 13 rowsets for step 16 --> get dim_organization
  88. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 17 --> get dim_project
  89. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  90. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_project.0 - Closure project.0]
  91. 2018/05/25 15:01:19 - load closure - Allocated 14 rowsets for step 17 --> get dim_project
  92. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 18 --> get dim_account
  93. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  94. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_account.0 - Closure account.0]
  95. 2018/05/25 15:01:19 - load closure - Allocated 15 rowsets for step 18 --> get dim_account
  96. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 19 --> Closure account
  97. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  98. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure account.0 - load closure account.0]
  99. 2018/05/25 15:01:19 - load closure - Allocated 16 rowsets for step 19 --> Closure account
  100. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 20 --> Closure asset
  101. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  102. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure asset.0 - load closure asset.0]
  103. 2018/05/25 15:01:19 - load closure - Allocated 17 rowsets for step 20 --> Closure asset
  104. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 21 --> load closure asset
  105. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  106. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure asset.0 - Write to log asset.0]
  107. 2018/05/25 15:01:19 - load closure - Allocated 18 rowsets for step 21 --> load closure asset
  108. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 22 --> get dim_asset
  109. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  110. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_asset.0 - Closure asset.0]
  111. 2018/05/25 15:01:19 - load closure - Allocated 19 rowsets for step 22 --> get dim_asset
  112. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 23 --> Write to log asset
  113. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  114. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log asset.0 - Abort asset.0]
  115. 2018/05/25 15:01:19 - load closure - Allocated 20 rowsets for step 23 --> Write to log asset
  116. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 24 --> Abort asset
  117. 2018/05/25 15:01:19 - load closure - Allocated 20 rowsets for step 24 --> Abort asset
  118. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 25 --> Closure costcenter
  119. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  120. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Closure costcenter.0 - load closure costcenter.0]
  121. 2018/05/25 15:01:19 - load closure - Allocated 21 rowsets for step 25 --> Closure costcenter
  122. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 26 --> load closure costcenter
  123. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  124. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [load closure costcenter.0 - Write to log costcenter.0]
  125. 2018/05/25 15:01:19 - load closure - Allocated 22 rowsets for step 26 --> load closure costcenter
  126. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 27 --> Write to log costcenter
  127. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  128. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [Write to log costcenter.0 - Abort costcenter.0]
  129. 2018/05/25 15:01:19 - load closure - Allocated 23 rowsets for step 27 --> Write to log costcenter
  130. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 28 --> Abort costcenter
  131. 2018/05/25 15:01:19 - load closure - Allocated 23 rowsets for step 28 --> Abort costcenter
  132. 2018/05/25 15:01:19 - load closure - Allocating rowsets for step 29 --> get dim_costcenter
  133. 2018/05/25 15:01:19 - load closure - prevcopies = 1, nextcopies=1
  134. 2018/05/25 15:01:19 - load closure - Transformation allocated new rowset [get dim_costcenter.0 - Closure costcenter.0]
  135. 2018/05/25 15:01:19 - load closure - Allocated 24 rowsets for step 29 --> get dim_costcenter
  136. 2018/05/25 15:01:19 - load closure - Allocating Steps & StepData...
  137. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure organization] of type [ClosureGenerator]
  138. 2018/05/25 15:01:19 - Closure organization.0 - distribution activated
  139. 2018/05/25 15:01:19 - Closure organization.0 - Starting allocation of buffers & new threads...
  140. 2018/05/25 15:01:19 - Closure organization.0 - Step info: nrinput=1 nroutput=1
  141. 2018/05/25 15:01:19 - Closure organization.0 - Got previous step from [Closure organization] #0 --> get dim_organization
  142. 2018/05/25 15:01:19 - Closure organization.0 - input rel is 1:1
  143. 2018/05/25 15:01:19 - Closure organization.0 - Found input rowset [get dim_organization.0 - Closure organization.0]
  144. 2018/05/25 15:01:19 - Closure organization.0 - output rel. is 1:1
  145. 2018/05/25 15:01:19 - Closure organization.0 - Found output rowset [Closure organization.0 - load closure org.0]
  146. 2018/05/25 15:01:19 - Closure organization.0 - Finished dispatching
  147. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure organization].0
  148. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure org] of type [TableOutput]
  149. 2018/05/25 15:01:19 - load closure org.0 - distribution activated
  150. 2018/05/25 15:01:19 - load closure org.0 - Starting allocation of buffers & new threads...
  151. 2018/05/25 15:01:19 - load closure org.0 - Step info: nrinput=1 nroutput=1
  152. 2018/05/25 15:01:19 - load closure org.0 - Got previous step from [load closure org] #0 --> Closure organization
  153. 2018/05/25 15:01:19 - load closure org.0 - input rel is 1:1
  154. 2018/05/25 15:01:19 - load closure org.0 - Found input rowset [Closure organization.0 - load closure org.0]
  155. 2018/05/25 15:01:19 - load closure org.0 - output rel. is 1:1
  156. 2018/05/25 15:01:19 - load closure org.0 - Found output rowset [load closure org.0 - Write to log org.0]
  157. 2018/05/25 15:01:19 - load closure org.0 - Finished dispatching
  158. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure org].0
  159. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log org] of type [WriteToLog]
  160. 2018/05/25 15:01:19 - Write to log org.0 - distribution activated
  161. 2018/05/25 15:01:19 - Write to log org.0 - Starting allocation of buffers & new threads...
  162. 2018/05/25 15:01:19 - Write to log org.0 - Step info: nrinput=1 nroutput=1
  163. 2018/05/25 15:01:19 - Write to log org.0 - Got previous step from [Write to log org] #0 --> load closure org
  164. 2018/05/25 15:01:19 - Write to log org.0 - input rel is 1:1
  165. 2018/05/25 15:01:19 - Write to log org.0 - Found input rowset [load closure org.0 - Write to log org.0]
  166. 2018/05/25 15:01:19 - Write to log org.0 - output rel. is 1:1
  167. 2018/05/25 15:01:19 - Write to log org.0 - Found output rowset [Write to log org.0 - Abort org.0]
  168. 2018/05/25 15:01:19 - Write to log org.0 - Finished dispatching
  169. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log org].0
  170. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort org] of type [Abort]
  171. 2018/05/25 15:01:19 - Abort org.0 - distribution activated
  172. 2018/05/25 15:01:19 - Abort org.0 - Starting allocation of buffers & new threads...
  173. 2018/05/25 15:01:19 - Abort org.0 - Step info: nrinput=1 nroutput=0
  174. 2018/05/25 15:01:19 - Abort org.0 - Got previous step from [Abort org] #0 --> Write to log org
  175. 2018/05/25 15:01:19 - Abort org.0 - input rel is 1:1
  176. 2018/05/25 15:01:19 - Abort org.0 - Found input rowset [Write to log org.0 - Abort org.0]
  177. 2018/05/25 15:01:19 - Abort org.0 - Finished dispatching
  178. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort org].0
  179. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log acccount] of type [WriteToLog]
  180. 2018/05/25 15:01:19 - Write to log acccount.0 - distribution activated
  181. 2018/05/25 15:01:19 - Write to log acccount.0 - Starting allocation of buffers & new threads...
  182. 2018/05/25 15:01:19 - Write to log acccount.0 - Step info: nrinput=1 nroutput=1
  183. 2018/05/25 15:01:19 - Write to log acccount.0 - Got previous step from [Write to log acccount] #0 --> load closure account
  184. 2018/05/25 15:01:19 - Write to log acccount.0 - input rel is 1:1
  185. 2018/05/25 15:01:19 - Write to log acccount.0 - Found input rowset [load closure account.0 - Write to log acccount.0]
  186. 2018/05/25 15:01:19 - Write to log acccount.0 - output rel. is 1:1
  187. 2018/05/25 15:01:19 - Write to log acccount.0 - Found output rowset [Write to log acccount.0 - Abort account.0]
  188. 2018/05/25 15:01:19 - Write to log acccount.0 - Finished dispatching
  189. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log acccount].0
  190. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort account] of type [Abort]
  191. 2018/05/25 15:01:19 - Abort account.0 - distribution activated
  192. 2018/05/25 15:01:19 - Abort account.0 - Starting allocation of buffers & new threads...
  193. 2018/05/25 15:01:19 - Abort account.0 - Step info: nrinput=1 nroutput=0
  194. 2018/05/25 15:01:19 - Abort account.0 - Got previous step from [Abort account] #0 --> Write to log acccount
  195. 2018/05/25 15:01:19 - Abort account.0 - input rel is 1:1
  196. 2018/05/25 15:01:19 - Abort account.0 - Found input rowset [Write to log acccount.0 - Abort account.0]
  197. 2018/05/25 15:01:19 - Abort account.0 - Finished dispatching
  198. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort account].0
  199. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure salesregion] of type [ClosureGenerator]
  200. 2018/05/25 15:01:19 - Closure salesregion.0 - distribution activated
  201. 2018/05/25 15:01:19 - Closure salesregion.0 - Starting allocation of buffers & new threads...
  202. 2018/05/25 15:01:19 - Closure salesregion.0 - Step info: nrinput=1 nroutput=1
  203. 2018/05/25 15:01:19 - Closure salesregion.0 - Got previous step from [Closure salesregion] #0 --> get dim_salesregion
  204. 2018/05/25 15:01:19 - Closure salesregion.0 - input rel is 1:1
  205. 2018/05/25 15:01:19 - Closure salesregion.0 - Found input rowset [get dim_salesregion.0 - Closure salesregion.0]
  206. 2018/05/25 15:01:19 - Closure salesregion.0 - output rel. is 1:1
  207. 2018/05/25 15:01:19 - Closure salesregion.0 - Found output rowset [Closure salesregion.0 - load closure salesregion.0]
  208. 2018/05/25 15:01:19 - Closure salesregion.0 - Finished dispatching
  209. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure salesregion].0
  210. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure salesregion] of type [TableOutput]
  211. 2018/05/25 15:01:19 - load closure salesregion.0 - distribution activated
  212. 2018/05/25 15:01:19 - load closure salesregion.0 - Starting allocation of buffers & new threads...
  213. 2018/05/25 15:01:19 - load closure salesregion.0 - Step info: nrinput=1 nroutput=1
  214. 2018/05/25 15:01:19 - load closure salesregion.0 - Got previous step from [load closure salesregion] #0 --> Closure salesregion
  215. 2018/05/25 15:01:19 - load closure salesregion.0 - input rel is 1:1
  216. 2018/05/25 15:01:19 - load closure salesregion.0 - Found input rowset [Closure salesregion.0 - load closure salesregion.0]
  217. 2018/05/25 15:01:19 - load closure salesregion.0 - output rel. is 1:1
  218. 2018/05/25 15:01:19 - load closure salesregion.0 - Found output rowset [load closure salesregion.0 - Write to log salesregion.0]
  219. 2018/05/25 15:01:19 - load closure salesregion.0 - Finished dispatching
  220. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure salesregion].0
  221. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log salesregion] of type [WriteToLog]
  222. 2018/05/25 15:01:19 - Write to log salesregion.0 - distribution activated
  223. 2018/05/25 15:01:19 - Write to log salesregion.0 - Starting allocation of buffers & new threads...
  224. 2018/05/25 15:01:19 - Write to log salesregion.0 - Step info: nrinput=1 nroutput=1
  225. 2018/05/25 15:01:19 - Write to log salesregion.0 - Got previous step from [Write to log salesregion] #0 --> load closure salesregion
  226. 2018/05/25 15:01:19 - Write to log salesregion.0 - input rel is 1:1
  227. 2018/05/25 15:01:19 - Write to log salesregion.0 - Found input rowset [load closure salesregion.0 - Write to log salesregion.0]
  228. 2018/05/25 15:01:19 - Write to log salesregion.0 - output rel. is 1:1
  229. 2018/05/25 15:01:19 - Write to log salesregion.0 - Found output rowset [Write to log salesregion.0 - Abort salesregion.0]
  230. 2018/05/25 15:01:19 - Write to log salesregion.0 - Finished dispatching
  231. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log salesregion].0
  232. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort salesregion] of type [Abort]
  233. 2018/05/25 15:01:19 - Abort salesregion.0 - distribution activated
  234. 2018/05/25 15:01:19 - Abort salesregion.0 - Starting allocation of buffers & new threads...
  235. 2018/05/25 15:01:19 - Abort salesregion.0 - Step info: nrinput=1 nroutput=0
  236. 2018/05/25 15:01:19 - Abort salesregion.0 - Got previous step from [Abort salesregion] #0 --> Write to log salesregion
  237. 2018/05/25 15:01:19 - Abort salesregion.0 - input rel is 1:1
  238. 2018/05/25 15:01:19 - Abort salesregion.0 - Found input rowset [Write to log salesregion.0 - Abort salesregion.0]
  239. 2018/05/25 15:01:19 - Abort salesregion.0 - Finished dispatching
  240. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort salesregion].0
  241. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure project] of type [ClosureGenerator]
  242. 2018/05/25 15:01:19 - Closure project.0 - distribution activated
  243. 2018/05/25 15:01:19 - Closure project.0 - Starting allocation of buffers & new threads...
  244. 2018/05/25 15:01:19 - Closure project.0 - Step info: nrinput=1 nroutput=1
  245. 2018/05/25 15:01:19 - Closure project.0 - Got previous step from [Closure project] #0 --> get dim_project
  246. 2018/05/25 15:01:19 - Closure project.0 - input rel is 1:1
  247. 2018/05/25 15:01:19 - Closure project.0 - Found input rowset [get dim_project.0 - Closure project.0]
  248. 2018/05/25 15:01:19 - Closure project.0 - output rel. is 1:1
  249. 2018/05/25 15:01:19 - Closure project.0 - Found output rowset [Closure project.0 - load closure project.0]
  250. 2018/05/25 15:01:19 - Closure project.0 - Finished dispatching
  251. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure project].0
  252. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure project] of type [TableOutput]
  253. 2018/05/25 15:01:19 - load closure project.0 - distribution activated
  254. 2018/05/25 15:01:19 - load closure project.0 - Starting allocation of buffers & new threads...
  255. 2018/05/25 15:01:19 - load closure project.0 - Step info: nrinput=1 nroutput=1
  256. 2018/05/25 15:01:19 - load closure project.0 - Got previous step from [load closure project] #0 --> Closure project
  257. 2018/05/25 15:01:19 - load closure project.0 - input rel is 1:1
  258. 2018/05/25 15:01:19 - load closure project.0 - Found input rowset [Closure project.0 - load closure project.0]
  259. 2018/05/25 15:01:19 - load closure project.0 - output rel. is 1:1
  260. 2018/05/25 15:01:19 - load closure project.0 - Found output rowset [load closure project.0 - Write to log project.0]
  261. 2018/05/25 15:01:19 - load closure project.0 - Finished dispatching
  262. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure project].0
  263. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log project] of type [WriteToLog]
  264. 2018/05/25 15:01:19 - Write to log project.0 - distribution activated
  265. 2018/05/25 15:01:19 - Write to log project.0 - Starting allocation of buffers & new threads...
  266. 2018/05/25 15:01:19 - Write to log project.0 - Step info: nrinput=1 nroutput=1
  267. 2018/05/25 15:01:19 - Write to log project.0 - Got previous step from [Write to log project] #0 --> load closure project
  268. 2018/05/25 15:01:19 - Write to log project.0 - input rel is 1:1
  269. 2018/05/25 15:01:19 - Write to log project.0 - Found input rowset [load closure project.0 - Write to log project.0]
  270. 2018/05/25 15:01:19 - Write to log project.0 - output rel. is 1:1
  271. 2018/05/25 15:01:19 - Write to log project.0 - Found output rowset [Write to log project.0 - Abort project.0]
  272. 2018/05/25 15:01:19 - Write to log project.0 - Finished dispatching
  273. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log project].0
  274. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort project] of type [Abort]
  275. 2018/05/25 15:01:19 - Abort project.0 - distribution activated
  276. 2018/05/25 15:01:19 - Abort project.0 - Starting allocation of buffers & new threads...
  277. 2018/05/25 15:01:19 - Abort project.0 - Step info: nrinput=1 nroutput=0
  278. 2018/05/25 15:01:19 - Abort project.0 - Got previous step from [Abort project] #0 --> Write to log project
  279. 2018/05/25 15:01:19 - Abort project.0 - input rel is 1:1
  280. 2018/05/25 15:01:19 - Abort project.0 - Found input rowset [Write to log project.0 - Abort project.0]
  281. 2018/05/25 15:01:19 - Abort project.0 - Finished dispatching
  282. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort project].0
  283. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure account] of type [TableOutput]
  284. 2018/05/25 15:01:19 - load closure account.0 - distribution activated
  285. 2018/05/25 15:01:19 - load closure account.0 - Starting allocation of buffers & new threads...
  286. 2018/05/25 15:01:19 - load closure account.0 - Step info: nrinput=1 nroutput=1
  287. 2018/05/25 15:01:19 - load closure account.0 - Got previous step from [load closure account] #0 --> Closure account
  288. 2018/05/25 15:01:19 - load closure account.0 - input rel is 1:1
  289. 2018/05/25 15:01:19 - load closure account.0 - Found input rowset [Closure account.0 - load closure account.0]
  290. 2018/05/25 15:01:19 - load closure account.0 - output rel. is 1:1
  291. 2018/05/25 15:01:19 - load closure account.0 - Found output rowset [load closure account.0 - Write to log acccount.0]
  292. 2018/05/25 15:01:19 - load closure account.0 - Finished dispatching
  293. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure account].0
  294. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_salesregion] of type [TableInput]
  295. 2018/05/25 15:01:19 - get dim_salesregion.0 - distribution de-activated
  296. 2018/05/25 15:01:19 - get dim_salesregion.0 - Starting allocation of buffers & new threads...
  297. 2018/05/25 15:01:19 - get dim_salesregion.0 - Step info: nrinput=0 nroutput=1
  298. 2018/05/25 15:01:19 - get dim_salesregion.0 - output rel. is 1:1
  299. 2018/05/25 15:01:19 - get dim_salesregion.0 - Found output rowset [get dim_salesregion.0 - Closure salesregion.0]
  300. 2018/05/25 15:01:19 - get dim_salesregion.0 - Finished dispatching
  301. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_salesregion].0
  302. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_organization] of type [TableInput]
  303. 2018/05/25 15:01:19 - get dim_organization.0 - distribution de-activated
  304. 2018/05/25 15:01:19 - get dim_organization.0 - Starting allocation of buffers & new threads...
  305. 2018/05/25 15:01:19 - get dim_organization.0 - Step info: nrinput=0 nroutput=1
  306. 2018/05/25 15:01:19 - get dim_organization.0 - output rel. is 1:1
  307. 2018/05/25 15:01:19 - get dim_organization.0 - Found output rowset [get dim_organization.0 - Closure organization.0]
  308. 2018/05/25 15:01:19 - get dim_organization.0 - Finished dispatching
  309. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_organization].0
  310. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_project] of type [TableInput]
  311. 2018/05/25 15:01:19 - get dim_project.0 - distribution de-activated
  312. 2018/05/25 15:01:19 - get dim_project.0 - Starting allocation of buffers & new threads...
  313. 2018/05/25 15:01:19 - get dim_project.0 - Step info: nrinput=0 nroutput=1
  314. 2018/05/25 15:01:19 - get dim_project.0 - output rel. is 1:1
  315. 2018/05/25 15:01:19 - get dim_project.0 - Found output rowset [get dim_project.0 - Closure project.0]
  316. 2018/05/25 15:01:19 - get dim_project.0 - Finished dispatching
  317. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_project].0
  318. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_account] of type [TableInput]
  319. 2018/05/25 15:01:19 - get dim_account.0 - distribution de-activated
  320. 2018/05/25 15:01:19 - get dim_account.0 - Starting allocation of buffers & new threads...
  321. 2018/05/25 15:01:19 - get dim_account.0 - Step info: nrinput=0 nroutput=1
  322. 2018/05/25 15:01:19 - get dim_account.0 - output rel. is 1:1
  323. 2018/05/25 15:01:19 - get dim_account.0 - Found output rowset [get dim_account.0 - Closure account.0]
  324. 2018/05/25 15:01:19 - get dim_account.0 - Finished dispatching
  325. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_account].0
  326. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure account] of type [ClosureGenerator]
  327. 2018/05/25 15:01:19 - Closure account.0 - distribution activated
  328. 2018/05/25 15:01:19 - Closure account.0 - Starting allocation of buffers & new threads...
  329. 2018/05/25 15:01:19 - Closure account.0 - Step info: nrinput=1 nroutput=1
  330. 2018/05/25 15:01:19 - Closure account.0 - Got previous step from [Closure account] #0 --> get dim_account
  331. 2018/05/25 15:01:19 - Closure account.0 - input rel is 1:1
  332. 2018/05/25 15:01:19 - Closure account.0 - Found input rowset [get dim_account.0 - Closure account.0]
  333. 2018/05/25 15:01:19 - Closure account.0 - output rel. is 1:1
  334. 2018/05/25 15:01:19 - Closure account.0 - Found output rowset [Closure account.0 - load closure account.0]
  335. 2018/05/25 15:01:19 - Closure account.0 - Finished dispatching
  336. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure account].0
  337. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure asset] of type [ClosureGenerator]
  338. 2018/05/25 15:01:19 - Closure asset.0 - distribution activated
  339. 2018/05/25 15:01:19 - Closure asset.0 - Starting allocation of buffers & new threads...
  340. 2018/05/25 15:01:19 - Closure asset.0 - Step info: nrinput=1 nroutput=1
  341. 2018/05/25 15:01:19 - Closure asset.0 - Got previous step from [Closure asset] #0 --> get dim_asset
  342. 2018/05/25 15:01:19 - Closure asset.0 - input rel is 1:1
  343. 2018/05/25 15:01:19 - Closure asset.0 - Found input rowset [get dim_asset.0 - Closure asset.0]
  344. 2018/05/25 15:01:19 - Closure asset.0 - output rel. is 1:1
  345. 2018/05/25 15:01:19 - Closure asset.0 - Found output rowset [Closure asset.0 - load closure asset.0]
  346. 2018/05/25 15:01:19 - Closure asset.0 - Finished dispatching
  347. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure asset].0
  348. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure asset] of type [TableOutput]
  349. 2018/05/25 15:01:19 - load closure asset.0 - distribution activated
  350. 2018/05/25 15:01:19 - load closure asset.0 - Starting allocation of buffers & new threads...
  351. 2018/05/25 15:01:19 - load closure asset.0 - Step info: nrinput=1 nroutput=1
  352. 2018/05/25 15:01:19 - load closure asset.0 - Got previous step from [load closure asset] #0 --> Closure asset
  353. 2018/05/25 15:01:19 - load closure asset.0 - input rel is 1:1
  354. 2018/05/25 15:01:19 - load closure asset.0 - Found input rowset [Closure asset.0 - load closure asset.0]
  355. 2018/05/25 15:01:19 - load closure asset.0 - output rel. is 1:1
  356. 2018/05/25 15:01:19 - load closure asset.0 - Found output rowset [load closure asset.0 - Write to log asset.0]
  357. 2018/05/25 15:01:19 - load closure asset.0 - Finished dispatching
  358. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure asset].0
  359. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_asset] of type [TableInput]
  360. 2018/05/25 15:01:19 - get dim_asset.0 - distribution de-activated
  361. 2018/05/25 15:01:19 - get dim_asset.0 - Starting allocation of buffers & new threads...
  362. 2018/05/25 15:01:19 - get dim_asset.0 - Step info: nrinput=0 nroutput=1
  363. 2018/05/25 15:01:19 - get dim_asset.0 - output rel. is 1:1
  364. 2018/05/25 15:01:19 - get dim_asset.0 - Found output rowset [get dim_asset.0 - Closure asset.0]
  365. 2018/05/25 15:01:19 - get dim_asset.0 - Finished dispatching
  366. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_asset].0
  367. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log asset] of type [WriteToLog]
  368. 2018/05/25 15:01:19 - Write to log asset.0 - distribution activated
  369. 2018/05/25 15:01:19 - Write to log asset.0 - Starting allocation of buffers & new threads...
  370. 2018/05/25 15:01:19 - Write to log asset.0 - Step info: nrinput=1 nroutput=1
  371. 2018/05/25 15:01:19 - Write to log asset.0 - Got previous step from [Write to log asset] #0 --> load closure asset
  372. 2018/05/25 15:01:19 - Write to log asset.0 - input rel is 1:1
  373. 2018/05/25 15:01:19 - Write to log asset.0 - Found input rowset [load closure asset.0 - Write to log asset.0]
  374. 2018/05/25 15:01:19 - Write to log asset.0 - output rel. is 1:1
  375. 2018/05/25 15:01:19 - Write to log asset.0 - Found output rowset [Write to log asset.0 - Abort asset.0]
  376. 2018/05/25 15:01:19 - Write to log asset.0 - Finished dispatching
  377. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log asset].0
  378. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort asset] of type [Abort]
  379. 2018/05/25 15:01:19 - Abort asset.0 - distribution activated
  380. 2018/05/25 15:01:19 - Abort asset.0 - Starting allocation of buffers & new threads...
  381. 2018/05/25 15:01:19 - Abort asset.0 - Step info: nrinput=1 nroutput=0
  382. 2018/05/25 15:01:19 - Abort asset.0 - Got previous step from [Abort asset] #0 --> Write to log asset
  383. 2018/05/25 15:01:19 - Abort asset.0 - input rel is 1:1
  384. 2018/05/25 15:01:19 - Abort asset.0 - Found input rowset [Write to log asset.0 - Abort asset.0]
  385. 2018/05/25 15:01:19 - Abort asset.0 - Finished dispatching
  386. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort asset].0
  387. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Closure costcenter] of type [ClosureGenerator]
  388. 2018/05/25 15:01:19 - Closure costcenter.0 - distribution activated
  389. 2018/05/25 15:01:19 - Closure costcenter.0 - Starting allocation of buffers & new threads...
  390. 2018/05/25 15:01:19 - Closure costcenter.0 - Step info: nrinput=1 nroutput=1
  391. 2018/05/25 15:01:19 - Closure costcenter.0 - Got previous step from [Closure costcenter] #0 --> get dim_costcenter
  392. 2018/05/25 15:01:19 - Closure costcenter.0 - input rel is 1:1
  393. 2018/05/25 15:01:19 - Closure costcenter.0 - Found input rowset [get dim_costcenter.0 - Closure costcenter.0]
  394. 2018/05/25 15:01:19 - Closure costcenter.0 - output rel. is 1:1
  395. 2018/05/25 15:01:19 - Closure costcenter.0 - Found output rowset [Closure costcenter.0 - load closure costcenter.0]
  396. 2018/05/25 15:01:19 - Closure costcenter.0 - Finished dispatching
  397. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Closure costcenter].0
  398. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [load closure costcenter] of type [TableOutput]
  399. 2018/05/25 15:01:19 - load closure costcenter.0 - distribution activated
  400. 2018/05/25 15:01:19 - load closure costcenter.0 - Starting allocation of buffers & new threads...
  401. 2018/05/25 15:01:19 - load closure costcenter.0 - Step info: nrinput=1 nroutput=1
  402. 2018/05/25 15:01:19 - load closure costcenter.0 - Got previous step from [load closure costcenter] #0 --> Closure costcenter
  403. 2018/05/25 15:01:19 - load closure costcenter.0 - input rel is 1:1
  404. 2018/05/25 15:01:19 - load closure costcenter.0 - Found input rowset [Closure costcenter.0 - load closure costcenter.0]
  405. 2018/05/25 15:01:19 - load closure costcenter.0 - output rel. is 1:1
  406. 2018/05/25 15:01:19 - load closure costcenter.0 - Found output rowset [load closure costcenter.0 - Write to log costcenter.0]
  407. 2018/05/25 15:01:19 - load closure costcenter.0 - Finished dispatching
  408. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [load closure costcenter].0
  409. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Write to log costcenter] of type [WriteToLog]
  410. 2018/05/25 15:01:19 - Write to log costcenter.0 - distribution activated
  411. 2018/05/25 15:01:19 - Write to log costcenter.0 - Starting allocation of buffers & new threads...
  412. 2018/05/25 15:01:19 - Write to log costcenter.0 - Step info: nrinput=1 nroutput=1
  413. 2018/05/25 15:01:19 - Write to log costcenter.0 - Got previous step from [Write to log costcenter] #0 --> load closure costcenter
  414. 2018/05/25 15:01:19 - Write to log costcenter.0 - input rel is 1:1
  415. 2018/05/25 15:01:19 - Write to log costcenter.0 - Found input rowset [load closure costcenter.0 - Write to log costcenter.0]
  416. 2018/05/25 15:01:19 - Write to log costcenter.0 - output rel. is 1:1
  417. 2018/05/25 15:01:19 - Write to log costcenter.0 - Found output rowset [Write to log costcenter.0 - Abort costcenter.0]
  418. 2018/05/25 15:01:19 - Write to log costcenter.0 - Finished dispatching
  419. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Write to log costcenter].0
  420. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [Abort costcenter] of type [Abort]
  421. 2018/05/25 15:01:19 - Abort costcenter.0 - distribution activated
  422. 2018/05/25 15:01:19 - Abort costcenter.0 - Starting allocation of buffers & new threads...
  423. 2018/05/25 15:01:19 - Abort costcenter.0 - Step info: nrinput=1 nroutput=0
  424. 2018/05/25 15:01:19 - Abort costcenter.0 - Got previous step from [Abort costcenter] #0 --> Write to log costcenter
  425. 2018/05/25 15:01:19 - Abort costcenter.0 - input rel is 1:1
  426. 2018/05/25 15:01:19 - Abort costcenter.0 - Found input rowset [Write to log costcenter.0 - Abort costcenter.0]
  427. 2018/05/25 15:01:19 - Abort costcenter.0 - Finished dispatching
  428. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [Abort costcenter].0
  429. 2018/05/25 15:01:19 - load closure - Transformation is about to allocate step [get dim_costcenter] of type [TableInput]
  430. 2018/05/25 15:01:19 - get dim_costcenter.0 - distribution de-activated
  431. 2018/05/25 15:01:19 - get dim_costcenter.0 - Starting allocation of buffers & new threads...
  432. 2018/05/25 15:01:19 - get dim_costcenter.0 - Step info: nrinput=0 nroutput=1
  433. 2018/05/25 15:01:19 - get dim_costcenter.0 - output rel. is 1:1
  434. 2018/05/25 15:01:19 - get dim_costcenter.0 - Found output rowset [get dim_costcenter.0 - Closure costcenter.0]
  435. 2018/05/25 15:01:19 - get dim_costcenter.0 - Finished dispatching
  436. 2018/05/25 15:01:19 - load closure - Transformation has allocated a new step: [get dim_costcenter].0
  437. 2018/05/25 15:01:19 - load closure - This transformation can be replayed with replay date: 2018/05/25 15:01:19
  438. 2018/05/25 15:01:19 - load closure - Initialising 30 steps...
  439. 2018/05/25 15:01:19 - Closure organization.0 - Released server socket on port 0
  440. 2018/05/25 15:01:19 - load closure org.0 - Released server socket on port 0
  441. 2018/05/25 15:01:19 - load closure org.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  442. 2018/05/25 15:01:19 - Write to log org.0 - Released server socket on port 0
  443. 2018/05/25 15:01:19 - OLAP - New database connection defined
  444. 2018/05/25 15:01:19 - Write to log acccount.0 - Released server socket on port 0
  445. 2018/05/25 15:01:19 - Abort account.0 - Released server socket on port 0
  446. 2018/05/25 15:01:19 - Closure salesregion.0 - Released server socket on port 0
  447. 2018/05/25 15:01:19 - load closure salesregion.0 - Released server socket on port 0
  448. 2018/05/25 15:01:19 - load closure salesregion.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  449. 2018/05/25 15:01:19 - OLAP - New database connection defined
  450. 2018/05/25 15:01:19 - Write to log salesregion.0 - Released server socket on port 0
  451. 2018/05/25 15:01:19 - Abort salesregion.0 - Released server socket on port 0
  452. 2018/05/25 15:01:19 - Closure project.0 - Released server socket on port 0
  453. 2018/05/25 15:01:19 - load closure project.0 - Released server socket on port 0
  454. 2018/05/25 15:01:19 - load closure project.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  455. 2018/05/25 15:01:19 - OLAP - New database connection defined
  456. 2018/05/25 15:01:19 - Write to log project.0 - Released server socket on port 0
  457. 2018/05/25 15:01:19 - Abort project.0 - Released server socket on port 0
  458. 2018/05/25 15:01:19 - Abort org.0 - Released server socket on port 0
  459. 2018/05/25 15:01:19 - get dim_project.0 - Released server socket on port 0
  460. 2018/05/25 15:01:19 - get dim_asset.0 - Released server socket on port 0
  461. 2018/05/25 15:01:19 - get dim_salesregion.0 - Released server socket on port 0
  462. 2018/05/25 15:01:19 - load closure asset.0 - Released server socket on port 0
  463. 2018/05/25 15:01:19 - load closure asset.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  464. 2018/05/25 15:01:19 - OLAP - New database connection defined
  465. 2018/05/25 15:01:19 - Closure account.0 - Released server socket on port 0
  466. 2018/05/25 15:01:19 - get dim_organization.0 - Released server socket on port 0
  467. 2018/05/25 15:01:19 - Closure asset.0 - Released server socket on port 0
  468. 2018/05/25 15:01:19 - OLAP - New database connection defined
  469. 2018/05/25 15:01:19 - OLAP - New database connection defined
  470. 2018/05/25 15:01:19 - Closure costcenter.0 - Released server socket on port 0
  471. 2018/05/25 15:01:19 - Abort asset.0 - Released server socket on port 0
  472. 2018/05/25 15:01:19 - load closure account.0 - Released server socket on port 0
  473. 2018/05/25 15:01:19 - OLAP - New database connection defined
  474. 2018/05/25 15:01:19 - Write to log asset.0 - Released server socket on port 0
  475. 2018/05/25 15:01:19 - OLAP - New database connection defined
  476. 2018/05/25 15:01:19 - get dim_account.0 - Released server socket on port 0
  477. 2018/05/25 15:01:19 - OLAP - New database connection defined
  478. 2018/05/25 15:01:19 - load closure account.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  479. 2018/05/25 15:01:19 - OLAP - New database connection defined
  480. 2018/05/25 15:01:19 - load closure costcenter.0 - Released server socket on port 0
  481. 2018/05/25 15:01:19 - load closure costcenter.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
  482. 2018/05/25 15:01:19 - OLAP - New database connection defined
  483. 2018/05/25 15:01:19 - Abort costcenter.0 - Released server socket on port 0
  484. 2018/05/25 15:01:19 - Write to log costcenter.0 - Released server socket on port 0
  485. 2018/05/25 15:01:19 - get dim_costcenter.0 - Released server socket on port 0
  486. 2018/05/25 15:01:19 - OLAP - New database connection defined
  487. 2018/05/25 15:01:19 - OLAP - Auto commit off
  488. 2018/05/25 15:01:19 - OLAP - Auto commit off
  489. 2018/05/25 15:01:19 - get dim_asset.0 - Connected to database...
  490. 2018/05/25 15:01:19 - OLAP - Auto commit off
  491. 2018/05/25 15:01:19 - get dim_organization.0 - Connected to database...
  492. 2018/05/25 15:01:19 - load closure org.0 - Connected to database [OLAP] (commit=1000)
  493. 2018/05/25 15:01:19 - OLAP - Auto commit off
  494. 2018/05/25 15:01:19 - load closure costcenter.0 - Connected to database [OLAP] (commit=1000)
  495. 2018/05/25 15:01:19 - OLAP - Auto commit off
  496. 2018/05/25 15:01:19 - OLAP - Auto commit off
  497. 2018/05/25 15:01:19 - get dim_account.0 - Connected to database...
  498. 2018/05/25 15:01:19 - load closure salesregion.0 - Connected to database [OLAP] (commit=1000)
  499. 2018/05/25 15:01:19 - OLAP - Auto commit off
  500. 2018/05/25 15:01:19 - get dim_salesregion.0 - Connected to database...
  501. 2018/05/25 15:01:19 - load closure account.0 - Connected to database [OLAP] (commit=1000)
  502. 2018/05/25 15:01:19 - OLAP - Auto commit off
  503. 2018/05/25 15:01:19 - load closure project.0 - Connected to database [OLAP] (commit=1000)
  504. 2018/05/25 15:01:19 - OLAP - Auto commit off
  505. 2018/05/25 15:01:19 - load closure asset.0 - Connected to database [OLAP] (commit=1000)
  506. 2018/05/25 15:01:19 - OLAP - Auto commit off
  507. 2018/05/25 15:01:19 - OLAP - Auto commit off
  508. 2018/05/25 15:01:19 - get dim_costcenter.0 - Connected to database...
  509. 2018/05/25 15:01:19 - OLAP - Auto commit off
  510. 2018/05/25 15:01:19 - get dim_project.0 - Connected to database...
  511. 2018/05/25 15:01:19 - load closure - Step [Closure organization.0] initialized flawlessly.
  512. 2018/05/25 15:01:19 - load closure - Step [load closure org.0] initialized flawlessly.
  513. 2018/05/25 15:01:19 - load closure - Step [Write to log org.0] initialized flawlessly.
  514. 2018/05/25 15:01:19 - load closure - Step [Abort org.0] initialized flawlessly.
  515. 2018/05/25 15:01:19 - load closure - Step [Write to log acccount.0] initialized flawlessly.
  516. 2018/05/25 15:01:19 - load closure - Step [Abort account.0] initialized flawlessly.
  517. 2018/05/25 15:01:19 - load closure - Step [Closure salesregion.0] initialized flawlessly.
  518. 2018/05/25 15:01:19 - load closure - Step [load closure salesregion.0] initialized flawlessly.
  519. 2018/05/25 15:01:19 - load closure - Step [Write to log salesregion.0] initialized flawlessly.
  520. 2018/05/25 15:01:19 - load closure - Step [Abort salesregion.0] initialized flawlessly.
  521. 2018/05/25 15:01:19 - load closure - Step [Closure project.0] initialized flawlessly.
  522. 2018/05/25 15:01:19 - load closure - Step [load closure project.0] initialized flawlessly.
  523. 2018/05/25 15:01:19 - load closure - Step [Write to log project.0] initialized flawlessly.
  524. 2018/05/25 15:01:19 - load closure - Step [Abort project.0] initialized flawlessly.
  525. 2018/05/25 15:01:19 - load closure - Step [load closure account.0] initialized flawlessly.
  526. 2018/05/25 15:01:19 - load closure - Step [get dim_salesregion.0] initialized flawlessly.
  527. 2018/05/25 15:01:19 - load closure - Step [get dim_organization.0] initialized flawlessly.
  528. 2018/05/25 15:01:19 - load closure - Step [get dim_project.0] initialized flawlessly.
  529. 2018/05/25 15:01:19 - load closure - Step [get dim_account.0] initialized flawlessly.
  530. 2018/05/25 15:01:19 - load closure - Step [Closure account.0] initialized flawlessly.
  531. 2018/05/25 15:01:19 - load closure - Step [Closure asset.0] initialized flawlessly.
  532. 2018/05/25 15:01:19 - load closure - Step [load closure asset.0] initialized flawlessly.
  533. 2018/05/25 15:01:19 - load closure - Step [get dim_asset.0] initialized flawlessly.
  534. 2018/05/25 15:01:19 - load closure - Step [Write to log asset.0] initialized flawlessly.
  535. 2018/05/25 15:01:19 - load closure - Step [Abort asset.0] initialized flawlessly.
  536. 2018/05/25 15:01:19 - load closure - Step [Closure costcenter.0] initialized flawlessly.
  537. 2018/05/25 15:01:19 - load closure - Step [load closure costcenter.0] initialized flawlessly.
  538. 2018/05/25 15:01:19 - load closure - Step [Write to log costcenter.0] initialized flawlessly.
  539. 2018/05/25 15:01:19 - load closure - Step [Abort costcenter.0] initialized flawlessly.
  540. 2018/05/25 15:01:19 - load closure - Step [get dim_costcenter.0] initialized flawlessly.
  541. 2018/05/25 15:01:20 - Closure organization.0 - Starting to run...
  542. 2018/05/25 15:01:20 - load closure org.0 - Starting to run...
  543. 2018/05/25 15:01:20 - Write to log org.0 - Starting to run...
  544. 2018/05/25 15:01:20 - Abort org.0 - Starting to run...
  545. 2018/05/25 15:01:20 - Write to log acccount.0 - Starting to run...
  546. 2018/05/25 15:01:20 - Abort account.0 - Starting to run...
  547. 2018/05/25 15:01:20 - Closure salesregion.0 - Starting to run...
  548. 2018/05/25 15:01:20 - load closure salesregion.0 - Starting to run...
  549. 2018/05/25 15:01:20 - Write to log salesregion.0 - Starting to run...
  550. 2018/05/25 15:01:20 - Abort salesregion.0 - Starting to run...
  551. 2018/05/25 15:01:20 - Closure project.0 - Starting to run...
  552. 2018/05/25 15:01:20 - load closure project.0 - Starting to run...
  553. 2018/05/25 15:01:20 - Write to log project.0 - Starting to run...
  554. 2018/05/25 15:01:20 - Abort project.0 - Starting to run...
  555. 2018/05/25 15:01:20 - load closure account.0 - Starting to run...
  556. 2018/05/25 15:01:20 - get dim_salesregion.0 - Starting to run...
  557. 2018/05/25 15:01:20 - get dim_salesregion.0 - SQL query : select id, parent_id from dim_salesregion
  558. 2018/05/25 15:01:20 - get dim_organization.0 - Starting to run...
  559. 2018/05/25 15:01:20 - get dim_organization.0 - SQL query : select id, parent_id from dim_organization
  560. 2018/05/25 15:01:20 - get dim_project.0 - Starting to run...
  561. 2018/05/25 15:01:20 - get dim_project.0 - SQL query : select id, parent_id from dim_project
  562. 2018/05/25 15:01:20 - Closure account.0 - Starting to run...
  563. 2018/05/25 15:01:20 - get dim_account.0 - Starting to run...
  564. 2018/05/25 15:01:20 - get dim_account.0 - SQL query : select id, parent_id from dim_account
  565. 2018/05/25 15:01:20 - Closure asset.0 - Starting to run...
  566. 2018/05/25 15:01:20 - load closure asset.0 - Starting to run...
  567. 2018/05/25 15:01:20 - get dim_asset.0 - Starting to run...
  568. 2018/05/25 15:01:20 - get dim_asset.0 - SQL query : select id, parent_id from dim_asset
  569. 2018/05/25 15:01:20 - Write to log asset.0 - Starting to run...
  570. 2018/05/25 15:01:20 - Abort asset.0 - Starting to run...
  571. 2018/05/25 15:01:20 - Closure costcenter.0 - Starting to run...
  572. 2018/05/25 15:01:20 - load closure costcenter.0 - Starting to run...
  573. 2018/05/25 15:01:20 - Write to log costcenter.0 - Starting to run...
  574. 2018/05/25 15:01:20 - Abort costcenter.0 - Starting to run...
  575. 2018/05/25 15:01:20 - get dim_costcenter.0 - Starting to run...
  576. 2018/05/25 15:01:20 - get dim_costcenter.0 - SQL query : select id, parent_id from dim_costcenter
  577. 2018/05/25 15:01:20 - load closure - Transformation has allocated 30 threads and 24 rowsets.
  578. 2018/05/25 15:01:20 - get dim_project.0 - Finished reading query, closing connection.
  579. 2018/05/25 15:01:20 - get dim_organization.0 - Finished reading query, closing connection.
  580. 2018/05/25 15:01:20 - Closure project.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  581. 2018/05/25 15:01:20 - get dim_salesregion.0 - Finished reading query, closing connection.
  582. 2018/05/25 15:01:20 - load closure org.0 - Prepared statement : INSERT INTO closure_organization (parent_id, id, distance) VALUES ( ?, ?, ?)
  583. 2018/05/25 15:01:20 - get dim_account.0 - Finished reading query, closing connection.
  584. 2018/05/25 15:01:20 - Closure organization.0 - Finished processing (I=0, O=0, R=47, W=150, U=0, E=0)
  585. 2018/05/25 15:01:20 - Closure salesregion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  586. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  587. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  588. 2018/05/25 15:01:20 - get dim_organization.0 - Finished processing (I=47, O=0, R=0, W=47, U=0, E=0)
  589. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  590. 2018/05/25 15:01:20 - get dim_salesregion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  591. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  592. 2018/05/25 15:01:20 - get dim_account.0 - Finished processing (I=256, O=0, R=0, W=256, U=0, E=0)
  593. 2018/05/25 15:01:20 - get dim_project.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  594. 2018/05/25 15:01:20 - load closure org.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
  595. 2018/05/25 15:01:20 - load closure org.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
  596. 2018/05/25 15:01:20 - load closure org.0 - Unable to roll back database transaction to savepoint
  597. 2018/05/25 15:01:20 - load closure org.0 - Server versions prior to 8.0 do not support savepoints.
  598. 2018/05/25 15:01:20 - load closure org.0 -
  599. 2018/05/25 15:01:20 - load closure org.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:4428)
  600. 2018/05/25 15:01:20 - load closure org.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:351)
  601. 2018/05/25 15:01:20 - load closure org.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
  602. 2018/05/25 15:01:20 - load closure org.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
  603. 2018/05/25 15:01:20 - load closure org.0 - at java.lang.Thread.run(Thread.java:748)
  604. 2018/05/25 15:01:20 - load closure org.0 - Caused by: org.postgresql.util.PSQLException: Server versions prior to 8.0 do not support savepoints.
  605. 2018/05/25 15:01:20 - load closure org.0 - at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:167)
  606. 2018/05/25 15:01:20 - load closure org.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:4426)
  607. 2018/05/25 15:01:20 - load closure org.0 - ... 4 more
  608. 2018/05/25 15:01:20 - Abort salesregion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  609. 2018/05/25 15:01:20 - Abort org.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  610. 2018/05/25 15:01:20 - Write to log salesregion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  611. 2018/05/25 15:01:20 - Abort project.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  612. 2018/05/25 15:01:20 - Write to log org.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  613. 2018/05/25 15:01:20 - Closure costcenter.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  614. 2018/05/25 15:01:20 - Closure account.0 - Finished processing (I=0, O=0, R=256, W=0, U=0, E=0)
  615. 2018/05/25 15:01:20 - Abort asset.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  616. 2018/05/25 15:01:20 - Write to log project.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  617. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  618. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  619. 2018/05/25 15:01:20 - load closure account.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  620. 2018/05/25 15:01:20 - load closure project.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  621. 2018/05/25 15:01:20 - Abort costcenter.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  622. 2018/05/25 15:01:20 - Write to log asset.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  623. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  624. 2018/05/25 15:01:20 - load closure asset.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  625. 2018/05/25 15:01:20 - Write to log costcenter.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  626. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  627. 2018/05/25 15:01:20 - load closure salesregion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  628. 2018/05/25 15:01:20 - get dim_asset.0 - Finished reading query, closing connection.
  629. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  630. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  631. 2018/05/25 15:01:20 - load closure costcenter.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  632. 2018/05/25 15:01:20 - get dim_asset.0 - Finished processing (I=442, O=0, R=0, W=440, U=0, E=0)
  633. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  634. 2018/05/25 15:01:20 - load closure org.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
  635. 2018/05/25 15:01:20 - load closure - Transformation detected one or more steps with errors.
  636. 2018/05/25 15:01:20 - load closure - Transformation is killing the other steps!
  637. 2018/05/25 15:01:20 - get dim_costcenter.0 - Finished reading query, closing connection.
  638. 2018/05/25 15:01:20 - Closure asset.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
  639. 2018/05/25 15:01:20 - OLAP - Connection to database closed!
  640. 2018/05/25 15:01:20 - Abort account.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  641. 2018/05/25 15:01:20 - get dim_costcenter.0 - Finished processing (I=2, O=0, R=0, W=0, U=0, E=0)
  642. 2018/05/25 15:01:20 - Write to log acccount.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  643. 2018/05/25 15:01:21 - Pan - Finished!
  644. 2018/05/25 15:01:21 - Pan - Start=2018/05/25 15:01:19.407, Stop=2018/05/25 15:01:21.023
  645. 2018/05/25 15:01:21 - Pan - Processing ended after 1 seconds.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!