My Oracle Support Banner

Publishing Schema Generates Error: 'Unable to publish the schema. Unable to create result set for query 'SELECT DISTINCT child.WEBSITEID...'" (Doc ID 471365.1)

Last updated on FEBRUARY 22, 2021

Applies to:

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

Symptoms

Can not "publish schema" due to the following error and the DCL values are not loading as a result.

Unable to publish the schema. Unable to create result set for query 'SELECT DISTINCT
child.WEBSITEID, child.NAME, child.DISTCHANNEL FROM DCLWEBSITE child WHERE
child.WEBSITEID=Internal Only'. DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC:
Only;d.WEBSITEID=Internal;END-OF-STATEMENT [ Details ]
An error has occurred. The stack trace below shows more information.
!csSchemaUnableToPublish!csDbUnableToCreateResultSet,SELECT DISTINCT child.WEBSITEID\,
child.NAME\, child.DISTCHANNEL FROM DCLWEBSITE child WHERE child.WEBSITEID=Internal Only!$DB2 SQL
error: SQLCODE: -104\, SQLSTATE: 42601\, SQLERRMC: Only;d.WEBSITEID=Internal;END-OF-STATEMENT
intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT DISTINCT child.WEBSITEID\,
child.NAME\, child.DISTCHANNEL FROM DCLWEBSITE child WHERE child.WEBSITEID=Internal Only!$DB2 SQL
error: SQLCODE: -104\, SQLSTATE: 42601\, SQLERRMC: Only;d.WEBSITEID=Internal;END-OF-STATEMENT

.

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.