My Oracle Support Banner

Unable to run UDR Due to Error : "Results cannot be retrieved. Please contact System Administrator. " (Doc ID 2583223.1)

Last updated on APRIL 30, 2020

Applies to:

Primavera Unifier Cloud Service - Version N/A and later
Primavera Unifier - Version 9.7 and later
Information in this document applies to any platform.

Symptoms

On Unifier : Any Version

User created a User-Defined Report (UDR) based on an SQL Data View:

ACTUAL BEHAVIOR
----------------------
The SQL Data View is running correctly but when try to run the UDR, the reports come back with the Error Message "Cannot Retrieve Data"

STEPS TO REPRODUCE
----------------------

  1. Login Unifier
  2. Go to All Projects
  3. Fine the UDR
  4. Run the UDR , got result :

Results cannot be retrieved. Please contact System Administrator.

5. Check debug mode Unifier log, could see error : ORA-00904: "XX"."XXXXXXXXXXXXX": invalid identifier.

EXPECTED BEHAVIOR
-----------------------
The UDR should return with Data.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.