Google Sheet Publisher Issue - Somehow DB entities for publisher got into problem state

Support
22

Thanks @ggalmazor, @Jeff_Davids,

The Aggregate server cannot load the fusion table entries in the publish webpage so it is popping up the error message, making it impossible to remove the broken publisher.

Is it safe to delete the entries in the Datastore? We have both _fusion_table_2 and _fusion_table_2_repeat items. What do I need to delete there?

Is there another way you suggest deleting the publisher?

Thanks,
Erik

23

I answered my question by trying it out in a test environment and found that it is not safe to delete the item from the fusion table datastore. I deleted a different entity in the datastore and have replicated (instead of fixed) the issue

Moral: If you delete the fusion table in the datastore, ODK Aggregate will report that the datastore is corrupt (because it is!).

This is a separate issue it seems than the one for this thread. I created a new thread with the problem.

1 Like