Bug #748
Syabas tranx not found in icubes
| Status: | Work Completed-End life cycle | Start date: | January 24, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | January 25, 2011 | |
| Assignee: |  Latipah Abdul Rashid | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Email from Sharon:
Dear Penril/Rosli,
We performed 1 Syabas tranx in today but the we're unable to locate the tranx in icubes.
Pls assist ASAP
========================
Email from Rosli:
Hi,
Upon investigation, found that the table IB_BILL_PAYMENT does not contain any data. Potential root cause is due to IB did not write/commit the transactions to the files/table.
BillPaymentReport_DAILY_20110124.csv 
(1.32 KB)
InternetTransactionReport_DAILY_20110124.csv
(6.25 KB)
IBSystem_bv_framework3.log_2011-01-24 (27.4 KB)
bvsystem.2011-01-24.log (619 KB)
KFH_DB_Migration_Plan_20110125.doc (47 KB)
KFH_DR_DB_Migration_Plan_20110125.doc (47.5 KB)
History
#1
Updated by Latipah Abdul Rashid over 13 years ago
- File BillPaymentReport_DAILY_20110124.csv added
- File InternetTransactionReport_DAILY_20110124.csv added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Updated by Sharon, the transaction was found in InternetTransactionReport but not in BillPaymentReport.
#2
Updated by Latipah Abdul Rashid over 13 years ago
- File IBSystem_bv_framework3.log_2011-01-24 added
- File bvsystem.2011-01-24.log added
- File KFH_DB_Migration_Plan_20110125.doc added
- File KFH_DR_DB_Migration_Plan_20110125.doc added
- Status changed from Development / Work In Progress to Pending Prod Deployment
- % Done changed from 0 to 90
Found in the log IBSystem_bv_framework3.log@2011-01-24 and bvsystem.2011-01-24.log, that column size for MERCHANT_ACC_NO in BVUSERPRD.IB_BILL_PAYMENT in PROD is insufficient and not the same as in STG.
Also found that:- column size of BILL_ACC_NO in BVUSERPRD.IB_BILL_PAYMENT is also smaller than in STG
- column size of MERCHANT_ACC_NO in BIB.BIB_BILL_PAYMENT is also smaller than in STG
Fixes:
Modify column size of MERCHANT_ACC_NO and BILL_ACC_NO in BVUSERPRD.IB_BILL_PAYMENT and
column size of MERCHANT_ACC_NO in BIB.BIB_BILL_PAYMENT to be the same as in STG.
#3
Updated by Latipah Abdul Rashid over 13 years ago
- Tracker changed from Task to Bug
2011/01/24 09:22:48:624 ERROR kfh.enterprise.services.GenericBVDataServicesImpl: Error code : 0000
2011/01/24 09:22:48:643 ERROR kfh.enterprise.services.GenericBVDataServicesImpl: Error details : SQL ErrorCode=0, State=null, Message=SQL ErrorCode=12899, State=72000, Message=ORA-12899: value too large for column "BVUSERPRD"."IB_BILL_PAYMENT"."MERCHANT_ACC_NO" (actual: 24, maximum: 16)
Exception class : com.broadvision.data.ejb.content.ContentDbSLBean, class method : insertData, line number : 4612com.broadvision.data.ejb.content.ContentDbSLBean.insertData(ContentDbSLBean.java:4612)
sun.reflect.GeneratedMethodAccessor804.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.invocation.Invocation.performCall(Invocation.java:359)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownInterceptor.java:278)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
org.jboss.ejb.Container.invoke(Container.java:954)
sun.reflect.GeneratedMethodAccessor575.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
org.jboss.proxy.ejb.RetryInterceptor.invoke(RetryInterceptor.java:176)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
$Proxy114.insertData(Unknown Source)
com.broadvision.data.ejb.content.ContentInfoSLBean.insertData(ContentInfoSLBean.java:4445)
sun.reflect.GeneratedMethodAccessor803.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.invocation.Invocation.performCall(Invocation.java:359)
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)
org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:77)
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownInterceptor.java:278)
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
org.jboss.ejb.Container.invoke(Container.java:954)
sun.reflect.GeneratedMethodAccessor575.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
org.jboss.proxy.ejb.RetryInterceptor.invoke(RetryInterceptor.java:176)
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
$Proxy112.insertData(Unknown Source)
com.broadvision.data.client.DataManagerImpl.insertData(DataManagerImpl.java:2715)
com.broadvision.data.client.DataManager.insertData(DataManager.java:1859)
my.com.kfh.enterprise.services.GenericBVDataServicesImpl.insertDataSQL(GenericBVDataServicesImpl.java:498)
my.com.kfh.web.utils.IBLogger.logBillPaymentActivity(IBLogger.java:4154)
my.com.kfh.enterprise.services.ib105_billpayment.IBPaymentResultsServices.executeServices(IBPaymentResultsServices.java:756)
my.com.kfh.controller.actions.ib105_billpayment.IBPaymentResultsAction.execute(IBPaymentResultsAction.java:124)
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)
my.com.kfh.web.utils.IBActionServlet.doPost(IBActionServlet.java:81)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
my.com.kfh.web.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:86)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
2011/01/24 09:22:48:672 ERROR kfh.web.utils.IBLogger: Failed to log Bill Payment Activity to IB_BILL_PAYMENT table. Error message[my.com.kfh.error.exception.IBServiceException: ]
2011/01/24 09:22:48:691 ERROR kfh.web.utils.IBLogger: Log dump:-
2011/01/24 09:22:48:710 ERROR kfh.web.utils.IBLogger: USER_ID=826
2011/01/24 09:22:48:729 ERROR kfh.web.utils.IBLogger: TRNX_ID=201101240000078190
2011/01/24 09:22:48:748 ERROR kfh.web.utils.IBLogger: TRNX_TYPE=Bill Payment Registered Payment
2011/01/24 09:22:48:767 ERROR kfh.web.utils.IBLogger: TRNX_DATE=24 Jan 2011 09:22:46
2011/01/24 09:22:48:785 ERROR kfh.web.utils.IBLogger: BILL_ACC_NAME=Bill Account No.
2011/01/24 09:22:48:804 ERROR kfh.web.utils.IBLogger: BILL_ACC_NO=0000323692018
2011/01/24 09:22:48:823 ERROR kfh.web.utils.IBLogger: PAYEE_NAME=Syabas
2011/01/24 09:22:48:842 ERROR kfh.web.utils.IBLogger: EFFECTIVE_DATE=24 Jan 2011 09:22:46
2011/01/24 09:22:48:861 ERROR kfh.web.utils.IBLogger: FROM_ACC_NO=001103001019
2011/01/24 09:22:48:880 ERROR kfh.web.utils.IBLogger: PHX_REFERENCE_NO=1001459819
2011/01/24 09:22:48:898 ERROR kfh.web.utils.IBLogger: REMOTE_IP=210.187.106.2
2011/01/24 09:22:48:917 ERROR kfh.web.utils.IBLogger: STATUS=Successful
2011/01/24 09:22:48:936 ERROR kfh.web.utils.IBLogger: AMOUNT=6
2011/01/24 09:22:48:954 ERROR kfh.web.utils.IBLogger: OTHER1=
2011/01/24 09:22:48:973 ERROR kfh.web.utils.IBLogger: OTHER2=
2011/01/24 09:22:48:991 ERROR kfh.web.utils.IBLogger: PAYEE_CODE=105
2011/01/24 09:22:49:010 ERROR kfh.web.utils.IBLogger: PHXREV_REF_NO=null
2011/01/24 09:22:49:030 ERROR kfh.web.utils.IBLogger: PRODUCT_CODE=SYABAS
2011/01/24 09:22:49:050 ERROR kfh.web.utils.IBLogger: SERVICE_CODE=BILLFAV
2011/01/24 09:22:49:068 ERROR kfh.web.utils.IBLogger: MERCHANT_ACC_NO=01-04-133-01-03-22900501
2011/01/24 09:22:49:087 ERROR kfh.web.utils.IBLogger: MERCHANT=Others
2011/01/24 09:22:49:106 ERROR kfh.web.utils.IBLogger: MERCHANT_REF_NO=null
2011/01/24 09:22:49:124 ERROR kfh.web.utils.IBLogger: MERCHANT_ID=null
2011/01/24 09:22:49:143 ERROR kfh.web.utils.IBLogger: OPERATOR_ID=null
2011/01/24 09:22:49:161 ERROR kfh.web.utils.IBLogger: TERMINAL_ID=null
2011/01/24 09:22:49:180 ERROR kfh.web.utils.IBLogger: RESP_PIN=null
2011/01/24 09:22:49:199 ERROR kfh.web.utils.IBLogger: RESP_PIN_EXP=null
2011/01/24 09:22:49:217 ERROR kfh.web.utils.IBLogger: RESP_CODE=null
2011/01/24 09:22:49:236 ERROR kfh.web.utils.IBLogger: RESP_MSG=null
2011/01/24 09:22:49:255 ERROR kfh.web.utils.IBLogger: TRNX_TRACE_ID=null
2011/01/24 09:22:49:273 ERROR kfh.web.utils.IBLogger: SUB_PRODUCT_CODE=
2011/01/24 09:22:49:292 ERROR kfh.web.utils.IBLogger: INFO2=26146209
2011/01/24 09:22:49:311 ERROR kfh.web.utils.IBLogger: INFO3=0122347422
2011/01/24 09:22:49:329 ERROR kfh.web.utils.IBLogger: CONTACT_NO=
2011/01/24 09:22:49:348 ERROR kfh.web.utils.IBLogger: SI_INDICATOR=1
#4
Updated by Latipah Abdul Rashid over 13 years ago
- Status changed from Pending Prod Deployment to Work Completed-End life cycle
- % Done changed from 90 to 100