We have been building reports in Analytics for some time now, and have commonly been using Select All Statements. Recently we reached our limit of 100 fields synced from a module, so we had to turn off 2 fields we no longer use in order to add 2 new ones. When we did this some of our reports got deleted automatically by Zoho. I un-deleted them and they were automatically deleted again. So I reached out to Zoho and they said that because we used Select All and then removed 2 fields from sync, the reports using Select All could not fetch all the data they were being told to and it broke them. Zoho said the only solution was to turn off sync and rebuild all reports using Select All statements, removing Select All and just getting individual columns.

This was never brought to our attention and we now have a large number of reports that use Select All, and it will take, at best, hours of time to fix this. Is this an issue anyone else has had? Is there any way around this without rebuilding half the reports in our database?