Hi, I'm trying to upgrade from DSpace 3.2 Oracle to DSpace CRIS 5.5 Oracle. Migration seems ok:
Database Software: Oracle version Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Database Driver: Oracle JDBC driver version 11.2.0.4.0 +----------------+----------------------------+---------------------+---------+ | Version | Description | Installed on | State | +----------------+----------------------------+---------------------+---------+ | 1.2 | Initial DSpace 1.2 Oracle | | PreInit | | 1.3 | Upgrade to DSpace 1.3 sche | | PreInit | | 1.3.9 | Drop constraint for DSpace | | PreInit | | 1.4 | Upgrade to DSpace 1.4 sche | | PreInit | | 1.4.2 | Upgrade to DSpace 1.4.2 sc | | PreInit | | 1.5 | Upgrade to DSpace 1.5 sche | | PreInit | | 1.5.9 | Drop constraint for DSpace | | PreInit | | 1.6 | Upgrade to DSpace 1.6 sche | | PreInit | | 1.7 | Upgrade to DSpace 1.7 sche | | PreInit | | 1.8 | Upgrade to DSpace 1.8 sche | | PreInit | | 3.0 | Initializing from DSpace 3 | 2016-09-21 12:59:12 | Success | | 4.0 | Upgrade to DSpace 4.x sche | 2016-09-21 12:59:14 | Success | | 4.1.0.0 | DSpaceCRIS-crismodule data | 2016-09-21 12:59:18 | Success | | 4.1.0.1 | DSpaceCRIS-crispubmed data | 2016-09-21 12:59:18 | Success | | 4.1.0.2 | DSpaceCRIS-subscription da | 2016-09-21 12:59:18 | Success | | 4.3.0.0 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 12:59:18 | Success | | 5.0.2014.08.08 | DS-1945 Helpdesk Request a | 2016-09-21 12:59:18 | Success | | 5.0.2014.09.25 | DS 1582 Metadata For All O | 2016-09-21 12:59:18 | Success | | 5.0.2014.09.26 | DS-1582 Metadata For All O | 2016-09-21 12:59:43 | Success | | 5.3.0.0 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 12:59:43 | Success | | 5.3.0.1 | FIX-SNAPSHOT-DSpaceCRIS-Up | 2016-09-21 12:59:43 | Success | | 5.3.0.2 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 12:59:43 | Success | | 5.3.0.3 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 12:59:43 | Success | | 5.3.0.4 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 13:19:00 | Success | | 5.3.0.5 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 13:55:24 | Success | | 5.3.0.6 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 13:55:24 | Success | | 5.3.1.0 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 13:55:24 | Success | | 5.3.1.1 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 13:55:24 | Success | | 5.4.0.0 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 14:18:12 | Success | | 5.4.0.1 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 17:20:19 | Success | | 5.5.0.1 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 17:20:19 | Success | | 5.5.1.0 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 17:44:05 | Success | | 5.5.1.1 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 17:44:05 | Success | | 5.5.1.2 | DSpaceCRIS-Upgrade-crismod | 2016-09-21 18:03:39 | Success | +----------------+----------------------------+---------------------+---------+ although I had to tweak some SQL files for FlywayDB not give errors. For example: in DSpace/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V5.3.0.2__DSpaceCRIS-Upgrade-crismodule_5_to_53.sql there is a field "mode" which is a reserved word in Oracle (renamed to "modo" ?????) Well, the point is that Dspace CRIS seems ok but when I try create a Researcher profile, I get this error: ============================================= org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: ORA-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.app.webui.cris.filter.DSpaceContextCleanupFilter.doFilter(DSpaceContextCleanupFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1082) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:724) Caused by: org.hibernate.exception.SQLGrammarException: ORA-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) at com.sun.proxy.$Proxy623.executeQuery(Unknown Source) at org.hibernate.loader.Loader.getResultSet(Loader.java:1926) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1727) at org.hibernate.loader.Loader.doQuery(Loader.java:852) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:293) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:263) at org.hibernate.loader.Loader.loadCollection(Loader.java:2123) at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:85) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:678) at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:80) at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1804) at org.hibernate.collection.internal.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:681) at org.hibernate.engine.internal.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:1024) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:298) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:263) at org.hibernate.loader.Loader.loadEntity(Loader.java:2006) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:82) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:111) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3887) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:458) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:427) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:204) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:260) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:148) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1078) at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:175) at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2424) at org.hibernate.internal.SessionImpl.get(SessionImpl.java:974) at it.cilea.osd.common.dao.impl.GenericDaoHibernateImpl.read(GenericDaoHibernateImpl.java:85) 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:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at it.cilea.osd.common.dao.impl.NamedQueryIntroductionAdvisor$1.invoke(NamedQueryIntroductionAdvisor.java:103) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy110.read(Unknown Source) at it.cilea.osd.common.service.PersistenceService.get(PersistenceService.java:163) at org.dspace.app.cris.service.ApplicationService.get(ApplicationService.java:808) at org.dspace.app.cris.service.ApplicationService.get(ApplicationService.java:850) at org.dspace.app.cris.service.ApplicationService$$FastClassByCGLIB$$600ec924.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at org.dspace.app.cris.service.ApplicationService$$EnhancerByCGLIB$$969d9351.get(<generated>) at org.dspace.app.webui.cris.controller.jdyna.FormDODynamicMetadataController.formBackingObject(FormDODynamicMetadataController.java:174) at org.springframework.web.servlet.mvc.AbstractFormController.getErrorsForNewForm(AbstractFormController.java:361) at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:341) at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:281) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) ... 36 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "AVALUE2_"."BOOLEANVALUE": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ... 99 more Has anyone tried to install a Dspace CRIS 5.5 + Oracle database? Thanks. -- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
