How to modify the Scheduled Reports attachment size limit

Applies to:

Call Analytics Standard/Enterprise

Description:

How to modify the attachment size in the scheduled reports

Solution:

Launch HeidiSQL tool, included into Imagicle UCX Suite file system.
You find this tool at this path <StonevoiceAS>\TroubleShooting\HeidiSQL

To access to the database for local SQL instances (default state) the credentials are reported below:

For SQL 2008 (UCX Suite version less or equal than Summer 2019):

Username: sa
Default password: SvBillyBlues$

For SQL 2017 (UCX Suite version greater or equal than Summer 2019)

Username: sa
Default password:SvB1llyBlues$

For any other SQL versions, or if the defaults has been changed, please check with the database administrator for the correct credentials.

Connect to Imagicle DB and execute the following query:

CODE

DELETE FROM opzioni WHERE sEntry = 'LimiteAllegatiMail'
insert into opzioni (sSection,sEntry,sValue) VALUES ('Configurazione','LimiteAllegatiMail','20480000')

Above sample’s “20,480,000” value can be adjusted as required:

1,024,000 - means 1 MB attachment

5,120,000 - means 5 MB attachment

10,240,000 - means 10 MB attachment

Values should be added without commas.

A value too high might overload the email server. Please ask your IT manager about maximum allowed email attachment size.

To apply the changes, please reboot Imagicle UCX Suite server.

IMPORTANT: Starting from Imagicle 2023.Spring.1 release, MS-SQL Server 2008/2008R2 is supported only for updating an existing installation to Spring 2023, but you can't deploy a new Imagicle instance with such old MS-SQL version. Starting from 2023.Summer.1 release, MS-SQL 2008/2008R2 is not supported anymore and therefore a MS-SQL update is mandatory.