Control Compliance Suite 11, notifications about the database maintenance plan being due keep being send despite running the maintenance plan through the CCS console.

Products

• Control Compliance Suite Exchange
• Control Compliance Suite Windows

Issue/Introduction

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)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Symantec.Implementation.AppServer.JobManager.DBMaintenanceExecuter.RebuildIndex(Object objectid, Object indexid, Object partitionnum, Object frag, String indexname, SqlConnection dbConnection)]"

 

Cause

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'.

Resolution

Apply QuickFix 10343 which contains an SQL script that updates the database maintenance stored procedure. Please find the hotfix attached to this kb.

 

That concludes this article, after reading this article, you might be intertested in the following: How does CCS determine when the database maintenance plan is due.

 

 

Applies To

Control Compliance Suite 11, Product Update 2013-2