Generic System Error When Opening Records For A Specific Business Process

(Doc ID 2404649.1)

Last updated on JUNE 05, 2018

Applies to:

Primavera Unifier Cloud Service - Version 17.12.0.0 and later
Primavera Unifier - Version 17.12.0.0 and later
Information in this document applies to any platform.

Symptoms

On Unifier : Version 17.12.4

Receiving a Generic system error (see below) when opening any records for a specific Business Process (BP) and only in one project/shell in this case.

ERROR
-----------------------

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

The follow excerpt can be found in the Unifier log files:

[[ACTIVE] ExecuteThread: '9' for queue:
'weblogic.kernel.Default (self-tuning)'] ERROR Target.Exception
...unifier:/share/recordPermission/value throws an exception at file:///share/action.xml:3827: ~
file:///share/action.xml:3827: java.sql.SQLSyntaxErrorException: ORA-00904: "PM"."GROUPID": invalid identifier

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

  1. Log into the Unifier Environment
  2. Navigate to applicable work space and attempt to open ANY of these records and receive the Generic System Error noted above

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