Error 12842



Message text

Adaptive Server cannot process this %s statement due to one or more errors. Please retry this command if it failed due to a deadlock. Please refer to your application log or Adaptive Server errorlog for more information on the cause of this failure.


Adaptive Server internally creates a hidden materialized computed column when a functional index is built. When the functional index is dropped, the corresponding hidden computed column also should be dropped. This error indicates that an error occurred while trying to drop the hidden computed column as part of dropping the functional index.


If there is a deadlock, rerun your command. If no deadlock was indicated, this may indicate an internal Adaptive Server error.

Additional information

A configurable shared memory dump (CSMD) on error 12842 may assist in determining root cause. Information about CSMD can be found in the section “Other Useful Tasks” in the Troubleshooting and Disaster Recovery guide.

Versions in which this error is raised

Version 15.0 and later