• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Very isolated problem with SaveAs(..., XLSX!) to network fileshare...

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

Resolved Very isolated problem with SaveAs(..., XLSX!) to network fileshare...

  1. Issue
0
Votes
Undo
  1. dale walker
    dale walker
  2. PowerBuilder
  3. Wednesday, 13 January 2021 01:03 AM UTC

Hello,

Running into strange and isolated issue with handful of users where the PB190.exe stopped working error occurs during dw_1.SaveAs (ls_file[1], XLSX!, true) call from application runtime when saving to network fileshare.  Same users can successfully SaveAs() to XLSX and local drive then manually copy file(s) to the network fileshare folder.    This is not a problem for 200+ other users. 

Tried running application compiled with PB 2019 and 2019 R2 runtimes with these users but with same result.  Confirmed runtime files pbDWExcel12Interop190.dll and Sybase.PowerBuilder.DataWindow.Excel12.dll are correct version for the runtime.    All 200+ app users are running Windows 10 November 2019 Update OS build 18363 and Excel 365.  

Any suggestions?  

64 bit vs 32 bit
use powerbuilder debugger
Responses (2)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 13 January 2021 12:23 PM UTC
  2. PowerBuilder
  3. # 1

Maybe this is playing a role here?

Comment
Load more comments
John Fauss
  1. John Fauss
  2. Wednesday, 13 January 2021 20:07 PM UTC
What if the user starts the application without the bat file (starting the exe directly)?

Also, can the user try right-clicking the icon for the bat file and select "Run as Administrator" to see if that changes anything?
  1. Helpful
dale walker
  1. dale walker
  2. Wednesday, 13 January 2021 20:57 PM UTC
john, yes confirmed that was attempted already as well
  1. Helpful
John Fauss
  1. John Fauss
  2. Wednesday, 13 January 2021 21:58 PM UTC
Try a refresh of the application exe, pbd's, and all runtime DLL's on a failing user's machine? Temporarily disable anti-virus software? I'm out of ideas, Dale.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 13 January 2021 01:43 AM UTC
  2. PowerBuilder
  3. # 2

Greetings, Dale -

As a test, can a user that is experiencing this problem manually create and save an Excel spreadsheet to the same network fileshare? This is not the same thing as saving the XLSX file to a local disk and manually copying it to the network fileshare. If they cannot, that would seem to indicate a permissions-related cause. Is there any common traits, rights, permissions, connection type (on-site, remote desktop, VPN, Citrix, etc.) shared by the ones that are experiencing this issue?

Regards, John

Comment
dale walker
  1. dale walker
  2. Wednesday, 13 January 2021 19:26 PM UTC
John, thanks for the taking the time. Confirmed, yes user is able to save XLSX directly from Excel 365 UI to the same folder on network fileshare.
  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.