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:r...@ua.es] 
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(AdvancedSearchServlet.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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to