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

Resolved Failed to connect to the database

  1. Issue
0
Votes
Undo
  1. Riccardo Pasqualetti
    Riccardo Pasqualetti
  2. PowerServer
  3. Friday, 3 November 2023 09:40 AM UTC

 

While running the application I get this error:

 "Failed to connect to the database. Please ensure that you have configured transaction-to-cache mapping in the database configuration for the application, or have set up dynamic database connection in the DBParm"

I think I have set the database settings correctly in my project, see the pictures
What am I doing wrong?

 

 

 

 

 

Attachments (3)
Database_Advanced.png Database_Advanced.png
Error.png Error.png
Database_Basic.png Database_Basic.png
Failed to download the file "n" because it does no...
Android and iOs from PB
Responses (7)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 3 November 2023 14:35 PM UTC
  2. PowerServer
  3. # 1

Hi Riccardo ;

  Can you try deleting the PowerServer C# Repository on your development PC. You should find this folder path in your PS App Project as follows (for example) ..

So in my File Explorer, I would delete the entire "PowerServer_orderentry_32bit" folder under the "C:\Users\Chris\source\repos". You just need to perform the same action in your equivalent folders for the PS App.

After that, then perform a full Build & Deploy again of your PS App.  HTH
Regards ... Chris

Comment
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Friday, 3 November 2023 16:16 PM UTC
  2. PowerServer
  3. # 2

Ok Chris,

After I deleted the folder I redeployed.
Now I no longer have the connection error but I have this new error when the file update starts:

2023-11-03 17:01:23.687 ERROR [38600] Failed to download configuration file http://localhost:5099/mep_cloud/apprun.json; ErrorCode: 404; Error: Not Found. Learn more at: https://docs.appeon.com/ps/troubleshooting_guide/Failed_to_download_the_config_file.html

I use the built-in Kestrel server, I don't have any errors in server console.

I also tried changing the port but I still get the same error

Thanks

 

 

 
Attachments (2)
Server Console.png Server Console.png
Update Cloud App Files.png Update Cloud App Files.png
Comment
Load more comments
Francisco Martinez @Appeon
  1. Francisco Martinez @Appeon
  2. Friday, 3 November 2023 17:34 PM UTC
Did you "Build and Deploy"? Or just "deploy"?
  1. Helpful
Riccardo Pasqualetti
  1. Riccardo Pasqualetti
  2. Saturday, 4 November 2023 09:25 AM UTC
No, development enviroment don't works.

Document said to check server console for error but there aren't but application don't start, see error.

I changed port number and did Build and Deploy but don't work, I have always same error
  1. Helpful
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Monday, 6 November 2023 03:27 AM UTC
Hi Riccardo,

There are some suggestions:

1) Please make sure you have deleted the current C# solution and Build and Deploy to generate a new one. Then verify it again.

2) Could you find mep_cloud/apprun.json in your C# solution folder -> ServerAPIs -> wwwroot folder?

When running the app within the PB IDE using the local Kestrel Server, it will deploy files to this folder.

3) Which build are you using? Have you ever tried the 2022 R2 MR Build 2828?

4) Could you create a small PB case that can reproduce this issue? If you run the Example App demo, can you reproduce the same issue?

Regards, Logan
  1. Helpful
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Friday, 3 November 2023 15:17 PM UTC
  2. PowerServer
  3. # 3

Thanks Chris

Sorry but I'm just starting to use PowerServer
What do you mean by "equivalent folders for the PS App"?

Comment
Francisco Martinez @Appeon
  1. Francisco Martinez @Appeon
  2. Friday, 3 November 2023 15:42 PM UTC
Hi Riccardo,



He means the folder you have indicated in the highlighted "Web API solution location" on your project.

Remove that folder, deploy again and try running the application one more time.



Regards - Francisco
  1. Helpful 1
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Monday, 6 November 2023 11:34 AM UTC
  2. PowerServer
  3. # 4

Last error, 2023-11-03 17:01:23.687 ERROR [38600] Failed to download configuration file http://localhost:5099/mep_cloud/apprun.json; ErrorCode: 404; Error: Not Found, it's my fault becouse I don't checked option in deploy settings, see image attached

So I deleted again solution folder, build and deployed again but I have again the first error of failed connection.

Why? I don't changed anithing!

 

 

Attachments (1)
Deploy Settings.png Deploy Settings.png
Comment
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Monday, 6 November 2023 16:21 PM UTC
  2. PowerServer
  3. # 5

I installed the latest build available, 2022 R2 MR Build 2828,deleted solution folder, build and deployed again.
Now I have no more errors, the server starts but not my application. This window appears, see the attached image, it closes and then nothing.
If I try to debug, with the appropriate button, I get the database connection error again.

 

Attachments (1)
Start.png Start.png
Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 6 November 2023 17:10 PM UTC
Use HTTP instead of HTTPS as the URL. HTTPS is what you use when really compiling and deploying to remote server (not when running inside the IDE for preview purposes).
  1. Helpful
Riccardo Pasqualetti
  1. Riccardo Pasqualetti
  2. Tuesday, 7 November 2023 10:09 AM UTC
I don't use https, my url is http://localhost:5099/mep_cloud but application don't start.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 7 November 2023 13:03 PM UTC
Hi Riccardo;

Try deleting the Cloud App Launcher (CAL) from the WebServer and also uninstalling the current CAL from your system. Then deploy the CAL again from the PB IDE's "Tools" menu to the WebServer. Then try your App again. HTH

Regards... Chris
  1. Helpful
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Tuesday, 7 November 2023 14:26 PM UTC
  2. PowerServer
  3. # 6

I have deleled all, created CAL again.
I run CAL, the folders are created correctly but if I run mep_cloud.exe nothing happens.
What can I do to try to understand what is not working?

Attachments (2)
localhost_mep_cloud.png localhost_mep_cloud.png
Runtime.png Runtime.png
Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 7 November 2023 16:53 PM UTC
Sounds like you need some training on PowerServer seems you are making basic config/deployment mistakes. I would recommend contacting whoever you purchased the software from for some free training or go through this Appeon-U course: https://www.appeon.com/appeon-u/ps
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 7 November 2023 17:25 PM UTC
Hi Riccardo;

FWIW: I have migrated all my test PB Apps from build 2819 to build 2828 including PowerClient and PowerServer 32 & 64 bit versions. Then performed a Build & Run on those deployments on W10 and W11 machine and have had no upgrade / execution issues. They all worked 100% right after a Build & Run. So I am not sure why yours would be failing.

FYI: I am using W10 version 22H2 and W11 version 23H2 and using the R2 Kestrel web server in development.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Riccardo Pasqualetti
Riccardo Pasqualetti Accepted Answer Pending Moderation
  1. Wednesday, 15 November 2023 16:27 PM UTC
  2. PowerServer
  3. # 7

A small update on my situation.

Now my application start without problems from IDE in debug.

But if I run application normally, always from IDE, application crash. I have in windows registry events an error, PBVM.DLL crash.

Any ideas why PBVM crash?

 

Name of the application that generated the error: mep_cloud.exe, version: 1.0.0.1, timestamp: 0x65314535
Name of the module that generated the error: PBVM.dll, version: 22.1.0.2828, timestamp: 0x653145aa
Exception code: 0xc0000005
Offset error 0x00317d77
Process ID that generated the error: 0x3920
Launch time of the application that generated the error: 0x01da17ded231e7f3
Path to the application that generated the error: C:\Users\umberto\AppData\Roaming\PBApps\Applications\localhost_mep_cloud\mep_cloud.exe
Path to the module that generated the error: C:\Users\umberto\AppData\Roaming\PBApps\Applications\Runtime\22.1.0.2828\PBVM.dll
Report ID: 9b026ec9-f947-451b-99e3-2d0ab12c3bf4
Full package name that generated the error:
Application ID for the package that generated the error:

 

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.