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

Resolved Power Server - DB setup as in hostname

  1. Advice
0
Votes
Undo
  1. Sim Joo Pee
    Sim Joo Pee
  2. PowerServer
  3. Thursday, 15 June 2023 09:36 AM UTC

Hi Master,

  I am trying to setup the Database cache's Server Host in hostname instead of IP address. Compilation no error. When i try to launch it, connect to web server ...etc. It gave me error. sqlHandle_08_761DB45. (see attachment).  I dnt have this error if the Database Server Host is in IP address. Please advice. Thank you.

Attachments (1)
PS_Handle.JPG PS_Handle.JPG
Powerserver - error [08001] Error
Try to deploy APISERVER app to on premise IIS
Responses (2)
Sim Joo Pee
Sim Joo Pee Accepted Answer Pending Moderation
  1. Friday, 16 June 2023 06:30 AM UTC
  2. PowerServer
  3. # 1

Hi,

  Yes, i found it is found in Esql folder. So, what should i do ? I dnt understand what you trying to explain? If i run from IDE, there is no issue. Please help. thanks.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 16 June 2023 16:12 PM UTC
Logan thinks that the REST Web APIs on your server are corrupt/missing the embedded SQL. Delete the folder that contains the source code of the generated C# Web API. Do a full build so it regenerates everything. Then compile the C# Web APIs and deploy to your server.
  1. Helpful 1
Sim Joo Pee
  1. Sim Joo Pee
  2. Monday, 19 June 2023 03:33 AM UTC
Hi,

I removed all and full build and regenerated and it worked finally. Thanks. However i still saw it in Esql folder. Is that normal? Besides that, there are many others too in this folder. Is that correct?

Thanks.
  1. Helpful
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 June 2023 10:31 AM UTC
  2. PowerServer
  3. # 2

Hi Sim,

When "Build & Deploy", the embedded SQL statements will be placed into the CS file under the PowerServer C# solution > "AppModels" project > [appname] > "ESql" folder according to their types, for example, Delete, Insert, Select, SelectBlob, Update, UpdateBlob etc. Refer to: https://docs.appeon.com/ps2022r2/Embedded_SQLs.html

If there is no sqlHandle_08_761DB45 in the C# solution (PowerServer Web API), you may see this error.

Please make sure the database configuration is correct and Build & Deploy the PowerServer project again. Make sure there is no error in the PB IDE output.

You can also refer to: https://community.appeon.com/index.php/qna/q-a/sql-handle-error-running-powerserver

Regards, Logan

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.