Overview
This article provides the solution to an issue you may encounter when generating a Storage Use report which fails with the following error being logged in ..\Store\Debuglogs\EmailMessageProvider.log
:
"error ","EmailMessageProvider","error: (FB) RptEmailStorage() - arithmetic exception, numeric overflow, or string truncation ;string right truncation ;At procedure 'RPTEMAILSTORAGEFA' line: 32, col: 19"
Information
This issue is caused by attachments which have a name of more than 255 characters. To identify this issue, run the following query against the database(s). If any rows are returned, the issue is confirmed:
SELECT * FROM ARC_ATT
WHERE STRLEN(filename) > 255
Process
WARNING: Before running the query below, create a backup of the Archive Stores (especially the databases).
Use this query to truncate file names to 255 characters:
UPDATE ARC_ATT
SET filename = SUBSTRING(fileName from 1 for 255)
WHERE STRLEN(filename) >= 256