Error 7410



Message text

%s: function called with invalid argument.

NoteThis error is only raised when using diagserver.


This error occurs when an attempt to execute a threshold action fails because of a problem in a memory structure.


If there are additional messages in the server error log that tell you which threshold was initiated, do the following steps:

  1. Select the database:

    1> use <database_name>
    2> go

    Where <database_name> is the database which contains the failed threshold.

  2. Determine the stored procedure that is associated with the segment for which the error occurred:

    1> sp_helpthreshold <segment_name>
    2> go
  3. Run the stored procedure manually.

If you were not able to determine which threshold was initiated by looking at the error log output, run the following curunreservedpgs query (appropriate to the version of Adaptive Server Enterprise that you are using) in each database to determine which threshold action did not execute properly:

This query returns the database name, device name, and the number of unreserved pages for each device fragment. If you can determine which threshold was reached (compare the output of the curunreservedpgs query with the free space for the segment), execute the threshold action manually. Refer to the chapter “Transact-SQL Functions” in the Reference Manual: Building Blocks for information about curunreservedpgs.

To prevent this error from occurring in the future, review the Adaptive Server error log and look for other messages associated with this error. There may be other errors that will tell you why the threshold failed. If more information is available, take the necessary steps to prevent the error from recurring.

Versions in which this error is raised

All versions