Activate your developer network - connect, collaborate & be inspired.
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? 🙏🏼
Hi Team, I wanted to pass DataTable as input parameter to C# DLL. I am unable to find Datatable parameter in the parameter type. Is it possible to pass Datatable as an input? Is there a workaround to pass a datatable as parameter? DLL Parameter
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
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
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?
Hi, I am trying to write the exception message into a CSV file using Log To File command. While doing that, the exception message is getting inserted into two cells, rather than in a single cell itself. So can someone please let me know on how to get the exception message in single cell?
Is there a way to filter Datatable based on specific columns using inbuilt Datatable package or other packages? For example, Suppose we have a Datatable with columns “Name and ID”. I want to filter all the data with specific name and ID. Note - I do not want to use loops since the number of data is high and also cannot write the data to excel and use excel as database query, due to certain limitations in the client environment.
HI ALL, I am creating a bot for Dynamics 365 where in a field is disabled and it will enable after few actions. So I need to confirm if the property of the field is enabled or not to perform next actions.For this , I am trying with Recorder - get property - ‘States’ which shows value as ‘Unavailable’ when that field is disabled and the value of States property is null as soon the field is enabled in UI screen.Now , running the bot when the field is disable and the States value is unavailable but then it is taking as null value though the value is assigned in the Property Please could you help
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.