Control Compliance Suite 11, notifications about the database maintenance plan being due keep being send despite running the maintenance plan through the CCS console.
Last Updated September 25, 2013
Control Compliance Suite (CCS) 11 Product Update (PU) 2013-1 introduced "Notifications when the database maintenance plan is due or a CCS Manager needs attention" and CCS 11 PU 2013-2 introduced "Database maintenance through CCS Console".
Between the two CCS displays an alert on the Product Health and Status area of the CCS Console Homepage, when the database maintenance plan is due. The alert is displayed if the index fragmentation in CCS databases goes above 90% or when the alert notification is due as per the number of days specified in the Health and Status Notifications configuration. Clicking the High index fragmentation alert link on the CCS Console Homepage launches a dialog box from where you can run the database maintenance (or view a help topic for creating a database maintenance plan.)
Despite running the maintenance through the CCS console - the notifications remain to be displayed and send by means of email.
2013-08-21 14:01:30.332,2013-08-21 15:01:30.332,CCSCARAPP,Error,AppServer.JobManager,AppserverService,1008,,9,RebuildIndex,,0,0,"Could not able to rebuild index for [[unci_SubjectTestResultEvidenceArchive_RID]] due to exception = [System.Data.SqlClient.SqlException (0x80131904): The index ""unci_SubjectTestResultEvidenceArchive_RID"" (partition 1) on table ""SubjectTestResultEvidenceArchive"" cannot be reorganized because page level locking is disabled.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
Defect: Two indexes with page level locking disabled fail to reorganize when defragmentation is below 40% and the H&S database maintenance job runs resulting in the database maintenance indicator remaining 'on'.
Apply QuickFix 10343 which contains an SQL script that updates the database maintenance stored procedure. Please find the hotfix attached to this kb.