SQL error for HTMLCONVERSIONSUMS using Dynamic Converter

(Doc ID 447649.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle WebCenter Content - Version 7.1.1 to 7.1.1 [Release Stellent]
Information in this document applies to any platform.

Symptoms

The customer noticed an 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='573155', dTotalFiles='46', dLastAccessed={ts '2006-06-13 14:50:48.031'}, dLastKey='local~15522~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.

Changes

 

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