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

Last updated on MAY 01, 2017

Applies to:

Oracle Universal Content Management - Version: 10.1.3.3.1 to 10.1.3.5.0 - Release: 10gR3 to 10gR3
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

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