Support #4219
[Request ID :##2079##] : Prod Issue - HD00014945 - Unavailable IB Registration Report dated 13.3.14 from BVMC
| Status: | Work Completed-End life cycle | Start date: | March 17, 2014 | |
|---|---|---|---|---|
| Priority: | Urgent | Due date: | ||
| Assignee: |  Nor Shuhaida Subri | % Done: | 0% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Customer reported that the IB Registration Report dated 13.3.14 was unavailable for retrieval from BVMC
History
#1
Updated by Nor Shuhaida Subri over 10 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
Due to acc_crt_date null.
acc_crt_date is retrieve from esb.
Somehow, acc creation date not available for financing account.
Interim solution we proceed to provid kfh the script to manually insert the date into acc_crt_date
Script to update the acc_crt_date field.
Please run this script under BVUSERPRD schema
UPDATE ib_registration SET acc_crt_dt='13-March-14' WHERE trnx_id='201403130001265883';
commit;
No server restart required for this action.
After implement the script. Server Admin can proceed to generate the IB Registration Report manually.
Go export/home/bvadmin/IBUtils
run command ./runReport.sh
choose option 2. Generate a single report
and than proceed with option 5. IB Registration Report
enter the correct date format
Input your option: 13032014
#2
Updated by Nor Shuhaida Subri over 10 years ago
- Status changed from Pending Customer Feedback to Work Completed-End life cycle
IT KFH Regen the report:-
We had re-generate the report as per Penril instruction.
No error occurred after re-generate. Please verify
User report:-
Upon checking at BVMC,
the IB Registration Report dated 13.3.14 is available for retrieval now.