Hi Yaw,
thank you for your anser. the exception is actually from the tomcat6
installation.
I tested tomcat7 (without success), then tried tomcat 6 and got the
exceptions.
My fault to mention tomcat7.
I've also installed a version on appspot, which works fine.
But I would like to have controll over the database, i.e. read the data
myself
without having to export to csv files or Fusion Tables.
In the log, catalina.out
The query is obviously wrong ... WHERE TABLE_ID
IN ()...
The exception occurs also when accessing the program for the first time,
i.e.
http://..../ODKAggregate/index.html but the Form management and
Submission page
is displayed anyway.
I have configured odk to use a valid google account.
Here is more of the stack trace.
Cheers
Christian
Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkMiscTasks
INFO: Done checking miscellaneous tasks
Sep 12, 2013 9:47:12 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkTasks
INFO: ---------------------END Watchdog
EXITING WATCHDOG TASK IN TOMCAT
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.RoleHierarchyImpl
refreshReachableGrantedAuthorities
INFO: Executing: refreshReachableGrantedAuthorities
Sep 12, 2013 9:56:25 AM
org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions
INFO: Executing: reloadPermissions
Sep 12, 2013 9:56:28 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _security_revisions
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_ENTRY
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: __ODKTABLES__TABLE_DEFINITIONS
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: fetching new list of Forms
Sep 12, 2013 9:56:29 AM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl assertRelation
INFO: before updateRelation: _form_info
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: incoming- last Fetch: -1378972589356 [S: -556484
Eq: -1378972589356 Fs: -1378972589356]
futureMillis: 0
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: -fetched- last Fetch: 0 [S: -557356
Eq: -158637356 Fs: -157737356]
futureMillis: -1
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: Eq-update last Fetch: 0 [S: -557356
Eq: 0 Fs: -157737356]
futureMillis: 0 requested: 0
Sep 12, 2013 9:56:29 AM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Sep 12, 2013 9:56:29 AM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Sep 12, 2013 9:56:29 AM
org.springframework.jdbc.support.SQLErrorCodesFactory
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
MySQL, Oracle, PostgreSQL, Sybase]
org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT _URI
,
_CREATOR_URI_USER
, _CREATION_DATE
, _LAST_UPDATE_URI_USER
,
_LAST_UPDATE_DATE
, TABLE_ID
, TABLE_KEY
, DB_TABLE_NAME
, TYPE
,
TABLE_ID_ACCESS_CONTROLS
FROM odk
.__ODKTABLES__TABLE_DEFINITIONS
WHERE TABLE_ID
IN ();]; nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
at
org.opendatakit.common.persistence.engine.mysql.QueryImpl.executeQuery(QueryImpl.java:259)
at org.opendatakit.common.ermodel.simple.Query.execute(Query.java:267)
at
org.opendatakit.aggregate.odktables.TableManager.getTableEntries(TableManager.java:141)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:84)
at
org.opendatakit.aggregate.odktables.TableManager.getTables(TableManager.java:119)
at
org.opendatakit.aggregate.server.ServerTableServiceImpl.getTables(ServerTableServiceImpl.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.SecurityContextHolderAwareAuthPreservingRequestFilter.doFilter(SecurityContextHolderAwareAuthPreservingRequestFilter.java:66)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.opendatakit.common.security.spring.OpenIDAuthenticationFilter.doFilter(OpenIDAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:115)
at
org.opendatakit.common.security.spring.DigestAuthenticationFilter.doFilter(DigestAuthenticationFilter.java:40)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.OutOfBandUserFilter.doFilter(OutOfBandUserFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.opendatakit.common.security.spring.Oauth2ResourceFilter.doFilter(Oauth2ResourceFilter.java:351)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:300)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
at
com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
... 69 more
On Wed, Sep 11, 2013 at 8:52 PM, Yaw Anokwa yanokwa@nafundi.com wrote:
Christian,
ODK Aggregate is not tested on Tomcat 7. You can probably make it
work, but I don't know anyone who has successfully done it. Try Tomcat
6 and see if that works.
Yaw
Need ODK services? http://nafundi.com provides form design,
professional support, custom reporting, and software development for
ODK.
On Tue, Sep 10, 2013 at 5:01 AM, Christian Steinebach eidemsnesset@gmail.com wrote:
Hi!
I installed odkaggregate (1.3.4) on a linux box running mysql, tomcat7
When going to hostname/ODKAggregate only the anonymous accessible page
is
shown.
Clicking on 'Login' hangs the system and nothing happens.
Studying the catalina.out file reveals that there is a problem with an
sql
query.
.....
org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback;
bad SQL grammar [SELECT _URI
, _CREATOR_URI_USER
, _CREATION_DATE
,
_LAST_UPDATE_URI_USER
, _LAST_UPDATE_DATE
, TABLE_ID
, TABLE_KEY
,
DB_TABLE_NAME
, TYPE
, TABLE_ID_ACCESS_CONTROLS
FROM
odk
.__ODKTABLES__TABLE_DEFINITIONS
WHERE TABLE_ID
IN ();]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You
have an error in your SQL syntax; check the manual that corresponds to
your
MySQL server version for the right syntax to use near ')' at line 1
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
......
I could not find anything in the documentation nor in this googlegroup
Any help appreciated
Christian
--
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/groups/opt_out.
--
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/ULKkwHnZ0rc/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/groups/opt_out.
--
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/groups/opt_out.