Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.

Problem You configure SQL Server Maintenance Plan and set it to e-mail you when the job is complete. When you check the job history, you notice that it fails to send the e-mail and the following message is logged: Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile […]

Continue Reading...

Remote Blob Storage Maintainer Configuration

Requirement When you implement Remote Blob Storage for SharePoint 2010, you also need to configure the RBS Maintainer as a scheduled task on your SharePoint database server in order to periodically clean the blob stores from orphaned objects (files that have been permanently removed from SharePoint do not get automatically deleted from the blob store!). […]

Continue Reading...

Expired sessions are not being deleted from the ASP.NET Session State database.

Problem This problem usually happens when you move your SharePoint farm to a different database server using SQL Aliases. When you create the Session State Database in SharePoint, it creates a SQL Agent job called <DB Name>_Job_DeleteExpiredSessions. This job runs every minute to clean out the expired sessions from the database. Without it, your database […]

Continue Reading...

Fixed: DPM could not enumerate sql server instances using windows management instrumentation

Problem We are using DPM 2012 to backup our SharePoint 2010 farm using the SharePoint connector in DPM (not SQL backups). I ran the configuresharepoint.exe -enablesharepointprotection followed by configuresharepoint.exe -resolveallsqlaliases (we are using SQL aliases) on one of our Web Front End Servers as required. I then verified that the SharePoint VSS Writer service was Started […]

Continue Reading...

SQL – Repairing a corrupted index in a database

Problem We recently moved all our SharePoint databases to a new server. This morning I noticed that the new SQL server was reporting that one of the databases had a corrupted index. Log Name:      Application Source:        MSSQL$SP Date:          2/01/2013 9:05:02 AM Event ID:      8646 Task Category: Server Level:         Error Keywords:      Classic User:          domain\user Computer:      db01.server.com […]

Continue Reading...