Support #13117
[SCP ID :##6365##] : Company Records failed to Upload and Core Banking Real Time inquiry didn;t populate correctly.
Status: | Work Completed-End life cycle | Start date: | July 22, 2022 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
1) Company record issue in the logs
2) Core Banking Screenshot
History
#1 Updated by Tan Lee Yong about 2 years ago
- Assignee changed from Najmi Pasarudin to Siti Nursyahira Suhaimi
Yaya, please try to look into this issue
#2 Updated by Siti Nursyahira Suhaimi about 2 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#3 Updated by Siti Nursyahira Suhaimi about 2 years ago
- Status changed from Development / Work In Progress to Finished Development
- % Done changed from 0 to 90
1) Company record
Root Cause:
On CUSTODY.STOCK_COMPANY table we found a unique constraint on the COUNTER column.
First 20 characters each line that will be used as COUNTER column, but those first 20 characters have been detected BLANK and Duplicates on certain lines.
Findings:
Based on, company.txt file that attempt to upload, I found 37 BLANK and 1 Duplicate data on the first 20 characters on the COUNTER column.
These are the lines of the data that you can refer to:
BLANK - 4011,4048,4049,4084,4110,4123,4125,4127,4129,4156,4157,4164,4168,4184,4214,4216,4217,4230,4274,
4278,4279,4315,4338,4363,4481,4483,4506,4539,4878,5299,5705,5855,5941,5964,6118,8202,8203.
Duplicates - 9596,14190
image.png
2) Core Banking
Root Cause:
The host response code should return a 3 digit value in form 001 - 025 for Source Code and 001 - 006 for Post Status
But based on log, the host returns blank.
Findings:
Refer to custody_1.out log provided, on line 260271, the <SrCode> and <PostStat>, the response values are empty and '...' value.
#4 Updated by Siti Nursyahira Suhaimi about 2 years ago
- File ecustody-production-fix-2022-07-27.zip added
- % Done changed from 90 to 100
Patch adding condition, if null or empty the whole row is not to be displayed.
#5 Updated by Najmi Pasarudin 8 months ago
- Status changed from Finished Development to Development / Work In Progress
#6 Updated by Najmi Pasarudin 8 months ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- Assignee changed from Siti Nursyahira Suhaimi to Zahir Abd Latif
Patch given to client. Last email on 27/7/2023 titled : Company Records failed to Upload and Core Banking Real Time inquiry didn;t populate correctly.