B - Production Support » KFH Support

<May 26, 2016 12:33:38 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,'20160526','20160526',null,'Y',null,'N','20160526123338776',null,'N','N',null,null,null,905,'MYR',null,'CK ','105','011050004004','CK ','105','009105000052',100.00,null,null,null,'20160526',null,null,null,'IB FT Intra|LAILINA'AM|HADJIRA @ AZEER|4 Kilos Ikan Bilis|-',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>20160526123338776</ReferenceNo>

    <Version>3.0</Version>

    <TranCode>905</TranCode>

    <ResponseCode>9999</ResponseCode>

  </MsgHeader>

  <MsgBody>

    <Records/>

  </MsgBody>

</Msg>> 

ESB  Phoenix WS Received XML = <Msg><MsgHeader><ServicesID>41</ServicesID><Version>3.0</Version><TranCode>61</TranCode></MsgHeader><MsgBody><Amt1>0</Amt1><ProprietaryATM>Y</ProprietaryATM><ApplType1>RM</ApplType1><Reversal>N</Reversal><MannedDevice>N</MannedDevice><AcctType1>RM</AcctType1><DepLoan></DepLoan><Integer1>0</Integer1><Offline>N</Offline><AcctNo1>668</AcctNo1><UserName>IB</UserName><TranType>6</TranType></MsgBody></Msg>

JNDI: PhoenixDS

exec atm.dbo.psp_ex_main3 41,'20160526','20160526',null,'Y',null,'N','2016052612333937',null,'N','N',null,null,null,61,null,null,'RM','RM','668',null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,'3.0',6,'',null,'IB',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null 

Return Header = {ErrorMessage=, ServicesID=41, ReferenceNo=2016052612333937, Version=3.0, TranCode=61, ResponseCode=0000}