My Oracle Support Banner

After Logging Into Team Member An Alert Window Pops Up 'tm_load_activities_error' (Doc ID 2168316.1)

Last updated on APRIL 09, 2018

Applies to:

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


On : version, P6 Application

After logging into Team Member an Alert window pops up:


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]

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.