My Oracle Support Banner

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 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.

 

Changes

 

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
Changes
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.