Support #8844

SCP ID :##4780##] : IBG ERROR (over the counter) - 0712018

Added by Zahir Abd Latif almost 6 years ago. Updated almost 6 years ago.

Status:Closed - End of life cycleStart date:November 07, 2018
Priority:HighDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY IBGSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Please help to check on unable to perform IBG transactions to CITIBANK from over the counter (branch)
Error as per attached.

IMG-20181107-WA0016.jpg (71.9 KB) Zahir Abd Latif, November 07, 2018 16:54

History

#2 Updated by Zahir Abd Latif almost 6 years ago

  • Status changed from New - Begin Life Cycle to Pending Customer Feedback
  • Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
  • % Done changed from 0 to 100

Chee Ping, Nov 8, 2018 10:12 AM:-

This problem is caused by there is ‘ (apostrophe) in payment ref, which will getting error when calling the stored procedure. You may refer to error below. In order to solve this problem please ask branch to remove the ‘ (apostrophe) in payment ref field.

####<Nov 7, 2018 3:25:52 PM MYT> <Debug> <ALSB Logging> <kfhib05> <ALSBServer> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1541575552971> <000000> < [Logging, Logging_request, Inbound Logging, REQUEST] <Msg>
<MsgHeader>
<ServicesID>800</ServicesID>
<Version>3.0</Version>
<TranCode>905</TranCode>
</MsgHeader>
<MsgBody>
<TranType>1</TranType>
<PhoenixTC>152</PhoenixTC>
<Description>OTC IBG:WESTERN UNION PAYMEN, KFH PROCESSING 05112, 21220 Workers' remit</Description>
<ApplType1>CK</ApplType1>
<AcctType1>105</AcctType1>
<AcctNo1>001105018356</AcctNo1>
<ISOCurrency>MYR</ISOCurrency>
<ApplType2>GL</ApplType2>
<AcctType2>102</AcctType2>
<AcctNo2>01-10-152-01-08-22001501</AcctNo2>
<ISOCurrency2>MYR</ISOCurrency2>
<Date1>20181107</Date1>
<Amt1>18487.20</Amt1>
<MannedDevice>N</MannedDevice>
<BranchNo>1</BranchNo>
<ProprietaryATM>Y</ProprietaryATM>
<Reversal>N</Reversal>
<DepLoan>DP</DepLoan>
<Debug>0</Debug>
<Offline>N</Offline>
</MsgBody>
</Msg>>
####<Nov 7, 2018 3:25:53 PM MYT> <Error> <ALSB Logging> <kfhib05> <ALSBServer> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1541575553013> <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(800,'20181107','20181107',null,'Y',null,'N','20181107152552991',null,'N','N',null,null,null,905,'MYR',null,'CK','105','001105018356','GL','102','01-10-152-01-08-22001501',18487.20,null,null,null,'20181107',null,null,null,'OTC IBG:WESTERN UNION PAYMEN, KFH PROCESSING 05112, 21220 Workers' remit',null,null,null,'3.0',1,'DP',null,null,1,null,null,null,'MYR',null,null,null,null,null,null,null,152,null,null,null,null,null,null,null,null,null,null,null,0)}'.</ErrorMessage>
<ServicesID>800</ServicesID>
<ReferenceNo>20181107152552991</ReferenceNo>
<Version>3.0</Version>
<TranCode>905</TranCode>
<ResponseCode>9999</ResponseCode>
</MsgHeader>
<MsgBody>
<Records/>
</MsgBody>
</Msg>>

#3 Updated by Zahir Abd Latif almost 6 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle

Issue closed in SCP.

Also available in: Atom PDF