Error and Exception Handling Errors

This section contains error messages for Adaptive Server error and exception handling.




Error 3604

Severity

10

Message text

Duplicate key was ignored.

Explanation

This error occurs when you try to insert duplicate key values in a column or columns which have a unique index that was created with the option ignore_dup_key.

Adaptive Server ignores the commands in a transaction which try to insert a duplicate index. The rest of the commands in the transaction will complete normally.

Action

No action is necessary.

If you want the row inserted, use one of the following procedures:

Additional information

Refer to “create index” in the Reference Manual for information about indexes.

Versions in which this error is raised

All versions




Error 3621

Severity

10

Message text

Command has been aborted.

Explanation

This error occurs when Adaptive Server is unable to complete a command. Error 3621 may be the last message displayed by your application even though another message was sent by Adaptive Server when the error actually occurred. The rest of the commands in the transaction will complete normally.

Some situations that may cause Error 3621 include:

Action

Look for an error before the 3621 error occurs. Resolve the problem that is causing the error before the 3621 error.

If client applications receive this error, ask your Adaptive Server system administrator to check the Adaptive Server error log.

Versions in which this error is raised

All versions




Error 3624

Severity

10

Message text

 Truncation error occurred.

Explanation

The precision of a datatype denotes the maximum number of digits allowed in columns of that datatype. For the exact numeric types dec, decimal and numeric, the allowed range of data depends on the column’s precision as well as its scale, that is, the maximum number of digits that are allowed to the right of the decimal point.

Error 3624 occurs when an operation inserts data into a target column or variable but the precision or scale of the target are too small for the data. The operation fails and the command is aborted.

Action

Examine the data involved in the arithmetic operation to ensure that the target column or variable is sized appropriately.

Additional information

The set arithabort and set arithignore options specify behavior following loss of precision or (for exact numeric types) loss of scale. For more information see:

Versions in which this error is raised

All versions




Error 3626

Severity

17

Message text

The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces. spid: %d, suid: %d, hostname: %.*s, application name: %.*s

Explanation

At start-up, Adaptive Server allocates one stack for each configured user connection. These stacks are in contiguous areas of memory, with a guard area at the end of each stack. Adaptive Server periodically checks to determine whether the stack point for a user connection has entered the stack guard area adjacent to that connection's stack. Error 3626 occurs when this has happened.

Because Error 3626 occurs before any stack corruption, Adaptive Server does not shut down. Instead, it aborts the user process and rolls back any transactions that existed for that process.

An Adaptive Server process usually encounters this error for one of two reasons:

If this error occurs frequently, there is increased risk a process may overflow its stack area and corrupt another process' stack. This situation will cause Adaptive Server to shutdown with the error:

kernel:  *** Stack guardword corrupted.

See Stack Guardword Error for more information.

Action

If this error occurs with a transaction which contains a where or where-in clause, you may need to rewrite the query. See Error 404 for additional actions which may be required.

If this error occurs because a complex query has run out of stack area, you can resolve it in one of two ways:

When changing the stack size on Adaptive Server, consider the following facts:

Additional information

Refer to “sp_configure” in the Reference Manual and “Setting Configuration Parameters” in the System Administration Guide for information about sp_configure and stack size and stack guard size configuration parameters.

Refer to the Performance and Tuning Guide and “Configuring Memory” in the System Administration Guide for information about configuring Adaptive Server memory.

Versions in which this error is raised

All versions