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

Resolved ct_cmd_alloc():user api layer: external error: The connection has been marked dead. - Error for VPN users

  1. Issue
1
Votes
Undo
  1. Gayathri Narayanan
    Gayathri Narayanan
  2. PowerBuilder
  3. Friday, 29 May 2020 14:22 PM UTC
Our PB applications crash and throw the DB error below:

ct_cmd_alloc():user api layer: external error: The connection has been marked dead.
 
This happens for users who connect to our network via VPN step away from their machine for a while.  It is because the VPN connection briefly drops so often, but it reconnects automatically so the user is only noticing the issue only in our PB applications.  The applications have to be restarted.  This is not the case with web pages or non-PB applications. Is there a way for the PB applications to be able to reconnect automatically after the network disconnects and reconnects.
 
 
Thanks
Gayathri Narayanan
Do a refresh by GIT without IDE PB19 R3
None of Datawindow's object focused
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 10 May 2021 22:18 PM UTC
  2. PowerBuilder
  3. # 1

The only way I know of to do this is to put a timer in your code to check the connection every "X" minutes. If your sqlca (or whatever) is not connected, then you reconnect to the database.

The PFC has a nice function called "of_isconnected()" which returns TRUE or FALSE. Copy the function if you are not using the PFC.


Olan

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 10 May 2021 19:19 PM UTC
  2. PowerBuilder
  3. # 2

This is unreliable way to give users remote access.  I recommend using PowerServer 2021: https://www.appeon.com/products/powerserver

 

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 11 May 2021 23:09 PM UTC
Hi Armeen;

FYI: Many PB Apps that I know of use temporary tables. Especially my favourite - for example...

Select Col1, Col2, ... from TableA, TableB, etc into #TEMP; // LUV this SS / ASE feature! ;-)

Regards ... Chris

  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 11 May 2021 23:31 PM UTC
Hi Chris, Most of the unsupported in PowerServer 2021 are due to architectural differences between client/server and REST API architecture because on the client side we use same PBVM as client/server apps. So it doesn't matter how popular an unsupported feature is... changing architecture will require rethinking some things. But there is nothing else on the market that comes close to how fast and easy PowerServer 2021 is!
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 14 May 2021 15:43 PM UTC
Hi Redentor, I just wanted to make sure you were aware that temp tables are supported with the exception of the temp table is used by different transactions. Also, we have updated our Unsupported Features Guide to provide some workarounds: https://docs.appeon.com/pb2021/whats_new/ch01s04s02.html#d0e6295
  1. Helpful
There are no comments made yet.
Redentor Cruz
Redentor Cruz Accepted Answer Pending Moderation
  1. Monday, 10 May 2021 18:59 PM UTC
  2. PowerBuilder
  3. # 3

Hi Gayathri, has this issue of yours been resolved?   We're experiencing the same issue right now when we moved our end users from RDP to VPN.

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.