Bug #844
Bulkpayment bug on sundays migration (10/04/2011)
| Status: | Closed - End of life cycle | Start date: | April 20, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | April 21, 2011 | |
| Assignee: |  Sarinah Darsy | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Found on the sundays' migration which already reverted because the migration is unsuccessful.
The unsuccessful error caused by Trigger gone and found bug on the bulkpayment module where user input single quote on the field batch_id, batch_name & customer name.
and the error as following:
2011/04/08 03:31:00:597 ERROR kfhbib.error.exception.IBBusinessException: [0000] Service is currently unavailable.
2011/04/08 03:31:02:859 ERROR kfhbib.error.exception.IBBusinessException: [0000] Service is currently unavailable.
2011/04/08 03:31:13:419 ERROR kfhbib.hibernate.utils.HibernateBulkPaymentUtils: Error code : 0000
2011/04/08 03:31:13:419 ERROR kfhbib.hibernate.utils.HibernateBulkPaymentUtils: Error details : Parameter serviceType does not exist as a named parameter in [select {a.},{p.*},{r.*},{b.*},{c.*},{g.*} from BIB_BULK_PAYMENT_DETAIL a join BIB_BULK_PAYMENT p on p.BATCH_ID=a.BATCH_ID left join RENTAS_DETAIL r on r.oid=a.trnx_id left join INTRABANK_BULK b on b.oid=a.trnx_id left join IBG_BULK g on g.oid=a.trnx_id left join BIB_COMPANY_TRANSACTION c on c.trnx_id=a.BATCH_ID AND c.ACTION_STATUS='4' where 3>1 AND ( p.FROM_ACCOUNT_NO = 001105013079 OR p.FROM_ACCOUNT_NO = 001105013087 OR 1337<1) AND p.BATCH_ID like '%'' AND p.SERVICE_TYPE = :serviceType AND p.BATCH_NAME like '%'%' order by a.TRNX_ID desc ]*
Exception class : org.hibernate.impl.AbstractQueryImpl, class method : setParameter, line number : 380org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:380)
org.hibernate.impl.AbstractQueryImpl.setString(AbstractQueryImpl.java:667)
my.com.kfhbib.hibernate.utils.HibernateBulkPaymentUtils.getBulkPaymentGeneric(HibernateBulkPaymentUtils.java:230)
my.com.kfhbib.hibernate.utils.HibernateBulkPaymentUtils.getBulkPayment(HibernateBulkPaymentUtils.java:92)
my.com.kfhbib.enterprise.services.bib106_bulkpayment.IBBulkPaymentSearchResultsServices.getCriteriaAndSearch(IBBulkPaymentSearchResultsServices.java:239)
my.com.kfhbib.enterprise.services.bib106_bulkpayment.IBBulkPaymentSearchResultsServices.getSearchData(IBBulkPaymentSearchResultsServices.java:90)
my.com.kfhbib.controller.actions.bib106_bulkpayment.IBBulkPaymentSearchResultsAction.execute(IBBulkPaymentSearchResultsAction.java:121)
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.kfhbib.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.kfhbib.web.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:95)
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)
History
#1
Updated by Sarinah Darsy over 13 years ago
- Status changed from New - Begin Life Cycle to Internal Testing
- % Done changed from 0 to 100
added validation on the fields (batch id, batch name & customer name) to handle specialCharacter input.
and clean up method getBulkPaymentGeneric() in HibernateBulkPaymentUtils that have duplicated function.
Fixed and branch created into mercurial directory;
https://hub.penril.net/hg/kfh/branch/BulkPaymentSearch_SingleQoute/kfh_bib/
#2
Updated by Tan Lee Yong almost 13 years ago
- Status changed from Internal Testing to Closed - End of life cycle
too old