I am facing an issue with an advanced Excel command. I have checked with our IT team and reinstalled the software, but I am still encountering the same problem. Please investigate and resolve this issue
To determine the problem, we need to look at the Bot Agent log. By default, this is located in C:\ProgramData\AutomationAnywhere\BotRunner\Logs. The filename will resemble Bot_Launcher_YOURNAME.log.
(Note that ProgramData is a hidden folder. You may have to show hidden folders or just copy/paste the path to a File Explorer window.)
Inside, look for something like these lines:
2024-Jul-19 Fri 07:41:28.536 INFO [BotRunner-c138642e-523c-4a5e-8061-585a6cf36eaa_c4b375ddb035da01] - com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel {deploymentId=c138642e-523c-4a5e-8061-585a6cf36eaa_c4b375ddb035da01, traceId=c4b375ddb035da01} - execute(OpenExcel.java:205) - Excel Source Option is : desktopfilepath
Hidden within that will be the reason for the issue. Feel free to add snippets of the log back here for assistance.
Â
I have the same issue. Provided log below. Kindly assist me.
2024-Sep-23 Mon 18:55:56.335 INFO Â main] - com.automationanywhere.botlauncher.LauncherApp {} - main(LauncherApp.java:70) - Username of the current bot launcher session: ERS1257
2024-Sep-23 Mon 18:54:51.973 INFO Â OBotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - execute(OpenExcel.java:205) - Excel Source Option is : desktopfilepath
2024-Sep-23 Mon 18:54:52.003 INFO Â FBotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.bot.service.GlobalSessionContext {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - getResources(GlobalSessionContext.java:454) - Looked up embedded resource with key 6.20.0-89f1aacc-e679-4ca7-b0f9-5345489546af
2024-Sep-23 Mon 18:54:52.003 INFO Â NBotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.bot.service.GlobalSessionContext {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - getResources(GlobalSessionContext.java:454) - Looked up embedded resource with key 6.20.0-89f1aacc-e679-4ca7-b0f9-5345489546af
2024-Sep-23 Mon 18:54:53.085 INFO Â ITokenRefreshService-0] - com.automationanywhere.refresh.token.TokenRefreshServiceImpl {} - lambda$new$1(TokenRefreshServiceImpl.java:117) - User token refreshed for deployment id:cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275
2024-Sep-23 Mon 18:54:53.791 ERROR BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.jniwrapper.win32.jexcel.Application {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - error(SourceFile:69) - java.lang.reflect.InvocationTargetException: null
   at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.rethrowExceptionIfSaved(MessageLoopThread.java:644) ~abot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread.doInvokeAndWait(MessageLoopThread.java:273) ~dbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.jexcel.Application.<init>(Unknown Source) ~nbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getApplicationInstance(MSExcelExecutor.java:154) ~xbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getExecutor(MSExcelExecutor.java:70) ~cbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.getExecutor(OpenExcel.java:267) ~tbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.execute(OpenExcel.java:242) ~xbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcelCommand.execute(OpenExcelCommand.java:202) ~tbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.toolchain.runtime.BotCommand.execute(BotCommand.java:73) ~mbot-runtime.jar:?]
   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~A?:?]
   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~h?:?]
   at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~M?:?]
   at java.lang.reflect.Method.invoke(Unknown Source) ~a?:?]
   at com.automationanywhere.bot.metrics.TimerInvocationHandler.invoke(TimerInvocationHandler.java:65) ~nbot-launcher.jar:?]
   at com.sun.proxy.$Proxy27.execute(Unknown Source) ~ ?:?]
   at com.automationanywhere.botrunner.bot.Bot_Test_excel.executeNode1(Bot_Test_excel.java:194) ~.?:?]
   at com.automationanywhere.botrunner.bot.Bot_Test_excel.play(Bot_Test_excel.java:295) ~t?:?]
   at com.automationanywhere.botrunner.Main.play(Main.java:63) ~a?:?]
   at com.automationanywhere.botengine.service.impl.BotLauncherImpl.runBot(BotLauncherImpl.java:22) ~ebot-launcher.jar:?]
   at com.automationanywhere.botengine.service.impl.DispatcherImpl.lambda$start$9(DispatcherImpl.java:621) ~rbot-launcher.jar:?]
   at com.automationanywhere.botengine.utils.ThreadUtil.lambda$withThreadContext$0(ThreadUtil.java:20) ~gbot-launcher.jar:?]
   at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) t?:?]
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) �:?]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) /?:?]
   at java.lang.Thread.run(Unknown Source) k?:?]
Caused by: com.jniwrapper.win32.com.ComException: COM object method returns error code: 0x80029C4A; Error loading type library/DLL.
   at com.jniwrapper.win32.com.ComException.checkResult(SourceFile:172) ~Lbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.com.ComFunctions.coCreateInstance(SourceFile:165) ~
   at com.jniwrapper.win32.automation.impl.IDispatchImpl.<init>(SourceFile:53) ~rbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.excel.impl._ApplicationImpl.<init>(Unknown Source) ~?bot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.excel.Application.create(Unknown Source) ~mbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.jexcel.ft.run(Unknown Source) ~~bot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.run(MessageLoopThread.java:620) ~ bot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread$LoopThread.run(MessageLoopThread.java:562) ~0bot-command-msexcel-6.20.0.jar:?]
2024-Sep-23 Mon 18:54:53.799 ERROR rBotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.jniwrapper.win32.jexcel.Application {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - error(SourceFile:69) - java.lang.reflect.InvocationTargetException: null
   at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.rethrowExceptionIfSaved(MessageLoopThread.java:644) ~nbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread.doInvokeAndWait(MessageLoopThread.java:273) ~lbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.jexcel.Application.<init>(Unknown Source) ~obot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getApplicationInstance(MSExcelExecutor.java:154) ~abot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getExecutor(MSExcelExecutor.java:70) ~ bot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.getExecutor(OpenExcel.java:267) ~2bot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.execute(OpenExcel.java:242) ~xbot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcelCommand.execute(OpenExcelCommand.java:202) ~.bot-command-msexcel-6.20.0.jar:?]
   at com.automationanywhere.toolchain.runtime.BotCommand.execute(BotCommand.java:73) ~0bot-runtime.jar:?]
   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~m?:?]
   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~t?:?]
   at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~.?:?]
   at java.lang.reflect.Method.invoke(Unknown Source) ~ ?:?]
   at com.automationanywhere.bot.metrics.TimerInvocationHandler.invoke(TimerInvocationHandler.java:65) ~.bot-launcher.jar:?]
   at com.sun.proxy.$Proxy27.execute(Unknown Source) ~e?:?]
   at com.automationanywhere.botrunner.bot.Bot_Test_excel.executeNode1(Bot_Test_excel.java:194) ~.?:?]
   at com.automationanywhere.botrunner.bot.Bot_Test_excel.play(Bot_Test_excel.java:295) ~t?:?]
   at com.automationanywhere.botrunner.Main.play(Main.java:63) ~ ?:?]
   at com.automationanywhere.botengine.service.impl.BotLauncherImpl.runBot(BotLauncherImpl.java:22) ~mbot-launcher.jar:?]
   at com.automationanywhere.botengine.service.impl.DispatcherImpl.lambda$start$9(DispatcherImpl.java:621) ~nbot-launcher.jar:?]
   at com.automationanywhere.botengine.utils.ThreadUtil.lambda$withThreadContext$0(ThreadUtil.java:20) ~bbot-launcher.jar:?]
   at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) n?:?]
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) r?:?]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) u?:?]
   at java.lang.Thread.run(Unknown Source) o?:?]
Caused by: com.jniwrapper.win32.com.ComException: COM object method returns error code: 0x80029C4A; Error loading type library/DLL.
   at com.jniwrapper.win32.com.ComException.checkResult(SourceFile:172) ~ibot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.com.ComFunctions.coCreateInstance(SourceFile:165) ~ bot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.com.impl.IUnknownImpl.<init>(SourceFile:81) ~obot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.automation.impl.IDispatchImpl.<init>(SourceFile:53) ~ibot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.excel.impl._ApplicationImpl.<init>(Unknown Source) ~pbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.excel.Application.create(Unknown Source) ~Âbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.jexcel.ft.run(Unknown Source) ~nbot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.run(MessageLoopThread.java:620) ~ bot-command-msexcel-6.20.0.jar:?]
   at com.jniwrapper.win32.MessageLoopThread$LoopThread.run(MessageLoopThread.java:562) ~2bot-command-msexcel-6.20.0.jar:?]
Â
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.