• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Powerserver app connected to Oracle fails or times out

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

Resolved Powerserver app connected to Oracle fails or times out

  1. Issue
0
Votes
Undo
  1. Håvard Heide
    Håvard Heide
  2. PowerServer
  3. Thursday, 20 January 2022 08:37 AM UTC

We have compiled out application to Powerserver and it works (mostly), but  after starting App from webbrowser (or shortcut)

it times out - or fails (see errors below). Motly I get the first error, but sometimes the second.

Any ideas ?

I have tried changing timout setting , but that does'nt help.

Oracle Client:  11.2.01

DB: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

 

Regards

 

  1. 32-bit
  2. Database
  3. Error
  4. PowerServer Toolkit
PowerClient Deploye Error
Help me to activate trial license for power server...
Accepted Answer
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 20 January 2022 09:39 AM UTC
  2. PowerServer
  3. # Permalink

Hello Havard,

for that kind of errors I had to tune application.json -> Transaction -> Timeout, in the PS C# solution.

HTH.

.m

Comment
Håvard Heide
  1. Håvard Heide
  2. Thursday, 20 January 2022 11:36 AM UTC
Yes it works! Thanks



H
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 20 January 2022 12:46 PM UTC
Note that PS2021 does not support Oracle 11 ... That includes the DB Client.
  1. Helpful
Håvard Heide
  1. Håvard Heide
  2. Thursday, 20 January 2022 14:41 PM UTC
Yes - I know - we have 12 as well.

I wonder where and how to catch that "lost/timeout connection" - have tried both dberror and error event in u_dw.

Also tried error event i n_tr.

I guess the error arises because of a transaction object no longer valid or maybe NULL ?

Another Question/answer suggested testing error 08051
  1. Helpful
There are no comments made yet.
Responses (2)
Håvard Heide
Håvard Heide Accepted Answer Pending Moderation
  1. Thursday, 20 January 2022 10:57 AM UTC
  2. PowerServer
  3. # 1

Thanks

Like this? transaction timeout from 120 -> ie. 3600  ?

"Applications": {
    "cts5_psrv": {
      "CloudTransactions": {
        "sqlca": {          "CacheName": "SQLCA"        }      },
      "Transaction": {        "Timeout": 3600,        "TransactionException": true      },
      "Session": {        "Timeout": 3600      },
      "Request": {        "Timeout": 3600      },
      "RunMode": 0

 

 

Will it be overwritten on next deployment ? I guess I have to remove Overwrite server settings ?

Regards

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.