You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

application engine issue regarding delivered program HR_FASTVIEW

3 replies [Last post]
Guest's picture
Guest

HI ALL,

HR_FASTVIEW IS an Delivered application engine program used to udate the rowlevel security.

when simultaneously two users access this program or another process access the tables used in HR_FASTVIEW then the 2nd process or user getting an error message resource is used by another process.

So our DBA ‘s said that lock the tables that r used in this appengine program.
do we need privilages to lock the database tables?

please reply to me if any idea about this issue.

Thanks in advance
sudha

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: application engine issue regarding delivered

you may try setting the max concurrent value in the process definition for the app engine..

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: application engine issue regarding HR_FASTVIEW

This is Deadlock Issue.
Increasing max concurrent value will not resolve the issue.
You can get this around by using temp table.

Thanks
Nitin Bhatia

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: application engine issue regarding delivered program

what about setting the max concurrent value so that only one instance of program is running at any time.. :-D