My Oracle Support Banner

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

Last updated on AUGUST 01, 2018

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

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.