Hi, this issue has been logged as DS-823 on the DSpace Jira site, and Ben Bosman made two Subversion commits (6091 modified trunk, and 6092 modified the 1.7.x branch), which reportedly solves this problem, and for which, he will forever remain my hero. :-)
https://jira.duraspace.org/browse/DS-823 If you'd like to get cracking on a 1.7.0 upgrade, and you're using Oracle, you may want to get the code from the 1.7.x branch in Subversion, or make a patch from changeset 6092 and apply that to your code. Other folks might have other advice, but this is what I'll be doing for our repository upgrade process. When 1.7.1 comes out in late March, we'll be ready for it. HTH --Hardy > -----Original Message----- > From: Jizba, Richard [mailto:[email protected]] > Sent: Friday, February 25, 2011 9:28 AM > To: Rafa Carreres; [email protected] > Subject: Re: [Dspace-tech] DSpace 1.7 problem > > The part of the program that manages the Oracle database is broken. It > will be fixed in the bug release (1.7.1). > > If you are an Oracle site, you can not upgrade yet. I wish they would > make that clear; maybe label the software as Postges only or something. > > > > Richard > > > > From: Rafa Carreres [mailto:[email protected]] > Sent: Friday, February 25, 2011 9:25 AM > To: Jizba, Richard > Subject: DSpace 1.7 problem > > > > Hi, Richard, > > I've just read your recent messages at dspace-tech list about some > problems with DSpace 1.7+Oracle. > > Did you fixed that? > > I'm having the same kind of errors when trying to index-init and got > this trace: > > > > Exception: > java.lang.IllegalArgumentException: Value for community_id is not an > integer > at > org.dspace.storage.rdbms.TableRow.getIntColumn(TableRow.java:153) > at org.dspace.content.Community.findAllTop(Community.java:322) > at > org.dspace.app.webui.servlet.AdvancedSearchServlet.doDSGet(AdvancedSearc > hServlet.java:35) > at > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet. > java:119) > at > org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:67) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > > Does it ring a bell? > > It's funny but previosly to this error I got a very strange one: > > Excepción: > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level > 1 > ORA-01882: timezone region not found > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) > at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573) > at > oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate. > java:431) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) > > > > Which I solved adding a new parameter to JAVA_OPTS: > declare -x JAVA_OPTS="-Xmx512M -Xms64M -Dfile.encoding=UTF-8 - > Duser.timezone=CET" > > Best, > > ------ > Rafael Carreres > University of Alicante Repository Administrator > http://rua.ua.es > > ------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
