“Sorry, something went wrong, you can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels” Error in SharePoint 2013 health data collection
Sorry, something went wrong,
You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.
By checking the error in Google I have found the solution. By updating the Stored Procedure in SQL server, we can fix the error. Here are the steps to fix the issue,
- Open SQL Server Management Studio where SharePoint installed.
- Open WSS_Logging DB
- In the Programmability select Stored Procedures
- Select dbo.proc_GetSlowestPages Stored Procedure, Right Click on it, Select "Modify"
- In the code, search for "WITH (READPAST)" and comment it as /* WITH (READPAST) */
- Run the Stored Procedure and run health data collection in SharePoint 2013.
- check your health reports again and you will reports populated.
