My Oracle Support Banner

SQLException: ORA-00904: "DCOLLECTIONCREATOR": invalid identifier (Doc ID 1071084.1)

Last updated on MAY 22, 2020

Applies to:

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

Symptoms

Error occurs on startup of UCM where latest Folders_g component has been installed.

Unable to execute service COLLECTION_UPDATE_ADMIN_CONFIG and function getCollectionAdminConfig.
(System Error: Unable to create result set for query 'SELECT COUNT(*) FROM Collections WHERE dCollectionCreator IS NULL or dCollectionCreator = '''. ORA-00904: "DCOLLECTIONCREATOR": invalid identifier) Unable to create result set for query 'SELECT COUNT(*) FROM Collections WHERE dCollectionCreator IS NULL or dCollectionCreator = '''. ORA-00904: "DCOLLECTIONCREATOR": invalid identifier
java.sql.SQLException: ORA-00904: "DCOLLECTIONCREATOR": invalid identifier

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.