API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 14th, 2017
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.70 KB | None | 0 0
raw download clone embed print report
  1. root@Marchio:~/pentaho/data-integration# sh pan.sh -logfile=/root/pentaho/data-integration/orc5atxt.log -rep=indexis_rep -user=repository -pass=U7366U53Vd -trans:m_woo_transfereorcamentos_v5 -level=Rowlevel
  2. 10:02:27,446 INFO [KarafInstance]
  3. *******************************************************************************
  4. *** Karaf Instance Number: 1 at /root/pentaho/data-integration/./system/kar ***
  5. *** af/caches/pan/data-1 ***
  6. *** Karaf Port:8802 ***
  7. *** OSGI Service Port:9051 ***
  8. *******************************************************************************
  9. 10:02:27,447 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
  10. Oct 14, 2017 10:02:28 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
  11. INFO: Lock acquired. Setting startlevel to 100
  12. 2017/10/14 10:02:30 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
  13. Oct 14, 2017 10:02:34 AM 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:/root/pentaho/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  17. SLF4J: Found binding in [jar:file:/root/pentaho/data-integration/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. 2017/10/14 10:02:37 - Pan - Logging is at level : Row Level (very detailed)
  21. Arguments:
  22. rep : indexis_rep
  23. user : repository
  24. pass : U7366U53Vd
  25. trans : m_woo_transfereorcamentos_v5
  26. dir :
  27. file :
  28. level : Rowlevel
  29. logfile : /root/pentaho/data-integration/orc5atxt.log
  30. log :
  31. listdir :
  32. listtrans :
  33. listrep :
  34. exprep :
  35. norep :
  36. safemode :
  37. version :
  38. jarfile :
  39. param : null
  40. listparam :
  41. metrics :
  42. maxloglines :
  43. maxlogtimeou :
  44. 2017/10/14 10:02:37 - Pan - Start of run.
  45. 2017/10/14 10:02:37 - Pan - Allocate new transformation.
  46. 2017/10/14 10:02:37 - Pan - Starting to look at options...
  47. 2017/10/14 10:02:37 - Pan - Parsing command line options.
  48. 2017/10/14 10:02:37 - Pan - Loading available repositories.
  49. 2017/10/14 10:02:37 - RepositoriesMeta - No repositories file found in the local directory: /root/pentaho/data-integration/repositories.xml
  50. 2017/10/14 10:02:37 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
  51. 2017/10/14 10:02:37 - RepositoriesMeta - We have 2 connections...
  52. 2017/10/14 10:02:37 - RepositoriesMeta - Looking at connection #0
  53. 2017/10/14 10:02:37 - RepositoriesMeta - Read at connection: Local Repository Marchio
  54. 2017/10/14 10:02:37 - RepositoriesMeta - Looking at connection #1
  55. 2017/10/14 10:02:37 - RepositoriesMeta - Read at connection: indexis_rep
  56. 2017/10/14 10:02:37 - RepositoriesMeta - We have 2 repositories...
  57. 2017/10/14 10:02:37 - RepositoriesMeta - Looking at repository #0
  58. 2017/10/14 10:02:37 - RepositoriesMeta - Read at repository: mar_rep
  59. 2017/10/14 10:02:37 - RepositoriesMeta - Looking at repository #1
  60. 2017/10/14 10:02:37 - RepositoriesMeta - Read at repository: indexis_rep
  61. 2017/10/14 10:02:37 - Pan - Finding repository [indexis_rep]
  62. 2017/10/14 10:02:37 - Pan - Allocate & connect to repository.
  63. Sat Oct 14 10:02:37 GMT-03:00 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
  64. 2017/10/14 10:02:37 - Pan - Check supplied username and password.
  65. 2017/10/14 10:02:37 - Pan - Load the transformation info...
  66. 2017/10/14 10:02:37 - indexis_rep - Looking for the transformation [m_woo_transfereorcamentos_v5] in directory [/]
  67. 2017/10/14 10:02:37 - indexis_rep - Loading transformation [m_woo_transfereorcamentos_v5] from repository...
  68. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 495
  69. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 496
  70. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 497
  71. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 498
  72. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 499
  73. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 500
  74. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 501
  75. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 502
  76. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 503
  77. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 504
  78. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 505
  79. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 506
  80. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 507
  81. 2017/10/14 10:02:37 - indexis_rep - Loading step with ID: 508
  82. 2017/10/14 10:02:37 - indexis_rep - ID_DIRECTORY=0
  83. 2017/10/14 10:02:38 - indexis_rep - Loaded the transformation [m_woo_transfereorcamentos_v5] , directory == null : false
  84. 2017/10/14 10:02:38 - indexis_rep - Loaded the transformation [m_woo_transfereorcamentos_v5] in directory /
  85. 2017/10/14 10:02:38 - Pan - Allocate transformation...
  86. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Dispatching started for transformation [m_woo_transfereorcamentos_v5]
  87. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Nr of arguments detected:0
  88. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - This is not a replay transformation
  89. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - I found 14 different steps to launch.
  90. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets...
  91. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 0 --> obtem_novas_ordens
  92. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  93. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  94. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 1 rowsets for step 0 --> obtem_novas_ordens
  95. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 1 --> desnormaliza_pedidos
  96. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  97. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  98. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 2 rowsets for step 1 --> desnormaliza_pedidos
  99. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 2 --> adiciona_constantes 2
  100. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  101. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  102. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 3 rowsets for step 2 --> adiciona_constantes 2
  103. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 3 --> obtem_user_santri_id
  104. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  105. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  106. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 4 rowsets for step 3 --> obtem_user_santri_id
  107. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 4 --> Obtem Shipping Method
  108. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  109. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [Obtem Shipping Method.0 - insere_orcamentos 2.0]
  110. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 5 rowsets for step 4 --> Obtem Shipping Method
  111. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 5 --> insere_orcamentos 2
  112. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  113. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [insere_orcamentos 2.0 - atualiza_ordens.0]
  114. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 6 rowsets for step 5 --> insere_orcamentos 2
  115. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 6 --> Block this step until steps finish 2
  116. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  117. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [Block this step until steps finish 2.0 - finaliza_pedido 2.0]
  118. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 7 rowsets for step 6 --> Block this step until steps finish 2
  119. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 7 --> finaliza_pedido 2
  120. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 7 rowsets for step 7 --> finaliza_pedido 2
  121. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 8 --> Calculator
  122. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  123. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [Calculator.0 - insere_itens.0]
  124. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 8 rowsets for step 8 --> Calculator
  125. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 9 --> insere_itens
  126. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 8 rowsets for step 9 --> insere_itens
  127. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 10 --> Obtem Itens
  128. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  129. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [Obtem Itens.0 - desnormaliza_itens.0]
  130. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 9 rowsets for step 10 --> Obtem Itens
  131. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 11 --> desnormaliza_itens
  132. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  133. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [desnormaliza_itens.0 - obtem_product_santri_id.0]
  134. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 10 rowsets for step 11 --> desnormaliza_itens
  135. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 12 --> atualiza_ordens
  136. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  137. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [atualiza_ordens.0 - Block this step until steps finish 2.0]
  138. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  139. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [atualiza_ordens.0 - Obtem Itens.0]
  140. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 12 rowsets for step 12 --> atualiza_ordens
  141. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating rowsets for step 13 --> obtem_product_santri_id
  142. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - prevcopies = 1, nextcopies=1
  143. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation allocated new rowset [obtem_product_santri_id.0 - Calculator.0]
  144. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocated 13 rowsets for step 13 --> obtem_product_santri_id
  145. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Allocating Steps & StepData...
  146. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [obtem_novas_ordens] of type [TableInput]
  147. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  148. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - distribution de-activated
  149. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Starting allocation of buffers & new threads...
  150. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Step info: nrinput=0 nroutput=1
  151. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - output rel. is 1:1
  152. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Found output rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  153. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Finished dispatching
  154. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [obtem_novas_ordens].0
  155. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [desnormaliza_pedidos] of type [Denormaliser]
  156. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  157. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - distribution de-activated
  158. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Starting allocation of buffers & new threads...
  159. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Step info: nrinput=1 nroutput=1
  160. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Got previous step from [desnormaliza_pedidos] #0 --> obtem_novas_ordens
  161. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - input rel is 1:1
  162. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Found input rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  163. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - output rel. is 1:1
  164. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Found output rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  165. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Finished dispatching
  166. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [desnormaliza_pedidos].0
  167. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [adiciona_constantes 2] of type [Constant]
  168. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  169. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - distribution de-activated
  170. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Starting allocation of buffers & new threads...
  171. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Step info: nrinput=1 nroutput=1
  172. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Got previous step from [adiciona_constantes 2] #0 --> desnormaliza_pedidos
  173. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - input rel is 1:1
  174. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Found input rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  175. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - output rel. is 1:1
  176. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Found output rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  177. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Finished dispatching
  178. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [adiciona_constantes 2].0
  179. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [obtem_user_santri_id] of type [DBLookup]
  180. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  181. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - distribution activated
  182. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Starting allocation of buffers & new threads...
  183. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Step info: nrinput=1 nroutput=1
  184. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Got previous step from [obtem_user_santri_id] #0 --> adiciona_constantes 2
  185. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - input rel is 1:1
  186. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Found input rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  187. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - output rel. is 1:1
  188. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Found output rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  189. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Finished dispatching
  190. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [obtem_user_santri_id].0
  191. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [Obtem Shipping Method] of type [DBLookup]
  192. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  193. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - distribution de-activated
  194. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Starting allocation of buffers & new threads...
  195. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Step info: nrinput=1 nroutput=1
  196. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Got previous step from [Obtem Shipping Method] #0 --> obtem_user_santri_id
  197. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - input rel is 1:1
  198. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Found input rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  199. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - output rel. is 1:1
  200. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Found output rowset [Obtem Shipping Method.0 - insere_orcamentos 2.0]
  201. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Finished dispatching
  202. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [Obtem Shipping Method].0
  203. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [insere_orcamentos 2] of type [DBProc]
  204. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  205. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - distribution de-activated
  206. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Starting allocation of buffers & new threads...
  207. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Step info: nrinput=1 nroutput=1
  208. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Got previous step from [insere_orcamentos 2] #0 --> Obtem Shipping Method
  209. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - input rel is 1:1
  210. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Found input rowset [Obtem Shipping Method.0 - insere_orcamentos 2.0]
  211. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - output rel. is 1:1
  212. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Found output rowset [insere_orcamentos 2.0 - atualiza_ordens.0]
  213. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Finished dispatching
  214. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [insere_orcamentos 2].0
  215. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [Block this step until steps finish 2] of type [BlockUntilStepsFinish]
  216. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  217. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - distribution activated
  218. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Starting allocation of buffers & new threads...
  219. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Step info: nrinput=1 nroutput=1
  220. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Got previous step from [Block this step until steps finish 2] #0 --> atualiza_ordens
  221. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - input rel is 1:1
  222. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Found input rowset [atualiza_ordens.0 - Block this step until steps finish 2.0]
  223. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - output rel. is 1:1
  224. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Found output rowset [Block this step until steps finish 2.0 - finaliza_pedido 2.0]
  225. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Finished dispatching
  226. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [Block this step until steps finish 2].0
  227. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [finaliza_pedido 2] of type [DBProc]
  228. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  229. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - distribution de-activated
  230. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Starting allocation of buffers & new threads...
  231. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Step info: nrinput=1 nroutput=0
  232. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Got previous step from [finaliza_pedido 2] #0 --> Block this step until steps finish 2
  233. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - input rel is 1:1
  234. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Found input rowset [Block this step until steps finish 2.0 - finaliza_pedido 2.0]
  235. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Finished dispatching
  236. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [finaliza_pedido 2].0
  237. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [Calculator] of type [Calculator]
  238. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  239. 2017/10/14 10:02:38 - Calculator.0 - distribution activated
  240. 2017/10/14 10:02:38 - Calculator.0 - Starting allocation of buffers & new threads...
  241. 2017/10/14 10:02:38 - Calculator.0 - Step info: nrinput=1 nroutput=1
  242. 2017/10/14 10:02:38 - Calculator.0 - Got previous step from [Calculator] #0 --> obtem_product_santri_id
  243. 2017/10/14 10:02:38 - Calculator.0 - input rel is 1:1
  244. 2017/10/14 10:02:38 - Calculator.0 - Found input rowset [obtem_product_santri_id.0 - Calculator.0]
  245. 2017/10/14 10:02:38 - Calculator.0 - output rel. is 1:1
  246. 2017/10/14 10:02:38 - Calculator.0 - Found output rowset [Calculator.0 - insere_itens.0]
  247. 2017/10/14 10:02:38 - Calculator.0 - Finished dispatching
  248. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [Calculator].0
  249. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [insere_itens] of type [DBProc]
  250. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  251. 2017/10/14 10:02:38 - insere_itens.0 - distribution de-activated
  252. 2017/10/14 10:02:38 - insere_itens.0 - Starting allocation of buffers & new threads...
  253. 2017/10/14 10:02:38 - insere_itens.0 - Step info: nrinput=1 nroutput=0
  254. 2017/10/14 10:02:38 - insere_itens.0 - Got previous step from [insere_itens] #0 --> Calculator
  255. 2017/10/14 10:02:38 - insere_itens.0 - input rel is 1:1
  256. 2017/10/14 10:02:38 - insere_itens.0 - Found input rowset [Calculator.0 - insere_itens.0]
  257. 2017/10/14 10:02:38 - insere_itens.0 - Finished dispatching
  258. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [insere_itens].0
  259. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [Obtem Itens] of type [DBJoin]
  260. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  261. 2017/10/14 10:02:38 - Obtem Itens.0 - distribution de-activated
  262. 2017/10/14 10:02:38 - Obtem Itens.0 - Starting allocation of buffers & new threads...
  263. 2017/10/14 10:02:38 - Obtem Itens.0 - Step info: nrinput=1 nroutput=1
  264. 2017/10/14 10:02:38 - Obtem Itens.0 - Got previous step from [Obtem Itens] #0 --> atualiza_ordens
  265. 2017/10/14 10:02:38 - Obtem Itens.0 - input rel is 1:1
  266. 2017/10/14 10:02:38 - Obtem Itens.0 - Found input rowset [atualiza_ordens.0 - Obtem Itens.0]
  267. 2017/10/14 10:02:38 - Obtem Itens.0 - output rel. is 1:1
  268. 2017/10/14 10:02:38 - Obtem Itens.0 - Found output rowset [Obtem Itens.0 - desnormaliza_itens.0]
  269. 2017/10/14 10:02:38 - Obtem Itens.0 - Finished dispatching
  270. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [Obtem Itens].0
  271. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [desnormaliza_itens] of type [Denormaliser]
  272. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  273. 2017/10/14 10:02:38 - desnormaliza_itens.0 - distribution activated
  274. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Starting allocation of buffers & new threads...
  275. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Step info: nrinput=1 nroutput=1
  276. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Got previous step from [desnormaliza_itens] #0 --> Obtem Itens
  277. 2017/10/14 10:02:38 - desnormaliza_itens.0 - input rel is 1:1
  278. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Found input rowset [Obtem Itens.0 - desnormaliza_itens.0]
  279. 2017/10/14 10:02:38 - desnormaliza_itens.0 - output rel. is 1:1
  280. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Found output rowset [desnormaliza_itens.0 - obtem_product_santri_id.0]
  281. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Finished dispatching
  282. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [desnormaliza_itens].0
  283. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [atualiza_ordens] of type [InsertUpdate]
  284. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  285. 2017/10/14 10:02:38 - atualiza_ordens.0 - distribution de-activated
  286. 2017/10/14 10:02:38 - atualiza_ordens.0 - Starting allocation of buffers & new threads...
  287. 2017/10/14 10:02:38 - atualiza_ordens.0 - Step info: nrinput=1 nroutput=2
  288. 2017/10/14 10:02:38 - atualiza_ordens.0 - Got previous step from [atualiza_ordens] #0 --> insere_orcamentos 2
  289. 2017/10/14 10:02:38 - atualiza_ordens.0 - input rel is 1:1
  290. 2017/10/14 10:02:38 - atualiza_ordens.0 - Found input rowset [insere_orcamentos 2.0 - atualiza_ordens.0]
  291. 2017/10/14 10:02:38 - atualiza_ordens.0 - output rel. is 1:1
  292. 2017/10/14 10:02:38 - atualiza_ordens.0 - Found output rowset [atualiza_ordens.0 - Block this step until steps finish 2.0]
  293. 2017/10/14 10:02:38 - atualiza_ordens.0 - output rel. is 1:1
  294. 2017/10/14 10:02:38 - atualiza_ordens.0 - Found output rowset [atualiza_ordens.0 - Obtem Itens.0]
  295. 2017/10/14 10:02:38 - atualiza_ordens.0 - Finished dispatching
  296. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [atualiza_ordens].0
  297. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation is about to allocate step [obtem_product_santri_id] of type [DBLookup]
  298. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Step has nrcopies=1
  299. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - distribution activated
  300. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Starting allocation of buffers & new threads...
  301. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Step info: nrinput=1 nroutput=1
  302. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Got previous step from [obtem_product_santri_id] #0 --> desnormaliza_itens
  303. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - input rel is 1:1
  304. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Found input rowset [desnormaliza_itens.0 - obtem_product_santri_id.0]
  305. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - output rel. is 1:1
  306. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Found output rowset [obtem_product_santri_id.0 - Calculator.0]
  307. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Finished dispatching
  308. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Transformation has allocated a new step: [obtem_product_santri_id].0
  309. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - This transformation can be replayed with replay date: 2017/10/14 10:02:38
  310. 2017/10/14 10:02:38 - m_woo_transfereorcamentos_v5 - Initialising 14 steps...
  311. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Released server socket on port 0
  312. 2017/10/14 10:02:38 - Marchio-Woo - New database connection defined
  313. 2017/10/14 10:02:38 - desnormaliza_pedidos.0 - Released server socket on port 0
  314. 2017/10/14 10:02:38 - adiciona_constantes 2.0 - Released server socket on port 0
  315. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Released server socket on port 0
  316. 2017/10/14 10:02:38 - Marchio-Woo - New database connection defined
  317. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Released server socket on port 0
  318. 2017/10/14 10:02:38 - M-WebData - New database connection defined
  319. 2017/10/14 10:02:38 - insere_orcamentos 2.0 - Released server socket on port 0
  320. 2017/10/14 10:02:38 - M-Prod - New database connection defined
  321. 2017/10/14 10:02:38 - Block this step until steps finish 2.0 - Released server socket on port 0
  322. 2017/10/14 10:02:38 - finaliza_pedido 2.0 - Released server socket on port 0
  323. 2017/10/14 10:02:38 - M-Prod - New database connection defined
  324. 2017/10/14 10:02:38 - Calculator.0 - Released server socket on port 0
  325. 2017/10/14 10:02:38 - insere_itens.0 - Released server socket on port 0
  326. 2017/10/14 10:02:38 - Marchio-Woo - Auto commit off
  327. 2017/10/14 10:02:38 - M-Prod - New database connection defined
  328. 2017/10/14 10:02:38 - Obtem Itens.0 - Released server socket on port 0
  329. 2017/10/14 10:02:38 - obtem_user_santri_id.0 - Connected to database...
  330. 2017/10/14 10:02:38 - Marchio-Woo - New database connection defined
  331. 2017/10/14 10:02:38 - atualiza_ordens.0 - Released server socket on port 0
  332. 2017/10/14 10:02:38 - desnormaliza_itens.0 - Released server socket on port 0
  333. 2017/10/14 10:02:38 - Marchio-Woo - New database connection defined
  334. 2017/10/14 10:02:38 - Obtem Itens.0 - Connected to database...
  335. 2017/10/14 10:02:38 - Obtem Itens.0 - Prepare SQL statement : SELECT * FROM exp_orderitems
  336. 2017/10/14 10:02:38 - Obtem Itens.0 - where oi_order_id=?
  337. 2017/10/14 10:02:38 - Marchio-Woo - Auto commit on
  338. 2017/10/14 10:02:38 - M-WebData - Auto commit off
  339. 2017/10/14 10:02:38 - obtem_novas_ordens.0 - Connected to database...
  340. 2017/10/14 10:02:38 - Obtem Shipping Method.0 - Connected to database...
  341. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Released server socket on port 0
  342. 2017/10/14 10:02:38 - Marchio-Woo - New database connection defined
  343. 2017/10/14 10:02:38 - Marchio-Woo - Auto commit off
  344. 2017/10/14 10:02:38 - obtem_product_santri_id.0 - Connected to database...
  345. 2017/10/14 10:02:42 - insere_itens.0 - Connected to database...
  346. 2017/10/14 10:02:43 - finaliza_pedido 2.0 - Connected to database...
  347. 2017/10/14 10:02:45 - insere_orcamentos 2.0 - Connected to database...
  348. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [obtem_novas_ordens.0] initialized flawlessly.
  349. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [desnormaliza_pedidos.0] initialized flawlessly.
  350. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [adiciona_constantes 2.0] initialized flawlessly.
  351. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [obtem_user_santri_id.0] initialized flawlessly.
  352. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [Obtem Shipping Method.0] initialized flawlessly.
  353. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [insere_orcamentos 2.0] initialized flawlessly.
  354. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [Block this step until steps finish 2.0] initialized flawlessly.
  355. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [finaliza_pedido 2.0] initialized flawlessly.
  356. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [Calculator.0] initialized flawlessly.
  357. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [insere_itens.0] initialized flawlessly.
  358. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [Obtem Itens.0] initialized flawlessly.
  359. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [desnormaliza_itens.0] initialized flawlessly.
  360. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [atualiza_ordens.0] initialized flawlessly.
  361. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Step [obtem_product_santri_id.0] initialized flawlessly.
  362. 2017/10/14 10:02:45 - desnormaliza_pedidos.0 - Starting to run...
  363. 2017/10/14 10:02:45 - adiciona_constantes 2.0 - Starting to run...
  364. 2017/10/14 10:02:45 - insere_orcamentos 2.0 - Starting to run...
  365. 2017/10/14 10:02:45 - Block this step until steps finish 2.0 - Starting to run...
  366. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Starting to run...
  367. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Starting to run...
  368. 2017/10/14 10:02:45 - obtem_novas_ordens.0 - Starting to run...
  369. 2017/10/14 10:02:45 - finaliza_pedido 2.0 - Starting to run...
  370. 2017/10/14 10:02:45 - insere_itens.0 - Starting to run...
  371. 2017/10/14 10:02:45 - desnormaliza_itens.0 - Starting to run...
  372. 2017/10/14 10:02:45 - Calculator.0 - Starting to run...
  373. 2017/10/14 10:02:45 - m_woo_transfereorcamentos_v5 - Transformation has allocated 14 threads and 13 rowsets.
  374. 2017/10/14 10:02:45 - obtem_product_santri_id.0 - Starting to run...
  375. 2017/10/14 10:02:45 - atualiza_ordens.0 - Starting to run...
  376. 2017/10/14 10:02:45 - Obtem Itens.0 - Starting to run...
  377. 2017/10/14 10:02:45 - obtem_novas_ordens.0 - SQL query : select * FROM exp_orders
  378. 2017/10/14 10:02:45 - obtem_novas_ordens.0 - Signaling 'output done' to 1 output rowsets.
  379. 2017/10/14 10:02:45 - obtem_novas_ordens.0 - Finished reading query, closing connection.
  380. 2017/10/14 10:02:45 - Marchio-Woo - Connection to database closed!
  381. 2017/10/14 10:02:45 - obtem_novas_ordens.0 - Finished processing (I=62, O=0, R=0, W=62, U=0, E=0)
  382. 2017/10/14 10:02:45 - desnormaliza_pedidos.0 - Signaling 'output done' to 1 output rowsets.
  383. 2017/10/14 10:02:45 - desnormaliza_pedidos.0 - Finished processing (I=0, O=0, R=62, W=1, U=0, E=0)
  384. 2017/10/14 10:02:45 - adiciona_constantes 2.0 - Wrote row 1 : [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT]
  385. 2017/10/14 10:02:45 - Marchio-Woo - Setting preparedStatement to [SELECT meta_value AS user_santri_id FROM wp_usermeta WHERE user_id = ? AND meta_key = ? ]
  386. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Checking row: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], ['']
  387. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Field [_order_user_id] has nr. 1
  388. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Field [user_santri_id_metakey] has nr. 15
  389. 2017/10/14 10:02:45 - adiciona_constantes 2.0 - Signaling 'output done' to 1 output rowsets.
  390. 2017/10/14 10:02:45 - adiciona_constantes 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  391. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Got row from previous step: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], ['']
  392. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Added 2 values to lookup row: [ 71.0], [_user_santri_id]
  393. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Found result after database lookup: [[B@39aa6e6c, null, null, null, null, null, null, null, null, null, null]
  394. 2017/10/14 10:02:45 - M-WebData - Setting preparedStatement to [SELECT order_item_santri_code, order_item_santri_eta, order_delivery_date FROM exp_shipping_methods WHERE order_id = ? ]
  395. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Checking row: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], [''], [64542]
  396. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Field [post_id] has nr. 0
  397. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Got row from previous step: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], [''], [64542]
  398. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Added 1 values to lookup row: [201000]
  399. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Found result after database lookup: [[B@ee0376c, 0, [B@22569b15, null, null, null, null, null, null, null, null, null, null]
  400. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Wrote row to next step: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], [''], [64542]
  401. 2017/10/14 10:02:45 - M-Prod - DBA setting callableStatement to [{ call INSERIR_PEDIDO_WEB ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]
  402. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Wrote row to next step: [201000], [71], [037.467.881-29], [509.7], [24.3], [Rua general Osório], [Alto Araguaia], [Centro], [749], [78780-000], [MT], [], [0], [_order_santri_id], [billing_cpf], [_user_santri_id], [1], [1], [11], [WEB], [''], [''], [0], [157], [104], ['']
  403. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Signaling 'output done' to 1 output rowsets.
  404. 2017/10/14 10:02:45 - Marchio-Woo - Commit on database connection [Marchio-Woo]
  405. 2017/10/14 10:02:45 - Marchio-Woo - Connection to database closed!
  406. 2017/10/14 10:02:45 - obtem_user_santri_id.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  407. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Signaling 'output done' to 1 output rowsets.
  408. 2017/10/14 10:02:45 - M-WebData - Commit on database connection [M-WebData]
  409. 2017/10/14 10:02:45 - M-WebData - Connection to database closed!
  410. 2017/10/14 10:02:45 - Obtem Shipping Method.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  411. 2017/10/14 10:02:47 - insere_orcamentos 2.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:
  412. 2017/10/14 10:02:47 - insere_orcamentos 2.0 - Unable to call procedure
  413. 2017/10/14 10:02:47 - insere_orcamentos 2.0 - ORA-01861: literal does not match format string
  414. 2017/10/14 10:02:47 - insere_orcamentos 2.0 - ORA-06512: at line 1
  415. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  416. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  417. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  418. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  419. 2017/10/14 10:02:47 - M-WebData - Statement canceled!
  420. 2017/10/14 10:02:47 - M-WebData - Statement canceled!
  421. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  422. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  423. 2017/10/14 10:02:47 - Marchio-Woo - Statement canceled!
  424. 2017/10/14 10:02:47 - insere_orcamentos 2.0 - Signaling 'output done' to 1 output rowsets.
  425. 2017/10/14 10:02:47 - Obtem Itens.0 - Signaling 'output done' to 1 output rowsets.
  426. 2017/10/14 10:02:47 - obtem_product_santri_id.0 - Signaling 'output done' to 1 output rowsets.
  427. 2017/10/14 10:02:47 - Block this step until steps finish 2.0 - Stopped looking for more rows.
  428. 2017/10/14 10:02:47 - Calculator.0 - Signaling 'output done' to 1 output rowsets.
  429. 2017/10/14 10:02:47 - Calculator.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  430. 2017/10/14 10:02:47 - insere_itens.0 - Signaling 'output done' to 0 output rowsets.
  431. 2017/10/14 10:02:47 - desnormaliza_itens.0 - Signaling 'output done' to 1 output rowsets.
  432. 2017/10/14 10:02:47 - desnormaliza_itens.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  433. 2017/10/14 10:02:47 - finaliza_pedido 2.0 - Signaling 'output done' to 0 output rowsets.
  434. 2017/10/14 10:02:47 - atualiza_ordens.0 - Signaling 'output done' to 2 output rowsets.
  435. 2017/10/14 10:02:47 - Marchio-Woo - Connection to database closed!
  436. 2017/10/14 10:02:47 - Block this step until steps finish 2.0 - Signaling 'output done' to 1 output rowsets.
  437. 2017/10/14 10:02:47 - Marchio-Woo - Commit on database connection [Marchio-Woo]
  438. 2017/10/14 10:02:47 - Block this step until steps finish 2.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  439. 2017/10/14 10:02:47 - Obtem Itens.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  440. 2017/10/14 10:02:47 - Marchio-Woo - Connection to database closed!
  441. 2017/10/14 10:02:47 - atualiza_ordens.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  442. 2017/10/14 10:02:47 - Marchio-Woo - Connection to database closed!
  443. 2017/10/14 10:02:47 - obtem_product_santri_id.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  444. 2017/10/14 10:02:47 - M-Prod - Connection to database closed!
  445. 2017/10/14 10:02:47 - insere_orcamentos 2.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
  446. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Transformation detected one or more steps with errors.
  447. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Transformation is killing the other steps!
  448. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: obtem_novas_ordens
  449. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: desnormaliza_pedidos
  450. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: adiciona_constantes 2
  451. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: obtem_user_santri_id
  452. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: Obtem Shipping Method
  453. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: insere_orcamentos 2
  454. 2017/10/14 10:02:47 - m_woo_transfereorcamentos_v5 - Looking at step: Block this step until steps finish 2
  455. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: finaliza_pedido 2
  456. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: Calculator
  457. 2017/10/14 10:02:48 - M-Prod - Connection to database closed!
  458. 2017/10/14 10:02:48 - insere_itens.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  459. 2017/10/14 10:02:48 - M-Prod - Connection to database closed!
  460. 2017/10/14 10:02:48 - finaliza_pedido 2.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
  461. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: insere_itens
  462. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: Obtem Itens
  463. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: desnormaliza_itens
  464. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: atualiza_ordens
  465. 2017/10/14 10:02:48 - m_woo_transfereorcamentos_v5 - Looking at step: obtem_product_santri_id
  466. 2017/10/14 10:02:48 - Pan - Finished!
  467. 2017/10/14 10:02:48 - Pan - Start=2017/10/14 10:02:37.077, Stop=2017/10/14 10:02:48.159
  468. 2017/10/14 10:02:48 - Pan - Processing ended after 11 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!