Question

1
Replies
90
Views
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
Share this page LinkedIn