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

Resolved Database sudden disconnect and PB crashing

  1. Advice
0
Votes
Undo
  1. Ins Build
    Ins Build
  2. PowerBuilder
  3. Wednesday, 4 August 2021 10:45 AM UTC

I have a customer who is reporting our PowerBuilder application is suddenly disappearing from the screen. I can see there is an event in the Windows Event Log showing the application has crashed, the dll in question is fairly random, usually one from the C++ or PowerBuilder runtime.

I suspect this is because a deadlock has occured in the database and the query was killed or perhaps the connection was suddenly dropped. I am looking into it :-(

But shouldn't PowerBuilder catch these issues somewhere deep down in the runtime and at least present an error message to the user?

So my question is, is this something worth reporting as a bug to Appeon, or an enahncement, or is it just impossible?

Any thoughts are most welcome.

Thanks!

 

  1. Crash
  2. PowerBuilder
In editor PowerBuilder2017 can the line numbers be...
PowerBuilder 2021 Release Date?
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 August 2021 13:13 PM UTC
  2. PowerBuilder
  3. # 1

Hi Ins;

   Is your PB coded in the SystemError event to try & capture all errors including DB ones not captured at a lower level?

Regards... Chris

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 4 August 2021 13:19 PM UTC
  2. PowerBuilder
  3. # 2

Another thing to consider is that all database activity is occurring in the database, NOT on the platform where the application is executing. When a deadlock occurs, in most cases the database does not issue an error. 

The SHOULD stop processing and issue an error, but that's not the norm, which means that your application is left hanging.

In my experience, the app just hangs when this occurs, it does not crash. There may be something else happening in the app that might bear investigation.

 

Good Luck,

Olan

Comment
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 5 August 2021 10:46 AM UTC
  2. PowerBuilder
  3. # 3

Ins,

Can you mention the PB Version and OS version you use?

Here we face a similar issue when we run PB 10.5 applications in Windows 10.   Is this your case?  

Happiness Always
BKR Sivaprakash

 

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.