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 UC 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 here:

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

• Username: sa
• Default password: SvBillyBlues$

For SQL 2017 (UC Suite version greater or equal than Summer 2019, up to Spring 2023)

• 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 right credentials

Connect to Imagicle DB and execute the following query:

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

The sample '20,480,000' value can be adjusted as required:

1,024,000 - means 1 MB attachment

5,120,000 - means 5 MB attachment