Support #6171
[Request ID :##3061##] : issue add fav FCR
| Status: | Work Completed-End life cycle | Start date: | April 07, 2016 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | % Done: | 100% | ||
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi Gabby
Kindly Assis
Pleasecheck for below issue when add new fav for FCR,
Pleaseuse swift code ABIVZAJ1XXX on sit enhance environment for testing
Ifcheck on table ib_ftt the field for branch_code_ftt is null, is this the mainissue? and why nullable field is used as a key?
instead of using branch_code_ftt, the field swift_code_ftt is more suitable used as key, as that field is mandatory dan unique.
<<<<<<<<<<<<<<<<< Performance Calculate Result >>>>>>>>>>>>>>>>>>>
Class:{http://www.bankbii.com/TokenServices/}TokenServices
MessageID:0271DE27-7AFA-44ED-B22B-72CFCFDB94EA
StartTime: Fri Apr 01 14:47:05 WIT 2016
EndTime: Fri Apr 01 14:47:06 WIT 2016
TimeUsed to complete whole service (in miliseconds): 742
[4/1/1614:47:06:142 WIT] 00000120 SystemOut O ##########Retrieving next value for sequence: IB_SEQ_TRNX
[4/1/1614:47:06:143 WIT] 00000120 SystemOut O ########## Lastsequence value: 112331
[4/1/1614:47:06:162 WIT] 00000120 SystemOut O [01/04/2016][14:47:06:162] [ERROR] [IBBusinessException]:527 - [default] System iscurrently unavailable. Please try again later.
[4/1/1614:47:06:164 WIT] 00000120 SystemOut O [01/04/2016][14:47:06:164] [ERROR] [IBControllerAction]:538 -
com.ib.common.error.exception.IBBusinessException:
atcom.ib.common.error.handler.IBErrorHandler.createBusinessException(IBErrorHandler.java:76)
at com.ib.rib.controller.actions.ib104_fundtransfer.ttfcy_maint.IBForeignTelegraphicMaintAddResultsAction.execute(IBForeignTelegraphicMaintAddResultsAction.java:159)
atorg.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.common.utils.IBActionServlet.doPost(IBActionServlet.java:82)
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:1230)
atcom.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
atcom.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
atcom.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
atcom.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)
atcom.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
atcom.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
atcom.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
atcom.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
atcom.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
atcom.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
atcom.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:283)
atcom.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
atcom.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
atcom.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
atcom.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:1862)
[4/1/1614:47:06:240 WIT] 000000ed WebContainer Ecom.ibm.ws.webcontainer.internal.WebContainer sendUnavailableExceptionServlet.has.become.temporarily.unavailable.for.service
History
#1
Updated by Zahir Abd Latif over 8 years ago
Dear Gabby,
Kindly assist to update the current status or any finding/progress on this issue in Redmine.
Thanks.
#2
Updated by Zahir Abd Latif about 8 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- % Done changed from 0 to 100
Update by Gabby, Aug 4, 2016 06:35 PM:-
Dear Pak Wahyu, Please help that in PROD database it contains different setting compared to development (attached). We have tried to create new database in dev with these params: db2set DB2_COMPATIBILITY_VECTOR=ORA (tried to remove this lines) db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES (tried to set to NO) db2stop force db2start db2 "create db BII2 automatic storage yes PAGESIZE 32768" db2 update db cfg for BII2 using auto_reval deferred_force db2 update db cfg for BII2 using decflt_rounding round_half_up We suspect that hibernate fails to perform select query if the value is longer than column length. Solution: #1 - Update DB2 Config to be as the same as Dev.
Issue closed in SCP.