API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 16th, 2019
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.74 KB | None | 0 0
raw download clone embed print report
  1. [1/16/19 19:24:48:298 CST] 000001a4 SystemOut O 2019-01-16 19:24:48: DEBUG [WebContainer : 21] BankGovernmentSecurity - Error in getting ledger details
  2. [1/16/19 19:24:48:303 CST] 000001a4 SystemOut O 2019-01-16 19:24:48: ERROR [WebContainer : 21] BankGSOperationsController - Error!
  3. gov.bsp.lcmis.exceptions.TechnicalIssueException: 555787877
  4. at gov.bsp.lcmis.report.dao.CollateralReportLedgerDao.retrieveCollateralEncodingTwoAmountAccountAdapter(CollateralReportLedgerDao.java:148) ~[LCMIS-CollateralLedgerService-0.0.1-SNAPSHOT.jar:na]
  5. at gov.bsp.lcmis.internal.domain.collateral.bankgs.BankGovernmentSecurity.setCollateralLedger(BankGovernmentSecurity.java:657) ~[LCMIS-Internal-BankGovernmentSecurities-0.1.1-SNAPSHOT.jar:na]
  6. at gov.bsp.lcmis.internal.controller.collateral.bankgs.BankGSOperationsController.save(BankGSOperationsController.java:191) [LCMIS-Internal-BankGSInterface-0.0.1-SNAPSHOT.jar:na]
  7. at gov.bsp.lcmis.internal.controller.collateral.bankgs.BankGSOperationsController.postCollateralToBatch(BankGSOperationsController.java:95) [LCMIS-Internal-BankGSInterface-0.0.1-SNAPSHOT.jar:na]
  8. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0]
  9. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) ~[na:1.7.0]
  10. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) ~[na:1.7.0]
  11. at java.lang.reflect.Method.invoke(Method.java:620) ~[na:2.6 (04-06-2016)]
  12. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  13. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  14. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:114) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  15. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  16. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  17. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  18. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  19. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  20. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  21. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  22. at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) [javax.j2ee.servlet.jar:na]
  23. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  24. at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) [javax.j2ee.servlet.jar:na]
  25. at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232) [com.ibm.ws.webcontainer.jar:na]
  26. at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781) [com.ibm.ws.webcontainer.jar:na]
  27. at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480) [com.ibm.ws.webcontainer.jar:na]
  28. at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [com.ibm.ws.webcontainer.jar:na]
  29. at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) [com.ibm.ws.webcontainer.jar:na]
  30. at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) [com.ibm.ws.webcontainer.jar:na]
  31. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  32. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  33. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  34. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  35. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  36. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  37. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  38. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  39. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  40. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  41. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  42. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  43. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  44. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  45. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  46. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  47. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  48. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  49. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  50. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  51. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  52. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  53. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  54. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  55. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  56. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  57. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  58. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
  59. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  60. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  61. at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195) [com.ibm.ws.webcontainer.jar:na]
  62. at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) [com.ibm.ws.webcontainer.jar:na]
  63. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  64. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.2.RELEASE.jar:4.3.2.RELEASE]
  65. at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195) [com.ibm.ws.webcontainer.jar:na]
  66. at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) [com.ibm.ws.webcontainer.jar:na]
  67. at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967) [com.ibm.ws.webcontainer.jar:na]
  68. at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107) [com.ibm.ws.webcontainer.jar:na]
  69. at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) [com.ibm.ws.webcontainer.jar:na]
  70. at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:947) [com.ibm.ws.webcontainer.jar:na]
  71. at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) [com.ibm.ws.webcontainer.jar:na]
  72. at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200) [com.ibm.ws.webcontainer.jar:na]
  73. at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463) [com.ibm.ws.runtime.jar:na]
  74. at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530) [com.ibm.ws.runtime.jar:na]
  75. at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316) [com.ibm.ws.runtime.jar:na]
  76. at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287) [com.ibm.ws.runtime.jar:na]
  77. at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214) [na:CCX.CF [o1537.01]]
  78. at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113) [na:CCX.CF [o1537.01]]
  79. at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) [com.ibm.ws.runtime.jar:na]
  80. at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [com.ibm.ws.runtime.jar:na]
  81. at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [com.ibm.ws.runtime.jar:na]
  82. at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [com.ibm.ws.runtime.jar:na]
  83. at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) [com.ibm.ws.runtime.jar:na]
  84. at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) [com.ibm.ws.runtime.jar:na]
  85. at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) [com.ibm.ws.runtime.jar:na]
  86. at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892) [com.ibm.ws.runtime.jar:na]
  87. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  88. ### Error querying database. Cause: com.ibm.db2.jcc.am.SqlException: The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.. SQLCODE=-811, SQLSTATE=21000, DRIVER=3.63.123
  89. ### The error may exist in gov/bsp/lcmis/report/mappers/CollateralLedgerReportMapper.xml
  90. ### The error may involve gov.bsp.lcmis.report.dao.mapper.CollateralLedgerReportMapper.retrieveCollateralEncodingTwoAmountAccountAdapter-Inline
  91. ### The error occurred while setting parameters
  92. ### SQL: SELECT TBL.COLLATERAL_NUMBER, COLL_TYP.DESCRIPTION, COLL_TYP.COLLATERAL_TYPE_ID, LEDG.COLLATERAL_VALUE, PRINCIPAL_TOTAL.TOTAL as PRINCIPAL_TOTAL, TBL.REGISTERED_OWNER, TBL.REF_COLLATERAL_LOCATION as COLLATERAL_LOCATION, LEDG.REF_PN_COLLATERAL_ID FROM COLLATERAL_LEDGER AS LEDG JOIN PN_COLLATERAL AS PN_COLL ON PN_COLL.PN_COLLATERAL_ID = LEDG.REF_PN_COLLATERAL_ID JOIN PN_TBL AS PN ON PN.PN_ID = PN_COLL.REF_PN_ID JOIN BANK_GS as TBL ON TBL.REF_GHOST_PN_ID = PN.PN_ID JOIN COLLATERAL_TYPE_TBL AS COLL_TYP ON COLL_TYP.COLLATERAL_TYPE_ID = PN.REF_COLLATERAL_TYPE_ID JOIN ( SELECT (DEBIT.TOTAL_DEBIT - CREDIT.TOTAL_CREDIT) AS TOTAL, CREDIT.REF_PN_COLLATERAL_ID FROM ( SELECT SUM(PRINCIPAL) AS TOTAL_DEBIT, REF_PN_COLLATERAL_ID FROM COLLATERAL_LEDGER LEDG WHERE LEDG.REF_PN_COLLATERAL_ID = ( SELECT PN_COLLATERAL_ID FROM ( SELECT DISTINCT(REF_GHOST_PN_ID), PN_COLLATERAL_ID FROM BANK_GS TBL LEFT JOIN PN_COLLATERAL PN_COLL ON TBL.REF_GHOST_PN_ID = PN_COLL.REF_PN_ID LEFT JOIN PN_TBL PN ON PN.PN_ID = PN_COLL.REF_PN_ID LEFT JOIN BANK_TBL BANK ON BANK.BANK_ID = PN.REF_BANK_ID WHERE PN_COLLATERAL_ID IS NOT NULL AND TBL.COLLATERAL_NUMBER = ? AND PN.REF_COLLATERAL_TYPE_ID = ? ) AS FILTER) AND LEDG.DEBIT_CREDIT = 'DEBIT' AND LEDG.COLLATERAL_ID NOT IN ( SELECT MIN(LEDG.COLLATERAL_ID) FROM COLLATERAL_LEDGER AS LEDG JOIN PN_COLLATERAL AS PN_COLL ON PN_COLL.PN_COLLATERAL_ID = LEDG.REF_PN_COLLATERAL_ID JOIN PN_TBL AS PN ON PN.PN_ID = PN_COLL.REF_PN_ID JOIN BANK_GS as TBL ON TBL.REF_GHOST_PN_ID = PN.PN_ID JOIN COLLATERAL_TYPE_TBL AS COLL_TYP ON COLL_TYP.COLLATERAL_TYPE_ID = PN.REF_COLLATERAL_TYPE_ID WHERE LEDG.DEBIT_CREDIT = 'DEBIT' AND TBL.COLLATERAL_NUMBER = ? AND PN.REF_COLLATERAL_TYPE_ID = ? ) GROUP BY REF_PN_COLLATERAL_ID ) AS DEBIT LEFT JOIN ( SELECT SUM(PRINCIPAL) AS TOTAL_CREDIT, REF_PN_COLLATERAL_ID FROM COLLATERAL_LEDGER LEDG WHERE LEDG.REF_PN_COLLATERAL_ID = ( SELECT PN_COLLATERAL_ID FROM ( SELECT DISTINCT(REF_GHOST_PN_ID), PN_COLLATERAL_ID FROM BANK_GS TBL LEFT JOIN PN_COLLATERAL PN_COLL ON TBL.REF_GHOST_PN_ID = PN_COLL.REF_PN_ID LEFT JOIN PN_TBL PN ON PN.PN_ID = PN_COLL.REF_PN_ID LEFT JOIN BANK_TBL BANK ON BANK.BANK_ID = PN.REF_BANK_ID WHERE PN_COLLATERAL_ID IS NOT NULL AND TBL.COLLATERAL_NUMBER = ? AND PN.REF_COLLATERAL_TYPE_ID = ? ) AS FILTER) AND LEDG.DEBIT_CREDIT = 'CREDIT' GROUP BY REF_PN_COLLATERAL_ID ) AS CREDIT ON DEBIT.REF_PN_COLLATERAL_ID = CREDIT.REF_PN_COLLATERAL_ID ) AS PRINCIPAL_TOTAL ON PRINCIPAL_TOTAL.REF_PN_COLLATERAL_ID = LEDG.REF_PN_COLLATERAL_ID JOIN ( SELECT MAX(LEDG.COLLATERAL_ID) AS COLLATERAL_ID, LEDG.REF_PN_COLLATERAL_ID FROM COLLATERAL_LEDGER AS LEDG JOIN PN_COLLATERAL AS PN_COLL ON PN_COLL.PN_COLLATERAL_ID = LEDG.REF_PN_COLLATERAL_ID JOIN PN_TBL AS PN ON PN.PN_ID = PN_COLL.REF_PN_ID JOIN BANK_GS as TBL ON TBL.REF_GHOST_PN_ID = PN.PN_ID JOIN COLLATERAL_TYPE_TBL AS COLL_TYP ON COLL_TYP.COLLATERAL_TYPE_ID = PN.REF_COLLATERAL_TYPE_ID WHERE LEDG.REF_PN_COLLATERAL_ID IS NOT NULL AND TBL.COLLATERAL_NUMBER = ? AND PN.REF_COLLATERAL_TYPE_ID = ? GROUP BY LEDG.REF_PN_COLLATERAL_ID ) AS LATEST_TRANS ON LATEST_TRANS.REF_PN_COLLATERAL_ID = LEDG.REF_PN_COLLATERAL_ID WHERE LEDG.REF_PN_COLLATERAL_ID IS NOT NULL AND TBL.COLLATERAL_NUMBER = ? AND PN.REF_COLLATERAL_TYPE_ID = ? AND LEDG.COLLATERAL_ID = LATEST_TRANS.COLLATERAL_ID
  93. ### Cause: com.ibm.db2.jcc.am.SqlException: The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.. SQLCODE=-811, SQLSTATE=21000, DRIVER=3.63.123
  94. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.4.6.jar:3.4.6]
  95. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) ~[mybatis-3.4.6.jar:3.4.6]
  96. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar:3.4.6]
  97. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.4.6.jar:3.4.6]
  98. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83) ~[mybatis-3.4.6.jar:3.4.6]
  99. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.6.jar:3.4.6]
  100. at com.sun.proxy.$Proxy688.retrieveCollateralEncodingTwoAmountAccountAdapter(Unknown Source) ~[na:1.7.0]
  101. at gov.bsp.lcmis.report.dao.CollateralReportLedgerDao.retrieveCollateralEncodingTwoAmountAccountAdapter(CollateralReportLedgerDao.java:117) ~[LCMIS-CollateralLedgerService-0.0.1-SNAPSHOT.jar:na]
  102. ... 82 common frames omitted
  103. Caused by: com.ibm.db2.jcc.am.SqlException: The result of a scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more than one row.. SQLCODE=-811, SQLSTATE=21000, DRIVER=3.63.123
  104. at com.ibm.db2.jcc.am.fd.a(fd.java:682) ~[db2jcc.jar:na]
  105. at com.ibm.db2.jcc.am.fd.a(fd.java:60) ~[db2jcc.jar:na]
  106. at com.ibm.db2.jcc.am.fd.a(fd.java:127) ~[db2jcc.jar:na]
  107. at com.ibm.db2.jcc.am.vn.b(vn.java:4031) ~[db2jcc.jar:na]
  108. at com.ibm.db2.jcc.am.vn.a(vn.java:4013) ~[db2jcc.jar:na]
  109. at com.ibm.db2.jcc.t4.cb.a(cb.java:835) ~[db2jcc.jar:na]
  110. at com.ibm.db2.jcc.t4.cb.n(cb.java:801) ~[db2jcc.jar:na]
  111. at com.ibm.db2.jcc.t4.cb.j(cb.java:253) ~[db2jcc.jar:na]
  112. at com.ibm.db2.jcc.t4.cb.d(cb.java:55) ~[db2jcc.jar:na]
  113. at com.ibm.db2.jcc.t4.q.c(q.java:44) ~[db2jcc.jar:na]
  114. at com.ibm.db2.jcc.t4.sb.j(sb.java:147) ~[db2jcc.jar:na]
  115. at com.ibm.db2.jcc.am.ho.ib(ho.java:2119) ~[db2jcc.jar:na]
  116. at com.ibm.db2.jcc.am.io.b(io.java:4299) ~[db2jcc.jar:na]
  117. at com.ibm.db2.jcc.am.io.fc(io.java:2674) ~[db2jcc.jar:na]
  118. at com.ibm.db2.jcc.am.io.execute(io.java:2658) ~[db2jcc.jar:na]
  119. at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958) ~[com.ibm.ws.runtime.jar:na]
  120. at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625) ~[com.ibm.ws.runtime.jar:na]
  121. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0]
  122. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) ~[na:1.7.0]
  123. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) ~[na:1.7.0]
  124. at java.lang.reflect.Method.invoke(Method.java:620) ~[na:2.6 (04-06-2016)]
  125. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.4.6.jar:3.4.6]
  126. at com.sun.proxy.$Proxy141.execute(Unknown Source) ~[na:1.7.0]
  127. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) ~[mybatis-3.4.6.jar:3.4.6]
  128. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.6.jar:3.4.6]
  129. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.6.jar:3.4.6]
  130. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar:3.4.6]
  131. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar:3.4.6]
  132. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.6.jar:3.4.6]
  133. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.4.6.jar:3.4.6]
  134. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar:3.4.6]
  135. ... 88 common frames omitted
  136. [1/16/19 19:24:48:306 CST] 000001a4 SystemOut O 2019-01-16 19:24:48: DEBUG [WebContainer : 21] BankGSOperationsController - MCO >> save
  137. [1/16/19 19:24:48:306 CST] 000001a4 SystemOut O 2019-01-16 19:24:48: DEBUG [WebContainer : 21] BankGSOperationsController - MCO >> postCollateralToBatch
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!