Unable to Schedule Reports/Dashboards for Multiple Recipients (More Than 10) in Helical Insight

Technical queries
, , , ,
#1

Hello,

We are using the open-source BI tool Helical Insight version 5.2.3.2019 GA and are attempting to configure report/dashboard scheduling with multiple email recipients.

When we include more than 10 email IDs in the recipients, the scheduling does not work as expected.

Example:

user1@example.com;user2@example.com;user3@example.com;user4@example.com;user5@example.com;user6@example.com;user7@example.com;user8@example.com;user9@example.com;user10@example.com;user11@example.com;user12@example.com;user13@example.com;user14@example.com;user15@example.com

Could you please suggest if there is any limitation or provide a workaround to support a larger number of recipients?

Thanks,
Netta.

#2

Hello Netta,

This issue occurs due to the column size limitation for storing email recipient information in the Helical Insight backend database.

If you are using Apache Derby as the backend database, you can increase the column size by executing the following command:

image

ALTER TABLE HIUSER.SCHEDULES 
ALTER COLUMN EMAIL_RECIPIENTS 
SET DATA TYPE VARCHAR(10000);

After applying the change, restart the Helical Insight service. In a similar way it can be done for other DB also if you are using any other DB as the backend DB for Helical Insight application DB.

Once the service is restarted, you should be able to schedule reports with a larger number of email recipients successfully

Thanks.