Just wanted to bump this in case it got lost in the shuffle...
(forms have been emailed directly to mitchellsundt at gmail)
Yes, I would need to have the form. Send it to me directly (
mitche...@gmail.com )
On Fri, Aug 28, 2015 at 12:29 PM, colind...@gmail.com wrote:
Need to reopen this one, unfortunately.
We have been unable to upload the large form with our new server stack.
Details:
Aggregate 1.4.7
Tomcat 6
mysql Ver 14.14 Distrib 5.6.25
Java 8 (openjdk version "1.8.0_45-internal")
Ubuntu 15.04
The form definition that we're trying to upload is 1.4 MB (about 27400
lines). I can send you the form if that would be helpful.
Error as observed on Aggregate:
HTTP Status 400 - Problem parsing submission XML
org.opendatakit.aggregate.exception.ODKParseException: Error processing new
form: org.opendatakit.aggregate.exception.ODKParseException: Unable to
create form data tables after 100 attempts.
type Status report
message Problem parsing submission XML
org.opendatakit.aggregate.exception.ODKParseException: Error processing new
form: org.opendatakit.aggregate.exception.ODKParseException: Unable to
create form data tables after 100 attempts.
description The request sent by the client was syntactically incorrect.
Apache Tomcat/6.0.41
catalina.out logfile
INFO: Executing DROP TABLE fresh
.BUILD_35524174_CORE
by user
anonymousUser
Aug 28, 2015 8:56:48 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl dropRelation
WARNING: BUILD_35524174_CORE exception:
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [DROP TABLE fresh
.BUILD_35524174_CORE
]; nested exception is
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table
'fresh.BUILD_35524174_CORE'
Aug 28, 2015 8:56:48 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: BUILD_35524174_CORE100
Aug 28, 2015 8:56:48 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: Attempting: CREATE TABLE fresh
.BUILD_35524174_CORE100
( _URI
VARCHAR(80) CHARACTER SET utf8 NOT NULL , _CREATOR_URI_USER
VARCHAR(80)
CHARACTER SET utf8 NOT NULL , _CREATION_DATE
DATETIME NOT NULL ,
_LAST_UPDATE_URI_USER
VARCHAR(80) CHARACTER SET utf8 NULL ,
_LAST_UPDATE_DATE
DATETIME NOT NULL , _PARENT_AURI
VARCHAR(80)
CHARACTER SET utf8 NULL , _ORDINAL_NUMBER
INTEGER(9 ) NOT NULL ,
_TOP_LEVEL_AURI
VARCHAR(80) CHARACTER SET utf8 NULL , ABC9
VARCHAR(255
) CHARACTER SET utf8 NULL , INDEX(_URI
) USING HASH ,
INDEX(_LAST_UPDATE_DATE
) , INDEX(_PARENT_AURI
) USING HASH )
Aug 28, 2015 8:56:49 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: create table success (before updateRelation):
BUILD_35524174_CORE100
Aug 28, 2015 8:56:49 PM
org.opendatakit.aggregate.parser.FormParserForJavaRosa orderlyDivideTable
INFO: Attempting to divide BUILD_35524174_CORE
Aug 28, 2015 8:56:49 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl hasRelation
INFO: BUILD_35524174_CORE101 does not exist!
Aug 28, 2015 8:56:49 PM
org.opendatakit.aggregate.parser.FormParserForJavaRosa orderlyDivideTable
INFO: Unable to cleave along groups; attempting phantom table!
BUILD_35524174_CORE
Aug 28, 2015 8:56:49 PM
org.opendatakit.aggregate.parser.FormParserForJavaRosa orderlyDivideTable
INFO: Created phantom for BUILD_35524174_CORE beginning at 608 with a
total of 1 cleaved
Aug 28, 2015 8:56:49 PM
org.opendatakit.aggregate.parser.FormParserForJavaRosa guardedInitHelper
SEVERE: Aborting form-creation due to fail-safe limit (100 attempts)!
Aug 28, 2015 8:56:49 PM
org.opendatakit.aggregate.parser.FormParserForJavaRosa guardedInitHelper
WARNING: Aborting form-creation do to exception:
org.opendatakit.aggregate.exception.ODKParseException: Unable to create
form data tables after 100 attempts.. Datastore exceptions are expected in
the following stack trace; other exceptions may indicate a problem:
org.opendatakit.aggregate.exception.ODKParseException: Unable to create
form data tables after 100 attempts.
at
org.opendatakit.aggregate.parser.FormParserForJavaRosa.guardedInitHelper(FormParserForJavaRosa.java:577)
org.opendatakit.aggregate.parser.FormParserForJavaRosa.initHelper(FormParserForJavaRosa.java:236)
org.opendatakit.aggregate.parser.FormParserForJavaRosa.(FormParserForJavaRosa.java:148)