All Reports are failing with error: Number: 0; Description: ; Comment: Problem stored procedure execution; Source: (NETIQKB70688)

All reports are failing with same error: Number: 0; Description: ; Comment: Problem stored procedure execution; Source:

When a report job fails with the symptom error, the default.log may contain the following content:

2007/10/4, 15:12:15 - ADODataSource.Execute PROVIDER ERROR (0x80040e14) Index 'ArchiveData_DataID_idx' on table 'dbo.ArchiveData' (specified in the FROM clause) does not exist.
2007/10/4, 15:12:15 - ADODataSource.Execute COM ERROR Code(0x80040e14) IDispatch error #3092
2007/10/4, 15:12:15 - ADODataSource.Execute COM ERROR Source= Microsoft OLE DB Provider for SQL Server
2007/10/4, 15:12:15 - ADODataSource.Execute COM ERROR Description= Index 'ArchiveData_DataID_idx' on table 'dbo.ArchiveData' (specified in the FROM clause) does not exist.
2007/10/4, 15:12:15 - ADODataSource::Execute Could not execute stored procedure
2007/10/4, 15:12:15 - Number: 0; Description: ; Comment: Problem stored procedure execution; Source:

It may be possible to correct this problem by re-creating the ArchiveData table's Index manually:

WARNING! Make a full backup of the AM Repository Database before beginning.  Should the following steps fail to correct the problem, you may need to be able to restore the AM Repository to its initial condition.

1. Run the following query against the AM Repository Database in SQL Query Analyzer:

CREATE INDEX ArchiveData_DataID_idx ON dbo.ArchiveData(DataID, Time, Value) WITH FILLFACTOR = 90

The manual creation of the Index should complete with the following result: "Command completed successfully".  You should then attempt to re-run your report script and verify that the reports can now be correctly and completely created.

The problem here is that the Index for the ArchiveData table of the AppManager Repository (QDB) has been deleted or corrupted.

Formerly known as NETIQKB70688