Introduction to Automation- failed

Help Studio
1

image
image689×263 14.9 KB

This section has failed several times, im not sure why. Please can could I get some tips on how to resolve

2

What is the reason of failure
Can you share exception ?

Check connection you can add this in retry scope
Increase time out

3

@N_L

Welcome to the community

Please show the exception message we can try checking from there

Cheers

4

I hope this is correct

2024-11-10 13:10:21.701 GMT: Error: UiPath.GSuite.Exceptions.GSuiteException: Multiple items with the name ExtractedSalesOpportunities1 found in the specified folder.
at UiPath.GSuite.Drive.Extensions.IDriveServiceExtensions.CreateSpreadsheetWithConflictResolution(IDriveService driveService, ISheetsService sheetsService, String fileName, CloudObjectIdentifier parentFolderId, String firstSheetName, ConflictBehaviorMaster conflictResolution, CancellationToken cancellationToken)
at UiPath.GSuite.Activities.CreateSpreadsheetConnections.SafeExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.GSuite.Activities.BaseLeafConnectionServiceActivityWithoutBindings.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.ContinuableAsyncCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.GSuite.Activities.GoogleBaseClientActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

5

Thank you for the welcome

6

Hello @N_L

The error indicates that the SpreadSheet ExtractedSalesOpportunities1 already exists in your Google Drive.

If you want to replace the SpreadSheet you could:

  1. Look for an “overwrite” property on the activity, if present
  2. Simply delete the existing document

If you want to write data to the existing SpreadSheet you should:

  • Look for a Write Range activity that works with Google Drive, if present

Regards
Soren

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.