After Logging Into Team Member An Alert Window Pops Up 'tm_load_activities_error'

(Doc ID 2168316.1)

Last updated on AUGUST 11, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 16.1.0.0 version, P6 Application

After logging into Team Member an Alert window pops up:

ERROR
-----------------------

tm_load_activities_error$@#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 * FROM (SELECT task.task_id FROM task,taskuser WHERE task.task_id=taskuser.task_id(+) AND ((taskuser.user_id = 72) AND (task.act_end_date IS NULL OR task.act_end_date >= TO_DATE('2015-12-25 00:00:00','yyyy-mm-dd hh24:mi:ss'))) order by task.task_id asc) WHERE rownum <=1025)) group by task_id} [72]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login Team Member


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Team Member.

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