Failed Loading data:dbengine.executeselect: When Clicking On Notifications.
Last updated on JANUARY 30, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 18.104.22.168 [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.
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