Problem with Dspace CRIS 5.5 Oracle database error
Alejandro Melián
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.
Pascarelli Luigi Andrea
I suggest to take a step back and try to migrate your DSpace with
DSpace-CRIS 5.x, before to build application you have to tweak two sql
files with the follow modification.
After checkout the branch dspace-5_x_x-cris from
https://github.com/4Science/DSpace.git follow this step:
1) at line
https://github.com/4Science/DSpace/blob/dspace-5_x_x-cris/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V5.3.0.0__DSpaceCRIS-Upgrade-crismodule_5_to_53.sql#L27
and
https://github.com/4Science/DSpace/blob/dspace-5_x_x-cris/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V5.3.0.2__DSpaceCRIS-Upgrade-crismodule_5_to_53.sql#L10
change the reserved word and enclose it with double quote, e.g. "create
table IF NOT EXISTS cris_orcid_queue (id number(10,0) not null, owner
varchar2(255), entityId number(10,0), typeId number(10,0), "MODE"
varchar2(255), fastlookupobjectname clob, fastlookupuuid varchar2(255),
primary key (id));"
2) at line
https://github.com/4Science/DSpace/blob/dspace-5_x_x-cris/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V5.3.0.0__DSpaceCRIS-Upgrade-crismodule_5_to_53.sql#L10
change the column name booleanValue with "BOOLEANVALUE".
Hope this help you.
Please, let me know
Luigi Andrea
--
Luigi Andrea Pascarelli
DSpace and DSpace-CRIS Committer
4Science, www.4science.it
office: Via Edoardo D'Onofrio 304, 00155 Roma, Italy
tel: +39 333 934 1782
skype: l_a_p82
linkedin: luigiandreapascarelli
an Itway Group Company
Italy, France, Spain, Portugal, Greece, Turkey, Lebanon, Qatar, U.A.Emirates
====================================
Save a tree. Don't print this e-mail unless it's really necessary.
DISCLAIMER: The information contained in this message is confidential, can be legally protected by local Laws,
and must be exclusively used by the recipient. The publication, use, distribution, printing or unauthorized copy
of the content of this message is strictly forbidden and it can be illegal. If you received this message by mistake,
please destroy it and notify it to the sender.