Question

4
Replies
42
Views
Rosemarie Biacolo (Rose030494)
Deloitte
Senior RPA Developer
Deloitte
CA
Rose030494 Member since 2018 5 posts
Deloitte
Posted: February 17, 2021
Last activity: February 19, 2021
Posted: 17 Feb 2021 13:28 EST
Last activity: 19 Feb 2021 10:56 EST

Excel 'Save As' issue in Virtual Machine

Hi,

Not sure if anyone experienced this but we are having issues saving an excel file in our production virtual machine (see below error snippet). Our code is working fine from Dev and UAT region and able to save the excel report with no issues. 

We already checked the office license, versions and also try to manually save it and no issues with these things.

 

Office Version: Office (2016)

Pega Version: 19.1.49

Excel Method Used: C# Script

 

'System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC

   at Microsoft.Office.Interop.Excel.WorkbookClass.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local)

   at Dynamic.Script_8D70AC9F674F417.Script.CreateEODReport(String strTemplatePath, String strNewFilePath, Int32 sheetIndex, DataTable dt, Int32 startIndex, String& exceptionMsg)'

 

Pega Robotic Automation 19.1 Robotic Process Automation Technology Services System Architect