02-07-2014 12:33 AM
Hi All -
I would like to ask for help regarding the timeout issue we are encountering when we associate a project to an existing program. Upon clicking Add Project button, the project look up is shown and after a while, an error is encountered: "Validation Query Timed Out".
We already increased the AUTO_COMPLETE_QUERY_TIMEOUT setting from 30 to 60. It was working for a while, but now the timeout issue is re-occurring.
Any help is appreciated! :)
03-06-2014 01:19 AM
Please check if the user that you are using, the one that is getting this error, has the "View all Projects" access grant.
Run the below query for two different users, one who has the "View all Projects" access grant , and the other who does not have this access grant.
select pm_utils.Has_Override_Access_Grant() from dual;
Lets see how long it takes for different users.
04-04-2014 10:55 AM
Upon checking, not all users who are encountering the time out error only has the "View Projects" access grant.
My own id has both the "View Projects" and "View All Projects" access grant and I am also getting the timeout error.
Is there a way to limit the projects that users get when searching?
Thank you for your response.