The reference creations at the publisher node failed.

Document ID : KB000085264
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
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.

Fix Status: No Fix
 
Additional Information:
Workaround :
N/A