Home

	Expand Search

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Query Processor Errors

Error 530

Error 530

Severity

16

Error message text

Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails.

Explanation

During the run-time phase of updates, Adaptive Server sometimes uses worktables to temporarily store query results. Later in the query processing, Adaptive Server selects the values from those tables.

If, as a result of your query, Adaptive Server tries to insert a null value into a column of a worktable, and nulls are not allowed for the column, Error 530 occurs. The command is aborted and the update fails. Error 530 is caused by an Adaptive Server problem.

Action

Depending on the context of the error, you may be able to rewrite the query (for example, supply a column name or specify isnull). If the error reoccurs, or you cannot write the query in another way, call Sybase Technical Support.

Versions in which this error is raised

All versions