search

Conal-Tuohy / ands-la-trobe

Automatically exported from code.google.com/p/ands-la-trobe
1 stars 1 forks source link

Projects not saving #44

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Add new project
2. Save

What is the expected output? What do you see instead?

Error transcript:

Sorry, we were unable to save: Exploring the Archaeology of the Modern City 
project (id: 6743, PROJECT)

Stacktrace 1 of 1
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC 
batch update; SQL [insert into resource (access_counter, date_registered, 
date_updated, description, resource_type, status, submitter_id, title, 
updater_id, url, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint 
[null]; nested exception is 
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC 
batch update at 
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessExc
eption(SessionFactoryUtils.java:637) at 
org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateA
ccessException(HibernateTransactionManager.java:793) at 
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(Hibernat
eTransactionManager.java:664) at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.proce
ssCommit(AbstractPlatformTransactionManager.java:754) at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.commi
t(AbstractPlatformTransactionManager.java:723) at 
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTrans
actionAfterReturning(TransactionAspectSupport.java:393) at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Transa
ctionInterceptor.java:120) at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM
ethodInvocation.java:172) at 
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.inter
cept(Cglib2AopProxy.java:621) at 
org.tdar.core.service.resource.ResourceService$$EnhancerByCGLIB$$d1375627.saveOr
Update(<generated>) at 
org.tdar.struts.action.resource.AbstractResourceController.saveBasicResourceMeta
data(AbstractResourceController.java:268) at 
org.tdar.struts.action.resource.ProjectController.save(ProjectController.java:53
) at 
org.tdar.struts.action.resource.ProjectController.save(ProjectController.java:27
) at 
org.tdar.struts.action.AbstractPersistableController.save(AbstractPersistableCon
troller.java:184) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method) at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:43) at java.lang.reflect.Method.invoke(Method.java:616) at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvoca
tion.java:452) at 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionIn
vocation.java:291) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:254) at 
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(Defau
ltWorkflowInterceptor.java:176) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationIn
terceptor.java:263) at 
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doInte
rcept(AnnotationValidationInterceptor.java:68) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(Convers
ionErrorInterceptor.java:133) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(Static
ParametersInterceptor.java:190) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterce
ptor.java:243) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDriven
Interceptor.java:100) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterc
eptor.java:145) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterc
eptor.java:171) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigI
nterceptor.java:164) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters
Interceptor.java:207) at 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt
erInterceptor.java:98) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInter
ceptor.java:75) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor
.java:94) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.ja
va:176) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.
java:190) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(Except
ionMappingInterceptor.java:187) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.tdar.struts.interceptor.AuthenticationInterceptor.intercept(AuthenticationIn
terceptor.java:63) at 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j
ava:248) at 
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at 
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:498) at 
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperatio
ns.java:77) at 
org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecu
teFilter.java:88) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.jav
a:129) at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepa
reFilter.java:82) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInter
nal(OpenSessionInViewFilter.java:198) at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilte
r.java:76) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestCont
extFilter.java:83) at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilte
r.java:76) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) 
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) at 
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90
) at 
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.jav
a:417) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:235) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:206) at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
33) at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
91) 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:298) at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Pr
otocol.java:588) at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at 
java.lang.Thread.run(Thread.java:636) Caused by: 
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC 
batch update at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) 
at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) 
at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) 
at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPers
ister.java:2419) at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPers
ister.java:2874) at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) at 
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abstract
FlushingEventListener.java:321) at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListe
ner.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at 
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) at 
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) at 
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(Hibernat
eTransactionManager.java:656) ... 98 more Caused by: 
java.sql.BatchUpdateException: Batch entry 0 insert into resource 
(access_counter, date_registered, date_updated, description, resource_type, 
status, submitter_id, title, updater_id, url, id) values ('0', '2011-10-24 
20:09:59.921000 +11:00:00', '2011-10-24 20:09:59.921000 +11:00:00', 'The 
‘Exploring the Archaeology of the Modern City’ project (EAMC) was 
established in 2001 by Professor Tim Murray of the Archaeology Program of La 
Trobe University and Industry Partners, to analyse and interpret the large 
assemblages excavated from historical archaeological sites which are held in 
storehouses across Sydney. Funding for the project was provided by the 
Australian Research Council through its Linkage (then SPIRT) Scheme.', 
'PROJECT', 'ACTIVE', '12049', 'Exploring the Archaeology of the Modern City 
project', '12049', NULL, '6743') was aborted. Call getNextException to see the 
cause. at 
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(Abstr
actJdbc2Statement.java:2569) at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1
796) at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.
java:2708) at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.jav
a:297) at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.jav
a:297) at 
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ... 
112 more

Please use labels and text to provide additional information.

Original issue reported on code.google.com by pennycro...@gmail.com on 24 Oct 2011 at 9:13

GoogleCodeExporter commented 9 years ago 
Believe this will be because Daniel dropped and recreated the tDAR database 
yesterday. Penny still has an account in "Crowd" which tDAR uses to log her in, 
but doesn't any more have a corresponding account in tDAR's own database, hence 
despite being logged in won't have rights to do anything; won't be able to own 
any resources, etc. Solution is to create a new account.

Original comment by Conal.Tuohy on 24 Oct 2011 at 11:51

GoogleCodeExporter commented 9 years ago

Original comment by Conal.Tuohy on 25 Oct 2011 at 1:16