Bug 4992

Application aborts when saving DataWindow as XLSX! 03 August, 2020

Roland Smith
28 July, 2020
Product: PowerBuilder Category: DataWindow
Version: 2019 Build: 2082
Classification: Publishing: Public
Priority: P3
Status: Transferring Reason:
Govinda Lopez @Appeon 03 August, 2020
Thanks for the update Roland,

I'll pass this as a documentation bug to our documentation team for their analysis. We will keep you posted here.

Roland Smith 31 July, 2020
We have confirmed that installing the file into the GAC fixes the abort.

We are not using the packager tool, we use InstallShield. The PowerBuilder Runtime topic in the help file doesn't mention that it should be in the GAC, only the packager topic does. The runtime topic should be updated.
Govinda Lopez @Appeon 30 July, 2020
Hi Roland,

The Sybase.PowerBuilder.DataWindow.Excel12.dll file will be installed to the Windows GAC folder, for example, C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Sybase.PowerBuilder.DataWindow.Excel12, when you run the MSM or MSI package created using the PowerBuilder Runtime Packager tool. If it wasn't, then do install it in the GAC. (https://docs.appeon.com/pb2019r2/application_techniques/ch36s02.html)

Please let us know if this worked for you.

Roland Smith 29 July, 2020
Is it required that Sybase.PowerBuilder.DataWindow.Excel12.dll be installed into the GAC? Currently it is just in with the other PB runtime folders installed with the application. Users who have also installed InfoMaker are not having the problem, perhaps because it does the GAC install?
Govinda Lopez @Appeon 29 July, 2020
Hi Roland,

We were not able to reproduce your case. Can you provide us with a simple reproducible test case? That would help us pinpoint out the problem.

Roland Smith 28 July, 2020
This is in our PB application that is deployed to end users.
Govinda Lopez @Appeon 28 July, 2020
Hi Roland,

I was not able to reproduce your case. I tried with PB opened and also with executable file. I also tried prompting the SaveAs popup window and setting it with the full details dw_customer.Saveas("C:\PB_Workspaces\2019R2\Support\Bug4992\test.xlsx", XLSX!, TRUE). InfoMaker is not installed on the Machine.

Is this happening with compiled PB app or running on the PB IDE?

Please try reinstalling PowerBuilder. Do let us know if this did any difference for you.

armando herrera @Appeon 28 July, 2020
Hi Roland, 

Thank you very much for your report.

We are working on it and we will get back to you after analyzing it.

We'll keep you posted here!

Roland Smith 28 July, 2020
The end user is doing a SaveAs in the PB application. The SaveAs window appears and they choose Excel12 with headers. The application aborts with the 'Product File has stopped working' message.
The datawindow has 1 row and 15 columns, no nested reports or dropdowns, just a simple free form.
The abort happens when the user does not have InfoMaker installed. If InfoMaker is installed, the problem goes away.
I have verified that the two DLL files listed in the docs are present as well as the required .Net Framework.
Windows 10
Database Type:
Microsoft SQL Server
Database Version: