• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Select Error: Transaction does not exist. Transaction ID

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

Resolved Select Error: Transaction does not exist. Transaction ID

  1. Issue
0
Votes
Undo
  1. Stèphan Eizinga
    Stèphan Eizinga
  2. PowerServer
  3. Friday, 22 April 2022 16:17 PM UTC

We are in the process of converting our application to a PowerBuilder application.

We use dynamic connections and after a while we get the following message.

'Select Error: Transaction does not exist. Transaction ID xxxx-xxxx-xxx-xx-xx'

We don't call any DISCONNECT or something like that.

Looks like an setting problem?

How do I deploy the PowerServer2022 Administrator ...
Title: PowerServer failed to start. Failed to veri...
Accepted Answer
Stèphan Eizinga
Stèphan Eizinga Accepted Answer Pending Moderation
  1. Thursday, 19 May 2022 13:54 PM UTC
  2. PowerServer
  3. # Permalink

It looks like an timeout issue we have changed some timeouts and it looks to work for now.

Comment
Louis Arena
  1. Louis Arena
  2. Wednesday, 26 October 2022 17:44 PM UTC
can you tell me what timeout you changed to fix this, I am converting as well and getting the same errors.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 26 October 2022 18:09 PM UTC
The "transaction" and "command" timeouts are what you need to adjust. If you use temp tables in your transaction, you also need to enable long connection option. Please read these docs:

Timeout Settings - https://docs.appeon.com/ps2022/Configure_timeout_settings.html

Long Connection - https://docs.appeon.com/ps2022/Enabling_long_connections.html
  1. Helpful
There are no comments made yet.
Responses (4)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 16:43 PM UTC
  2. PowerServer
  3. # 1

For PowerServer, it is cloud architecture so does not work same as client p/server.  You need to pre-define all your DB connections in the Web API project.  What you can do is dynamically switch the DB to use for your transaction object by assigning CacheName property in DBParm.  I suggest you carefully read the documentation:  

https://docs.appeon.com/ps2021/bk04ch13s03s02.html

https://docs.appeon.com/ps2021/Setting_up_dynamic_database_connection_for_the_app_runtime.html

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 17:09 PM UTC
  2. PowerServer
  3. # 2

Hi Stèphan ;

  Unfortunately, you have not given us much information to go on in order to answer your question.

Can you tell us...

  • O/S version & build that you are using?
  • PowerBuilder Version & build that you are using?
  • PowerServer version & build that you are using?
  • DBMS version & build that you are using?
  • What technology are you converting from?
  • What DB Client is the PB App using to connect to the DBMS?
  • etc

Regards ... Chris

 

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 22 April 2022 17:27 PM UTC
  2. PowerServer
  3. # 3

Seems like a timeout issue...

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.