API tools faq
paste
ronaldkwandy

Untitled

ronaldkwandy
Sep 5th, 2019
313
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.48 KB | None | 0 0
raw download clone embed print report
  1. 2019-09-05 15:10:20,625 239073 [http-nio-8844-exec-6] DEBUG org.hibernate.SQL -
  2. select
  3. trxsurattu0_.id as id1_153_,
  4. trxsurattu0_.creation_time as creation2_153_,
  5. trxsurattu0_.modification_time as modifica3_153_,
  6. trxsurattu0_.user_create as user_cre4_153_,
  7. trxsurattu0_.user_modify as user_mod5_153_,
  8. trxsurattu0_.version as version6_153_,
  9. trxsurattu0_.hm_msy019_aprvl_log_id as hm_msy18_153_,
  10. trxsurattu0_.hm_msy012_trx_id as hm_msy19_153_,
  11. trxsurattu0_.trx_date as trx_date7_153_,
  12. trxsurattu0_.trx_number as trx_numb8_153_,
  13. trxsurattu0_.dapat_cuti_pengganti as dapat_cu9_153_,
  14. trxsurattu0_.full_day as full_da10_153_,
  15. trxsurattu0_.jam_akhir as jam_akh11_153_,
  16. trxsurattu0_.jam_awal as jam_awa12_153_,
  17. trxsurattu0_.jam_istirahat as jam_ist13_153_,
  18. trxsurattu0_.jam_lembur as jam_lem14_153_,
  19. trxsurattu0_.jam_non_lembur as jam_non15_153_,
  20. trxsurattu0_.hm_mat005_jenis_absensi_id as hm_mat20_153_,
  21. trxsurattu0_.tanggal_akhir as tanggal16_153_,
  22. trxsurattu0_.tanggal_awal as tanggal17_153_
  23. from
  24. hm_tat007 trxsurattu0_
  25. where
  26. (
  27. (
  28. ? is null
  29. )
  30. and (
  31. trxsurattu0_.hm_msy012_trx_id is null
  32. )
  33. or trxsurattu0_.hm_msy012_trx_id=?
  34. )
  35. and (
  36. (
  37. ? is null
  38. )
  39. and (
  40. trxsurattu0_.trx_number is null
  41. )
  42. or trxsurattu0_.trx_number=?
  43. )
  44. and (
  45. (
  46. ? is null
  47. )
  48. and (
  49. trxsurattu0_.trx_date is null
  50. )
  51. or trxsurattu0_.trx_date=?
  52. )
  53. 2019-09-05 15:10:20,661 239109 [http-nio-8844-exec-6] DEBUG o.h.e.jdbc.spi.SqlExceptionHelper - could not extract ResultSet [n/a]
  54. org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $5
  55. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  56. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  57. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  58. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  59. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  60. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
  61. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
  62. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  63. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  64. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
  65. at org.hibernate.loader.Loader.getResultSet(Loader.java:2167)
  66. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1930)
  67. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)
  68. at org.hibernate.loader.Loader.doQuery(Loader.java:937)
  69. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
  70. at org.hibernate.loader.Loader.doList(Loader.java:2689)
  71. at org.hibernate.loader.Loader.doList(Loader.java:2672)
  72. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)
  73. at org.hibernate.loader.Loader.list(Loader.java:2501)
  74. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
  75. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
  76. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
  77. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)
  78. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)
  79. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)
  80. at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1553)
  81. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository.findByBk(TrxSuratTugasKeluarRepository.java:40)
  82. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$FastClassBySpringCGLIB$$773c39b1.invoke(<generated>)
  83. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  84. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  85. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  86. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  87. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  88. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  89. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  90. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  91. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  92. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$EnhancerBySpringCGLIB$$c12278e7.findByBk(<generated>)
  93. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.findByBk(TrxSuratTugasKeluarService.java:154)
  94. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:107)
  95. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:1)
  96. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.doAddValidation(BaseService.java:78)
  97. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:88)
  98. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:106)
  99. at id.co.sofcograha.gajiidapi.base.extendables.BaseService$$FastClassBySpringCGLIB$$2aa36326.invoke(<generated>)
  100. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  101. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  102. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  103. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  104. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  105. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  106. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  107. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService$$EnhancerBySpringCGLIB$$2cc1441c.add(<generated>)
  108. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.controllers.TrxSuratTugasKeluarController.add(TrxSuratTugasKeluarController.java:54)
  109. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  110. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  111. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  112. at java.lang.reflect.Method.invoke(Method.java:498)
  113. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  114. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  115. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  116. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  117. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  118. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  119. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  120. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  121. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  122. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
  123. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  124. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  125. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  126. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  127. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  128. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  129. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  130. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  131. at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
  132. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  133. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  134. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  135. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  136. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  137. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  138. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  139. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  140. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  141. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  142. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  143. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  144. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  145. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  146. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  147. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  148. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  149. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  150. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  151. at id.co.sofcograha.gajiidapi.base.authentication.filters.TokenAuthenticationFilter.successfulAuthentication(TokenAuthenticationFilter.java:84)
  152. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240)
  153. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  154. at id.co.sofcograha.gajiidapi.base.authentication.filters.CorsFilter.doFilter(CorsFilter.java:45)
  155. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  156. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  157. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  158. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
  159. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  160. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  161. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  162. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  163. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  164. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  165. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  166. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  167. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  168. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  169. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  170. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  171. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  172. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
  173. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
  174. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  175. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  176. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  177. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  178. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  179. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  180. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  181. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  182. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  183. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  184. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  185. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  186. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  187. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  188. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  189. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  190. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  191. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  192. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  193. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  194. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  195. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  196. at java.lang.Thread.run(Thread.java:745)
  197. 2019-09-05 15:10:20,662 239110 [http-nio-8844-exec-6] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 42P18
  198. 2019-09-05 15:10:20,662 239110 [http-nio-8844-exec-6] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - ERROR: could not determine data type of parameter $5
  199. 2019-09-05 15:10:20,665 239113 [http-nio-8844-exec-6] DEBUG o.h.r.t.b.j.i.JdbcResourceLocalTransactionCoordinatorImpl - JDBC transaction marked for rollback-only (exception provided for stack trace)
  200. java.lang.Exception: exception just for purpose of providing stack trace
  201. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.markRollbackOnly(JdbcResourceLocalTransactionCoordinatorImpl.java:314)
  202. at org.hibernate.engine.transaction.internal.TransactionImpl.markRollbackOnly(TransactionImpl.java:206)
  203. at org.hibernate.internal.AbstractSharedSessionContract.markForRollbackOnly(AbstractSharedSessionContract.java:381)
  204. at org.hibernate.internal.ExceptionConverterImpl.handlePersistenceException(ExceptionConverterImpl.java:297)
  205. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
  206. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1514)
  207. at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1553)
  208. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository.findByBk(TrxSuratTugasKeluarRepository.java:40)
  209. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$FastClassBySpringCGLIB$$773c39b1.invoke(<generated>)
  210. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  211. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  212. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  213. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  214. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  215. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  216. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  217. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  218. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  219. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$EnhancerBySpringCGLIB$$c12278e7.findByBk(<generated>)
  220. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.findByBk(TrxSuratTugasKeluarService.java:154)
  221. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:107)
  222. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:1)
  223. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.doAddValidation(BaseService.java:78)
  224. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:88)
  225. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:106)
  226. at id.co.sofcograha.gajiidapi.base.extendables.BaseService$$FastClassBySpringCGLIB$$2aa36326.invoke(<generated>)
  227. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  228. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  229. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  230. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  231. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  232. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  233. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  234. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService$$EnhancerBySpringCGLIB$$2cc1441c.add(<generated>)
  235. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.controllers.TrxSuratTugasKeluarController.add(TrxSuratTugasKeluarController.java:54)
  236. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  237. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  238. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  239. at java.lang.reflect.Method.invoke(Method.java:498)
  240. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  241. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  242. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  243. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  244. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  245. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  246. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  247. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  248. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  249. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
  250. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  251. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  252. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  253. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  254. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  255. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  256. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  257. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  258. at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
  259. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  260. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  261. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  262. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  263. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  264. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  265. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  266. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  267. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  268. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  269. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  270. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  271. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  272. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  273. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  274. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  275. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  276. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  277. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  278. at id.co.sofcograha.gajiidapi.base.authentication.filters.TokenAuthenticationFilter.successfulAuthentication(TokenAuthenticationFilter.java:84)
  279. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240)
  280. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  281. at id.co.sofcograha.gajiidapi.base.authentication.filters.CorsFilter.doFilter(CorsFilter.java:45)
  282. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  283. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  284. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  285. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
  286. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  287. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  288. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  289. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  290. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  291. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  292. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  293. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  294. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  295. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  296. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  297. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  298. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  299. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
  300. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
  301. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  302. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  303. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  304. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  305. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  306. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  307. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  308. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  309. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  310. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  311. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  312. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  313. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  314. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  315. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  316. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  317. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  318. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  319. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  320. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  321. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  322. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  323. at java.lang.Thread.run(Thread.java:745)
  324. 2019-09-05 15:10:20,673 239121 [http-nio-8844-exec-6] DEBUG o.h.r.t.b.j.i.JdbcResourceLocalTransactionCoordinatorImpl - JDBC transaction marked for rollback-only (exception provided for stack trace)
  325. java.lang.Exception: exception just for purpose of providing stack trace
  326. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.markRollbackOnly(JdbcResourceLocalTransactionCoordinatorImpl.java:314)
  327. at org.hibernate.engine.transaction.internal.TransactionImpl.markRollbackOnly(TransactionImpl.java:206)
  328. at org.hibernate.engine.transaction.internal.TransactionImpl.setRollbackOnly(TransactionImpl.java:227)
  329. at org.springframework.orm.jpa.JpaTransactionManager$JpaTransactionObject.setRollbackOnly(JpaTransactionManager.java:682)
  330. at org.springframework.orm.jpa.JpaTransactionManager.doSetRollbackOnly(JpaTransactionManager.java:581)
  331. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:847)
  332. at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:812)
  333. at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:552)
  334. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:299)
  335. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  336. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  337. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  338. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$EnhancerBySpringCGLIB$$c12278e7.findByBk(<generated>)
  339. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.findByBk(TrxSuratTugasKeluarService.java:154)
  340. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:107)
  341. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:1)
  342. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.doAddValidation(BaseService.java:78)
  343. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:88)
  344. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:106)
  345. at id.co.sofcograha.gajiidapi.base.extendables.BaseService$$FastClassBySpringCGLIB$$2aa36326.invoke(<generated>)
  346. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  347. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  348. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  349. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  350. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  351. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  352. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  353. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService$$EnhancerBySpringCGLIB$$2cc1441c.add(<generated>)
  354. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.controllers.TrxSuratTugasKeluarController.add(TrxSuratTugasKeluarController.java:54)
  355. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  356. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  357. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  358. at java.lang.reflect.Method.invoke(Method.java:498)
  359. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  360. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  361. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  362. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  363. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  364. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  365. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  366. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  367. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  368. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
  369. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  370. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  371. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  372. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  373. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  374. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  375. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  376. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  377. at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
  378. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  379. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  380. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  381. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  382. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  383. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  384. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  385. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  386. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  387. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  388. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  389. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  390. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  391. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  392. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  393. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  394. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  395. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  396. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  397. at id.co.sofcograha.gajiidapi.base.authentication.filters.TokenAuthenticationFilter.successfulAuthentication(TokenAuthenticationFilter.java:84)
  398. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240)
  399. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  400. at id.co.sofcograha.gajiidapi.base.authentication.filters.CorsFilter.doFilter(CorsFilter.java:45)
  401. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  402. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  403. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  404. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
  405. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  406. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  407. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  408. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  409. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  410. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  411. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  412. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  413. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  414. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  415. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  416. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  417. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  418. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
  419. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
  420. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  421. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  422. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  423. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  424. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  425. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  426. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  427. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  428. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  429. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  430. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  431. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  432. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  433. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  434. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  435. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  436. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  437. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  438. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  439. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  440. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  441. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  442. at java.lang.Thread.run(Thread.java:745)
  443. 2019-09-05 15:10:20,674 239122 [http-nio-8844-exec-6] DEBUG o.h.e.t.internal.TransactionImpl - rolling back
  444. 2019-09-05 15:10:20,708 239156 [http-nio-8844-exec-6] ERROR i.c.s.g.b.r.GlobalExceptionHandler - =============================[internal.server.exception1567671020708]=============================
  445. 2019-09-05 15:10:20,708 239156 [http-nio-8844-exec-6] ERROR i.c.s.g.b.r.GlobalExceptionHandler - request: http://localhost:8844/gaji-id-api/private/trxSuratTugasKeluar
  446. 2019-09-05 15:10:20,708 239156 [http-nio-8844-exec-6] ERROR i.c.s.g.b.r.GlobalExceptionHandler - method: POST
  447. 2019-09-05 15:10:20,709 239157 [http-nio-8844-exec-6] DEBUG i.c.s.g.b.r.GlobalExceptionHandler - trace:
  448. org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  449. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:279)
  450. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:253)
  451. at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
  452. at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
  453. at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
  454. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
  455. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  456. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  457. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  458. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  459. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  460. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$EnhancerBySpringCGLIB$$c12278e7.findByBk(<generated>)
  461. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.findByBk(TrxSuratTugasKeluarService.java:154)
  462. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:107)
  463. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService.valUniquenessOnAdd(TrxSuratTugasKeluarService.java:1)
  464. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.doAddValidation(BaseService.java:78)
  465. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:88)
  466. at id.co.sofcograha.gajiidapi.base.extendables.BaseService.add(BaseService.java:106)
  467. at id.co.sofcograha.gajiidapi.base.extendables.BaseService$$FastClassBySpringCGLIB$$2aa36326.invoke(<generated>)
  468. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  469. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  470. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  471. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
  472. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  473. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  474. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  475. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.services.TrxSuratTugasKeluarService$$EnhancerBySpringCGLIB$$2cc1441c.add(<generated>)
  476. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.controllers.TrxSuratTugasKeluarController.add(TrxSuratTugasKeluarController.java:54)
  477. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  478. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  479. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  480. at java.lang.reflect.Method.invoke(Method.java:498)
  481. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  482. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  483. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  484. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  485. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  486. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  487. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  488. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  489. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  490. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
  491. at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
  492. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  493. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  494. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  495. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  496. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  497. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  498. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  499. at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
  500. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  501. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  502. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  503. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
  504. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  505. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  506. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  507. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
  508. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  509. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  510. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  511. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  512. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  513. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  514. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  515. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  516. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  517. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
  518. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  519. at id.co.sofcograha.gajiidapi.base.authentication.filters.TokenAuthenticationFilter.successfulAuthentication(TokenAuthenticationFilter.java:84)
  520. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:240)
  521. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  522. at id.co.sofcograha.gajiidapi.base.authentication.filters.CorsFilter.doFilter(CorsFilter.java:45)
  523. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  524. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  525. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  526. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
  527. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  528. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  529. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  530. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  531. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  532. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  533. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
  534. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
  535. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
  536. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
  537. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
  538. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  539. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  540. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
  541. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
  542. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  543. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  544. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  545. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  546. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  547. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  548. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  549. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  550. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  551. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  552. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  553. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  554. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  555. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  556. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  557. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  558. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  559. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  560. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  561. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  562. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  563. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  564. at java.lang.Thread.run(Thread.java:745)
  565. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  566. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
  567. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  568. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  569. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  570. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
  571. at org.hibernate.loader.Loader.getResultSet(Loader.java:2167)
  572. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1930)
  573. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)
  574. at org.hibernate.loader.Loader.doQuery(Loader.java:937)
  575. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
  576. at org.hibernate.loader.Loader.doList(Loader.java:2689)
  577. at org.hibernate.loader.Loader.doList(Loader.java:2672)
  578. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)
  579. at org.hibernate.loader.Loader.list(Loader.java:2501)
  580. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
  581. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
  582. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
  583. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)
  584. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)
  585. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)
  586. at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1553)
  587. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository.findByBk(TrxSuratTugasKeluarRepository.java:40)
  588. at id.co.sofcograha.gajiidapi.domain.hris.attendance.trx.surattugaskeluar.repositories.TrxSuratTugasKeluarRepository$$FastClassBySpringCGLIB$$773c39b1.invoke(<generated>)
  589. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  590. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
  591. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  592. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  593. ... 110 common frames omitted
  594. Caused by: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $5
  595. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  596. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  597. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  598. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  599. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  600. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
  601. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
  602. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  603. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  604. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
  605. ... 132 common frames omitted
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!