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 JUNE 06, 2017

Applies to:

Oracle WebCenter Content - Version: 7.5.1 and later   [Release: Stellent 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

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