Maintenance Process 


Archive Process will delete the old report processes from the database and their related outputs from tmp directory on the server thereby increasing the  efficiency of the system. While deleting the report processes data, it archives basic information of the process that can be used to view report execution history and their parameters passed. This can be viewed from Admin Reports Report Execution History report.


To schedule Archive Process:


  1. Login to SplashBI.
  2. Navigate to Reports module tabular view.
  3. Search for Archive Process report.


 


4.  Click on Run icon.

5.  User will be navigated to report submit page with parameters to be passed.



6.  Provide parameter values based on the requirement and below is the description for each parameter behavior.


  • Retention Days: If the user provides a number, for example 10 days, the system will retain last 10 days report processes and deletes the rest of the report processes.
  • Delete If Rows Greater Than: If the user wishes to delete huge report processes data, then number of rows retrieved can be provided here. For example if 10,000 is given, system will delete all report processes in the system having record count greater than or equal to 10,000.
  • From Date: If user wishes to delete Report processes after a specific date,  then this value is provided where system deletes the report processes from this provided date value.
  • To Date: If the user wishes to delete Report processes before a specific date, then this value is provided where system deletes the report processes before this provided date value.
  • Report Name: If the user wishes to delete the report processes, then the user needs to provide the report name containing string in quotes for example %Employee%, then system deletes all the report processes of reports which contains the provided string.
  • Dashboard Name: The system deletes the processes for the dashboard name provided. You need to provide the name in the quotes. For example, if you give the dashboard name as "%Employee%" the system deletes all the dashboard processes of dashboards which contain the provided string
  • Combination of the parameter values also will work.


Examples:

  1. If the user wishes to delete Report processes in between a start date and end date then both From Date and To Date are provided, where system deletes the report processes falling in between these dates.
  2. If the user wishes to delete reports containing the string %Employee% with rows greater than 10,000, then user can provide value in Delete If Rows Greater Than parameter as 10,000 and in the Report Name parameter as %Employee%.





7.  After configuring parameter values, user can schedule the report by clicking on Schedule icon.




Recommended by SplashBI


  • Every 15 days, old report processes in DEV /TEST and 30 days old report processes in PROD need to be purged.