I have not seen this error before. Perhaps you have an incorrect setting for db.schema in your config.
https://github.com/DSpace/DSpace/blob/master/dspace/config/dspace.cfg#L83-L87 On Mon, Feb 13, 2017 at 7:19 AM, Stefan Fritzsche < [email protected]> wrote: > Hi, > > i try to install dspace 6 but the application won't start. The build > process is done without errors. When i start my tomcat 7 some strange > errors occurr in the dspace.log and in the catalina.log file. The following > lines are from the catalina log file. > > SEVERE: Exception sending context destroyed event to listener instance of > class org.dspace.app.util.DSpaceWebappListener > org.hibernate.exception.SQLGrammarException: could not execute batch > at org.hibernate.exception.internal.SQLStateConversionDelegate. > convert(SQLStateConversionDelegate.java:123) > at org.hibernate.exception.internal.StandardSQLExceptionConvert > er.convert(StandardSQLExceptionConverter.java:49) > at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql > ExceptionHelper.java:124) > at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.perfo > rmExecution(BatchingBatch.java:122) > at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExe > cuteBatch(BatchingBatch.java:101) > at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl. > execute(AbstractBatchImpl.java:161) > at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.execu > teBatch(JdbcCoordinatorImpl.java:207) > at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu > eue.java:390) > at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu > eue.java:310) > at org.hibernate.event.internal.AbstractFlushingEventListener.p > erformExecutions(AbstractFlushingEventListener.java:349) > at org.hibernate.event.internal.DefaultFlushEventListener.onFlu > sh(DefaultFlushEventListener.java:56) > at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce > ssorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe > thodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.hibernate.context.internal.ThreadLocalSessionContext$Tra > nsactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352) > at com.sun.proxy.$Proxy41.flush(Unknown Source) > at org.dspace.core.HibernateDBConnection.commit(HibernateDBConn > ection.java:84) > at org.dspace.core.Context.commit(Context.java:402) > at org.dspace.core.Context.complete(Context.java:354) > at org.dspace.app.util.AbstractDSpaceWebapp.deregister(Abstract > DSpaceWebapp.java:89) > at org.dspace.app.util.DSpaceWebappListener.contextDestroyed(DS > paceWebappListener.java:43) > at org.apache.catalina.core.StandardContext.listenerStop(Standa > rdContext.java:5115) > at org.apache.catalina.core.StandardContext.stopInternal(Standa > rdContext.java:5779) > at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase. > java:224) > at org.apache.catalina.util.LifecycleBase.start(LifecycleBase. > java:159) > at org.apache.catalina.core.ContainerBase.addChildInternal(Cont > ainerBase.java:899) > at org.apache.catalina.core.ContainerBase.addChild(ContainerBas > e.java:875) > at org.apache.catalina.core.StandardHost.addChild(StandardHost. > java:652) > at org.apache.catalina.startup.HostConfig.deployDirectory(HostC > onfig.java:1260) > at org.apache.catalina.startup.HostConfig$DeployDirectory.run( > HostConfig.java:2002) > at java.util.concurrent.Executors$RunnableAdapter.call( > Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool > Executor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo > lExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.sql.BatchUpdateException: Batch entry 0 delete from > .webapp where webapp_id=1 was aborted: ERROR: syntax error at or near "." > Position: 13 Call getNextException to see other errors in the batch. > at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResu > ltHandler.java:151) > at org.postgresql.core.ResultHandlerDelegate.handleError(Result > HandlerDelegate.java:45) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer > yExecutorImpl.java:2159) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut > orImpl.java:463) > at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement. > java:794) > at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPrepa > redStatement.java:1662) > at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(De > legatingStatement.java:345) > at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(De > legatingStatement.java:345) > at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.perfo > rmExecution(BatchingBatch.java:113) > ... 33 more > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or > near "." > Position: 13 > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons > e(QueryExecutorImpl.java:2458) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer > yExecutorImpl.java:2158) > ... 39 more > > Can someone explain me where the dot come from in the sql query? I think > this is the problem why the application won't start. > > Thanks and Regards, > Stefan > > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Terry Brady Applications Programmer Analyst Georgetown University Library Information Technology http://georgetown-university-libraries.github.io/ <https://www.library.georgetown.edu/lit/code> 425-298-5498 (Seattle, WA) -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
