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 MAY 16, 2023

Applies to:

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

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