P6 Professional Event Code: VTRAP-0462-9 "TCVirtualTable.RefreshAppend: PROJECT: SQL State: 3, SQL Error Code: 242, Level: 16, Procedure: , Line: 1 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." (Doc ID 2761703.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

When attempting to use the Maintain Baselines functionality, the following Event Code occurs for all users:

EVENT CODE

Executable: PM.EXE
Application: Primavera P6 Professional 18
Event Code: VTRAP-0462-9
Message:
TCVirtualTable.RefreshAppend: PROJECT: SQL State: 3,
SQL Error Code: 242, Level: 16, Procedure: , Line: 1
The conversion of a varchar data type to a datetime data
type resulted in an out-of-range value.

Context:
1: TDevxMainForm.actProjectBaselineMaintainExecute
2: TDevxMainForm.BeforeFormShow
3: TfrmEPS.mnuOpenProjectClick
4: TCFormManager.SetToolbar
5: TDevxMainForm.BeforeFormShow
6: TfrmLogin.FormCreate
7:

STEPS

The issue can be reproduced at will with the following steps:
1. Log-in to P6 Professional.
2. Open Maintain baselines.
3. Click on Add New Baseline.
4. Save a project of the current project as a baseline.
5. Click OK.
6. Observe reported event code after a minute or two.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.