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

Resolved SQL handle error running PowerServer

  1. Issue
0
Votes
Undo
  1. Stephen Koyanagi
    Stephen Koyanagi
  2. PowerServer
  3. Friday, 15 July 2022 15:23 PM UTC

Hi,

I am getting a SQL handle error running PowerServer 2021.  When I get the error, it is an error that I cannot get out of.

I am using Powerbuilder 2021 and Oracle 19.  What does this error mean?  Any help would be greatly appreciated.

Thanks,

Stephen.

 

Appeon server mistake
Powerserver 2022 IIS requirements
Accepted Answer
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 July 2022 20:19 PM UTC
  2. PowerServer
  3. # Permalink
Adding to what Francisco said, it sounds like you made some change to a DataWindow or ESQL but the Web APIs are still the ones corresponding to a previous build or for some reason the Web API didn't get correctly generated. So first, go to PowerBuilder and make sure in General tab "Full build" is selected and in the Web API tab select a completely new solution (this is equivalent of doing full build for the Web APIs). Then, compile and deploy the newly generated Web APIs. Third, make sure the Web API URL configured in the Web API tab is pointing to where these new Web APIs are hosted.
Comment
There are no comments made yet.
Responses (4)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 July 2022 16:28 PM UTC
  2. PowerServer
  3. # 1

Hi Stephen,

This usually means that the Web APIs are out-of-sync with the Cloud Application, so it's usually fixed by re-deploying the Web APIs.

Regards,
Francisco

Comment
Stephen Koyanagi
  1. Stephen Koyanagi
  2. Friday, 15 July 2022 20:18 PM UTC
Hi Armeen,



I did a full build and it worked.

Thank you very much!

Stephen.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Saturday, 16 July 2022 16:32 PM UTC
You’re very welcome, and glad it is working now!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 July 2022 15:43 PM UTC
  2. PowerServer
  3. # 2

Hi Stephen;

  Please open a Support Ticket for this issue.

Regards ... Chris 

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 15 July 2022 20:19 PM UTC
  2. PowerServer
  3. # 3
Adding to what Francisco said, it sounds like you made some change to a DataWindow or ESQL but the Web APIs are still the ones corresponding to a previous build or for some reason the Web API didn't get correctly generated. So first, go to PowerBuilder and make sure in General tab "Full build" is selected and in the Web API tab select a completely new solution (this is equivalent of doing full build for the Web APIs). Then, compile and deploy the newly generated Web APIs. Third, make sure the Web API URL configured in the Web API tab is pointing to where these new Web APIs are hosted.
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.