I'm having trouble viewing or exporting data from my aggregate server
running on google app engine.
When trying to view the data i get an error message of the type
"Error: Problem persisting data or accessing data
([ChoiceSubmissionType.getValueFromEntity] SQL: SELECT * FROM
opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS WHERE _PARENT_AURI =
uuid:aa257213-95f0-4c52-acf6-94dea91787c7 ORDER BY _PARENT_AURI exception:
This request (f83cfd6354961c39) started at 2016/02/15 16:07:27.675 UTC and
was still executing at 2016/02/15 16:08:27.564 UTC.)"
However each time it is for a different data table name and a different
instance ID (i.e. "opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS"
and "uuid:aa257213-95f0-4c52-acf6-94dea91787c7" change each time).
In fact, I cannot find the same error messages on the App Engine Logs as I
receive on the Aggregate website. I find this type of error message
instead:
"org.opendatakit.aggregate.submission.Submission fetchSubmission: Unable to
reconstruct submission for opendatakit.RHO14_95_CORE uri
uuid:5011450e-4510-4e07-a19c-e74e8d3e267f" However, if I search using the
table name and uuid from this error message nothing is found.
I also receive errors when I try to export the dataset using Aggregate, or
when I try to pull them from the server using Briefcase. Briefcase
sometimes manages to download more instances before showing error than at
other times.
You will likely need to upgrade to 1.4.7 to get better error messages.
···
On Mon, Feb 15, 2016 at 8:37 AM, Jim Hammond wrote:
Hello
I'm having trouble viewing or exporting data from my aggregate server
running on google app engine.
When trying to view the data i get an error message of the type
"Error: Problem persisting data or accessing data
([ChoiceSubmissionType.getValueFromEntity] SQL: SELECT * FROM
opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS WHERE _PARENT_AURI =
uuid:aa257213-95f0-4c52-acf6-94dea91787c7 ORDER BY _PARENT_AURI exception:
This request (f83cfd6354961c39) started at 2016/02/15 16:07:27.675 UTC and
was still executing at 2016/02/15 16:08:27.564 UTC.)"
However each time it is for a different data table name and a different
instance ID (i.e. "opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS"
and "uuid:aa257213-95f0-4c52-acf6-94dea91787c7" change each time).
In fact, I cannot find the same error messages on the App Engine Logs as I
receive on the Aggregate website. I find this type of error message
instead:
"org.opendatakit.aggregate.submission.Submission fetchSubmission: Unable
to reconstruct submission for opendatakit.RHO14_95_CORE uri
uuid:5011450e-4510-4e07-a19c-e74e8d3e267f" However, if I search using the
table name and uuid from this error message nothing is found.
I also receive errors when I try to export the dataset using Aggregate,
or when I try to pull them from the server using Briefcase. Briefcase
sometimes manages to download more instances before showing error than at
other times.
If I update aggregate, will my data stored on the aggregate server be
disrupted or lost? As I can't download the data at the moment I cannot
back it up.
I'm having trouble viewing or exporting data from my aggregate server
running on google app engine.
When trying to view the data i get an error message of the type
"Error: Problem persisting data or accessing data
([ChoiceSubmissionType.getValueFromEntity] SQL: SELECT * FROM
opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS WHERE _PARENT_AURI =
uuid:aa257213-95f0-4c52-acf6-94dea91787c7 ORDER BY _PARENT_AURI exception:
This request (f83cfd6354961c39) started at 2016/02/15 16:07:27.675 UTC and
was still executing at 2016/02/15 16:08:27.564 UTC.)"
However each time it is for a different data table name and a different
instance ID (i.e. "opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS"
and "uuid:aa257213-95f0-4c52-acf6-94dea91787c7" change each time).
In fact, I cannot find the same error messages on the App Engine Logs as
I receive on the Aggregate website. I find this type of error message
instead:
"org.opendatakit.aggregate.submission.Submission fetchSubmission: Unable
to reconstruct submission for opendatakit.RHO14_95_CORE uri
uuid:5011450e-4510-4e07-a19c-e74e8d3e267f" However, if I search using
the table name and uuid from this error message nothing is found.
I also receive errors when I try to export the dataset using Aggregate,
or when I try to pull them from the server using Briefcase. Briefcase
sometimes manages to download more instances before showing error than at
other times.
···
--
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 Fri, Mar 25, 2016 at 12:38 PM, peter kabiro mwangi p.mwangi34@gmail.com wrote:
hi guys? am a new odk user can someone help me to solve this error in my
aggragate.
You need to upload and deploy an application before you can make Web
history.
Read about using appcfg to upload and deploy one.
You have not uploaded any versions of this application.
Learn more about uploading Python versions, Java versions, Go versions or
PHP versions.
Use the appcfg download_app command to download your application's code. If
you do not want any admin to be able to download code, you
Data is not affected during an upgrade unless specifically noted (e.g.,
most recently, updates have forced anyone using the 2.0 tools to delete all
of their 2.0 data tables; we have not had incompatible 1.x upgrades for
quite some time).
In this case, from 1.4.5 to 1.4.7, the main annoyance is the breaking of
the row/column filters.
···
On Thu, Feb 18, 2016 at 2:54 AM, Jim Hammond wrote:
Thanks Mitch
If I update aggregate, will my data stored on the aggregate server be
disrupted or lost? As I can't download the data at the moment I cannot
back it up.
I'm having trouble viewing or exporting data from my aggregate server
running on google app engine.
When trying to view the data i get an error message of the type
"Error: Problem persisting data or accessing data
([ChoiceSubmissionType.getValueFromEntity] SQL: SELECT * FROM
opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS WHERE _PARENT_AURI =
uuid:aa257213-95f0-4c52-acf6-94dea91787c7 ORDER BY _PARENT_AURI exception:
This request (f83cfd6354961c39) started at 2016/02/15 16:07:27.675 UTC and
was still executing at 2016/02/15 16:08:27.564 UTC.)"
However each time it is for a different data table name and a
different instance ID (i.e. "opendatakit.RHO14_95_MILKDTLSMILKBSCNFO_DAIRY_PRODUCTS"
and "uuid:aa257213-95f0-4c52-acf6-94dea91787c7" change each time).
In fact, I cannot find the same error messages on the App Engine Logs as
I receive on the Aggregate website. I find this type of error message
instead:
"org.opendatakit.aggregate.submission.Submission fetchSubmission:
Unable to reconstruct submission for opendatakit.RHO14_95_CORE uri
uuid:5011450e-4510-4e07-a19c-e74e8d3e267f" However, if I search using
the table name and uuid from this error message nothing is found.
I also receive errors when I try to export the dataset using Aggregate,
or when I try to pull them from the server using Briefcase. Briefcase
sometimes manages to download more instances before showing error than at
other times.