ODK Aggregate Errors - multiple-choice valueSet is missing an entry OR has an extra copy of one

Hi,

I've recently deployed a survey using ODK and things were going well. This I logged into ODK Aggregate and noticed the following error:

Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)

Having looked at the ODK Aggregate docs and the github it looks to be a problem with one form submission. I'm a little out of my depth repairing the database myself though have been following the instructions posted here:
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting

Is there anyone who could help me resolve this problem?

Thanks

Marty

ODK is a good tool please try it

Hi Marty,

Add yanokwa@nafundi.com as an owner on your App Engine instance and
I'll try to fix it.

Upgrading to Aggregate v1.4.11 will prevent this from happening in the future.

Yaw

··· On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community wrote: > Hi, > > I've recently deployed a survey using ODK and things were going well. This I logged into ODK Aggregate and noticed the following error: > > `Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)` > > Having looked at the ODK Aggregate docs and the github it looks to be a problem with one form submission. I'm a little out of my depth repairing the database myself though have been following the instructions posted here: > `https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting` > > Is there anyone who could help me resolve this problem? > > Thanks > > Marty > > -- > -- > 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.

Hi,

I've recently deployed a survey using ODK and things were going well. This
I logged into ODK Aggregate and noticed the following error:

Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)

Having looked at the ODK Aggregate docs and the github it looks to be a
problem with one form submission. I'm a little out of my depth repairing
the database myself though have been following the instructions posted
here:
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting

Is there anyone who could help me resolve this problem?

Thanks

Marty

··· On Tuesday, August 2, 2016 at 4:32:37 AM UTC-4, chuzzl...@googlemail.com wrote:

Hi Marty,

Add yanokwa@nafundi.com as an owner on your App Engine instance and
I'll try to fix it.

Upgrading to Aggregate v1.4.11 will prevent this from happening in the future.

Yaw

Hi,

I've recently deployed a survey using ODK and things were going well. This I logged into ODK Aggregate and noticed the following error:

Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)

Having looked at the ODK Aggregate docs and the github it looks to be a problem with one form submission. I'm a little out of my depth repairing the database myself though have been following the instructions posted here:
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting

Is there anyone who could help me resolve this problem?

Thanks

Marty

--

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.

Hi Yaw,

We also have a similar problem that just started happening now in the last week.

Error: Problem persisting data or accessing data (SELECT * FROM PTENTS05_INTRVW_QSTNS_CD_TECH_US_NTRNT_CNNCTON_TECH_9 WHERE _TOP_LEVEL_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f AND _PARENT_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f multiple-choice valueSet is missing an entry OR has an extra copy of one)

Any assistance you can provide would be highly appreciated.

··· On Tuesday, August 2, 2016 at 8:32:46 AM UTC-4, Yaw Anokwa wrote: > On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community wrote:

Hi Imo,

Follow the instructions at

and upgrade to Aggregate v1.4.11 to prevent this from happening in the
future.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Thu, Aug 11, 2016 at 1:59 PM, imo.etuk@mymdoc.com wrote:

On Tuesday, August 2, 2016 at 8:32:46 AM UTC-4, Yaw Anokwa wrote:

Hi Marty,

Add yanokwa@nafundi.com as an owner on your App Engine instance and
I'll try to fix it.

Upgrading to Aggregate v1.4.11 will prevent this from happening in the future.

Yaw

On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community opendatakit@googlegroups.com wrote:

Hi,

I've recently deployed a survey using ODK and things were going well. This I logged into ODK Aggregate and noticed the following error:

Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)

Having looked at the ODK Aggregate docs and the github it looks to be a problem with one form submission. I'm a little out of my depth repairing the database myself though have been following the instructions posted here:
https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting

Is there anyone who could help me resolve this problem?

Thanks

Marty

--

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.

Hi Yaw,

We also have a similar problem that just started happening now in the last week.

Error: Problem persisting data or accessing data (SELECT * FROM PTENTS05_INTRVW_QSTNS_CD_TECH_US_NTRNT_CNNCTON_TECH_9 WHERE _TOP_LEVEL_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f AND _PARENT_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f multiple-choice valueSet is missing an entry OR has an extra copy of one)

Any assistance you can provide would be highly appreciated.

--

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.

Thanks so much!

Best,
Imo

··· > On Aug 11, 2016, at 11:26 AM, Yaw Anokwa wrote: > > Hi Imo, > > Follow the instructions at > https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission > and upgrade to Aggregate v1.4.11 to prevent this from happening in the > future. > > Yaw > -- > Need ODK consultants? Nafundi provides form design, server setup, > in-field training, and software development for ODK. Go to > https://nafundi.com to get started. > > On Thu, Aug 11, 2016 at 1:59 PM, wrote: >> On Tuesday, August 2, 2016 at 8:32:46 AM UTC-4, Yaw Anokwa wrote: >>> Hi Marty, >>> >>> Add yanokwa@nafundi.com as an owner on your App Engine instance and >>> I'll try to fix it. >>> >>> Upgrading to Aggregate v1.4.11 will prevent this from happening in the future. >>> >>> Yaw >>> >>> On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community wrote: >>>> Hi, >>>> >>>> I've recently deployed a survey using ODK and things were going well. This I logged into ODK Aggregate and noticed the following error: >>>> >>>> `Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)` >>>> >>>> Having looked at the ODK Aggregate docs and the github it looks to be a problem with one form submission. I'm a little out of my depth repairing the database myself though have been following the instructions posted here: >>>> `https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting` >>>> >>>> Is there anyone who could help me resolve this problem? >>>> >>>> Thanks >>>> >>>> Marty >>>> >>>> -- >>>> -- >>>> 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. >> >> Hi Yaw, >> >> We also have a similar problem that just started happening now in the last week. >> >> Error: Problem persisting data or accessing data (SELECT * FROM PTENTS05_INTRVW_QSTNS_CD_TECH_US_NTRNT_CNNCTON_TECH_9 WHERE _TOP_LEVEL_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f AND _PARENT_AURI = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f multiple-choice valueSet is missing an entry OR has an extra copy of one) >> >> Any assistance you can provide would be highly appreciated. >> >> -- >> -- >> 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 a topic in the Google Groups "ODK Community" group. > To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/Nj8Gx6mlMOA/unsubscribe. > To unsubscribe from this group and all its topics, send an email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

Hi Yaw,

Thanks for sending the steps to fix it. I too am very much out of my depth
here in trying to address the issues on the server. Can we add you as an
owner of our app engine instance?

Many thanks.

Best,

Imo

··· On Thursday, August 11, 2016 at 11:27:26 AM UTC-4, Yaw Anokwa wrote: > > Hi Imo, > > Follow the instructions at > > https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission > and upgrade to Aggregate v1.4.11 to prevent this from happening in the > future. > > Yaw > -- > Need ODK consultants? Nafundi provides form design, server setup, > in-field training, and software development for ODK. Go to > https://nafundi.com to get started. > > On Thu, Aug 11, 2016 at 1:59 PM, <imo....@mymdoc.com > wrote: > > On Tuesday, August 2, 2016 at 8:32:46 AM UTC-4, Yaw Anokwa wrote: > >> Hi Marty, > >> > >> Add yan...@nafundi.com as an owner on your App Engine > instance and > >> I'll try to fix it. > >> > >> Upgrading to Aggregate v1.4.11 will prevent this from happening in the > future. > >> > >> Yaw > >> > >> On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community <opend...@googlegroups.com > wrote: > >> > Hi, > >> > > >> > I've recently deployed a survey using ODK and things were going well. > This I logged into ODK Aggregate and noticed the following error: > >> > > >> > `Error: Problem persisting data or accessing data (SELECT * FROM > RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = > uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = > uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is > missing an entry OR has an extra copy of one)` > >> > > >> > Having looked at the ODK Aggregate docs and the github it looks to be > a problem with one form submission. I'm a little out of my depth repairing > the database myself though have been following the instructions posted > here: > >> > ` > https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting` > > >> > > >> > Is there anyone who could help me resolve this problem? > >> > > >> > Thanks > >> > > >> > Marty > >> > > >> > -- > >> > -- > >> > Post: opend...@googlegroups.com > >> > Unsubscribe: opendatakit...@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...@googlegroups.com . > >> > For more options, visit https://groups.google.com/d/optout. > > > > Hi Yaw, > > > > We also have a similar problem that just started happening now in the > last week. > > > > Error: Problem persisting data or accessing data (SELECT * FROM > PTENTS05_INTRVW_QSTNS_CD_TECH_US_NTRNT_CNNCTON_TECH_9 WHERE _TOP_LEVEL_AURI > = uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f AND _PARENT_AURI = > uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f multiple-choice valueSet is > missing an entry OR has an extra copy of one) > > > > Any assistance you can provide would be highly appreciated. > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@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...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

Hi Imo,

Please upgrade to 1.4.11
(https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes)
and then add 'yanokwa@nafundi.com' as an Owner to your App Engine
instance. The URL will be
https://console.cloud.google.com/iam-admin/iam/project?project=YOUR_APP_ID.

Thanks,

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Sun, Aug 21, 2016 at 12:31 PM, Imo imo.etuk@gmail.com wrote:

Hi Yaw,

Thanks for sending the steps to fix it. I too am very much out of my depth
here in trying to address the issues on the server. Can we add you as an
owner of our app engine instance?

Many thanks.

Best,

Imo

On Thursday, August 11, 2016 at 11:27:26 AM UTC-4, Yaw Anokwa wrote:

Hi Imo,

Follow the instructions at

https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting#repairing-a-filled-in-form-submission
and upgrade to Aggregate v1.4.11 to prevent this from happening in the
future.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Aug 11, 2016 at 1:59 PM, imo....@mymdoc.com wrote:

On Tuesday, August 2, 2016 at 8:32:46 AM UTC-4, Yaw Anokwa wrote:

Hi Marty,

Add yan...@nafundi.com as an owner on your App Engine instance and
I'll try to fix it.

Upgrading to Aggregate v1.4.11 will prevent this from happening in the
future.

Yaw

On Tue, Aug 2, 2016 at 8:32 AM, chuzzlewit69 via ODK Community opend...@googlegroups.com wrote:

Hi,

I've recently deployed a survey using ODK and things were going well.
This I logged into ODK Aggregate and noticed the following error:

Error: Problem persisting data or accessing data (SELECT * FROM RW_1607EL_TL_CONSNT_SECTION1_MODLE_1_4_COFFEE_SALE2 WHERE _TOP_LEVEL_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad AND _PARENT_AURI = uuid:9a5b719a-331c-4e50-b779-828ae14875ad multiple-choice valueSet is missing an entry OR has an extra copy of one)

Having looked at the ODK Aggregate docs and the github it looks to be
a problem with one form submission. I'm a little out of my depth repairing
the database myself though have been following the instructions posted here:

https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting

Is there anyone who could help me resolve this problem?

Thanks

Marty

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Yaw,

We also have a similar problem that just started happening now in the
last week.

Error: Problem persisting data or accessing data (SELECT * FROM
PTENTS05_INTRVW_QSTNS_CD_TECH_US_NTRNT_CNNCTON_TECH_9 WHERE _TOP_LEVEL_AURI
= uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f AND _PARENT_AURI =
uuid:e9c432d6-1331-48ed-b49d-53c79a249d3f multiple-choice valueSet is
missing an entry OR has an extra copy of one)

Any assistance you can provide would be highly appreciated.

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@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.