-------------
<Jun 10, 2015 3:10:52 PM MYT> <Error> <ALSB Logging> <000000> < [Logging, Logging_response, Outbound Error Logging, RESPONSE] <Msg>
  <MsgHeader>
    <ErrorMessage/>
    <ServicesID>41</ServicesID>
    <ReferenceNo>20150610151052323</ReferenceNo>
    <Version>3.0</Version>
    <TranCode>100</TranCode>
    <ResponseCode>0000</ResponseCode>
  </MsgHeader>
  <MsgBody>
    <Records>
      <Record>
        <Status>Active</Status>
        <Acct_Desc/>
        <No_Signatures>1</No_Signatures>
        <Last_Dep_Dt>2015-06-05 00:00:00.0</Last_Dep_Dt>
        <PB_Credits>0.000000</PB_Credits>
        <Int_Pd_Lst_Yr>0.000000</Int_Pd_Lst_Yr>
        <Last_WD_Amt>100.000000</Last_WD_Amt>
        <Issue_Dt/>
        <RSM_Name>R00P000000-Staff</RSM_Name>
        <Customer_Type>P</Customer_Type>
        <Int_Ytd>0.000000</Int_Ytd>
        <PB_Balance>0.000000</PB_Balance>
        <NSF_Items_Pending>N</NSF_Items_Pending>
        <Last_Dep_Amt>800.000000</Last_Dep_Amt>
        <Title_1>WONG HUI KHENG</Title_1>
        <Acct_Avail>367.120000</Acct_Avail>
        <Memo_Net>0.000000</Memo_Net>
        <RSM_ID>573</RSM_ID>
        <Avail_LOC_Bal>0.000000</Avail_LOC_Bal>
        <Cur_Bal>367.120000</Cur_Bal>
        <Trm/>
        <Mat_Dt/>
        <Last_WD_Dt>2015-06-09 00:00:00.0</Last_WD_Dt>
        <Memo_Float>0.000000</Memo_Float>
        <PB_Debits>21.000000</PB_Debits>
        <Hold_Bal>0.000000</Hold_Bal>
        <Rim_No>1625</Rim_No>
        <PB_Last_Line>0</PB_Last_Line>
        <Ucf_Amt>0.000000</Ucf_Amt>
        <PB_Discrepancy_Date>1901-01-01 00:00:00.0</PB_Discrepancy_Date>
        <Class_Description>KFH SAVINGS ACCOUNT-i (STAFF)</Class_Description>
        <Orig_Amt/>
        <Period/>
        <Current_Rate_Tier/>
        <IBA_Cr>N</IBA_Cr>
        <Class_Code>10</Class_Code>
        <ISO_Currency>MYR</ISO_Currency>
        <Branch_No>1</Branch_No>
        <Available_Bal>367.120000</Available_Bal>
        <IBAN/>
        <Title_2/>
        <Passbook>N</Passbook>
        <Cur_Bal_Begin>367.120000</Cur_Bal_Begin>
      </Record>
    </Records>
  </MsgBody>
</Msg>> 
JNDI: PhoenixDS
Branch Code query: {call crystal.dbo.getbranchcode('001102012596')}
JNDI: PhoenixDS
Branch Code query: {call crystal.dbo.getbranchcode('001102007312')}
JNDI: PhoenixDS
Branch Code query: {call crystal.dbo.getbranchcode('001102012596')}
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>
JNDI: PhoenixDS
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 
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}
<Jun 10, 2015 3:10:52 PM MYT> <Error> <ALSB Logging> <000000> < [Logging, Logging_response, Outbound Error Logging, RESPONSE] <Msg>
  <MsgHeader>
    <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>
    <ServicesID>41</ServicesID>
    <ReferenceNo>20150610151052894</ReferenceNo>
    <Version>3.0</Version>
    <TranCode>905</TranCode>
    <ResponseCode>9999</ResponseCode>
  </MsgHeader>
  <MsgBody>
    <Records/>
  </MsgBody>
</Msg>> 
--------------------
2015/06/10 17:28:48:347 ERROR kfh.hibernate.utils.HibernateTACUtils: Error code : 0000
2015/06/10 17:28:48:370 ERROR kfh.hibernate.utils.HibernateTACUtils: Error details : could not execute query
Exception class : org.hibernate.exception.SQLStateConverter, class method : handledNonSpecificException, line number : 126org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2231)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
org.hibernate.loader.Loader.list(Loader.java:2120)
org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
my.com.kfh.hibernate.utils.HibernateTACUtils.getUserTacSvrInfo(HibernateTACUtils.java:46)
my.com.kfh.enterprise.services.GenericIBAuthenticationServicesImpl.userGenerateTac(GenericIBAuthenticationServicesImpl.java:702)
my.com.kfh.enterprise.services.ib106_utility.IBTACRequestServices.requestTAC(IBTACRequestServices.java:139)
my.com.kfh.controller.actions.ib106_utility.IBTACRequestAction.execute(IBTACRequestAction.java:70)
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.doGet(ActionServlet.java:507)
my.com.kfh.web.utils.IBActionServlet.doGet(IBActionServlet.java:63)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
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)

2015/06/10 17:30:08:807 ERROR kfh.error.exception.IBBusinessException: [0000] Service is currently unavailable.
------