Question

1
Replies
96
Views
Close popover
Naveen Mekala (NaveenM4289)
HSBC

HSBC
IN
NaveenM4289 Member since 2015 40 posts
HSBC
Posted: February 10, 2016
Last activity: February 10, 2016
Closed

System is not adding entry into pr_sys_context table

Hi team,

We are using PRPC 6.1SP2. We are facing the issue in PROD frequently but not consistently. After session timed out, system is not adding entry into pr_sys_context table sometimes.

We added the below entry in prconfig xml file to save into pr_sys_context table.

<env name="initialization/persistrequestor/storage" value="database" />

We dont find any issue in non Prod but in PROD we see the issue in some cases.

We have a requirement not to allow multiple logins with same user.

When user already logged in, we add an entry into custom table and this entry would be removed when the user logged off or requestor is timed out. Agent runs for every 15 mins will check for pr_sys_context table and if entry is available in pr_sys_context table then that user record is cleared from custom table. If the entry available in custom table another session will not be logged in with the user.

But sometimes, even if the session timed out entry is not being added to pr_sys_context table which causes agent not able to pick the record so another session is not able to logged in.

Security System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.