My Oracle Support Banner

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 NOVEMBER 29, 2023

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.2 to 10.1.3.6 [Release 10gR3]
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.