Generic System Error When Accessing the Task Node on the Unifier Home Page (Doc ID 2291046.1)

Last updated on AUGUST 04, 2017

Applies to:

Primavera Unifier Cloud Service - Version 16.2.0.0 to 16.2.0.0 [Release 16.2]
Primavera Unifier - Version 16.2.0.0 to 16.2.0.0 [Release 16.2]
Information in this document applies to any platform.

Symptoms

On Unifier : Version 16.2.6.0

When attempting to access the "Tasks" log in the Unifier HOME page, a Generic System Error is generated.

ERROR
-----------------------
"Unifier Notification They system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems".

Excerpt from the Unifier log files:

unifier:/task/log/queryresult throws an exception at /wf/action.xml:1090: ~
/wf/action.xml:1092: java.sql.SQLSyntaxErrorException: ORA-00904:
"PR"."COMPANYNAME": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into a Unifier environment
  2. Navigate to HOME page > Select the Tasks node
    1. If the Sort Order is defaulted to Company Name the error will immediately be thrown
    2. If the Sort Order is not defaulted to Company Name then sorting on the column, navigating to another page, and navigating back to the Task log will allow the error to be thrown

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms