The reference creations at the publisher node failed.

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.
######################

Patch level detected:Publisher 3.1.0
Product Version: Dollar.Universe 5.6.0 FX25010

Description :The reference creations at the publisher node failed.

Cause

Cause type:
Configuration
Root Cause: This happens when an upgrade is performed on the publisher server without running the DB alteration scripts .

Environment

OS: Linux
OS Version: NA

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.

Fix Status: No Fix
 

Additional Information

Workaround :
N/A