My Oracle Support Banner

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

Last updated on JANUARY 31, 2022

Applies to:

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


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')'. [IBM][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

The issue is the idoc query that is within the ../shared/config/resource/query.htm contains a SQL Update that updates a single record in the HTMLCONVERSIONSUMS table. The idoc query was intended to only do updates to the database table for the single record.  If for some reason the table contains more than one record the SQL exception is thrown.




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

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