Unable To Change Owner of WCI Job Due To Error "Unable to receive data from server before time-out occurs" and DatabaseCommandTimeout Setting Not Being Available
Last updated on DECEMBER 02, 2016
Applies to:Oracle WebCenter Interaction - Version 10.3.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2013***
When attempting to change the owner of a Webcenter Interaction (WCI) job, a 30 second database timeout may generate the generic portal error, "Error - The server has experienced an error...".
The error in Logging Spy (PTSPY) appears as follows:
The SQL query that is executed when this error occurs will look similar to the following:
FROM PTVUSERS A, PTADMINFOLDERSECURITY B,PTVGROUPMEMBERSHIP C, PTMIGRATION M
WHERE C.USERID=@p0 AND C.GROUPID=B.GROUPID AND A.FOLDERID=B.FOLDERID AND A.FOLDERID =@p1 AND M.OBJECTID=A.OBJECTID AND M.CLASSID=1 AND B.ACCESSLEVEL >= @p2) A ORDER BY LOWER(A.NAME) ASC',N'@p0 int ,@p1 int ,@p2 int ',@p0=2441237,@p1=299,@p2=3
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