Support #11488
[SCP ID :##5719##] : IB Transaction Enquiry Report
| Status: | Closed - End of life cycle | Start date: | January 11, 2021 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY CORUS | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Kindly assist to check IB Transaction Enquiry at Corus Report is unavailable to view after click "View Report".
datetime : 7/1/2021, 1:5PM
History
#1
Updated by Zahir Abd Latif over 3 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Kah Yan, Jan 11, 2021 05:32 PM:-
We have fixed this issue and the patch is at \\10.20.8.35\Internet Banking\20200111_5719_IB_Transaction_Enquiry_Report Root Cause: invalid identifier Solution: To use the correct column name. Kindly refer to below logs for more info. nohup1 15:50:16,431 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2231) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) at my.com.cst.hibernate.utils.HBGenericUtils.getIBTrnxHistory(HBGenericUtils.java:370) at my.com.cst.enterprise.services.cst105_trnx_history.CSTTrnxHistoryReportServices.getRowList(CSTTrnxHistoryReportServices.java:120) ... Caused by: java.sql.SQLException: ORA-00904: "A"."CREATIONDATE": invalid identifier 15:54:25,237 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2231) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) at my.com.cst.hibernate.utils.HBGenericUtils.getIBTrnxHistory(HBGenericUtils.java:370) at my.com.cst.enterprise.services.cst105_trnx_history.CSTTrnxHistoryReportServices.getRowList(CSTTrnxHistoryReportServices.java:120) ... Caused by: java.sql.SQLException: ORA-00904: "A"."CREATIONDATE": invalid identifier
#2
Updated by Zahir Abd Latif over 3 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.