Failed Loading data:dbengine.executeselect: When Clicking On Notifications.
(Doc ID 2083676.1)
Last updated on JUNE 04, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 126.96.36.199 [Release 8.3]
Information in this document applies to any platform.
When attempting to open notifications, the following error occurs and also in the P6 Web Access logs you will see the following errors:
where not exists (select * from discussion_read where
discussion.discussion_id = discussion_read.discussion_id and
discussion_read.user_id = ? and discussion.task_id in (SELECT
taskrsrc.task_id FROM taskrsrc WHERE taskrsrc.task_id IN (SELECT
chgtrsrc.task_id FROM chgtrsrc WHERE chgtrsrc.proj_id in (select proj_id from
projshar where session_id = ? ) AND chgtrsrc.status_code <> ? ))) group by
STEPS TO REPRODUCE:
1. Log into P6.
2. Wait for the notifications button to load in the lower left hand corner of the screen and click it.
3. Click on the pending status updates notification and wait for the screen to load.
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