API tools faq
paste
Advertisement
ariswb22

ExampleTriggers-SCM

ariswb22
Feb 19th, 2020
287
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 9.35 KB | None | 0 0
raw download clone embed print report
  1. Hosting environment: empyrean
  2. Content root path: /home/ClientMandiriTrigger
  3. Now listening on: http://[::]:5797
  4. Application started. Press Ctrl+C to shut down.
  5. [2020-02-19 09:41:33.902 Verbose] No triggers to be processed
  6. [2020-02-19 09:41:33.920 Verbose] TriggerExecutor sleeping for 300000 ms
  7. [2020-02-19 09:42:13.368 Information] Incoming request for Trigger creation for source system [SCM]
  8. [2020-02-19 09:42:13.514 Information] Creating trigger for source system SCM
  9. [2020-02-19 09:46:33.965 Verbose] Checking audit trail for source: SCM and reporting date: 20200218
  10. [2020-02-19 09:46:34.085 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  11. SELECT
  12. j.job_group_id,
  13. ji.job_invocation
  14. bmdwhaud.audit_trail_mst_job j
  15. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  16. WHERE
  17. 1 = 1
  18. AND j.target_table = :tableName
  19. AND j.job_phase = 'SRC'
  20. )
  21. [2020-02-19 09:46:34.085 Verbose] With parameter tableName: CUSTOMER
  22. [2020-02-19 09:46:45.346 Verbose] mstJobInvocationCount for table CUSTOMER : 1
  23. ------------------------------
  24. [2020-02-19 09:46:45.357 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  25. SELECT
  26. dtl.job_set_date,
  27. dtl.job_result,
  28. j.job_group_id,
  29. ji.job_invocation
  30. bmdwhaud.audit_trail_trn_dtl dtl
  31. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  32. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  33. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  34. WHERE
  35. 1 = 1
  36. AND dtl.job_set_date = :reportingDate
  37. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  38. AND j.target_table = :tableName
  39. AND j.job_phase = 'SRC'
  40. GROUP BY
  41. dtl.job_set_date,
  42. dtl.job_result,
  43. j.job_group_id,
  44. ji.job_invocation
  45. )
  46. [2020-02-19 09:46:45.357 Verbose] With parameter tableName: CUSTOMER, reportingDate: 20200218
  47. [2020-02-19 09:46:45.432 Verbose] trnDtlCount for table CUSTOMER : 1
  48. ------------------------------
  49. [2020-02-19 09:46:45.432 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  50. SELECT
  51. j.job_group_id,
  52. ji.job_invocation
  53. bmdwhaud.audit_trail_mst_job j
  54. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  55. WHERE
  56. 1 = 1
  57. AND j.target_table = :tableName
  58. AND j.job_phase = 'SRC'
  59. )
  60. [2020-02-19 09:46:45.432 Verbose] With parameter tableName: TCDA_COMPANY
  61. [2020-02-19 09:46:45.433 Verbose] mstJobInvocationCount for table TCDA_COMPANY : 1
  62. ------------------------------
  63. [2020-02-19 09:46:45.434 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  64. SELECT
  65. dtl.job_set_date,
  66. dtl.job_result,
  67. j.job_group_id,
  68. ji.job_invocation
  69. bmdwhaud.audit_trail_trn_dtl dtl
  70. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  71. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  72. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  73. WHERE
  74. 1 = 1
  75. AND dtl.job_set_date = :reportingDate
  76. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  77. AND j.target_table = :tableName
  78. AND j.job_phase = 'SRC'
  79. GROUP BY
  80. dtl.job_set_date,
  81. dtl.job_result,
  82. j.job_group_id,
  83. ji.job_invocation
  84. )
  85. [2020-02-19 09:46:45.434 Verbose] With parameter tableName: TCDA_COMPANY, reportingDate: 20200218
  86. [2020-02-19 09:46:45.435 Verbose] trnDtlCount for table TCDA_COMPANY : 1
  87. ------------------------------
  88. [2020-02-19 09:46:45.436 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  89. SELECT
  90. j.job_group_id,
  91. ji.job_invocation
  92. bmdwhaud.audit_trail_mst_job j
  93. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  94. WHERE
  95. 1 = 1
  96. AND j.target_table = :tableName
  97. AND j.job_phase = 'SRC'
  98. )
  99. [2020-02-19 09:46:45.436 Verbose] With parameter tableName: TCLS_LOAN
  100. [2020-02-19 09:46:45.437 Verbose] mstJobInvocationCount for table TCLS_LOAN : 1
  101. [2020-02-19 09:46:45.437 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  102. SELECT
  103. dtl.job_set_date,
  104. dtl.job_result,
  105. j.job_group_id,
  106. ji.job_invocation
  107. bmdwhaud.audit_trail_trn_dtl dtl
  108. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  109. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  110. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  111. WHERE
  112. 1 = 1
  113. AND dtl.job_set_date = :reportingDate
  114. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  115. AND j.target_table = :tableName
  116. AND j.job_phase = 'SRC'
  117. GROUP BY
  118. dtl.job_set_date,
  119. dtl.job_result,
  120. j.job_group_id,
  121. ji.job_invocation
  122. )
  123. [2020-02-19 09:46:45.437 Verbose] With parameter tableName: TCLS_LOAN, reportingDate: 20200218
  124. [2020-02-19 09:46:45.439 Verbose] trnDtlCount for table TCLS_LOAN : 1
  125. ------------------------------
  126. [2020-02-19 09:46:45.439 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  127. SELECT
  128. j.job_group_id,
  129. ji.job_invocation
  130. bmdwhaud.audit_trail_mst_job j
  131. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  132. WHERE
  133. 1 = 1
  134. AND j.target_table = :tableName
  135. AND j.job_phase = 'SRC'
  136. )
  137. [2020-02-19 09:46:45.439 Verbose] With parameter tableName: TCLS_LOANEXT
  138. [2020-02-19 09:46:45.440 Verbose] mstJobInvocationCount for table TCLS_LOANEXT : 1
  139. [2020-02-19 09:46:45.440 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  140. SELECT
  141. dtl.job_set_date,
  142. dtl.job_result,
  143. j.job_group_id,
  144. ji.job_invocation
  145. bmdwhaud.audit_trail_trn_dtl dtl
  146. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  147. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  148. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  149. WHERE
  150. 1 = 1
  151. AND dtl.job_set_date = :reportingDate
  152. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  153. AND j.target_table = :tableName
  154. AND j.job_phase = 'SRC'
  155. GROUP BY
  156. dtl.job_set_date,
  157. dtl.job_result,
  158. j.job_group_id,
  159. ji.job_invocation
  160. )
  161. [2020-02-19 09:46:45.440 Verbose] With parameter tableName: TCLS_LOANEXT, reportingDate: 20200218
  162. [2020-02-19 09:46:45.442 Verbose] trnDtlCount for table TCLS_LOANEXT : 1
  163. ------------------------------
  164. [2020-02-19 09:46:45.442 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  165. SELECT
  166. j.job_group_id,
  167. ji.job_invocation
  168. bmdwhaud.audit_trail_mst_job j
  169. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  170. WHERE
  171. 1 = 1
  172. AND j.target_table = :tableName
  173. AND j.job_phase = 'SRC'
  174. )
  175. [2020-02-19 09:46:45.442 Verbose] With parameter tableName: TCLS_LOANINTEREST
  176. [2020-02-19 09:46:45.443 Verbose] mstJobInvocationCount for table TCLS_LOANINTEREST : 1
  177. ------------------------------
  178. [2020-02-19 09:46:45.443 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  179. SELECT
  180. dtl.job_set_date,
  181. dtl.job_result,
  182. j.job_group_id,
  183. ji.job_invocation
  184. bmdwhaud.audit_trail_trn_dtl dtl
  185. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  186. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  187. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  188. WHERE
  189. 1 = 1
  190. AND dtl.job_set_date = :reportingDate
  191. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  192. AND j.target_table = :tableName
  193. AND j.job_phase = 'SRC'
  194. GROUP BY
  195. dtl.job_set_date,
  196. dtl.job_result,
  197. j.job_group_id,
  198. ji.job_invocation
  199. )
  200. [2020-02-19 09:46:45.443 Verbose] With parameter tableName: TCLS_LOANINTEREST, reportingDate: 20200218
  201. [2020-02-19 09:46:45.445 Verbose] trnDtlCount for table TCLS_LOANINTEREST : 1
  202. ------------------------------
  203. [2020-02-19 09:46:45.445 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  204. SELECT
  205. j.job_group_id,
  206. ji.job_invocation
  207. bmdwhaud.audit_trail_mst_job j
  208. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON j.job_code = ji.job_code
  209. WHERE
  210. 1 = 1
  211. AND j.target_table = :tableName
  212. AND j.job_phase = 'SRC'
  213. )
  214. [2020-02-19 09:46:45.445 Verbose] With parameter tableName: TRMS_LIMIT
  215. [2020-02-19 09:46:45.446 Verbose] mstJobInvocationCount for table TRMS_LIMIT : 1
  216. ------------------------------
  217. [2020-02-19 09:46:45.446 Verbose] Executing query: SELECT COUNT(*) RECORDCOUNT FROM (
  218. SELECT
  219. dtl.job_set_date,
  220. dtl.job_result,
  221. j.job_group_id,
  222. ji.job_invocation
  223. bmdwhaud.audit_trail_trn_dtl dtl
  224. INNER JOIN bmdwhaud.audit_trail_trn_hdr hdr ON dtl.job_code = hdr.job_code and dtl.job_set_date = hdr.job_set_date
  225. INNER JOIN bmdwhaud.audit_trail_mst_job j ON dtl.job_code = j.job_code
  226. INNER JOIN bmdwhaud.audit_trail_mst_job_invocation ji ON dtl.job_code = ji.job_code
  227. WHERE
  228. 1 = 1
  229. AND dtl.job_set_date = :reportingDate
  230. AND dtl.job_result = 'FINISHED' AND hdr.job_status = 'FINISHED'
  231. AND j.target_table = :tableName
  232. AND j.job_phase = 'SRC'
  233. GROUP BY
  234. dtl.job_set_date,
  235. dtl.job_result,
  236. j.job_group_id,
  237. ji.job_invocation
  238. )
  239. [2020-02-19 09:46:45.446 Verbose] With parameter tableName: TRMS_LIMIT, reportingDate: 20200218
  240. [2020-02-19 09:46:45.450 Verbose] trnDtlCount for table TRMS_LIMIT : 1
  241. ------------------------------
  242. [2020-02-19 09:46:45.450 Verbose] Data is  ready for source: SCM
  243. [2020-02-19 09:46:45.450 Information] Data ready for source system SCM
  244. [2020-02-19 09:46:45.478 Information] Calling extractor for source system SCM
  245. [2020-02-19 09:46:45.904 Information] Terminating trigger for source system SCM
  246. [2020-02-19 09:46:45.908 Verbose] TriggerExecutor sleeping for 300000 ms
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!