Failed Loading data:dbengine.executeselect: When Clicking On Notifications. (Doc ID 2083676.1)

Last updated on JANUARY 30, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 8.3.10.0 [Release 8.3]
Information in this document applies to any platform.

Symptoms

 When attempting to open notifications, the following error occurs and also in the P6 Web Access logs you will see the following errors:

Failed loading Data:DBEngine.executeSelect: {select task_id, count(*) Unread from discussion
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
task_id}

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.

 

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