Oracle Legal Whitehill Enterprise - Upgraded 5.7.1 Template Crashes Designer Preview with Error: "The text, ntext, and image data types cannot be compared or sorted" in Error.log (Doc ID 967048.1)

Last updated on NOVEMBER 26, 2009

Applies to:

Oracle Legal Whitehill Enterprise - Version: 5.7.1
Information in this document applies to any platform.

Symptoms

When upgrading Whitehill Enterprise templates to 5.7.1 and testing in Converter or Designer, users may see Word crash unexpectedly.  Further investigation of the error.log produces the following error:

"An unexpected error occured while a source file was being loaded: System.Data.SqlClient.SqlException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

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