Support #12875

[SCP ID :##6209##] : SMS truncated

Added by Nurul Akmal over 2 years ago. Updated over 2 years ago.

Status:Work Completed-End life cycleStart date:March 21, 2022
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:BIBSpent 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

Also available in: Atom PDF