My Oracle Support Banner

A P6 Web Services Request Takes a Long Time to Run and Log File Shows Error "com.primavera.PhoenixException: DBEngine.executeStatement for {call pv_login(?, ?, ?, ?)} failed:Numeric Overflow" (Doc ID 2772579.1)

Last updated on JULY 07, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 to [Release 18.8 to 20.12]
Primavera Web Services - Version 18.8 to [Release 18.8 to 20.12]
Information in this document applies to any platform.


When attempting to run a P6 Web Services request, it takes a long time and eventually fails with the following error. Read timed out

The following error also occurs in the P6 Web Service Log:

com.primavera.PhoenixException:  DBEngine.executeStatement for {call pv_login(?, ?, ?, ?)}failed:Numeric  Overflow

This can also occur when logging in to P6 as a non-admin superuser.  During login to P6, the UI/browser will hang indefinitely while loading the page before completing the login process.




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.