My Oracle Support Banner

SQL "Execution timeout expired." Exception Thrown By Jobs Run With WCI 10.3.x Automation Server (Doc ID 1096511.1)

Last updated on JULY 01, 2020

Applies to:

Oracle WebCenter Interaction - Version and later
Information in this document applies to any platform.


Jobs that run queries against the DB where the result takes longer than 30s to return fail with exceptions similar to the following in both the joblog and Automation logging spy:

Mar 23, 2010 12:45:15 PM- JobShell: Exception occurred when processing operation operation 0:22: Error in function PTScheduler.DeleteJobHistory (olderThen == March 16, 2010 12:44:40 PM PDT): Exception: [plumtree][SQLServer JDBC Driver]Execution timeout expired. SQL: '/* DELETE_FROM_JOB_LOGS:ANSI */ DELETE FROM PTJOBLOGS WHERE INSTANCEID < (SELECT MAX(INSTANCEID) FROM PTJOBHISTORY WHERE RUNTIME <=?)'


This problem can occur in all 10.3.0.x environments, including those patched to, as well as in 10.3.3. In all cases, apply the solution provided in this article.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.