Bug 7472

Can a DW 'overflow' cause the client to crash? 17 November, 2021

Thomas Bytebier
08 November, 2021
Product: PowerBuilder Category: DataWindow
Version: 2019 R3 Build: 2703
Classification: Issue Publishing: Public
Priority: P3
Status: Closed Reason: CANNOT REPRODUCE
Ken Guo @Appeon 17 November, 2021
#5
Hi Thomas,

Thanks for sharing this information with us.
We will close this ticket first and please feel free to open a new one if you encounter any problems.

Regards,
Ken
Thomas Bytebier 17 November, 2021
#4
Hi Ken,

Our application is used in a 24/7 environment and crashes randomly about 5 times per day, but because we cannot reproduce the crash, this bug can be closed. We'll create a new bug if we manage to reproduce the issue.

Thanks.

Kind regards,

Thomas Bytebier
Ken Guo @Appeon 10 November, 2021
#3
Hi Thomas,

From the log you provided, it is true that there is a problem with Web Browser. If we want to locate the root cause, we need you to provide a small case.

I suggest you pay more attention to Web Browser to see if you can find the pattern of reproducing the crash, and then make a small case for us so that we can better locate the issue and analyze it.

Regards,
Ken
Thomas Bytebier 09 November, 2021
#2
lbs.evtx (68KB)

Hi Ken,

We asked these questions because we have some users where the client suddenly crashes. We have no idea when or how, so there is no way to reproduce the issue in a test case. We just expected the char overflow might have been a cause.

However, I also attached a (small) export of the event viewer. The user was opening a PDF file using the new Chromium web control when the client suddenly crashed. The faulting module name "libcef.dll" is something we have seen before in the event viewer of users who also experience sudden crashes. Is this helpful?

Thanks in advance!

Thomas
Ken Guo @Appeon 08 November, 2021
#1
Hi Thomas,

We haven’t had any crash issues reported caused by insufficient field length in DW.
I suggest you send Windows Error Events to us for a look when the application crashes.

Meanwhile, can you build a small case that can reproduce this issue for our analysis, including PBL, DB Table, Store Procedure syntax, and so on?


Regards,
Ken
Thomas Bytebier 08 November, 2021
Dear support,

We have been using Powerbuilder since version 4.0. We have always thought there is a memory leak if we return more data for string fields than defined in the datawindow.
E.g. define a string as char(30) in the datawindow, but the stored procedure returns 50 characters. We think that it causes memory leaks or stack traces. 
It seems that the Powerbuilder executable suddenly crashes if it occurs too often. We now have it more often and we have a lot of DW’s and stored procedures.

Could you:
- Indicate true/false if the behaviour is right?
- And can you help us how to determine these DW overflows? Perhaps some undocumented error event?

Thanks in advance!

Thomas Bytebier
OS:
Windows Server 2012 R2
Platform:
64-bit
Database Type:
SAP ASE
Database Version:
16.0 SP04