Support #12875
[SCP ID :##6209##] : SMS truncated
Status: | Work Completed-End life cycle | Start date: | March 21, 2022 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | BIB | Spent time: | - | |
Target version: | - |
Description
Hi Balqis,
Kindly attend below request.
We found below error while review BIB log file. Please help to check. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'agroib_db.prod.dbo.SMS_TABLE', column 'SMS_CUST_NAME'. Truncated value: 'MUHAMMAD ABDURRAHMAN AN NUR BIN MOHD HIZ'. Log file: \\172.16.49.7\prod logs\VPIBKA01\BIB1\210322 \\172.16.49.7\prod logs\VPIBKA02\BIB1\210322
Thank you.
History
#1 Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Finished Development
- % Done changed from 0 to 100
Reported issue:
The customer received session expired when redirected to the fund transfer module result page.
Root cause:
Based on the log, the session expired happened due to IB unable to save the customer name into column SMS_CUST_NAME at table SMS_TABLE.
After further investigation, the passing corporate contact name character length is more than 40 which is more than allowable length.
Solution:
Added checking on the length of passing customer name and substring it if the length is more than 40.
#2 Updated by Siti Balqis Othman over 2 years ago
- Status changed from Finished Development to Development / Work In Progress
#3 Updated by Siti Balqis Othman over 2 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- Assignee changed from Siti Balqis Othman to Zahir Abd Latif
Migrated to production on 17/06/2022. Can close this ticket