Error: Problem persisting data or accessing data multiple-choice valueSet is missing an entry OR has an extra copy

Support
1

Hi,

I have the error message
Error: Problem persisting data or accessing data (SELECT * FROM
QUE47ON_CONSOME_PAIN WHERE _TOP_LEVEL_AURI =
uuid:267ecd1f-9443-4013-9fe2-ba857d1125b6 AND _PARENT_AURI =
uuid:267ecd1f-9443-4013-9fe2-ba857d1125b6 multiple-choice valueSet is
missing an entry OR has an extra copy of one)

Can you help me please?

2

Hi Franck,

Please see https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission

Yaw

ยทยทยท On Sun, Mar 26, 2017 at 2:09 PM, Franck Koutepe wrote: > Hi, > > I have the error message > Error: Problem persisting data or accessing data (SELECT * FROM > QUE47ON_CONSOME_PAIN WHERE _TOP_LEVEL_AURI = > uuid:267ecd1f-9443-4013-9fe2-ba857d1125b6 AND _PARENT_AURI = > uuid:267ecd1f-9443-4013-9fe2-ba857d1125b6 multiple-choice valueSet is > missing an entry OR has an extra copy of one) > > Can you help me please? > > -- > -- > 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.
3

Hi Yaw,

I also have a similar error "Error: Problem persisting data or accessing data (Activity_Type@parentAuri(uuid:e7116f2a-5e0a-4e4f-848c-60b63cd9c143) valueSet is missing an entry OR has an extra copy of one)" when I select my form on aggregate. All the other forms are ok.
I can pull the data from briefcase storage but then when I need to check data submitted, I'm unable to do so.
I followed the steps on https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission but the error still persists.
Anything else I need to check?

Thanks MK.

4

If you are seeing this error, you still have corrupt submissions.

Try downloading the submissions with ODK Briefcase and it will report which submission is corrupt. Use that information to repeat the steps at https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission.