Support #12996
[SCP ID :##6276##] : SESSION EXPIRED AGRONETBIZ : NUR IMANA ENTERPRISE : MY0667972
| Status: | Work Completed-End life cycle | Start date: | May 12, 2022 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | BIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
BIB user initiator and approver unable to initiate and approve transaction with error "You have left the browser idle for more than 5 minutes''. Please login (session expired).
Kindly check as per below details.
Company:
Company Id: 11311
CIF Number: 230811884
Company Name: NUR IMANA ENTERPRISE
Initiator
User ID: 36251
Username: nurimanamaker
Full Name: SITI NUR FATIHA BINTI JAAFAR
Approver
User ID: 36253
Username: nurimanaapprove
Full Name: NOORFAZLIANA BINTI MUHAMAD JAHARI
Timestamp: 11/5/2022 15:40:02
log file can be found at staging server.
History
#1
Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- Assignee changed from Siti Balqis Othman to Zahir Abd Latif
- % Done changed from 0 to 100
Migrated to production on 17/06/2022. Can close this ticket
Finding:
Based on the log given, the DuitNow transaction approved by the approver was successful based on response. However, IB is unable to store sms notifications in IB DB due to the size name being more than 40 characters, which is causing customers to receive session expiration.
Error from log
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
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: 'TENGKU NURUL AISYAH BINTI TENGKU SHAHADA'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1608)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:578)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:508)
Solution:
Added checking on the length of passing customer name and substring it if the length is more than 40.