Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Timeouts occurring in PowerServer web app so Oracle session is lost.

  1. Issue
0
Votes
Undo
  1. Michael Turton
    Michael Turton
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 7 September 2021 11:19 AM UTC

Hi,

I am getting database connection timeouts on a PowerServer 2020 web application even when in use (not idle).  Seems to be after several minutes.   The app will automatically reconnect to the Oracle 12c database but the fallout is that the session context is lost so duplicate rows are visible.  The app uses Oracle session context to separate out data records so they are visible to different users as they desire.

Any idea which timeout is happening and where?    The AEM timeout settings are all as default (3600).   There are no transaction timeout errors so it i snot that.

Thanks,

Michael Turton

 

 

  1. Oracle
  2. PowerServer Web
Code samples app is a blank screen in Edge - works...
PowerServer error connecting to Oracle: System.Dat...
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 13:15 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

"Oracle session context"

By default users share database connections in Powerserver.

Your session context won't work unless PS is setup to use per user database connection, unless you add some sort of preceding code to each sql execution to set the session context back.

The per user database connection is listed as not being supported in PS 2021.  (It is possible that has changed since PS2021 was released).

 

Comment
There are no comments made yet.
Michael Turton
Michael Turton Accepted Answer Pending Moderation
  1. Tuesday, 7 September 2021 14:01 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Thanks Mike

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.