Task #1099
CASE: HD00011640 - GIA Placement CMS - Clients Account
| Status: | Closed - End of life cycle | Start date: | August 11, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Sarinah Darsy | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Dear IT Team / Penril,
Pls check the following transaction failure for CMS customer on GIA Placement.
CMS CUSTOMER (JOHARI & ZELIKA) USING HIS "CLIENTS ACCOUNT" FAILED TO PERFORM GIA PLACEMENT FOR 3 TIMES. HE DID 3 GIA PLACEMENT FROM OTHER ACCOUNTS WERE SUCCESSFUL. PLS ASSIST.
History
#1
Updated by Sarinah Darsy about 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 50
Found the error which is 'An escape sequence in a SQL Query was malformed'.
Seems like our SP return user name with aphosthrophy (') symbol to phoenix which is JOHARI & ZELIKA (CLIENTS' ACCOUNT). But need confirmation from KFH IT team whether taht is the caused.
ESB Phoenix WS Received XML = <Msg><MsgHeader/><MsgBody><OpeningAmt>10000.00</OpeningAmt><BranchNo>9</BranchNo><EffectiveDate>2011-08-09</EffectiveDate><RimNo>10212</RimNo><ClassCode>051</ClassCode><Period>Month(s)</Period><MaturityMethod>AutoRenew</MaturityMethod><InterfaceName>Mosaic</InterfaceName><AcctType>104</AcctType><EmplName>Phoenix</EmplName><TranCode>TCD</TranCode><CustomerName>JOHARI & ZELIKA (CLIENTS' ACCOUNT)</CustomerName><EmplID>878</EmplID><ChannelID>1</ChannelID><Term>001</Term></MsgBody></Msg>
m_oHeader: {}
m_oBody : {OpeningAmt=10000.00, BranchNo=9, EffectiveDate=2011-08-09, RimNo=10212, ClassCode=051, Period=Month(s), MaturityMethod=AutoRenew, InterfaceName=Mosaic, AcctType=104, EmplName=Phoenix, TranCode=TCD, CustomerName=JOHARI & ZELIKA (CLIENTS' ACCOUNT), EmplID=878, Term=001, ChannelID=1}
m_sTranCode = TCD
JNDI: PhoenixDS
exec atm..atm_tpi_processing '''D'',''mosaic'',''Phoenix'',''2011-08-09'',''ANYTHING'',''JOHARI & ZELIKA (CLIENTS' ACCOUNT)'',NULL,null','878,9,1,NULL','CUS ''S'',NULL,NULL,NULL,NULL,NULL,10212','DEP ''A'',''104'',null,051,NULL,9,NULL,878,NULL,NULL, NULL,null,NULL, NULL,10000.00,NULL, NULL,001,''Month(s)'',NULL,null,''AutoRenew'',','NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,','NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,''Y'',NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL'
<Aug 9, 2011 10:59:34 AM 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..atm_tpi_processing('''D'',''mosaic'',''Phoenix'',''2011-08-09'',''ANYTHING'',''JOHARI & ZELIKA (CLIENTS' ACCOUNT)'',NULL,null','878,9,1,NULL','CUS ''S'',NULL,NULL,NULL,NULL,NULL,10212','DEP ''A'',''104'',null,051,NULL,9,NULL,878,NULL,NULL, NULL,null,NULL, NULL,10000.00,NULL, NULL,001,''Month(s)'',NULL,null,''AutoRenew'',','NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,','NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,''Y'',NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL')}'.</ErrorMessage>
<ResponseCode>9999</ResponseCode>
</MsgHeader>
<MsgBody>
<Records/>
</MsgBody>
</Msg>>
#2
Updated by Sarinah Darsy about 13 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- % Done changed from 50 to 100
KFHIT confirms it because the customer name has an asphostrophy symbols.
And KFHIT reverted their side (phoenix) need to do changes on the customer name value to remove the aphostrophy symbol in phoenix.
Pending on the customer feedback
#3
Updated by Norhaidah Md Dasuki over 10 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Updated by Vincent. No other issue reported by customer. Issue closed.