Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

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]
Thu, 09/18/2008 - 8:06am
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

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 3238 reads
Fri, 09/19/2008 - 2:43pm
#1
Ashar's picture
Ashar
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..

Top
Sun, 09/21/2008 - 3:47am
#2
Nitin's picture
Nitin
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

Top
Sun, 09/21/2008 - 12:56pm
#3
Ashar's picture
Ashar
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

Top