This section contains error messages for the Adaptive Server Fault Isolation Utility.
17
Data unavailable: Unable to complete because the required data is currently unavailable. The command failed and the transaction aborted. Try again later or contact your System Administrator.
Adaptive Server's Recovery Fault Isolation (RFI) feature enables recovery to mark a single page or a set of pages of a user database suspect, while allowing access to the remainder of the database. The bad page(s) are said to be "offline", and may not be used until the problem is corrected. (For a detailed discussion of RFI, refer to “Online Recovery and Recovery Fault Isolation” in the Encyclopedia of Tasks chapter).
Error message 12716 results when you issue a query that requires access to an offline page. This error is followed by Error 12717 (Suspect data encountered: Database '%.*s', object '%.*s', index ID '%ld', page ID '%ld'.).
The offline page(s) must be repaired before they can be used. Responsibility for repairing offline pages belongs to a user with sa_role. The System Administrator can bring a page online to make it accessible to sa_role:
1> sp_forceonline_page database_name, pgid, 'sa_on' 2> go
where pgid is the page ID shown in the accompanying 12717 error.
WARNING! When forcing pages online, note that Adaptive Server does not do any consistency checks before onlining pages.
Use existing methods to diagnose and repair problems, checking the server error log for any errors related to the offline page and determining appropriate corrective action. Before making repaired pages available to all users, check that repairs have been made correctly by running dbcc commands or queries with known results.
Refer to “Online Recovery and Recovery Fault Isolation” in the Encyclopedia of Tasks chapter for a detailed discussion of RFI.
All versions
17
Suspect data encountered: Database '%.*s', object '%.*s', index ID '%ld', page ID '%ld'
Adaptive Server's Recovery Fault Isolation (RFI) feature enables recovery to mark a single page or a set of pages of a user database suspect, while allowing access to the remainder of the database. The bad page(s) are said to be "offline", and may not be used until the problem is corrected. (For a detailed discussion of RFI, refer to “Online Recovery and Recovery Fault Isolation” in the Encyclopedia of Tasks chapter).
Error message 12717 results when you issue a query that requires access to an offline page. This error is preceded by Error 12716 (Data unavailable: Unable to complete because the required data is currently unavailable. The command failed and the transaction aborted. Try again later or contact your System Administrator.).
The offline page(s) must be repaired before they can be used. Responsibility for repairing offline pages belongs to a user with sa_role. The System Administrator can bring a page online to make it accessible to sa_role:
1> sp_forceonline_page database_name, pgid, 'sa_on' 2> go
where pgid is the page ID shown in the 12717 error.
WARNING! When forcing pages online, note that Adaptive Server does not do any consistency checks before onlining pages.
Use existing methods to diagnose and repair problems, checking the server error log for any errors related to the offline page and determining appropriate corrective action. Before making repaired pages available to all users, check that repairs have been made correctly by running dbcc commands or queries with known results.
Refer to “Online Recovery and Recovery Fault Isolation” in the Encyclopedia of Tasks chapter for a detailed discussion of RFI.
All versions
