Developers Forum

Hi Guys, In an excel sheet I have column where there dates in the format as below :12/26/202211/12/20215/5/202110/10/2020……. etc.I want to use select query (excel as database) where I want to filter records using the year only. Basically, I want to build a query something like this : select * from [Sheet1$$] where ‘Date’ <> 2021. In the above query what I am trying to do is filter the records where year is 2021 and leave rest of the records. Need some help on how to achieve this. Thanks in advance :)

Hi Guys, While running the code in a production server (unattended mode), I am getting an error when it is trying to run a basic select query in an excel and getting an error as below : The connection for viewing your linked Microsoft Excel worksheet was lost. I am getting this error on the exact same line where the select query is written and I was not getting this kind of error before (not even once!) . Surprisingly when I log in to the VM & run the code again, it runs fine. Any suggestions or resolutions please ?

What is best approch for data mapping?Like Manually in Excel we use Vlookup , what about in Automation Anywhere?

I’ve got a very simple BOT I started testing with:Excel Advanced Opens Excel file Excel Advanced Gets multiple cells and saves to data tableEach time it fails on step 2 saying “Zulu Platform x64 Architecture has stopped working”. There are 32,000 rows in the excel sheet. I’ve also tried just grabbing 5000 rows but same error.I’ve done this before in other BOTs so I don’t know what the deal is here. Any help would be appreciated.

Buenos Dias! Tengo configurado la conexion de envio de correo con EWS SERVER y Basic con usuario y password, me indicaron que para el 31 de diciembre dejara de funcionar , alguien me puede confirmar que asi sea o si me va a seguir funcionando a como lo tengo?  

the task is checked in, it doesnt throw an error, but its not in the checked in list

Bot Creatorユーザーが使うパソコンに、ネットワーク通信キャプチャツール「Fiddler」をインストールして以降、Fiddlerを立ち上げてないとローカルデバイスの接続ができなくなりました。Bot Creatorユーザーが使うパソコンを立ち上げた直後、BotAgentサービスは正常に開始中になります。Control Roomでデバイスのステータスは「接続中」です。ところが、Bot Creatorユーザーでログインしてもローカルデバイスが「接続中」になりません。ここでFiddlerを立ち上げると、ローカルデバイスが「接続中」になります。一旦ローカルデバイスが「接続中」になった後は、Bot Creatorユーザーをログアウトするまで、ローカルデバイスが「接続中」のまま使えます。BotAgentがローカルデバイスを接続するときにProxyを使うように記憶してしまっているように思われます。BotAgentが記憶しているProxy設定をリセットする方法があれば、この問題を解決と思うのですが、何か良い方法はないでしょうか？(Botエージェントのバージョン：21.210)

Hello,I need add a conditional logic to my bot so that it continues if there is no data returned from a search within a web application.Specifically, here is what is occurring:Search is executed. If a record is returned, the record will be presented in a row format with a radio button to be selected, as shown below: If there records returned, the screen will look like this with no radio button to select: If condition #2 occurs, the bot will click the radio button and the processing for that specific row will continueIf condition #3 occurs, the bot needs to terminate that iteration of the loop and go on to the next search parameter in the loop.I had my if statement set to if  the data table if blank (as shown in #3) to continue to the next search parameter in the loop, and my if else has the actions necessary to continue processing with the returned record (as shown in #2). However, when the bot encounters no records returned (as shown in #3) the bot stops processing. I believe using i

Issue :: Audit logs are not populating in A11.3 control room Error: “Failed to save to index: org.elasticsearch.ElasticsearchStatusException: Elasticsearch exception [type=cluster_block_exception, reason=blocked by: [FORBIDDEN/12/index read-only / allow delete (api)]”.Resolution :Stop elastic service  Rename data folder to data_bkp (C:\ProgramData\AutomationAnywhere\elasticsearch) Restart the service if you have more than one node do above steps for all nodes 

Issue :: Bot schedules are missing to run in A360This is happening after DR exercise Resolution : check if you have Disaster Recovery environment on different time zone and AA services are up on these servers.  Stop all AA services in DR environment. PN: AA control room servers are supposed to be run on same time zone otherwise schedules will fail to run.

Issue :: Bots are unable to run after control room upgrade to V23 in A360Bot agent V21.200 VDI’s are failing to connect control roomThis is due to botagent vs control room versions not compatible Resolution :: update bot agent v21.121 or higher… 

Is it possible to use devops practices in automation anywhere v11? What devops practices could I use to automate the continuous integration (CI) and continuous deployment (CD) of the different bots. Could I automate tests for the bots?

Hi Everyone, I have problem that I schedule bot runner to run process and error occured.The error showed that bot cannot set text in some objects on recorder action.When I remote to VM(bot runner) and let process run, it shows that bot can set text in the object that had an error before.I don’t know how to solve this issue.Please let me know if you have any suggestions. Thank you.

I am trying to login to A360 Control room. Login is taking time and thowing message Could not execute query.Note - Telnet is working fine for control room and datebase

Hello I would to delete the browser data through CMD I used Application: Open program/file command to impelention but does not work  

Hello- I have this scenario: I have one mainBot with 3 subBots.  In the subBots I pass an Employee ID from the mainBot to the subBots. Each bot is responsible for checking one system for information.  If there is information in any one of these systems then it will trigger a boolean flag that means that I will then need to do or more substantial check.  Is there a way to do this more efficiently then just using an if statement?  Essentially I am looping through three bots…. If a flag equals true then exit and go to another subBot that does the more substantial check. i.e. Here are two scenarios: Scenario 1:subBotA runs there is info found which triggers flag to TRUEsubBotB is now skippedsubBotC is now SkippedsubBotX (substantial check) is now run  Scenario 2:subBotA runs there is no info found so the flag is FALSEsubBotB runs there is info found which triggers flag to TRUEsubBotC is now SkippedsubBotX (substantial check) is now run  i.e. I want the Flag being TRUE to trigger the event

Hi Team,We have reset the password for our DEV runner machine. After reset, the new password is updated in the folollwing places.AAE client in runner machine (Tools→ Login Settings). Legal disclaimer is checked. Client version is 11.3.1 Web CR - Administration→ Bots to upload the bot files into SVN All the services are stopped. Reset the login information and restarted Runner machine is rebootedStill we are getting the error “Unable to acquire the bot runner's remote desktop session as the bot runner's machine state is unlock” when we try to run the bots and they are not getting invoked at all. Please assist us to resolve the issue.

I’m not able to find plugin for Firefox. Could you please share URL or extension file to install plugin

Hi All,  We have two control room , two creator for respective control room. Can we run both creator in same machine as it points both to different control room 

Hi All,I have built a bot but I get an error saying the webpage took too long to load even after I see the webpage is completely loaded.So I need a wait condition to check and proceed only if the webpage has loaded completely in all forms.Does any one know how to check this in AAE? If you have any method via JavaScript Please feel free to share the script and its usage. Thanks and Regards.

issue : A360 - Domain drop down not populating in control rom, this may happen during windows server maintenance or during OS patching  Resolution :: Restart services  Stop Services :  Open notepad copy below commands and save as StopService.batnet stop "Automation Anywhere Control Room Caching"net stop "Automation Anywhere Control Room Messaging"net stop "Automation Anywhere Elastic Search Service"net stop "Automation Anywhere Control Room Service"net stop "Automation Anywhere Control Room Bot Compiler Service"net stop "Automation Anywhere Control Room Robotic Interface Service"net stop "Automation Anywhere Control Room IQBot Service"net stop "Automation Anywhere Control Room Discovery Bot Service"net stop "Automation Anywhere Control Room Discovery Bot ML Service"net stop "Automation Anywhere Control Room Storage Service"net stop "Automation Anywhere Bot Agent"net stop "Automation Anywhere Control Room Reverse proxy" Start Services:Open notepad copy below commands and save as StartSe

IQ bot - Dev - Issue exporting Dev learning instance.  Issue :: No error message appeared in control room, however when the page was refreshed the 'Last Migrated' status in the upper right updated to 'Failed'. Logs gave no clear picture of the error.   Resolution : Issue was related to a space issue. Even though output is pointed to D: drive, low space on server's C: was causing the failure. Beware leaving trace mode on server logs for extended periods.

ISsue :: IQBOT Import into Production failed with error 'No project data available' Possible resolution: Converting iqba file to zip and opening reveals that there are 2 different folders with learning instances id's; One of which contains only two files. We deleted this one as it was a learning instance which was only present in SDLC env. Reference forum post: https://apeople.automationanywhere.com/s/article/Learning-instance-migration-import-failsInfo from AA: https://docs.automationanywhere.com/bundle/iq-bot-v6.5/page/iq-bot/topics/release-notes/iq-bot-release-notes-11-3-5-5.htmlThis issue is due to VisionBot being created for Invalid GroupIds ,in this case there were VisionBot records  which were pointing to classificationId=-1 and queries used for export did not filter out these invalid classificationIds as a result data that is referred with ClassificationId=-1 is getting picked up across learning instances. 

ISSUE::IQ BOT : Dev Control Room Migration Status was 'Not Available' and thus no migration could be done    (or) / (and)IQBOT Migration failed and throwing java.lang.Runtime error parsing CSV values null  Reason: Groups were opened by users while migration was being attempted, Also caused by locked groups RESOLUTIONupdate FileManager.dbo.VisionBotDetail set LockedUserid= '', LockedTimestamp=NULL where LockedTimestamp IS not NULL;

Kindly Please Schedule a call with me my available trimmings are (8:00 AM to 4:30 PM IST)  Thanks & Regards,Lakshmi Priya IllaSolutions Engineer RPA Carl Zeiss India Bangalore Pvt LtdMobile: +91-9949608060Plot No 3, Bommasandra Jigani Link Rd, Bommasandra Industrial Area,Bengaluru, Karnataka 560099Email: lakshmi.priya@zeiss.com