API tools faq
paste
Fanadia_Friska

log jms client

Fanadia_Friska
May 6th, 2021
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.66 KB | None | 0 0
raw download clone embed print report
  1. 2021-05-06 13:17:00.098 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_invoice_ap","processNo":"34_PPAPI-MF/2105/000004","tenantId":10,"schema":"devmemeflorist"}
  2. 2021-05-06 13:17:05.213 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  3. 2021-05-06 13:18:15.259 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_payment_order_ap","processNo":"19_POAP-MF/2105/000007","tenantId":10,"schema":"devmemeflorist"}
  4. 2021-05-06 13:18:15.857 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  5. 2021-05-06 13:19:25.759 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"cb_submit_cb_out","processNo":"33_CBO-MF/2105/000007","tenantId":10,"schema":"devmemeflorist"}
  6. 2021-05-06 13:19:26.201 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  7. 2021-05-06 13:28:37.855 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_receive_goods","processNo":"32_RG-MF/2105/000005","tenantId":10,"schema":"devmemeflorist"}
  8. 2021-05-06 13:28:39.862 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  9. 2021-05-06 13:29:58.789 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_purch_invoice","processNo":"20_BMEG21.05.0007","tenantId":10,"schema":"devmemeflorist"}
  10. 2021-05-06 13:29:59.659 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  11. 2021-05-06 13:30:35.210 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_payment_order_ap","processNo":"20_POAP-MF/2105/000008","tenantId":10,"schema":"devmemeflorist"}
  12. 2021-05-06 13:30:35.310 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  13. 2021-05-06 13:42:35.492 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_submit_sales_quotation","processNo":"53_MEL-SQ21.05.0002","tenantId":10,"schema":"devmemeflorist"}
  14. 2021-05-06 13:42:35.886 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  15. 2021-05-06 13:45:56.612 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_submit_so","processNo":"42_MEL-SO21.05.0001","tenantId":10,"schema":"devmemeflorist"}
  16. 2021-05-06 13:45:56.942 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  17. 2021-05-06 13:46:30.472 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_cancel_submit_so","processNo":"3ae63519-3495-4f06-afe0-b5877a4e2f06","tenantId":10,"schema":"devmemeflorist"}
  18. 2021-05-06 13:46:30.627 INFO 1 --- [enerContainer-1] o.j.j.c.consumer.CancelApproveConsumer : BEGIN processing cancel queue sl_cancel_submit_so
  19. 2021-05-06 13:48:45.115 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_submit_so","processNo":"42_MEL-SO21.05.0001","tenantId":10,"schema":"devmemeflorist"}
  20. 2021-05-06 13:48:46.584 ERROR 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : ERROR EXCEPTION : executeQueue
  21.  
  22. org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; ERROR: duplicate key value violates unique constraint "sl_so_status_pkey"
  23. Detail: Key (so_id)=(42) already exists.
  24. Where: SQL statement "INSERT INTO sl_so_status
  25. (so_id, tenant_id, ou_id, doc_no, doc_date, partner_id, status_picking,
  26. version, create_datetime, create_user_id, update_datetime, update_user_id)
  27. SELECT A.so_id, A.tenant_id, A.ou_id, A.doc_no, A.doc_date, A.partner_id, vStatusPickingNo,
  28. 0, vDatetime, vUserId, vDatetime, vUserId
  29. FROM sl_so A
  30. WHERE A.so_id = vSoId"
  31. PL/pgSQL function sl_submit_so(bigint,character varying,character varying) line 120 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sl_so_status_pkey"
  32. Detail: Key (so_id)=(42) already exists.
  33. Where: SQL statement "INSERT INTO sl_so_status
  34. (so_id, tenant_id, ou_id, doc_no, doc_date, partner_id, status_picking,
  35. version, create_datetime, create_user_id, update_datetime, update_user_id)
  36. SELECT A.so_id, A.tenant_id, A.ou_id, A.doc_no, A.doc_date, A.partner_id, vStatusPickingNo,
  37. 0, vDatetime, vUserId, vDatetime, vUserId
  38. FROM sl_so A
  39. WHERE A.so_id = vSoId"
  40. PL/pgSQL function sl_submit_so(bigint,character varying,character varying) line 120 at SQL statement
  41. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:242) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  42. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  43. at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  44. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  45. at org.jleaf.jmsclient.core.bo.FunctionSubmitExecutor.process(FunctionSubmitExecutor.java:75) ~[jms-client-core-4.0.0.jar!/:na]
  46. at org.jleaf.core.AbstractBusinessTransaction.execute(AbstractBusinessTransaction.java:41) ~[jleaf-core-4.0.0.jar!/:na]
  47. at org.jleaf.core.DefaultBusinessTransaction.execute(DefaultBusinessTransaction.java:46) ~[jleaf-core-4.0.0.jar!/:na]
  48. at org.jleaf.core.DefaultBusinessTransaction$$FastClassBySpringCGLIB$$7c40641c.invoke(<generated>) ~[jleaf-core-4.0.0.jar!/:na]
  49. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  50. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  51. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  52. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295) ~[spring-tx-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  53. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  54. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  55. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  56. at org.jleaf.jmsclient.core.bo.FunctionSubmitExecutor$$EnhancerBySpringCGLIB$$9d732a7e.execute(<generated>) ~[jms-client-core-4.0.0.jar!/:na]
  57. at org.jleaf.jmsclient.core.consumer.ErpJleafFunctionConsumer.processExecuteQueue(ErpJleafFunctionConsumer.java:59) ~[jms-client-core-4.0.0.jar!/:na]
  58. at org.jleaf.jms.AbstractConsumer.executeQueue(AbstractConsumer.java:335) [jleaf-jms-4.0.0.jar!/:na]
  59. at org.jleaf.jms.AbstractConsumer.onMessage(AbstractConsumer.java:107) [jleaf-jms-4.0.0.jar!/:na]
  60. at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:761) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  61. at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:699) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  62. at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  63. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:318) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  64. at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:257) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  65. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1189) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  66. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1179) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  67. at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1076) [spring-jms-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  68. at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212]
  69. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sl_so_status_pkey"
  70. Detail: Key (so_id)=(42) already exists.
  71. Where: SQL statement "INSERT INTO sl_so_status
  72. (so_id, tenant_id, ou_id, doc_no, doc_date, partner_id, status_picking,
  73. version, create_datetime, create_user_id, update_datetime, update_user_id)
  74. SELECT A.so_id, A.tenant_id, A.ou_id, A.doc_no, A.doc_date, A.partner_id, vStatusPickingNo,
  75. 0, vDatetime, vUserId, vDatetime, vUserId
  76. FROM sl_so A
  77. WHERE A.so_id = vSoId"
  78. PL/pgSQL function sl_submit_so(bigint,character varying,character varying) line 120 at SQL statement
  79. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468) ~[postgresql-42.2.6.jar!/:42.2.6]
  80. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211) ~[postgresql-42.2.6.jar!/:42.2.6]
  81. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:309) ~[postgresql-42.2.6.jar!/:42.2.6]
  82. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) ~[postgresql-42.2.6.jar!/:42.2.6]
  83. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) ~[postgresql-42.2.6.jar!/:42.2.6]
  84. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:149) ~[postgresql-42.2.6.jar!/:42.2.6]
  85. at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:138) ~[postgresql-42.2.6.jar!/:42.2.6]
  86. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.2.jar!/:na]
  87. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar!/:na]
  88. at org.jleaf.jmsclient.core.bo.FunctionSubmitExecutor$2.doInPreparedStatement(FunctionSubmitExecutor.java:69) ~[jms-client-core-4.0.0.jar!/:na]
  89. at org.jleaf.jmsclient.core.bo.FunctionSubmitExecutor$2.doInPreparedStatement(FunctionSubmitExecutor.java:66) ~[jms-client-core-4.0.0.jar!/:na]
  90. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616) ~[spring-jdbc-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
  91. ... 24 common frames omitted
  92.  
  93. 2021-05-06 13:57:43.722 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_submit_so","processNo":"43_MEG-SO21.05.0008","tenantId":10,"schema":"devmemeflorist"}
  94. 2021-05-06 13:57:43.775 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  95. 2021-05-06 14:03:37.900 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"sl_submit_so","processNo":"44_MEL-SO21.05.0002","tenantId":10,"schema":"devmemeflorist"}
  96. 2021-05-06 14:03:37.979 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  97. 2021-05-06 14:14:29.625 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_po","processNo":"46_PO-MF/2105/000004","tenantId":10,"schema":"devmemeflorist"}
  98. 2021-05-06 14:14:30.034 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  99. 2021-05-06 14:15:19.871 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_invoice_ap","processNo":"35_PPAP-MF/2105/000001","tenantId":10,"schema":"devmemeflorist"}
  100. 2021-05-06 14:15:20.108 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  101. 2021-05-06 14:16:03.947 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_payment_order_ap","processNo":"21_POAP-MF/2105/000009","tenantId":10,"schema":"devmemeflorist"}
  102. 2021-05-06 14:16:03.987 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  103. 2021-05-06 14:16:46.430 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"cb_submit_cb_out","processNo":"34_CBO-MF/2105/000008","tenantId":10,"schema":"devmemeflorist"}
  104. 2021-05-06 14:16:46.474 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  105. 2021-05-06 14:17:23.814 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_receive_goods","processNo":"33_RG-MF/2105/000006","tenantId":10,"schema":"devmemeflorist"}
  106. 2021-05-06 14:17:24.512 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  107. 2021-05-06 14:19:04.958 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_purch_invoice","processNo":"21_BMEL21.05.0001","tenantId":10,"schema":"devmemeflorist"}
  108. 2021-05-06 14:19:05.181 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  109. 2021-05-06 14:20:07.419 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_payment_order_ap","processNo":"22_POAP-MF/2105/000010","tenantId":10,"schema":"devmemeflorist"}
  110. 2021-05-06 14:20:07.532 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  111. 2021-05-06 14:25:32.735 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_invoice_ap","processNo":"36_CNAP-MF/2105/000001","tenantId":10,"schema":"devmemeflorist"}
  112. 2021-05-06 14:25:33.089 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  113. 2021-05-06 14:26:18.161 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_payment_order_ap","processNo":"23_POAP-MF/2105/000011","tenantId":10,"schema":"devmemeflorist"}
  114. 2021-05-06 14:26:18.184 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  115. 2021-05-06 14:30:59.967 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"fi_submit_invoice_ap","processNo":"37_DNAP-MF/2105/000001","tenantId":10,"schema":"devmemeflorist"}
  116. 2021-05-06 14:31:00.280 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  117. 2021-05-06 15:31:53.942 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_po","processNo":"12_PO/2105/00002","tenantId":10,"schema":"devfreenonpkp"}
  118. 2021-05-06 15:31:54.280 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  119. 2021-05-06 16:59:09.308 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_po","processNo":"13_PO/2105/00003","tenantId":10,"schema":"devfreenonpkp"}
  120. 2021-05-06 16:59:09.469 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  121. 2021-05-06 17:02:29.102 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_po","processNo":"78_PO-JRP/2105/000001","tenantId":10,"schema":"devjrp"}
  122. 2021-05-06 17:02:29.416 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  123. 2021-05-06 17:05:53.403 INFO 1 --- [enerContainer-1] org.jleaf.jms.AbstractConsumer : Received TextMessage : {"processName":"pu_submit_po","processNo":"132_HPO-2105/000001","tenantId":10,"schema":"devjenindo"}
  124. 2021-05-06 17:05:54.332 INFO 1 --- [enerContainer-1] o.j.j.c.c.ErpJleafFunctionConsumer : END processing queue
  125.  
  126.  
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!