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

Resolved Powerserver Transaction gets disconnected

  1. Issue
0
Votes
Undo
  1. Louis Arena
    Louis Arena
  2. PowerServer
  3. Wednesday, 26 October 2022 20:56 PM UTC

I am in the process of converting and testing my PB app to Powerserver 2022.  What I am noticing is that after I log in and just wait at some point the transactions get disconnected.  I am sure this is a timeout setting I can set but not sure where.  This has never happened in the IDE, so not sure why it is happening here.

For further explanation.  I log into the app, I run a report and the report comes up.  After I wait a while I try and run another report and that is where I get the Transaction error.  This happens on the remote server and on my development laptop.

Thanks 

Could not load file or assembly 'OracleManagedData...
A Look Under the Hood
Accepted Answer
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Friday, 28 October 2022 10:15 AM UTC
  2. PowerServer
  3. # Permalink

Hi Louis,

Please refer to these knowledge bases to see if they are helpful.

https://www.appeon.com/developers/get-help/knowledgebase/transaction-does-not-exist

https://www.appeon.com/developers/get-help/knowledgebase/transaction-timeout

https://www.appeon.com/developers/get-help/knowledgebase/experiencing-timeout-when-stored-procedure-complex-sqlselect-takes-more-than-30-seconds-execute

If still not solved, please report your issue via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/

Regards, Logan

Comment
There are no comments made yet.
Responses (6)
Louis Arena
Louis Arena Accepted Answer Pending Moderation
  1. Friday, 28 October 2022 19:52 PM UTC
  2. PowerServer
  3. # 1

Hey everyone, thanks for the help.  I got this link from Logan Liu at Appeon

https://www.appeon.com/developers/get-help/knowledgebase/transaction-does-not-exist

 

It explains my issue perfectly.  What is happening is some of my datawindows are calling stored procedures for read only.  However, PowerServer has no idea it is read only - it assumes there is an update, therefore it keeps the transaction open.  This is why I am timing out.  The same thing holds true for embedded sql.

I am going through my code and either changing the transaction for reports to a transaction that has autocommit set to true or I have to manually issue a commit.

 

Louis

Comment
John Fauss
  1. John Fauss
  2. Friday, 28 October 2022 20:50 PM UTC
That is great news, Louis! Thanks for sharing the explanation and solution. Would you please mark this issue as resolved when you get a chance?
  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 21:29 PM UTC
  2. PowerServer
  3. # 2

do you mean the session gets disconnected, or the transaction?

transaction means you are running a long process, maybe a big sql select.  

 

session gets disconnected is basically you are idle.  I don't recall the default for that, i'd say at least an hour.  

 

In either case, how long are you talking? 1 minute, 1 hour, 1 day?

Comment
There are no comments made yet.
Louis Arena
Louis Arena Accepted Answer Pending Moderation
  1. Thursday, 27 October 2022 20:59 PM UTC
  2. PowerServer
  3. # 3

I am still having this problem.  See the attached image from my applications.jason transaction parameters.  Please note that IIS, the .Net server and SQL server are all on the same box.  The box is more than powerful for this testing as we are a seasonal business and we have a limited staff right now.  Any help is appreciated as this is very frustration.

 

 

Attachments (1)
c-snap transaction timeout parameters.JPG c-snap transaction timeout parameters.JPG
Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 October 2022 21:22 PM UTC
  2. PowerServer
  3. # 4

Make sure your IIS and your database are in same LAN.  Otherwise, it's gonna be unstable and unreliable.

Comment
Louis Arena
  1. Louis Arena
  2. Thursday, 27 October 2022 12:19 PM UTC
I am testing this out and the IIS, .Net and SQL are all on the same server!
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 27 October 2022 14:28 PM UTC
Ok great, then probably you just need to adjust the timeout settings and possibly the Long Connection option.
  1. Helpful 1
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 October 2022 21:14 PM UTC
  2. PowerServer
  3. # 5

Hi Louis,

Please review this page to see where to locate these settings.

Hope this helps!

Regards,
Francisco

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 26 October 2022 21:20 PM UTC
Adding to what Francisco said, the Command Timeout and Transaction Timeout are what you want to adjust. Also, if you are using temp tables in your transaction you need to enable Long Connection option: https://docs.appeon.com/ps2022/Enabling_long_connections.html
  1. Helpful
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.