Server Error Messages 500 - 599
782
526 18 SQL Server has run out of alarms. Re-run your command when there are fewer users
running WAITFOR, or ask your System Administrator to raise the con figuration
parameter ’number of alarms’.
Explanation: Retry later, or increase the configuration parameter `number of alarms'.
527 20 Cannot remove alarm.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
528 20 System error detected during attempt to use upsleep system call.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
529 16 Explicit conversion from datatype `%s' to `%s' is not allowed.
Explanation: Command failed due to invalid request. Consult the Adaptive Server
Reference Manual for information on datatype conversions.
530 16 Attempt to insert NULL value into column %d in work table (table id %ld); column does
not allow NULLS. UPDATE fails.
Explanation: Refer to the writeup for Error 530.
532 16 The timestamp (changed to %.*s) shows that the row has been updated by another user.
Explanation: The command failed and no data was updated in the d ataba se beca use a n
integrity check or other semantic check on the data failed.
533 20 Can't find a range table entry for range %d.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
534 16 TEXT and IMAGE datatypes require DBLIB version 4.0 or grea ter.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
535 16 Difference of two datetime fields caused overflow at runtime.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. The result of the DATEDIFF function may be too large.
536 16 Invalid length parameter with value of %d passed to the substring function.
Explanation: Check command syntax. There may be more constraints to report than
sp_helpconstraint can fit.
537 16 Overflow resulted from a SMALLMONEY remainder operation.
Explanation: Adaptive Server could not perform the requested action. Check your
command for missing or incorrect database objects, variable names, and /or input data.
Number Severity Text and Explanation