how to ignore error 500 during web extraction loop

[zyb5586]

I have created a loop to extract a specific type of table from many pages. However, in some pages when there are no records the asp page displays ADODB.Recordset error ... and no table is formed. That is when automation anywhere freezes and popups message of 500 error being detected. When popup clicked the whole processs aborts.

Is there any way for "automation anywhere" to ignore this error and continue its loop ?

[forumsupport]

Hello,

Definitely yes, what you can do is, before the 'Extract Data' command that extracts data into CSV file insert 'If' condition to check for ADODB.Recordset error. If this message is displayed on the page, itself then you can copy the entire contents of page into clipboard and then check if clipboard includes 'ADODB.Recordset error'. When you copy any text using 'Ctrl + C', the text gets copied to an object in Window operating system called Clipboard. Automation Anywhere provides a System Variable called $Clipboard$ using which you can get the text copied in the Clipboard object.
Using 'If Variable' command you can check if $Clipboard$ does not include 'ADODB.Recordset error' then extract that particular table. Text format of commands would appear something like this,

1) If $Clipboard$ Does Not Include "ADODB.Recordset error" Then
2) Extract table from 'http://www.....
3) End If


Otherwise, if this error message is displayed in some dialog box, then you can chek using 'If Window Does not Exist' command check if this particular window exist or not. Based on the result perform table extraction. Text format of commands would appear something like this,

1) If Window Does Not Exists("Window title of error dialog box") Then
2) Extract table from 'http://www......
3) End If

Alternatively, Automation Anywhere Enterprise version offers 'Upon error continue with next loop' option with Loop command. You can use this option to continue with the next iteration in the loop if an error occurs in any of the commands within the Loop-End Loop block. Optionally, you can also log your custom text to a log file when an error occurs.

Hope that helps. If not, then please send us screenshot of error that you receive so that we can actually see and if possible, also send us URL so that we can help you more with specific task.