Bug #4228: [SCP ID :##2084##] : error trx skn/rtgs - Maybank BII M2U-RIB Support - Penril Support System

Bug #4228

[SCP ID :##2084##] : error trx skn/rtgs

Added by Ahmad Hazri over 10 years ago. Updated almost 10 years ago.

Status:

Closed - End of life cycle

Start date:

March 19, 2014

Priority:

Normal

Due date:

March 26, 2014

Assignee:

Rayvandy Gabbytian

% Done:

100%

Category:

Spent time:

Target version:

Description

Please attend below user query:

Error when doing trx skn/rtgs, attach log.

<<<<<<<<<<<<<<<<<   Performance Calculate Result   >>>>>>>>>>>>>>>>>>>

Class: {http://www.bankbii.com/TransactionServices/}TransactionServices

MessageID: 69919838-F139-4669-9D01-FFD998DAA44D

Start Time: Tue Mar 18 16:42:14 WIT 2014

End Time: Tue Mar 18 16:42:15 WIT 2014

Time Used to complete whole service (in miliseconds): 421

[3/18/14 16:42:15:229 WIT] 00000557 SystemOut     O [18/03/2014] [16:42:15:228] [ERROR] [JDBCExceptionReporter]:101 - The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.123

[3/18/14 16:42:15:229 WIT] 00000557 SystemOut     O [18/03/2014] [16:42:15:228] [ERROR] [JDBCExceptionReporter]:101 - The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.123

[3/18/14 16:42:15:232 WIT] 00000557 SystemOut     O [18/03/2014] [16:42:15:232] [ERROR] [IBTelegraphicTransferResultsServices]:527 - Error code : 9999

[3/18/14 16:42:15:234 WIT] 00000557 SystemOut     O [18/03/2014] [16:42:15:234] [ERROR] [IBTelegraphicTransferResultsServices]:527 - Error details : org.hibernate.exception.DataException: could not insert: [net.penril.ibss.core.hibernate.SmsTable]

               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)

               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)

               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)

               at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)

               at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)

               at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

               at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)

               at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)

               at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)

               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)

               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)

               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)

               at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)

               at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:534)

               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:526)

               at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:522)

               at net.penril.generic.hibernate.GenericDAOHibernate.makePersistent(GenericDAOHibernate.java:125)

               at net.penril.ibss.core.hibernate.SmsTable.setSMS(SmsTable.java:591)

               at com.ib.enterprise.services.common.IBLogger.logSms(IBLogger.java:310)

               at com.ib.enterprise.services.common.IBLogger.logSms(IBLogger.java:231)

               at com.ib.enterprise.services.ib104_fundtransfer.telegraphic_transfer.IBTelegraphicTransferResultsServices.execute(IBTelegraphicTransferResultsServices.java:628)

               at com.ib.rib.controller.actions.ib104_fundtransfer.telegraphic_transfer.IBTelegraphicTransferResultsAction.execute(IBTelegraphicTransferResultsAction.java:80)

               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.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:1225)

               at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)

               at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)

               at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)

               at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)

               at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)

               at com.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)

               at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)

               at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)

               at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)

               at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)

               at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)

               at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)

               at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)

               at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)

               at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)

               at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)

               at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)

               at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)

               at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

               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:1815)

Caused by: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.63.123

               at com.ibm.db2.jcc.am.fd.a(fd.java:671)

               at com.ibm.db2.jcc.am.fd.a(fd.java:60)

               at com.ibm.db2.jcc.am.fd.a(fd.java:127)

               at com.ibm.db2.jcc.am.ho.c(ho.java:2644)

               at com.ibm.db2.jcc.am.ho.a(ho.java:2124)

               at com.ibm.db2.jcc.t4.cb.o(cb.java:844)

               at com.ibm.db2.jcc.t4.cb.j(cb.java:266)

               at com.ibm.db2.jcc.t4.cb.d(cb.java:55)

               at com.ibm.db2.jcc.t4.q.c(q.java:44)

               at com.ibm.db2.jcc.t4.sb.j(sb.java:147)

               at com.ibm.db2.jcc.am.ho.ib(ho.java:2119)

               at com.ibm.db2.jcc.am.io.b(io.java:4268)

               at com.ibm.db2.jcc.am.io.b(io.java:4429)

               at com.ibm.db2.jcc.am.io.dc(io.java:759)

               at com.ibm.db2.jcc.am.io.executeUpdate(io.java:742)

               at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1185)

               at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:802)

               at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)

               at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

               ... 54 more

Increase column USER_NAME in SMS_TABLE.sql (499 Bytes) Rayvandy Gabbytian , March 27, 2014 18:06

History

#1 Updated by Rayvandy Gabbytian over 10 years ago

File Increase column USER_NAME in SMS_TABLE.sql added
Due date set to March 26, 2014
Status changed from New - Begin Life Cycle to System Integration Test

SQL Query is executed on 26th March 2014.

Root Cause:
- Column USRE_NAME was set to 40 chars in length. This field was mapped to USER_DISPLAY NAME in IB_CUST_PROFILE which length is 64.

Solution:
Increase column length of customer name from 40 to 200. Customer Name is getting from table IB_CUST_PROFILE column USER_DISPLAY_NAME (64).
The reason why I increased to 200 is incase, if this customer name is mapped to IB_CUST_PROFILE column USER_DISPLAY_NAME (200), it can accommodate that length.

#2 Updated by Rayvandy Gabbytian over 10 years ago

Tracker changed from Support to Bug

#3 Updated by Zahir Abd Latif about 10 years ago

Dear Gabbytian,

Any updates on this case? please help to follow up with to see we closed this case or update the
status.

#4 Updated by Zahir Abd Latif almost 10 years ago

Status changed from System Integration Test to Closed - End of life cycle
% Done changed from 0 to 100

Also available in: Atom PDF

B - Production Support » Maybank Support » Maybank BII M2U-RIB Support

Issues