PB Web Quit Unexpectedly

[Former Member]

Hi All,

I have a PB web hosted in a Windows 2008 R2 64-bit server. My User reported that the web auto quit itself and back to login page. I found that the Server Event Log having many similar errors as below:

Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7a5f8

Faulting module name: PBSHR115.dll, version: 11.5.1.4964, time stamp: 0x4da50417

Exception code: 0x80000003

Fault offset: 0x000f4627

Faulting process id: 0x13ec

Faulting application start time: 0x01d0d0dbf25b9d90

Faulting application path: C:\Windows\SysWOW64\inetsrv\w3wp.exe

Faulting module path: C:\Program Files (x86)\Sybase\Shared\PowerBuilder\PBSHR115.dll

Report Id: 98cbde24-3ccf-11e5-af06-000c291214ba

Development environment:

- PB 11.5.1 Build 4964, Windows 7 Enterprise

- Oracle 11g

Please advice, many thanks.

Regards,

VS Chew

[Former Member]

Hi Both,

I roughly able to simulate the scenario, which are:

1. DW in querymode = Y

2. Click on Tab button in a decimal column

3. Click on a button to set querymode = N and retrieve output

It will prompt me an error in the step 3 with the error below and not able to proceed anything, need to close the IE and access back to the web

Please advice.

Thanks.

Regards,

VS Chew

[Former Member]

Hi VS;

  Great detective work! 

  Unfortunately, this sounds like a PB bug in the WebForms feature. To add to that, there were many issues with the Webform feature in PB 11.x releases.

  Sybase may have fixed it in later 12.x releases. The PB version you are using is no longer supported so a fix for this version is not going to happen. The other issue is that SAP removed the webforms feature in PB 12.5.2 and thus is no longer supports Webforms from that version onward.

  I can only see two possibilities to resolve this - a) upgrade to PB 12.5.1 (last Webforms supported version and see if that resolves the issue or b) try looking for a work around.

For a work around, I would suggest:

1) Have a look at the code in your DW's GetFocus, LooseFocus, ItemChanged, and/or RowFocusChanged events to see if there might be some code that might make the DW control unstable.

2) Try using SetReDraw (True/False) around the QueryMode Y/N code to help reduce processing around the state switch.

3) Add TRY..CATCH commands around the QueryMode Y/N code.

4) Make sure that your DW Control have the Error and ItemError events coded to trap other issues surrounding the decimal column.

5) Try using a Yield ( ) command around the QueryMode Y/N code to let the DW Control complete its processing before you ask it to do more work.

HTH

Regards ... Chris

[Former Member]

You might be able to find a log file under iinet/webroot/ < your app > containing a PB system error message equivalent.

Adding to Chris questions

5) is it following a period of inactivity?

[Former Member]

Hi VS;

   This sounds like you are describing a WebForms based application. Is that the case?

Can you tell us ...

1) Have other users complained about the same problem?

2) Does the application fail at the same place each time?

3) Have their been any changes recently to the Application or Environment?

4) Any recent MS patches been applied?

Regards ... Chris

[Former Member]

Hi Chris,

Thanks for prompt reply, my answer as below:

1) Have other users complained about the same problem? - Yes

2) Does the application fail at the same place each time? - No, happened in different entries

3) Have their been any changes recently to the Application or Environment? - Last application changed on 02-Jul-2015

4) Any recent MS patches been applied? - Server? If yes, last Windows updates on 26-Apr-2015

Thanks.

Regards,

Vin See