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

  • 7770688
  • 04-Oct-2007
  • 10-Jan-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

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:

Resolution

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.

Cause

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

Additional Information

Formerly known as NETIQKB70688

 


Feedback service temporarily unavailable. For content questions or problems, please contact Support.