Developers Forum

Hello everyone,I'm encountering a persistent syntactical error in Automation Anywhere A360 when trying to insert data into a database. The error occurs whether I use the `INSERT` or `DELETE` command. Here’s an example of the code I’m using:```INSERT INTO RPATest ([Case Id], MRN, Resident_First_Name, Resident_Last_Name)VALUES (123, '123Test', 'ABC', 'abc');```Error message: `There is a syntactical error in the SQL statement. - SQL statement got timed out.`Interestingly, the same code works perfectly when executed in SQL Server Management Studio (SSMS), so I suspect this issue might be specific to A360.Has anyone else experienced a similar issue or knows how to resolve it? Any insights would be greatly appreciated! 

I am encountering this error “Bot Launcher for user session USERNAME crashed.Last recorded command xyz at line number XX”.  Requesting your helps in resolving this?

Hi everyone, I have tried to create  a Process, with a form and a Button Validate/Cancel.I want to have a if/else that tests if the button chosen is Validate or Cancel. But I have found no way to get the value.Does anyone know how to get the value of the buttons ? 

Hi , i want to insert an image into a word document using Automation anyhwere 360. I Installed a MS word package but it only had insert text, replace text options. 

I'm planning to develop a dedicated bot for code review analysis. The bot will focus on checking best practices in code, including aspects like variable naming conventions, loops, and the number of lines. Any thoughts or guidance would be greatly appreciated!

I was trying to pass some input values to a process from a bot...and it’s not possible to send it as variables, so I passed it as form input in the start request and i was able to pass it. But now I want to get the output value from the process to do the further bot functions is there anyway I can do that?I’m passing the agent output to a process and trying to get the process output..even though there is an option to create output variables in the process composer, I’m not able to pass that variable to the bot.

I am having issues with the SAP bapi connect action. AA is having issues finding the dependent libraries for the .dll file associated with the bapi connect.Does anyone know how to resolve this issue? Note that I do not get this error on my local device, just on my development VM.My VM has access to the .dll file, in fact I have printed the folder to verify that the VM can see and access it from AA. I have also updated my environment PATH variable to include the folder containing the .dll. Any other suggestions would be great. Thank you.  

Hi,When using the REST Web Services POST method to upload an attachment on ServiceNow, I am continuously getting the following error:{"error":{"message":"Failed to create the attachment. File part might be missing in the request.","detail"},"status":"failure"}I have tested via Postman with exactly the same headers and user credentials, and it works. The service also works via the ServiceNow REST API service.I have tried copying the exact same headers from Postman when it worked, but with no luck. I have also tried different files, as I feel this could be the issue, but I am always getting this error.Any support with this issue would be appreciated.Thanks, Brett

Hi developers,I am new to AA. I have a small doubt about throw activity. I am performing below steps:Step1: Launch acme web application. https://acme-test.uipath.com/loginStep2: After launching application I want to check if it is a fresh login or already logged in.           If it is already logged in, then I want to throw an exception and I want to click logout button and                 close the window. (here, I am capturing dashboard text and checking for availability                                   in https://acme-test.uipath.com/home and if text is available then I want to throw exception as                   “Already logged in”Step3: Once logout and safe close is done, then i want to send an email and I want to exit from the flow and I don’t to want to perform the rest of logic Here, I have used try, catch and finally blocks Attaching the logic and I am very much confused about what logic I have to kept inside the catch block.Kindly clear my doubt and provide the best solutio

Hi, I have a situation where exists something like a sub-class in the xml structure. When I build the SOAP request, the AA select this sub-class like parameters and the parameters inside not is selected. Example:<soapenv:Body>   <tem:Manifestacao>        <tem:ChamadaManifestacao>                  <wsd:usuario>test</wsd:usuario>                  <wsd:senha>test</wsd:senha>                  <wsd:code>test</wsd:code>                  <wsd:number>test</wsd:number>        </tem:ChamadaManifestacao>   </tem:Manifestacao></soapenv:Body> The AA build using “ChamadaManifestacao” like parameter instead of usuario, senha, code and number. Thanks!

I created a new user before the user’s email account was set up. Now that the emails are actually going to an inbox (confirmed), they are not receiving the account verification/activation email. I think AA360 received an undeliverable message and won’t send the confirmation email to the same address again.  I have tried:Resending verification email from Control Room Checking spam/junk etc. Deleting and re-creating the user Changing the user’s email address, verifying by clicking the link, changing it back Waiting 24 hours between changes Updating the “emailVerified” field via the Control Room API Deleting/Re-Creating the user via the API Automation 360 build 23207Automation 360 Cloud : Control Room - US Central 1Environment - PROD

What is the best implementation for dividing a file name string into its folder, file name, and extension components. I haven’t found a package that takes a string and parses it. Am I missing something?I’ve written a utility bot to do it by reversing the string and looking for the first period and first slash to accomplish what I want. However, it feels sloppy in what it does.I’ve looked at calling out to javascript, but that doesn’t have all-in-one solution.Also, any chance there will be a powershell package like there is javascript and vba?

Hi, I have a data of 3500 records in my data table how can i paste at a time in excel. The activity "Write from data table" is taking long time as it is writing line by line.

Hi, when i am applying vlookup in two separate files i am getting issue in Excel. I am getting pop up do you want to recover the data. Open action of excel is failing any idea how bot can handle this in next run. 

Hello guys, I am trying to create a table to write it to an excel file, i have two files: one txt and another csv and i am iterating through all the rows of these files. 1st question: how do i initialize a table? using assign table?2nd question; how do i add an element to this table? i would need to insert the value of a list (each row of these files) to the table or is there another approach?  any help would be great!!

I have now attempted to try and obtain a community edition download 4 times and 4 times i havent received an email with a link on how to do so. I have checked my junk email and also my on hold messages. I just never seem to receive the email

Hi Team, I am getting this error whenever i am try to run the bot “file=C:\Users\KAS1020\AppData\Local\AA\messaging\c5986c93-8c4c-4e6b-a737-1e3f32ac7f27_fa2f84b11b2bca32\request\metadata.cq4tIf the problem persists, please contact your system administrator.” This path doesn’t exist in my system and while installing i haven’t had selected this location as well.Could anyone please help me to resolve this issue? 

So we have workspaces to run the bot unattended, So I have strange problem that I’ve encountered that is new to me, the problem is  when I execute the bot in workspace it doesn't capture the ui elements in the website in workspace but in my actual device it works, I found a solution by restarting the workspace the bot is capturing the element well,  but then again after few runs or few hours the issue persists again.

Hi All, Please help me to create a Bot to log into a Gmail mailbox and delete all its messages using Gmail API. Thanks,Shivansh

HiSorry if the question appears rudimentary but we need some help urgently. We are trying to upload files in a SOAP web service request using A360 to SAP Ariba. The SOAP web service action doesn’t seem to have any feature to attach any files. RegardsSaptarshi

Hi everyone,I recently deployed a bot using the AA360 API with the following payload:{  "fileId": //BotId,   "runAsUserIds": [    //UserID  ],  "poolIds": [],  "overrideDefaultDevice": false,  "callbackInfo": {    "url": "https://callbackserver.com/storeBotExecutionStatus",     "headers": {      "X-Authorization": "//token"    }  }}Everything works fine, and in the response I receive both a deploymentId and an automationName.However, I'm struggling to understand how I can actually use the deploymentId. What is its specific purpose within the API?Additionally, I'm wondering if there is an API that allows me to view in-progress activities or access a historical table of executions, similar to what can be viewed in Control Room. So far, I’ve only found the API for the AUDIT log, but nothing akin to an Activity table or In-progress executions.Has anyone dealt with this issue or have any suggestions on how to proceed?Thanks in advance!

I've completed the basic API settings and confirmed that the connection is working. However, I'm encountering an error when opening Google Sheets.I also deleted the file located at C:\Users\user\AppData\Local\AutomationAnywhere\G-SuiteAuth, but it still doesn't function correctly.   

Just reporting a bug that I discovered because it took me several hours to fix and could be resolved with enhanced error handling.Essentially, AARI bots will be stuck in queue indefinitely and will never trigger if you delete one of the variables used as input parameter for child task bots within the process. For example in my case, one of my child task bots uses the input variable numCounter which is generated by the main task bot and passed to one if the main bot’s children. In the process of modifying and optimizing my code, I deleted numCounter from the main task bot and removed the the input variable reference from the child bot that uses numCounter. Keep in mind I had made several changes, this being one of them. After doing this, any time that I ran this bot from AARI, the bot would be stuck in queue and would never trigger. There would be no error message other than “Bot is in queue and will start shortly”. It was only after hours of troubleshooting that I decided to trigger th

i have completed the advanced certificate, but i am unable to download as the registered email id is locked by the organization:please send me the certificate on dineshdonakonda@gmail.com

Hi, I am planning to upgrade the platform from V20 to V24,and v24 to v27,v27 to v30 and finally v30 to v33.So please share a reference  to get the server and database to upgrade each versions .I am using On-premVersions v20 Server configuration cpu 3 & 8 gb RAM Database configuration sql express 2019 SAP suported versions 760 & 800 Elastic search No clue This is my current configurations is this supports each versions?Thanks,Ardra