Checking for volatile data source connections

Volatile data source is a configuration setting that checks the data connections in a connection pool for the scheduled time period and frequency. If the data connection is unavailable, but gets restored during the configured time period, all the tasks that were performed during this period and were interrupted, such as report execution, broadcasts and so on are executed. For example, consider that you have configured the volatile data source that checks the data connectivity every 3 seconds for a period of 30 minutes. If you have a scheduled broadcast that runs daily at 9 a.m., and the data connection is unavailable at that time, the broadcast remains in the Running status. The volatile data source monitors the data connection for 3 seconds. If the connection restores, the broadcast is executed, else the volatile data source monitors the data connection for next 3 seconds. This process continues till the data connection is restored within the configured time, in this case, for 30 minutes. If not, the scheduled broadcast fails for that day.

To enable volatile data sources

1. To enable volatile data sources, run the following query in the Remedy Smart Reporting database:
   
   

   INSERT INTO Configuration (iporg, configtypecode, configcode, configdata) 
   VALUES (1, 'SYSTEM', 'VOLATILESOURCES', 'TRUE');

2. To set the frequency in milliseconds for checking the data connectivity, run the following query in the Remedy Smart Reporting database:
   
   

   INSERT INTO Configuration (iporg, configtypecode, configcode, configdata) 
   VALUES (1, 'SYSTEM', 'VOLATILETIMEOUT', '3000');

3. To set the number of retries for checking the data source connectivity, run the following query in the Remedy Smart Reporting database:

   INSERT INTO Configuration (iporg, configtypecode, configcode, configdata) 
   VALUES (1, 'SYSTEM', 'VOLATILERETRIES', '600');

4. Restart the Remedy Smart Reporting service.
   This enables the volatile data source capability.