After upgrading to CMS12 we have seen some customer's report that they could not find the stored procedure 'netSoftLinksGetBrokenCount' using the following instructions.
- Navigate to the Admin area.
- Select Reports.
- Choose "Link Status".
- The Link Status report fails with the error message "The page cannot be displayed because an internal server error has occurred."
- Check the application log, the exception below shows up.
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'netSoftLinksGetBrokenCount'
The Store Procedure 'netSoftLinksGetBrokenCount' is not present in versions of CMS 12 before CMS version 12.13.1. Upgrading to this version at the minimum should show the stored procedure.
As a temporary workaround, you can execute the following SQL script to fix the issue if you cannot upgrade to version 12.13.1:
CREATE PROCEDURE [dbo].[netSoftLinksGetBrokenCount]
basically you create a dummy SP to allow the upgrade script to proceed