Error: "TCVirtualDBEngine.RefreshRowsByKey: table=(Activity), EDBEngineError=(Lock Time Out" When Attempting To Login To Project Management (Doc ID 904980.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version: 4.0 to 7.0 - Release: 4.0 to 7.0
Primavera Contractor - Version: 4.0 to 6.1   [Release: 4.0 to 6.1]
All Platforms
***Checked for relevance on 06-Aug-2010***

Symptoms

The following error is encountered when attempting to logon to Project Management connecting to a SQL Server or SQL Server/Express/MSDE database:
TCVirtualDBEngine.RefreshRowsByKey: table=(Activity), EDBEngineError=(Lock time out.
SQL Server connection timed out.), sql=(Select t.* from task t, project p where task_id in (
(select distinct pred_task_id from taskpred where pred_proj_id not in (select proj_id from projshar where session_id = 2658) and proj_id in (select proj_id from projshar where session_id = 2658)) UNION (select distinct task_id from taskpred where proj_id not in (select proj_id from projshar where session_id = 2658) and pred_proj_id in (select proj_id from projshar where session_id = 2658))) and p.proj_id = t.proj_id and p.orig_proj_id is NULL)

After clicking OK to the error message, it takes a long time to move to the next view.

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