ERROR: "TCVirtualTable.ExistInDB: table=(User Session), Sql=(), Exception=(Error Executing Query. Error: Numeric Overflow" or "ORA-01455: Converting Column Overflows Integer Datatype" When Logging Into P6 Professional (Doc ID 2134192.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Symptoms

ISSUE #1

When attempting to login to P6 Professional (using the "P6 Pro Cloud Connect" driver type) the following error occurs:

TCVirtualTable.ExistInDB: table=(User Session), sql=(), Exception=(Error executing query. Error: Numeric Overflow

Session -1 -- privuser:: (PM.exe) -- UTF-8 -- BE18-A5EA-xxx.xxx.xxx.xxx{7D29E32E-8112-4454-99CC-3E085133B2C7}
DB Connection oracle.jdbc.driver.T4CConnection@42cca9a0
Request type: GET_SQL_RESULT
Command text: Generic_Select_All_Where
Parameter count: 3
0 -- INPUT -- String = usession
1 -- INPUT -- String = ####
2 -- INPUT -- String = headerParam=pt|name,pw|session_id
Block count: 0
Total data size: 0 bytes (before compression)
Total job time spent to push in the queue: 0 ms
Total job time: 0 ms (not including compression)

ISSUE #2

When attempting to login to P6 Professional (using the "Oracle" driver type) the following error occurs:

TCVirtualTable.ExistInDB: table=(User Session), sql=(SELECT * from usession WHERE session_id=####), Exception=(ORA-01455: Converting column overflows integer datatype)

The issue can be reproduced at will using the following steps:

1. Launch the P6 Professional using either the CloudConnect or Oracle Database driver type and login.
2. Note the reported error.

Cause