After launching the RMS Console, the Task Status window does not come up automatically.
Description : Timeout expired.
ErrorSource : Microsoft OLE DB Provider for SQL Server, Native error 0x0, HelpFile:. error 0xe21.
Description: Multi-step OLE DB operation generated error. Check each OLE DB status value, if available. No work was done.
ErrorSource: Microsoft OLE DB Provider for SQL Server, Native error 0x0, HelpFile:." comes up while loading task status window.
The JobResultsSet table in the BV SQL database has reached its maximum capacity. This error will occur when the RMS Console Task Status window is full of completed jobs (datasets). The Task Status window for every registered RMS Console user is stored in this same table. Modify Solution as follows: To resolve this issue: If possible, have each registered RMS Console user launch the RMS Console Task Status window and delete as many jobs as possible. If the Task Status window will not open, records must be manually removed from the JobResultSet table in the BV SQL database. If you are not familiar with SQL Enterprise Manager, please contact Technical Support before attempting these steps:
To resolve this issue:
METHOD 1: Modify the BV Database (if the Task Status Window does not open)
WARNING: Incorrect use of Microsoft SQL Server may prevent the software from functioning properly. Special care should be taken when making changes to any SQL Server database or table. Modifications should only be performed by people with experience in the use of SQL Server. It is recommended that a complete backup of the database be made prior to making any changes.
METHOD 2: Have RMS Users perform Task Status maintenance (preferred method)
1. Have each registered RMS Console user launch the RMS Console.
2. In the Task Status window, have each user delete as many completed jobs as possible.
3. Restart the RMS Console.
Best practices to manage disk space on the Control Compliance Suite (CCS) Data Collection Information Server (IS)
Task Status window contains only unsaved queries.