Project and Portfolio Management Practitioners Forum
cancel

Connection delays in PPM log during workflow Graphical View

Highlighted
Cherie Machler
New Member.

Connection delays in PPM log during workflow Graphical View

We are suddenly having problems in production with viewing workflows in the Graphical View. The display of the graphical view is going from a couple of seconds to four minutes. We turned on logging in development and ran Graphical View. I can see the SQL statements in the jdbc log file but the elapsed time on the timestamp doesn't seem to be increasing during the execution of the SQL. I did notice in the log file that the only step that showed elapsed time was during the release-connection and request-connection steps. My question is what release-connection and request-connection means in the log file. Is SQL running in the background during this time? Or is it already completed? Thanks for any insight that you can give me.

FOllowing is the excerpt from the log:

Tue Jul 28 09:48:22 CDT 2009 [1248792502492]




556.622


false


Tue Jul 28 09:48:22 CDT 2009 [1248792502492]




Tue Jul 28 09:48:30 CDT 2009 [1248792510380]


556.623


0


false


true