Re: [dspace-tech] Problem with Dspace CRIS 5.5 Oracle database error
Dear Alejandro, 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. -- 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.
[dspace-tech] Problem with Dspace CRIS 5.5 Oracle database error
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(DS