1. Michael Kench
  2. PowerBuilder
  3. Tuesday, 25 May 2021 05:51 AM UTC

Hi Guys,

Hoping someone may be able to help point me in the right direction to overcome my issue. Using a modified version of the web datawindow com object "pbdwr110.dll" on a web server. Calling the object from cshtml to create forms/reports etc.

This has been working great until recently a client upgraded to windows 2019 server. The com object seems to install fine through component services however getting lots of random COMException when using it.

These 2 entries seems to be reoccurring quite often in the event log.

Faulting application path: C:\Windows\SysWOW64\dllhost.exe
Faulting module path: C:\mypathsysfolder\PBVM110.DLL

Faulting application path: C:\Windows\SysWOW64\dllhost.exe
Faulting module path: C:\mypathsysfolder\PBSHR110.dll

 

Any suggestions on how to track down further as event log gives no help on reason for crash?

 

Thanks Michael

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 25 May 2021 18:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi Michael;

     I see that you are using the PB v11.x Web DataWindow and also PB's COM object feature for that as well. Sybase deprecated the COM "Server" feature in PB 12.0 and the Web Data as well. So these features will no longer work in Appeon PB as when SAP handed the PB code-line over to Appeon is was from the PB12.6 version, where Sybase had removed those features well before hand.

Regards ... Chris

 

Comment
There are no comments made yet.
Michael Kench Accepted Answer Pending Moderation
  1. Tuesday, 25 May 2021 23:05 PM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

That is a shame. I really loved the webdatawindow.

I guess it's finally time to rewrite those old updateable datawindow forms as html.

How about the reports? Did the HTML5 reporting datawindow ever come about?

I was creating PDF's on demand from my complex, nested reports. Surely PB newer releases would have something like that where I can instantiate a datastore with childs from a library and create a PDF to redirect a web client to?

 

BTW. What does the PBSHR110.dll file do?  I the mean time I think I'll try my hand at inspecting com dump files for fun. 

 

Thanks

Michael

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 26 May 2021 00:14 AM UTC
Hi Michael;

Yes, the Web DW was really "Kool" and so was Distributed PB. I helped build an all "web" based application system at Agriculture Canada using both of those features. It had 4 DPB servers that could each handle 1,000 *concurrent* web sessions. There were 10K users on the system at multiple peak periods of the day. The DPB servers never faulted - pushing 800 peak concurrent DB threads each over to an Oracle DBMS. We even wrote our own round-robin load balancing for web session handling. All the report viewing was done via the Web DW & pure HTML generated by DPB NVUO's & HTML based DWO's housed in DataStores.

Yes, Sybase (John Strano) demoed the HTML5 DW at my Ottawa PB User group circa PB 12.5 => PB 15. However, SAP forced Sybase into stripping the features down in PB15 and releasing it as PB12.6. Unfortunately, the HTML5 DW was a casualty.

For web based PDF generation the Web DW was very effective. You can still build PB Web based Apps & do Web based PDF generation using Roland's product ...

http://www.topwizprogramming.com/topwizweb.html

The PBSHR DLL is mainly PB's runtime module for interfacing the runtime "C" calls over to the various MS-Windows API's.

Regards ... Chris
  1. Helpful
  1. Michael Kench
  2. Friday, 28 May 2021 03:49 AM UTC
Thanks. I'll take a look at some of the topwiz stuff going forward.

Good news is the comexceptions have stopped, I think the "local service" account didn't have sufficient rights to do what was needed.

My webdatawindow will live on for a little longer!
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 28 May 2021 14:34 PM UTC
Hi Michael ... that's awesome news!

Don't forget to hug a DW today! ;-)
  1. Helpful
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.