Support #7808
SCP ID :##4065##] : MSS failed to approve delete payee
| Status: | Closed - End of life cycle | Start date: | August 28, 2017 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | August 28, 2017 | |
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request.
. MSS checker failed to approve delete payee content, (able to recreate issue in UAT MSS) below is the log
[8/28/17 10:49:57:155 WIB] 0000011c PmiRmArmWrapp I PMRM0003I: parent:ver=1,ip=10.247.12.54,time=1503570358070,pid=5832940,reqid=24583,event=1 - current:ver=1,ip=10.247.12.54,time=1503570358070,pid=5832940,reqid=24603,event=1 type=JDBC detail=java.sql.Connection.rollback() elapsed=1
[8/28/17 10:49:57:156 WIB] 0000011c SystemOut O [28/08/2017] [10:49:57:155] [ERROR] [IBSSLoggerBase]:242 - could not delete: [net.penril.ib.content.hibernate.IbPayee#143]
org.hibernate.exception.ConstraintViolationException: could not delete: [net.penril.ib.content.hibernate.IbPayee#143]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at net.penril.ib.content.hibernate.IbPayee.deletePayee(IbPayee.java:1234)
at com.ib.ibss.enterprise.services.ss106_maker_checker.IBSSAuthorizationDeletePayeeServices.execute(IBSSAuthorizationDeletePayeeServices.java:41)
at com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.executeDeletePayee(IBSSAuthorizationResultDeletePayeeServices.java:219)
at com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.execute(IBSSAuthorizationResultDeletePayeeServices.java:61)
at com.ib.ibss.controller.actions.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeAction.execute(IBSSAuthorizationResultDeletePayeeAction.java:48)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.ib.ibss.common.utils.IBSSActionServlet.doPost(IBSSActionServlet.java:81)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3980)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1016)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
Caused by:
com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: A parent row cannot be deleted because the relationship "DBO.IB_STP_ACCOUNT_CONFIG.FK_PAYEE_ID" restricts the deletion.. SQLCODE=-532, SQLSTATE=23001, DRIVER=4.13.127
at com.ibm.db2.jcc.am.id.a(id.java:673)
at com.ibm.db2.jcc.am.id.a(id.java:60)
at com.ibm.db2.jcc.am.id.a(id.java:127)
at com.ibm.db2.jcc.am.no.b(no.java:2310)
at com.ibm.db2.jcc.am.no.c(no.java:2293)
at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
at com.ibm.db2.jcc.t4.q.a(q.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
at com.ibm.db2.jcc.am.oo.oc(oo.java:3428)
at com.ibm.db2.jcc.am.oo.b(oo.java:4383)
at com.ibm.db2.jcc.am.oo.gc(oo.java:784)
at com.ibm.db2.jcc.am.oo.executeUpdate(oo.java:763)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1261)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:808)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2548)
... 46 more
[8/28/17 10:49:57:158 WIB] 0000011c SystemOut O [28/08/2017] [10:49:57:158] [ERROR] [IBSSAuthorizationDeletePayeeServices]:141 - Error code : 0000
[8/28/17 10:49:57:158 WIB] 0000011c SystemOut O [28/08/2017] [10:49:57:158] [ERROR] [IBSSAuthorizationDeletePayeeServices]:141 - Error details : could not delete: [net.penril.ib.content.hibernate.IbPayee#143]
Exception class : org.hibernate.exception.SQLStateConverter, class method : convert, line number : 94
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
net.penril.ib.content.hibernate.IbPayee.deletePayee(IbPayee.java:1234)
com.ib.ibss.enterprise.services.ss106_maker_checker.IBSSAuthorizationDeletePayeeServices.execute(IBSSAuthorizationDeletePayeeServices.java:41)
com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.executeDeletePayee(IBSSAuthorizationResultDeletePayeeServices.java:219)
com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.execute(IBSSAuthorizationResultDeletePayeeServices.java:61)
com.ib.ibss.controller.actions.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeAction.execute(IBSSAuthorizationResultDeletePayeeAction.java:48)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
com.ib.ibss.common.utils.IBSSActionServlet.doPost(IBSSActionServlet.java:81)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3980)
com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1016)
com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
[8/28/17 10:49:57:159 WIB] 0000011c SystemOut O [28/08/2017] [10:49:57:159] [ERROR] [IBSSLoggerBase]:242 -
com.ib.ibss.error.exception.IBSSServiceException:
at com.ib.ibss.error.handler.IBSSErrorHandler.createServiceException(IBSSErrorHandler.java:142)
at com.ib.ibss.error.handler.IBSSErrorHandler.handleServiceError(IBSSErrorHandler.java:247)
at com.ib.ibss.enterprise.services.ss106_maker_checker.IBSSAuthorizationDeletePayeeServices.execute(IBSSAuthorizationDeletePayeeServices.java:56)
at com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.executeDeletePayee(IBSSAuthorizationResultDeletePayeeServices.java:219)
at com.ib.ibss.enterprise.services.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeServices.execute(IBSSAuthorizationResultDeletePayeeServices.java:61)
at com.ib.ibss.controller.actions.ss106_maker_checker.content.IBSSAuthorizationResultDeletePayeeAction.execute(IBSSAuthorizationResultDeletePayeeAction.java:48)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.ib.ibss.common.utils.IBSSActionServlet.doPost(IBSSActionServlet.java:81)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3980)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1016)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
History
#1
Updated by Rayvandy Gabbytian about 7 years ago
- Due date set to August 28, 2017
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
Dear Zahir,
Gabby replied the message 28th Aug 2017 11:42:
Dear Pak Wahyu, You need to delete the payee inside STP config first in order to successfully delete the payee ID. Because the payee is an active content, deleting it while still registered in STP table will cause exception in STP function. This is a failsafe mechanism. Thank you.
Wahyu replied the message 28th Aug 2017 12:13:
Penril team, Please create a more friendly message that able to understand by the users. As in this way, user will se as an unexpected error instead of failsafe mechanism.
Gabby replied the message 28th Aug 2017 12:43:
Pak Wahyu, Below proposed message: “Unable to delete payee due to an active content” Is it sufficient? Thank you.
No reply from bank since then. Please ask Maybank whether we can close this ticket.
Thank you.
#2
Updated by Zahir Abd Latif about 7 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.