Robotic Process Automation (RPA)

 View Only
  • 1.  WDG Cloud Scheduling Issue

    Bot Builder
    Posted Fri May 14, 2021 09:55 AM
    Hello everyone,

    I'm encountering a problem when trying to schedule the bot to run from the cloud platform, related to Microsoft office. Everything is working fine until the bot reaches a point where it should open office app and write into that opened file. Basically the issue emerges from the open office command. Since I'm not really sure what exactly is going on, I'll place the error code below for everyone out there to check. The logic behind the error is simply that my office is not supported, but it's actually updated to the latest version.

    System.NotSupportedException: Microsoft Office versions prior to 2010 are not supported
    at WDG.Automation.MicrosoftOffice.OfficeFactory.New(OfficeDrivers driver)
    at WDG.Automation.Windows.OfficeOpenCommand.jq2AabrUcs(IOfficeFile& , OfficeApplicationVariant& )
    at WDG.Automation.Windows.OfficeOpenCommand.Execute(WindowsContext context)
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at WDG.Automation.Language.ErrorHandler.U6tfsDdhaS(Exception )
    at WDG.Automation.Language.ErrorHandler.HandleExecutionExceptionIfNeeded(Exception exception, IAutomationCommand command)
    at WDG.Automation.Language.CommandInterpreter.<Run>d__12.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at WDG.Automation.Language.ScriptInterpreter.<RunCore>d__17.MoveNext()

    ------------------------------
    Stefan Stefanov
    ------------------------------


  • 2.  RE: WDG Cloud Scheduling Issue

    Posted Mon May 17, 2021 03:40 AM
    Hi Stefan,

    By the look of the error, it is likely there is an office version problem rather than a scheduling problem.  Does the bot run from Studio?  Do you have old versions of Office still installed?  Maybe uninstall office completely then install the latest.

    Regards,


    ------------------------------
    NIGEL CROWTHER
    ------------------------------



  • 3.  RE: WDG Cloud Scheduling Issue

    Bot Builder
    Posted Mon May 17, 2021 03:53 AM
    Hello Nigel,

    First of all thank you for the reply. I believe the error is strictly related to scheduling and executing from the Cloud, because when we run it from the Studio, the bot executes with no problems whatsoever. I've also checked for older versions of office and nothing comes up.

    Regards,


    ------------------------------
    Stefan Stefanov
    ------------------------------



  • 4.  RE: WDG Cloud Scheduling Issue

    Posted Mon May 17, 2021 04:25 AM
    Hi Stefan!

    As we have earlier spoke and as Nigel also suspects, this is not likely to be a scheduling issue. What scheduling does, it runs the same WAL-script / bot that you have developed and tested in the Studio using the runtime defined for the schedule.

    The Office commands use Windows registry to determine if the Office is installed and available. Could you please provide the registry value for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office from the computer where the WAL-script works and also from the computer where it does not. Thanks!

    ------------------------------
    Jukka Juselius
    Senior Solution Architect - IBM EMEA
    WDG Automation Program Lead for EMEA
    IBM Technology - Business Automation
    ------------------------------



  • 5.  RE: WDG Cloud Scheduling Issue

    Posted Fri December 10, 2021 04:45 PM
    Hi friends!

    Did anything cleared in this question?
    I have exactly the same problem, and can not figure out how to solve...
    From studio, the bot runs like a charm, from launcher, and from web browser it tells me that the "Microsoft Office versions prior to 2010 are not supported".
    Amazing.

    Thanks for any help!
    Kind regards!

    István Nagy

    ------------------------------
    István Nagy
    ------------------------------



  • 6.  RE: WDG Cloud Scheduling Issue

    Posted Sat December 11, 2021 01:27 PM
    By the way... Office 2019 is the installed version...

    ------------------------------
    István Nagy
    ------------------------------



  • 7.  RE: WDG Cloud Scheduling Issue

    Posted Sat December 11, 2021 02:09 PM
    Mmm... I found a bypass, until the problem will be solved, maybe others are interested in it:

    openFile --file "C:\\Program Files\\...\\WINWORD.EXE" --args "C:\\Users\\...\\Sablon_02.docm" WordProcessId=value
    delay --timeout "00:00:05"
    officeAttach --type "Word" --title "Sablon_02.docm - Word" WordApplication=officeapplication WordProcessId=processid

    This seems to be stable, if you use the delay between the other two lines, without it officeAttach may fail.

    Kind regards

    ------------------------------
    István Nagy
    ------------------------------



  • 8.  RE: WDG Cloud Scheduling Issue

    Posted Sun December 12, 2021 05:03 PM

    Hello István!

    The original issue with Stefan was related Excel and was actually fixed by a special fix from the engineering team. It seems that in certain situations RPA might fail to inspect the Office version available.

    But, it seems like you have this under control with the delay? If you want, I can try to push this to our engineering team.



    ------------------------------
    Jukka Juselius
    Senior Solution Architect - IBM EMEA
    IBM RPA Program Lead for EMEA
    IBM Technology - Business Automation
    ------------------------------



  • 9.  RE: WDG Cloud Scheduling Issue

    Posted Sat December 18, 2021 09:20 AM
    Hi Jukka!

    Yes, my problem is solved this way.
    In the other hand - I think - this is still a problem, so I guess it would be nice to make it work the way as the documentation tells.
    Just to make IBM RPA a better product, which has one less bugs in it. :-)  (If it's really a bug - as I imagine -, and not my fault somewhere in the environment)

    Thanks!
    István

    ------------------------------
    István Nagy
    ------------------------------