Skip to main content

Error when adding a new Bank Holiday in the Admin Tool

In this article, we look at how to fix the 'String or binary data would be truncated' error when adding a new Bank Holiday in the Admin Tool

Y
Written by Yusef Abulaynain
Updated over 5 months ago

Error:
​'String or binary data would be truncated in the table 'DB_NAME.dbo.BANK_HOLIDAYS', column 'CREATED_BY''

The issue has been fixed in Mosaic version 24.1


The MO_WORKERS.SYSTEM_USER_ID database column has length 64 but BANK_HOLIDAYS.CREATED_BY only has a length of 16. As a result, a database error occurs when a worker with a system user id longer than 16 characters attempts to update the bank holiday configuration.
​
The BANK_HOLIDAYS.CREATED_BY column will be extended in a future release.


​

Did this answer your question?