Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act diagnostics error

Copper Contributor
Posts: 202
Country: USA

Act diagnostics error

When I run the Act! diagnostics (not from inside Act Check&Repair, but standalone on the database). If I run "Check" database, it halts and displays the following error message. Nothing has been done to alter the database. No other error messages. The internal Tools-Check&Repair works fine. Does anyone have an idea what is wrong with the database or the program.

 

The page (1:185), object ID 4, index ID 1, partition ID 262144, allocation unit ID 262144 (type In-row data) has been modified, but is not marked as modified in the differential backup bitmap.
Database 'MAGdb2009': consistency errors in system catalogs prevent further DBCC checkdb processing.
Database Maintenance error occurred with PRC_MAINT_REPAIRDB: CHECKDB
DBCC results for 'MAGdb2009'.
        The repair level on the DBCC statement caused this repair to be bypassed.
There are 2546 rows in 21 pages for object "sys.sysrowsetcolumns".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysrowsetcolumns' (object ID 4).
CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'MAGdb2009'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MAGdb2009, repair_rebuild).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Moderator
Posts: 4,395
Country: USA

Re: Act diagnostics error

Try running a reindex on the database first from actdiag.  If that doesn't work, create an empty copy and try to run repairs on the copy.  If it works, import your database into the copy.