Hi,
So I attempted to delete one of my forms from ODK Aggregate but unbeknownst to me, one of the form's tables had a view that was dependent on it. The delete was incomplete while some of the forms tables were deleted, others were not.
I removed the dependent view and tried to delete the form again through the web client, which still displayed the form. No luck. I then attempted to purge any reference I could find to the form in the Aggregate tables.
I deleted rows in these tables:
public._form_info
public._form_info_fileset
public._form_info_submission_association
public._form_info_xform_bin
public._form_info_xform_blb
public._form_info_xform_ref
public._misc_tasks
public._form_data_model
public._backend_actions
But that doesn't seem to have done the trick. To make matters worse, the web client won't stop refreshing when you login.
Any suggestions?
See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure
and make sure you didn't miss anything. It might also be good to look
through the logs
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting
to see what the error messages say.
Yaw
···
On Mon, Oct 24, 2016 at 8:27 PM, wrote:
> Hi,
>
> So I attempted to delete one of my forms from ODK Aggregate but unbeknownst to me, one of the form's tables had a view that was dependent on it. The delete was incomplete while some of the forms tables were deleted, others were not.
>
> I removed the dependent view and tried to delete the form again through the web client, which still displayed the form. No luck. I then attempted to purge any reference I could find to the form in the Aggregate tables.
>
> I deleted rows in these tables:
>
> public._form_info
> public._form_info_fileset
> public._form_info_submission_association
> public._form_info_xform_bin
> public._form_info_xform_blb
> public._form_info_xform_ref
> public._misc_tasks
> public._form_data_model
> public._backend_actions
>
> But that doesn't seem to have done the trick. To make matters worse, the web client won't stop refreshing when you login.
>
> Any suggestions?
>
> --
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups "ODK Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
If you exported to csv or set up publishers for the form, you might have
some of those left over in their tables.
It is perhaps best to roll back to an earlier version of your database,
remove the dependent view, then use the UI to delete the form. That should
properly clean everything up.
···
On Wed, Oct 26, 2016 at 12:59 AM, Yaw Anokwa wrote:
See https://github.com/opendatakit/opendatakit/wiki/
Aggregate-Database-Structure
and make sure you didn't miss anything. It might also be good to look
through the logs
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-
Troubleshooting
to see what the error messages say.
Yaw
On Mon, Oct 24, 2016 at 8:27 PM, alb-tab@swcacloud.com wrote:
Hi,
So I attempted to delete one of my forms from ODK Aggregate but
unbeknownst to me, one of the form's tables had a view that was dependent
on it. The delete was incomplete while some of the forms tables were
deleted, others were not.
I removed the dependent view and tried to delete the form again through
the web client, which still displayed the form. No luck. I then attempted
to purge any reference I could find to the form in the Aggregate tables.
I deleted rows in these tables:
public._form_info
public._form_info_fileset
public._form_info_submission_association
public._form_info_xform_bin
public._form_info_xform_blb
public._form_info_xform_ref
public._misc_tasks
public._form_data_model
public._backend_actions
But that doesn't seem to have done the trick. To make matters worse,
the web client won't stop refreshing when you login.
Any suggestions?
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com