Global Scheduled Services or Project Publication is Failing with the Error: "Connection has been recycled. Database PMDB Pool PML"
Last updated on NOVEMBER 09, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
When Project Publication is enabled in P6, one or many of the Project log files in P6_home\p6\WebAccessLogs\services\jt_project is marked as Failed. (Eg. 3843_04.05.2013-14.33.28_FAILED.log). The message in the log file is similar to 'Io exception: Socket read time out' and 'Connection has been recycled. Database Pool PML'.
In P6 Global Scheduled Services, Publish Security, Publish Enterprise Data and Publish Enterprise Summaries are failing with 'Io exception: Socket read timed out' and 'Connection has been recycled. Database Pool PML'.
The status of the Global Scheduled jobs shows 'Failed'
Also there are errors like the following that are captured in the P6webaccess.html log file, that will have the same cause:
A Threadpool thread PrmThread-1 was determined to be non responsive, a new thread has been created. On a side note, check your Maximum Task Duration and Maximum Long Running Task Duration values under ThreadPool settings
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