When upgrading to versaSRS version 7.2.0 the Custom Stored procedures are not updated as these can contain customisations that should not be overwritten.
For version 7.2.0 to be compatible with the Custom Stored Procedures the following changes are required:
1. Access the versaSRS database under Programmability > Stored Procedures, locate and take a copy of any Custom Stored Procedures that have been modified from the original. These include:
- sp_Get_Custom_Actions_By_Page
- sp_Get_Custom_Calls_By_Page
- sp_Get_Custom_ChangeRequests_By_Page
- sp_Get_Custom_Contacts_By_Page
- sp_Get_Custom_Dashboard_Call_Count_Summary
- sp_Get_Custom_Dashboard_ChangeRequest_Count_Summary
- sp_Get_Custom_Dashboard_Problem_Count_Summary
- sp_Get_Custom_Dashboard_Task_Count_Summary
- sp_Get_Custom_ManagedOrganizations_By_Page
- sp_Get_Custom_Problems_By_Page
2. To make the necessary changes to these Custom Stored Procedures the version 7.2.0 compatible scripts will need to be downloaded and run on the versaSRS database.
NOTE: This will delete and recreate the Custom Stored Procedures, which is why the existing ones that have been modified need to be saved first. VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when running queries directly on the database, we recommend performing a backup and implementing on a test environment before performing on production.
3. After running the scripts, apply any of the custom modifications made in the copied Custom Stored Procedures to the newly created Custom Stored Procedures.
Once the above steps have been completed the Custom Stored Procedures will be compatible with versaSRS version 7.2.0 upon upgrading from version 7.0.0-7.1.5. Users will need to clear their browser cache after updating and/or making any changes to these Stored Procedures.