We get a lot of legacy sheets that stick around after data pushes, it's as if they don't delete themselves and they will just build up in our sheets.
Is there a way to make sure they delete themselves?
Thanks
Which EasyMorph version are you using?
In case your version is older than 5.6, replace it with a newer one.
And check if the Export Google Sheets action gives you any warnings or errors. It it does - please post a screenshot of the message here.
Running version: 5.6.1.9
Error Log:
2024-05-03 8:00:39 AM Warning in action "Export Google Sheets", table "New Budgets": Replacement of a sheet failed. Temporary sheet 'NewBudgetsByCOA-dd592f0e-6664-4a53-a88c-f0276d7accba', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-03 8:01:21 AM Warning in action "Export Google Sheets", table "Deals": Replacement of a sheet failed. Temporary sheet 'RawData-7caa1bb6-df33-492f-83c5-8e6e37b624ca', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-03 8:03:05 AM Task failed with 1 error(s).
It seems that the deletion of temporary sheets is timing out. This is very strange because the timeout is 5 seconds, and sheet deletion is a very fast operation. Do your sheets possibly have triggers or something similar that might slow down a deletion operation?
We have multiple data sources being loaded and exported in this project. None of the processes have steps after each export but there's multiple processes running at once.
And what about Google Sheets itself? Is it possible that your sheets have Apps Script triggers or something similar?
We use a extension for PDF and email, would that affect it? other than that no App Scripts.
How do those extensions work? Are they automatically triggered when something is changed in a workbook or a sheet?
They just run on a schedule every day between 7-8 am AST.
Is it possible that the project that exports data to Google Sheets issues a warning about the temporary sheet not being deleted because of a timeout only around the same time (7-8 a.m. AST) and works without warnings at other times of the day?
nope, it seems to be after:
2024-05-29 11:01:24 AM Warning in action "Export Google Sheets", table "1.70 Retail New Budgets": Replacement of a sheet failed. Temporary sheet 'NewBudgetsByCOA-74aa1d26-6b53-42cb-967f-1bbd3a9be8f3', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-29 11:01:24 AM Warning in action "Export Google Sheets", table "1.70 Retail Used Budgets": Replacement of a sheet failed. Temporary sheet 'UsedBudgetsByCOA-9e24eac8-a1d3-4aef-af6b-a4f06c675237', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
2024-05-29 11:01:48 AM Warning in action "Export Google Sheets", table "dbo.Deal_VehicleSales 2": Replacement of a sheet failed. Temporary sheet 'RawData-0b32a02f-3a05-4611-a5bc-ffbb33eb7b08', created by EasyMorph, wasn't deleted because of the following error: The operation has timed out.
How many rows and columns does that sheet have? Does it contain cells with long strings (more than 100-200 characters long)?