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

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