My Oracle Support Banner

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 JULY 15, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 19.12.12.0 [Release 18.8 to 19.12]
Information in this document applies to any platform.

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

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