An Error is Returned When Attempting to Apply a Process After an Upgrade to 10.1.3.3.2. The Upgrade Script Causes the PK_ACTION Index to be Clustered. (Doc ID 601795.1)

Last updated on AUGUST 10, 2011

Applies to:

Oracle Imaging and Process Management - Version: 10.1.3.3.2 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.

Symptoms

An error is returned when attempting to apply a Process from Process Builder after an upgrade to 10.1.3.3.2.

Failed to execute update SQL statement. SQL Error statement returned: [Microsoft][ODBC SQL Server
Driver][SQL Server] The query processor could not produce a query plan from the optimizer because
a query cannot update a text, ntext, or image column and a clustering key at the same time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms