Error when performing upgrade from vReplicator 2.5.x to vReplicator 3.0.1
“5.Database installation failed.Reason:Cannot drop the procedure ‘dbo.vz_ReplicationJobSelectAllActive’, because it does not exist or you do not have permission.”
This error presents itself when doing the database upgrade portion of vReplicator from 2.5.x to 3.0.1
*** Note: Editing the SQL database should be treated in the same manner as editing the Registry. If you are uncomfortable with this, you should submit a Support case. ***
Use the SQL Server Management Studio Express to modify the stored procedures in the database
Once installed, launch the application
1.Enter the Servername (or IP address) and database instance (computername\vizioncore
2.Expand Databases and Vizioncore Applications
3.Expand Programmability and Stored Procedures
4.Right-click on Stored Procedures and choose New Stored Procedure
5.Press Ctrl-Shift-M in the Query Window
6. In the Procedure_name field, type dbo.vz_ReplicationJobSelectAllActive and click OK (case sensitive)
7.Execute the query to create the stored procedure
8. Uninstall the vReplicator installation. If you want to keep you're current existing configurations and jobs, click NO to the prompt 'Do you want to perform a FULL uninstall...'
9. Re-run the vReplicator installation
