Developers Forum

Hi everyone,I am finding the way to deal with A360 Workload Management. I have created a Queue, executed “Run bot with Queue and selected a Device pool.  But after a few days, all work items have Ready to run status and no one has been deployed to the device as below: So anyone know about this issue, I have no idea for troubleshooting.Thank.

Hello together! I'm working on a new bot where I have multiple dropdowns.I have to select a value from the dropdown list. Any idea how to do that besides from using the "insert mouse click" function?  TIA 

It is a dynamic data, so sometimes i may need to enter 2 data, sometimes 3 etc.When i use mouse click ,it clicks on same place everytime.But what I want is to go down one after one.(click and simulate keystrokes)it cant be done with Recorder:Capture, it doesnt create special path. Whereever I click on the page shows me the same path (I can create Loop, and put DownArrow, so it can go down, but i wonder if there may be a better solution)

it throws this error when i run over controlroom, but when i watch it it works.

I have power queries in the excel which retrieve data from EDW. There are multiple tabs in the excel. The bot will launch the excel that contains the power queries and use excel shortcut key to open the queries screen at the side. Subsequently, either use the image recognition to click on the refresh icon in the query or excel shortcut key to refresh that particular tab. The bot will switch tab and do the same refresh activity. Its working perfectly fine in DEV environment. However, when it was move to PROD environment, it managed to refresh the first few tabs and the remaining 3-4 tabs will not be refresh. I observed it in attended run and the bot is not clicking on the refresh icon or using excel shortcut key to refresh that particular tab.  Not sure if anyone has the same experience and how you manage to overcome it. Do kindly advice.

Hi Community Team, I am trying to run DLL to perform email actions (O365 - shared mailbox) but intermittently I am getting following exceptionBot Logs for 2023-Mar-24 Fri 10:10:34.066 INFO  [Thread-19] - ExternalScript {deploymentId=c6751097-3cde-4eca-ae3a-3240ed6594f9_d813b6b64133284d, traceId=d813b6b64133284d} - log_aroundBody0(LogUtil.java:32) - 2023-03-24 10:10:34,064 [1] ERROR AutomationAnywhere.ManagedDLLWrapper.ApiInvokerOperations - ApiInvokerOperations: Error occurred while invoking DLL methodSystem.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.2023-Mar-24 Fri 10:10:34.066 INFO  [Thread-19] - ExternalScript {deploymentId=c6751097-3cde

Hi friends,I am creating bot that helps HR team to reduce their time in screening, can you people suggest any idea how can i integrate chat gpt with community edition. Thanks:)

Hi, I need to use automation anywhere tool in macbook ,I have downloaded the bot agent but i am unable to install and getting below error.You can’t open the application “AutomationAnywhereBotAgent.exe” because Microsoft Windows applications are not supported on macOS.Can anyone help to fix this issue.Is there any alternative way to use AutomationAnywhere in mac book ?.Please let me know if any

But it works without any issue when direct access to AX without run as different user. Any solution for above issue stated?

Even after Unlock the Accounts, still facing the issue

Hi there,                 I have added a new VM device as a runner machine to the CR. After opening an active RDP session of the VM, I ran a test bot with a message box, which resulted in disconnection of the RDP session. Additionally, I observed that the VM restarts whenever I run  a bot. There is no issues when I login to VM and run the bot. 

I am trying to work on an Excel file stored on One Drive where I need to insert a new row and then copy formulas from a cell in existing row to the cell below that using Office 365 Excel package. When we do that manually using Ctrl+C & Ctrl+V, the formula is updated automatically based on the cell where we are pasting it. Using the package commands, the formula is pasted as it is. Is there an easy way out for this? ASK- The formula from cell D2 (A2+B2) when pasted to D3 should give us (A3+B3) and not (A2+B2).

Apologies if I am missing something really obvious, but is there a refresh command in the Browser Package. Currently I am relying on Simulate Keystrokes (CTRL+R) to refresh Chrome, which feels a bit backward.

I am facing difficulty in extracting the columns of a grid(Table) in a Legacy application using Automation Anywhere 360. Despite multiple attempts, I am unable to extract the required data from the grid using Automation Anywhere 360. I need to find a solution to automate this process as manual extraction of data is time-consuming and prone to errors. Additionally, the Legacy application has outdated technology, making it challenging to extract data using modern automation tools.I am not even able to extract a single column of that table grid(Tried with Capturing its not working on legacy application)

Hello,I'm trying the essentials certification and having trouble with the part where you need to generate the bot code to text. The link https://rpademo.automationanywhere.com/mcbe/is saying that my credentials are wrong but I use the right credentials (ctrl-c and ctrl-v in the control room work). I already tried the email learning@automationanywhere.com but they send me here.

Hi Team,I have completed my AA360 Advance 2023 certification on 17th March 2023, but still not received the Certificate, also i have given the Test twice once i got 98% and 2nd time got 97%, i have the screen shot for the 2nd time, PFB the image for your reference, i have also mailed the above issue to learning@automationanywhere.com, the Request (69314) is created but there is not respnse on the email.Please help in getting the Certificate. 

allawe

Excelから読込み作成したデータテーブルをBot内のアクションで、ある項目(文字列)を昇順でソートしています。その項目で、空白で始まる内容があった時に、Excelでは最初にきていたのですがデータテーブルで並び替えた時は、空白を無視してソートされてしまいます。(例) 「 VX1」「ABCD」と2つ項目(「」はこの記述のためのものなので実際には入っていません)があった時、Excelでの並び順→「 VX1」「ABCD」Botでの並び順→「ABCD」「 VX1」Excelのように空白も含めて並び替える事はできないのでしょうか。

Hello, As we noticed that Zulu Platform x64 Architecture has high memory usage.Hence we are considering to stop the relevant service which is Automation Anywhere Bot Insight services to release the memory used by Zulu Platform x64 Architecture. Before stopping Automation Anywhere Bot Insight services , we want to know that will it affect the process of history log on Control room as shown below  

I need to extract the data from a table in Microsoft access and insert it in a csv file, however, I am required to use log to file command for the csv file. Also when the bot runs again it should append the new information into the same file but with no hearders since they will already be there

How to automate a shared mailbox in A360? Is it possible to save a email from shared mailbox in .msg format?

Hi everyone. I am trying to run a task with an unattended Bot runner. However, I am unable to select the available bot runner since the status is depicted as “Autologin not set”. Here is what I did beforehand:1) Created a Task and put it in Public2) Created a Bot Runner User and assigned the following Roles: AAE_Basic, AAE_Locker Admin, AAE_Bot Migration Admin3) Assigned a Unattended Bot Runner License to the Bot Runner User4) Went to Administration → Settings → Devices → Auto Login Settings and followed this Guide: https://docs.automationanywhere.com/bundle/enterprise-v2019/p

Hi Team,We have implemented a bot that will work on the Oracle DB, which support only in IE. So we have created the bot as same.Now we could not run the bot because of IE disabled as per recent update. So we want to migrated the code in automation anywhere from IE to MS edge(IE mode)Kindly help us on how to work on this issue ?

good morningwhen exporting the bot, i find it in historical tab with run fail status,and get the following error message“An unexpected problem occurredUNKNOWN: Error in exporting the BI BLM Dashboards”error image is attachedany help is appreciated. thanks

Hi all,We are trying to access a xls file from one of the automated mail and saving it in local location.While we try to access the xls file using excel commands, one of the Add-in program script which was added is getting diappeared. But when we open the file manually, we can see the Add-in ribbon visible.We even tried to check the ‘Load Add-in’ option in the Excel Open command. But still the issue is there.Can anyone help us get a solution for this issue? Thanks & Regards,Gopinath S