The reference creations at the publisher node failed.
book
Article ID: 85264
calendar_today
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Affects Release version(s): 5
Error Message : In the publisher server log file: ###################### [04 Sep 2012 15:45:10] The reference build process has encountered a problem: Reference process aborted because of: ORA-00979: not a GROUP BY expression [04 Sep 2012 15:45:10] Reference building ABORTED. Status changed to ABORTED. ######################
Description :The reference creations at the publisher node failed.
Environment
OS: Linux OS Version: NA
Cause
Cause type: Configuration Root Cause: This happens when an upgrade is performed on the publisher server without running the DB alteration scripts .
Resolution
After installing the server patch, the ORACLE or SQLSERVER publisher DB schema must be upgraded using the provided alter DB script. The script is : /dbscripts/alter_publisher_db_*_FX24xxxx.sql
Oracle or SQLSERVER DB Creation script is also provided to recreate a new schema from scratch. /dbscripts/publisher_db_creation_*.sql
It is highly recommended to backup your Oracle or SQLSERVER DB before upgrade for possible rollback.