I am using the Recorder: Capture action to select an item from a combobox in an Excel dialogue window. See screenshot of dialogue: dialogue window in Excel The goal is that the bot selects “Column A”. The issue is that the bot is failing to select the item. I can see with my eyes that the bot is clicking or doing something to trigger the dropdown menu to appear, but the bot is failing to actually select the item (“column A”) from the menu. After the action completes, the box appears empty with nothing selected. This action is able to work in a separate task. I have copy/pasted the action from the task where it works, but the action still fails in the main task I am trying to work with. I have tried keystrokes and that did not work either. Here are my Action parameters:Action Parameters 1 of 2Action Parameters 2 of 2Window Variable: Variable Definition Does anyone have any suggestions?
Hello community, please I need your help and expertise.Currently I want import data from my sql server to csv file, but I am receiving this error: “Cannot find any Connect command using session name 'Default'” I was checking some way to verify if the “Default” session is configurate but I cannot find anything in the control room.¿Can you help me somebody please? 🙏🏼
Hello, We are repeatedly getting error pop up when we try to run the task on A360. The error pop up says UNKOWN: User:(user id) is already running a bot on device: (device name). We also see, the task is listed in pending execution state under CR->In Progress screen even though the task is successfully completed. The only workaround we are aware is to restart bot agent service and we are doing almost every-time before running a task. We see similar issues reported by other users here but none has found a solution yet.https://apeople.automationanywhere.com/s/question/0D52t00001b0rvkCAA/why-am-i-getting-this-error-while-trying-to-run-a-bot-unknown-user-username-is-already-running-a-bot-on-device-if-the-problem-persists-please-contact-your-system-administrator?language=en_US__;!!KLCbKzk!jzFApkASE3W4sOY5Rlfbx5iyY1u_iiY8SJjsbO7cEYNO3E-RbmHFCiV8vlcbcAwqHLLh74ulmXIgYPxt2LGNwQeihmSEX6Dq7kQ$"alt="https://urldefense.com/v3/__https://apeople.automationanywhere.com/s/question/0D52t00001b0rvkC
Can anyone help me with below problem statementCode for Splitting Single page PDF into 2 individual PDFs via Text delimiterPlease don't share stack overflow links already been there, open for Python or any other programming solution which will work.
I am using the 'Open Program/File' action to launch a website. One webpage is already open in the chrome, and I want to launch a new one in the same tab. I have entered the path of chrome.exe in the Location field and the URL in the Parameters field. What parameter should I add to launch the URL in the the same chrome tab?
Hi All,I am trying to delete a row based on a condition using Database Command in Automation Anywhere. Below is my code:DELETE FROM [outstanding alert$$] WHERE [Status] = 'PB_RM Investigation'; I am getting error “This may be due to the following reason: - There is a syntactical error in the SQL statement. - SQL statement got timed out. “Appreciate your help on this. Thank You.
Bot is not working properly while running un attendant bot on virtual machine.Issue is , For scheduled bots , application login screens are not appearing as activated , hence bot cannot enter the login name and password as it cannot identify the objects correctly because of open login screen is not activated.( After schedule finish , we can see only login screen of the system after login to VM machine ) But if we login virtual machine and run the BOT manually while connecting with RDP login , we can see that BOT executes properly . Note : My runner is running on virtual machine.
hello,I have a bot that sends an email in one of its steps, I have chosen the option to send with the outlook configuration. The bot runs without errors, the problem is that as long as I don't log in to the bot runner, the emails don't leave the outbox. Has it happened to someone? how did they solve it? please help me, thank you
Good Afternoon - I am having an issue where i have a loop, wherein I do some processing to a series of pdfs. After Im done processing, I move the files to an archive folder, and delete from that current folder. This works, except for the last pdf file in the queue. When the bot encounters the delete task for the last file, I receive an error stating: “Unable to delete the file(s) ‘**file location omitted for post**’ because they are being used by another process. Try after sometime.I have tried entering a delay, but to no avail. Every other file is deleted successfully.Any ideas?
I am developing a bot which reads from a SQL database. All works well with the exception of one column in the table. The bot does not retrieve any text from that column - when storing that column's contents to a data table, that row is blank. All other columns' contents are read/exported fine. The data type of the column is VARCHAR(MAX) and its contents are the body of an email. My query works fine in MySQL but nothing is returned from the query when used within Automation Anywhere. I have tried removing the carriage return (CHAR(13)), the line feed (CHAR(10)), and tab (CHAR(9)) in the SELECT statement, thinking that could be the cause of the problem but the data table row for this column is still blank. I have tried exporting the data to CSV using every encoding option and Automation Anywhere still retrieves nothing, although the queries work fine in MySQL. What could be the reason for this? Example of the SLEECT statement as used in the 'Export to data table' and
I still get the error: UNKNOWN: User: (username) is already running a bot on the device: If the problem persists, contact your system administrator. Can anybody help me?
URL:https://community2.cloud-2.automationanywhere.digital/ I have run a bot and it stayed very long time without execution so I just clicked on Cancel.Then I tried to run it once again, and it gives me the following message://UNKNOWN: User: (<user_name>) is already running a bot on device: (<device_name>)// I tried also to delete the device but it gives me the following message://Cannot delete device, as it is part of an active bot deployment// So, I have tried the following action without any success in resolving the issue: 1 - Restart the "Automation Anywhere Bot Agent" service.2 - Stop and then Start "Automation Anywhere Bot Agent" service.3 - Uninstall and install the agent.4 - Uninstall and clean the AA folders in the profile and install with admin the agent.5 - Restart the computer6 - Leaving the computer shut down (clean shut down with no sleep and no hibernation) for 1 night.7 - Installing an older version of Automation Anywhere Bot Agent. These
Hi, Good day! Does someone here has an idea on how to fix this error “ An unexpected problem occurred” ? I can’t successfully run a taskbot in botcreator because of this prompt error. I don’t know where it started and how to fix this. So I’m here asking for your help and guidance. Thanks in Advance.
We are migrating a SQL query over a DB2 file from V11 to A360 that outputs to a CSV file. The values from V11 look like this:The same results from the A360 query look like this:Any suggestions on what might be causing this or how to correct it?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.