Error 7403

Severity

10

Message text

Threshold task could not use database %d, and so cannot execute the threshold procedure for segment %d, free space %ld.

Explanation

A threshold is “owned” by the user who creates it, or the last user to modify it with sp_modifythreshold (refer to sp_addthreshold and sp_modifythreshold in the Reference Manual: Procedures for details). Error 7403 occurs when the Threshold Manager tries to use a database and execute a stored procedure and access is denied. The procedure is not executed.

Action

To perform the threshold task that did not run because of this error:

  1. Select the database:

    1> use <database_name>
    2> go
    

    Where <database_name> is the database for which the error occurred.

  2. Run sp_helpthreshold <segment_name> for the segment named in the error message. This will display the stored procedure associated with the threshold.

  3. Run the stored procedure manually using the account of the owning user.

    To determine the owner of the procedure and user access to the database, type:

    1> sp_help <procedure_name>
    2> go
    
    1> sp_helpuser <database_name>
    2> go
    
    1> sp_helprotect <procedure_name>
    2> go
    

To prevent this error from occurring in the future, make sure that the owner of each threshold has access to the database to which the threshold applies, and that the user has execute permission on the stored procedure associated with the threshold.

Versions in which this error is raised

All versions