My Oracle Support Banner

SQL Error for HTMLCONVERSIONSUMS using Dynamic Converter (Doc ID 447649.1)

Last updated on AUGUST 15, 2023

Applies to:

Oracle WebCenter Content - Version 7.0 and later
Information in this document applies to any platform.

Symptoms

Error when converting documents to HTML using Dynamic Converter 7.2.1:

Content Server Request Failed
Unable to get dynamic conversion. Unable to execute query 'UhtmlConversionSums(UPDATE HtmlConversionSums SET dTotalCached='#####', dTotalFiles='46', dLastAccessed={ts '2006-06-13 14:50:48.031'}, dLastKey='local~####~GWL_MAIN_CONTENT')'. [abc][CLI Driver][DB2/NT] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "ADMINISTRATOR.HTMLCONVERSIONSUMS" from having duplicate rows for those columns. SQLSTATE=23505


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.