1. A message showing error as the status of Advisories is found in the Performance Analysis Agent Admin, and/or
2. Historical data is incomplete for time interval of 6 hours and above.
In the stderr.quest_sc_rep log error like the following is captured:
<DATABASE ERROR>Error Code: 7102; Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Internal Error: Text Manager cannot continue with current statement. Run DBCC CHECKTABLE; SQL Text: INSERT INTO dbo.QUEST_SC_SQL_SYNTAX_DIM VAR Info: </DATABASE ERROR>
Error Code 7102 is due to the long term performance repository SQL Server health issue or database hardware issue.
For more information about this error code, refer to MSDN Library- Troubleshooting (SQL Server 2000) Error 7102
This error code is specific to Microsoft SQL Server. It is advisable to contact Microsoft Support for further assistance.