Hi, Well, the relevant part of this is the only thing that's not in English!! But the context is clear enough - it's having trouble parsing a valid date.
Can you confirm that the start / end dates that you are passing to the script are of the form 'yyyy-mm-dd'. If your input is valid, then you've got a problem with one of the metadata value fields. You'll need to check the text_value of all the dc.date.accessioned entries (probably metadata_field_id=11). It looks like the offending item is of the correct format (yyyy-mm-ddThh:mi:ssZ), but contains invalid data. G On Mon, 2007-09-10 at 08:49 +0000, Andrea Garrido Fernández wrote: > Hi: > I have a problem when I try to execute the perl scripts for generating > statistics. > When I try to run the LogAnalyser class with a start or end date, I have an > error like this: > > java.sql.SQLException: ORA-01841: el valor (completo) del año debe estar > entre -4713 y +9999, y no debe ser igual a 0 > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062) > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) > at > org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:259) > at > org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:384) > at > org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:395) > at > org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1264) > at > org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:535) > at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java:327) > ------------------------------------------------------------------------------------------ > > I have tried many things, incluiding the solution given in this forum > before, using the REGEXP_REPLACE , but I find it impossible because oracle > don´t recognize this expression. > Colud yo help me, please? I am a bit lost. > Thanks, > Andrea > > _________________________________________________________________ > Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio con > MSN Entretenimiento. http://entretenimiento.msn.es/ > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech This email has been scanned by Postini. For more information please visit http://www.postini.com ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
