API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 13th, 2017
107
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 20.98 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_v5a -level=Debug
  2. 10:28:45,037 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:28:45,038 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
  10. Oct 13, 2017 10:28:46 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
  11. INFO: Lock acquired. Setting startlevel to 100
  12. 2017/10/13 10:28:48 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
  13. Oct 13, 2017 10:28:52 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/13 10:28:55 - Pan - Logging is at level : Debug
  21. Arguments:
  22. rep          : indexis_rep
  23. user         : repository
  24. pass         : U7366U53Vd
  25. trans        : m_woo_transfereorcamentos_v5a
  26. dir          :
  27. file         :
  28. level        : Debug
  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/13 10:28:55 - Pan - Start of run.
  45. 2017/10/13 10:28:55 - Pan - Allocate new transformation.
  46. 2017/10/13 10:28:55 - Pan - Starting to look at options...
  47. 2017/10/13 10:28:55 - Pan - Parsing command line options.
  48. 2017/10/13 10:28:55 - Pan - Loading available repositories.
  49. 2017/10/13 10:28:55 - RepositoriesMeta - No repositories file found in the local directory: /root/pentaho/data-integration/repositories.xml
  50. 2017/10/13 10:28:55 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
  51. 2017/10/13 10:28:55 - RepositoriesMeta - We have 2 connections...
  52. 2017/10/13 10:28:55 - RepositoriesMeta - Looking at connection #0
  53. 2017/10/13 10:28:55 - RepositoriesMeta - Read at connection: Local Repository Marchio
  54. 2017/10/13 10:28:55 - RepositoriesMeta - Looking at connection #1
  55. 2017/10/13 10:28:55 - RepositoriesMeta - Read at connection: indexis_rep
  56. 2017/10/13 10:28:55 - RepositoriesMeta - We have 2 repositories...
  57. 2017/10/13 10:28:55 - RepositoriesMeta - Looking at repository #0
  58. 2017/10/13 10:28:55 - RepositoriesMeta - Read at repository: mar_rep
  59. 2017/10/13 10:28:55 - RepositoriesMeta - Looking at repository #1
  60. 2017/10/13 10:28:55 - RepositoriesMeta - Read at repository: indexis_rep
  61. 2017/10/13 10:28:55 - Pan - Finding repository [indexis_rep]
  62. 2017/10/13 10:28:55 - Pan - Allocate & connect to repository.
  63. Fri Oct 13 10:28:55 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/13 10:28:56 - Pan - Check supplied username and password.
  65. 2017/10/13 10:28:56 - Pan - Load the transformation info...
  66. 2017/10/13 10:28:56 - indexis_rep - Looking for the transformation [m_woo_transfereorcamentos_v5a] in directory [/]
  67. 2017/10/13 10:28:56 - indexis_rep - Loading transformation [m_woo_transfereorcamentos_v5a] from repository...
  68. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 458
  69. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 459
  70. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 460
  71. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 461
  72. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 462
  73. 2017/10/13 10:28:56 - indexis_rep - Loading step with ID: 463
  74. 2017/10/13 10:28:56 - indexis_rep - ID_DIRECTORY=0
  75. 2017/10/13 10:28:56 - indexis_rep - Loaded the transformation [m_woo_transfereorcamentos_v5a] , directory == null : false
  76. 2017/10/13 10:28:56 - indexis_rep - Loaded the transformation [m_woo_transfereorcamentos_v5a] in directory /
  77. 2017/10/13 10:28:56 - Pan - Allocate transformation...
  78. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Dispatching started for transformation [m_woo_transfereorcamentos_v5a]
  79. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Nr of arguments detected:0
  80. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - This is not a replay transformation
  81. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - I found 6 different steps to launch.
  82. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Allocating rowsets...
  83. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 0 --> obtem_novas_ordens
  84. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   prevcopies = 1, nextcopies=1
  85. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation allocated new rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  86. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 1 rowsets for step 0 --> obtem_novas_ordens
  87. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 1 --> desnormaliza_pedidos
  88. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   prevcopies = 1, nextcopies=1
  89. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation allocated new rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  90. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 2 rowsets for step 1 --> desnormaliza_pedidos
  91. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 2 --> adiciona_constantes 2
  92. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   prevcopies = 1, nextcopies=1
  93. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation allocated new rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  94. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 3 rowsets for step 2 --> adiciona_constantes 2
  95. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 3 --> obtem_user_santri_id
  96. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   prevcopies = 1, nextcopies=1
  97. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation allocated new rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  98. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 4 rowsets for step 3 --> obtem_user_santri_id
  99. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 4 --> Obtem Shipping Method
  100. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   prevcopies = 1, nextcopies=1
  101. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation allocated new rowset [Obtem Shipping Method.0 - Text file output.0]
  102. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 5 rowsets for step 4 --> Obtem Shipping Method
  103. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocating rowsets for step 5 --> Text file output
  104. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Allocated 5 rowsets for step 5 --> Text file output
  105. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Allocating Steps & StepData...
  106. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [obtem_novas_ordens] of type [TableInput]
  107. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  108. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - distribution de-activated
  109. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Starting allocation of buffers & new threads...
  110. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Step info: nrinput=0 nroutput=1
  111. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - output rel. is  1:1
  112. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Found output rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  113. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Finished dispatching
  114. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [obtem_novas_ordens].0
  115. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [desnormaliza_pedidos] of type [Denormaliser]
  116. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  117. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - distribution de-activated
  118. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Starting allocation of buffers & new threads...
  119. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Step info: nrinput=1 nroutput=1
  120. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Got previous step from [desnormaliza_pedidos] #0 --> obtem_novas_ordens
  121. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - input rel is 1:1
  122. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Found input rowset [obtem_novas_ordens.0 - desnormaliza_pedidos.0]
  123. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - output rel. is  1:1
  124. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Found output rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  125. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Finished dispatching
  126. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [desnormaliza_pedidos].0
  127. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [adiciona_constantes 2] of type [Constant]
  128. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  129. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - distribution de-activated
  130. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Starting allocation of buffers & new threads...
  131. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Step info: nrinput=1 nroutput=1
  132. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Got previous step from [adiciona_constantes 2] #0 --> desnormaliza_pedidos
  133. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - input rel is 1:1
  134. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Found input rowset [desnormaliza_pedidos.0 - adiciona_constantes 2.0]
  135. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - output rel. is  1:1
  136. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Found output rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  137. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Finished dispatching
  138. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [adiciona_constantes 2].0
  139. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [obtem_user_santri_id] of type [DBLookup]
  140. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  141. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - distribution activated
  142. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Starting allocation of buffers & new threads...
  143. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Step info: nrinput=1 nroutput=1
  144. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Got previous step from [obtem_user_santri_id] #0 --> adiciona_constantes 2
  145. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - input rel is 1:1
  146. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Found input rowset [adiciona_constantes 2.0 - obtem_user_santri_id.0]
  147. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - output rel. is  1:1
  148. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Found output rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  149. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Finished dispatching
  150. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [obtem_user_santri_id].0
  151. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [Obtem Shipping Method] of type [DBLookup]
  152. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  153. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - distribution de-activated
  154. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Starting allocation of buffers & new threads...
  155. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Step info: nrinput=1 nroutput=1
  156. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Got previous step from [Obtem Shipping Method] #0 --> obtem_user_santri_id
  157. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - input rel is 1:1
  158. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Found input rowset [obtem_user_santri_id.0 - Obtem Shipping Method.0]
  159. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - output rel. is  1:1
  160. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Found output rowset [Obtem Shipping Method.0 - Text file output.0]
  161. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Finished dispatching
  162. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [Obtem Shipping Method].0
  163. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation is about to allocate step [Text file output] of type [TextFileOutput]
  164. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -   Step has nrcopies=1
  165. 2017/10/13 10:28:56 - Text file output.0 - distribution activated
  166. 2017/10/13 10:28:56 - Text file output.0 - Starting allocation of buffers & new threads...
  167. 2017/10/13 10:28:56 - Text file output.0 - Step info: nrinput=1 nroutput=0
  168. 2017/10/13 10:28:56 - Text file output.0 - Got previous step from [Text file output] #0 --> Obtem Shipping Method
  169. 2017/10/13 10:28:56 - Text file output.0 - input rel is 1:1
  170. 2017/10/13 10:28:56 - Text file output.0 - Found input rowset [Obtem Shipping Method.0 - Text file output.0]
  171. 2017/10/13 10:28:56 - Text file output.0 - Finished dispatching
  172. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -  Transformation has allocated a new step: [Text file output].0
  173. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - This transformation can be replayed with replay date: 2017/10/13 10:28:56
  174. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Initialising 6 steps...
  175. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Released server socket on port 0
  176. 2017/10/13 10:28:56 - Marchio-Woo - New database connection defined
  177. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Released server socket on port 0
  178. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Released server socket on port 0
  179. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Released server socket on port 0
  180. 2017/10/13 10:28:56 - Marchio-Woo - New database connection defined
  181. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Connected to database...
  182. 2017/10/13 10:28:56 - Text file output.0 - Released server socket on port 0
  183. 2017/10/13 10:28:56 - Text file output.0 - Parent folder exists [file:///root/pentaho/data-integration]!
  184. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Released server socket on port 0
  185. 2017/10/13 10:28:56 - M-WebData - New database connection defined
  186. 2017/10/13 10:28:56 - Text file output.0 - Opening output stream using provider: None
  187. 2017/10/13 10:28:56 - Text file output.0 - Opening output stream in default encoding
  188. 2017/10/13 10:28:56 - Text file output.0 - Opened new file with name [file:///root/pentaho/data-integration/orc5a.txt]
  189. 2017/10/13 10:28:56 - Marchio-Woo - Auto commit off
  190. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Connected to database...
  191. 2017/10/13 10:28:56 - M-WebData - Auto commit off
  192. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Connected to database...
  193. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [obtem_novas_ordens.0] initialized flawlessly.
  194. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [desnormaliza_pedidos.0] initialized flawlessly.
  195. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [adiciona_constantes 2.0] initialized flawlessly.
  196. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [obtem_user_santri_id.0] initialized flawlessly.
  197. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [Obtem Shipping Method.0] initialized flawlessly.
  198. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step [Text file output.0] initialized flawlessly.
  199. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Starting to run...
  200. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - SQL query : select * FROM exp_orders
  201. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Starting to run...
  202. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Starting to run...
  203. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Starting to run...
  204. 2017/10/13 10:28:56 - Text file output.0 - Starting to run...
  205. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Transformation has allocated 6 threads and 5 rowsets.
  206. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Starting to run...
  207. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Signaling 'output done' to 1 output rowsets.
  208. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Finished reading query, closing connection.
  209. 2017/10/13 10:28:56 - Marchio-Woo - Connection to database closed!
  210. 2017/10/13 10:28:56 - obtem_novas_ordens.0 - Finished processing (I=62, O=0, R=0, W=62, U=0, E=0)
  211. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Signaling 'output done' to 1 output rowsets.
  212. 2017/10/13 10:28:56 - desnormaliza_pedidos.0 - Finished processing (I=0, O=0, R=62, W=1, U=0, E=0)
  213. 2017/10/13 10:28:56 - Marchio-Woo - Setting preparedStatement to [SELECT meta_value AS user_santri_id FROM wp_usermeta WHERE user_id = ?  AND meta_key = ? ]
  214. 2017/10/13 10:28:56 - 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], ['']
  215. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Signaling 'output done' to 1 output rowsets.
  216. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Field [_order_user_id] has nr. 1
  217. 2017/10/13 10:28:56 - adiciona_constantes 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
  218. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Field [user_santri_id_metakey] has nr. 15
  219. 2017/10/13 10:28:56 - M-WebData - Setting preparedStatement to [SELECT order_item_santri_code, order_item_santri_eta, order_delivery_date FROM exp_shipping_methods WHERE order_id = ? ]
  220. 2017/10/13 10:28:56 - 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]
  221. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Field [post_id] has nr. 0
  222. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Signaling 'output done' to 1 output rowsets.
  223. 2017/10/13 10:28:56 - Marchio-Woo - Commit on database connection [Marchio-Woo]
  224. 2017/10/13 10:28:56 - Marchio-Woo - Connection to database closed!
  225. 2017/10/13 10:28:56 - obtem_user_santri_id.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  226. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Signaling 'output done' to 1 output rowsets.
  227. 2017/10/13 10:28:56 - M-WebData - Commit on database connection [M-WebData]
  228. 2017/10/13 10:28:56 - M-WebData - Connection to database closed!
  229. 2017/10/13 10:28:56 - Obtem Shipping Method.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0)
  230. 2017/10/13 10:28:56 - Text file output.0 - Signaling 'output done' to 0 output rowsets.
  231. 2017/10/13 10:28:56 - Text file output.0 - Closing normal file ...
  232. 2017/10/13 10:28:56 - Text file output.0 - Finished processing (I=0, O=2, R=1, W=1, U=0, E=0)
  233. 2017/10/13 10:28:56 - Pan - Finished!
  234. 2017/10/13 10:28:56 - Pan - Start=2017/10/13 10:28:55.448, Stop=2017/10/13 10:28:56.725
  235. 2017/10/13 10:28:56 - Pan - Processing ended after 1 seconds.
  236. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a -
  237. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step obtem_novas_ordens.0 ended successfully, processed 62 lines. ( 62 lines/s)
  238. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step desnormaliza_pedidos.0 ended successfully, processed 62 lines. ( 62 lines/s)
  239. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step adiciona_constantes 2.0 ended successfully, processed 1 lines. ( 1 lines/s)
  240. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step obtem_user_santri_id.0 ended successfully, processed 1 lines. ( 1 lines/s)
  241. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step Obtem Shipping Method.0 ended successfully, processed 1 lines. ( 1 lines/s)
  242. 2017/10/13 10:28:56 - m_woo_transfereorcamentos_v5a - Step Text file output.0 ended successfully, processed 1 lines. ( 1 lines/s)
  243. root@Marchio:~/pentaho/data-integration#
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!