1
|
-------------
|
2
|
<Jun 10, 2015 3:10:52 PM MYT> <Error> <ALSB Logging> <000000> < [Logging, Logging_response, Outbound Error Logging, RESPONSE] <Msg>
|
3
|
<MsgHeader>
|
4
|
<ErrorMessage/>
|
5
|
<ServicesID>41</ServicesID>
|
6
|
<ReferenceNo>20150610151052323</ReferenceNo>
|
7
|
<Version>3.0</Version>
|
8
|
<TranCode>100</TranCode>
|
9
|
<ResponseCode>0000</ResponseCode>
|
10
|
</MsgHeader>
|
11
|
<MsgBody>
|
12
|
<Records>
|
13
|
<Record>
|
14
|
<Status>Active</Status>
|
15
|
<Acct_Desc/>
|
16
|
<No_Signatures>1</No_Signatures>
|
17
|
<Last_Dep_Dt>2015-06-05 00:00:00.0</Last_Dep_Dt>
|
18
|
<PB_Credits>0.000000</PB_Credits>
|
19
|
<Int_Pd_Lst_Yr>0.000000</Int_Pd_Lst_Yr>
|
20
|
<Last_WD_Amt>100.000000</Last_WD_Amt>
|
21
|
<Issue_Dt/>
|
22
|
<RSM_Name>R00P000000-Staff</RSM_Name>
|
23
|
<Customer_Type>P</Customer_Type>
|
24
|
<Int_Ytd>0.000000</Int_Ytd>
|
25
|
<PB_Balance>0.000000</PB_Balance>
|
26
|
<NSF_Items_Pending>N</NSF_Items_Pending>
|
27
|
<Last_Dep_Amt>800.000000</Last_Dep_Amt>
|
28
|
<Title_1>WONG HUI KHENG</Title_1>
|
29
|
<Acct_Avail>367.120000</Acct_Avail>
|
30
|
<Memo_Net>0.000000</Memo_Net>
|
31
|
<RSM_ID>573</RSM_ID>
|
32
|
<Avail_LOC_Bal>0.000000</Avail_LOC_Bal>
|
33
|
<Cur_Bal>367.120000</Cur_Bal>
|
34
|
<Trm/>
|
35
|
<Mat_Dt/>
|
36
|
<Last_WD_Dt>2015-06-09 00:00:00.0</Last_WD_Dt>
|
37
|
<Memo_Float>0.000000</Memo_Float>
|
38
|
<PB_Debits>21.000000</PB_Debits>
|
39
|
<Hold_Bal>0.000000</Hold_Bal>
|
40
|
<Rim_No>1625</Rim_No>
|
41
|
<PB_Last_Line>0</PB_Last_Line>
|
42
|
<Ucf_Amt>0.000000</Ucf_Amt>
|
43
|
<PB_Discrepancy_Date>1901-01-01 00:00:00.0</PB_Discrepancy_Date>
|
44
|
<Class_Description>KFH SAVINGS ACCOUNT-i (STAFF)</Class_Description>
|
45
|
<Orig_Amt/>
|
46
|
<Period/>
|
47
|
<Current_Rate_Tier/>
|
48
|
<IBA_Cr>N</IBA_Cr>
|
49
|
<Class_Code>10</Class_Code>
|
50
|
<ISO_Currency>MYR</ISO_Currency>
|
51
|
<Branch_No>1</Branch_No>
|
52
|
<Available_Bal>367.120000</Available_Bal>
|
53
|
<IBAN/>
|
54
|
<Title_2/>
|
55
|
<Passbook>N</Passbook>
|
56
|
<Cur_Bal_Begin>367.120000</Cur_Bal_Begin>
|
57
|
</Record>
|
58
|
</Records>
|
59
|
</MsgBody>
|
60
|
</Msg>>
|
61
|
JNDI: PhoenixDS
|
62
|
Branch Code query: {call crystal.dbo.getbranchcode('001102012596')}
|
63
|
JNDI: PhoenixDS
|
64
|
Branch Code query: {call crystal.dbo.getbranchcode('001102007312')}
|
65
|
JNDI: PhoenixDS
|
66
|
Branch Code query: {call crystal.dbo.getbranchcode('001102012596')}
|
67
|
ESB Phoenix WS Received XML = <Msg><MsgHeader><ServicesID>41</ServicesID><Version>3.0</Version><TranCode>905</TranCode></MsgHeader><MsgBody><ApplType1>SV </ApplType1><AcctNo2>001102012596</AcctNo2><MannedDevice>N</MannedDevice><ISOCurrency2>MYR</ISOCurrency2><AcctType1>102</AcctType1><BranchNo>1</BranchNo><Date1>20150610</Date1><AcctNo1>001102007312</AcctNo1><TranType>1</TranType><PhoenixTC>163</PhoenixTC><Amt1>41.25</Amt1><ProprietaryATM>Y</ProprietaryATM><Description>IB FT Intra|WONG HUI K|NOR JULIANA BIN|Muna's farewell|-</Description><Reversal>N</Reversal><ISOCurrency>MYR</ISOCurrency><AcctType2>102</AcctType2><DepLoan>DP</DepLoan><Debug>0</Debug><Offline>N</Offline><ApplType2>SV </ApplType2></MsgBody></Msg>
|
68
|
JNDI: PhoenixDS
|
69
|
exec atm.dbo.psp_ex_main3 41,'20150610','20150610',null,'Y',null,'N','20150610151052894',null,'N','N',null,null,null,905,'MYR',null,'SV ','102','001102007312','SV ','102','001102012596',41.25,null,null,null,'20150610',null,null,null,'IB FT Intra|WONG HUI K|NOR JULIANA BIN|Muna's farewell|-',null,null,null,'3.0',1,'DP',null,null,1,null,null,null,'MYR',null,null,null,null,null,null,null,163,null,null,null,null,null,null,null,null,null,null,null,0
|
70
|
Return Header = {ErrorMessage=JZ0S8: An escape sequence in a SQL Query was malformed: '{call atm.dbo.psp_ex_main3(41,'20150610','20150610',null,'Y',null,'N','20150610151052894',null,'N','N',null,null,null,905,'MYR',null,'SV ','102','001102007312','SV ','102','001102012596',41.25,null,null,null,'20150610',null,null,null,'IB FT Intra|WONG HUI K|NOR JULIANA BIN|Muna's farewell|-',null,null,null,'3.0',1,'DP',null,null,1,null,null,null,'MYR',null,null,null,null,null,null,null,163,null,null,null,null,null,null,null,null,null,null,null,0)}'., ServicesID=41, ReferenceNo=20150610151052894, Version=3.0, TranCode=905, ResponseCode=9999}
|
71
|
<Jun 10, 2015 3:10:52 PM MYT> <Error> <ALSB Logging> <000000> < [Logging, Logging_response, Outbound Error Logging, RESPONSE] <Msg>
|
72
|
<MsgHeader>
|
73
|
<ErrorMessage>JZ0S8: An escape sequence in a SQL Query was malformed: '{call atm.dbo.psp_ex_main3(41,'20150610','20150610',null,'Y',null,'N','20150610151052894',null,'N','N',null,null,null,905,'MYR',null,'SV ','102','001102007312','SV ','102','001102012596',41.25,null,null,null,'20150610',null,null,null,'IB FT Intra|WONG HUI K|NOR JULIANA BIN|Muna's farewell|-',null,null,null,'3.0',1,'DP',null,null,1,null,null,null,'MYR',null,null,null,null,null,null,null,163,null,null,null,null,null,null,null,null,null,null,null,0)}'.</ErrorMessage>
|
74
|
<ServicesID>41</ServicesID>
|
75
|
<ReferenceNo>20150610151052894</ReferenceNo>
|
76
|
<Version>3.0</Version>
|
77
|
<TranCode>905</TranCode>
|
78
|
<ResponseCode>9999</ResponseCode>
|
79
|
</MsgHeader>
|
80
|
<MsgBody>
|
81
|
<Records/>
|
82
|
</MsgBody>
|
83
|
</Msg>>
|
84
|
--------------------
|
85
|
2015/06/10 17:28:48:347 ERROR kfh.hibernate.utils.HibernateTACUtils: Error code : 0000
|
86
|
2015/06/10 17:28:48:370 ERROR kfh.hibernate.utils.HibernateTACUtils: Error details : could not execute query
|
87
|
Exception class : org.hibernate.exception.SQLStateConverter, class method : handledNonSpecificException, line number : 126org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
|
88
|
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
|
89
|
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
|
90
|
org.hibernate.loader.Loader.doList(Loader.java:2231)
|
91
|
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
|
92
|
org.hibernate.loader.Loader.list(Loader.java:2120)
|
93
|
org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
|
94
|
org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)
|
95
|
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
|
96
|
org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
|
97
|
my.com.kfh.hibernate.utils.HibernateTACUtils.getUserTacSvrInfo(HibernateTACUtils.java:46)
|
98
|
my.com.kfh.enterprise.services.GenericIBAuthenticationServicesImpl.userGenerateTac(GenericIBAuthenticationServicesImpl.java:702)
|
99
|
my.com.kfh.enterprise.services.ib106_utility.IBTACRequestServices.requestTAC(IBTACRequestServices.java:139)
|
100
|
my.com.kfh.controller.actions.ib106_utility.IBTACRequestAction.execute(IBTACRequestAction.java:70)
|
101
|
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
|
102
|
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
|
103
|
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
|
104
|
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
|
105
|
my.com.kfh.web.utils.IBActionServlet.doGet(IBActionServlet.java:63)
|
106
|
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
|
107
|
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
|
108
|
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
|
109
|
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
110
|
my.com.kfh.web.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:86)
|
111
|
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
|
112
|
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
113
|
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
|
114
|
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
|
115
|
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
116
|
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
|
117
|
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
|
118
|
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
|
119
|
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
|
120
|
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
|
121
|
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
|
122
|
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
|
123
|
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
|
124
|
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
|
125
|
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
|
126
|
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
|
127
|
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
|
128
|
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
|
129
|
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
|
130
|
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
|
131
|
java.lang.Thread.run(Thread.java:595)
|
132
|
|
133
|
2015/06/10 17:30:08:807 ERROR kfh.error.exception.IBBusinessException: [0000] Service is currently unavailable.
|
134
|
------
|
135
|
|