ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
The reference creations at the publisher node failed.
Article ID: 85264
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.
######################
Patch level detected:Publisher 3.1.0
Product Version: Dollar.Universe 5.6.0 FX25010
Description :The reference creations at the publisher node failed.
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 .
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
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
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
N/A
Feedback
Yes
No
Powered by
