Hi all, we are upgrading from DSpace 1.8.3 to DSpace 5.3 (jspui, Oracle 11g database). When running the dspace migrate-embargo -a script, some errors are reported on some of our embargoed items. Two errors are about dates being in the past. Apparently something went wrong with the embargo lifter for those items. There are some errors in the log file that can be explained.
The main problem is that now items that should still be under embargo have become publicly available. We have been using either a date or 'forever' conform the instructions in the Dspace 1.8.3 manual. All those embargoed items that don't have a date, but use "forever" instead, throw an error. 'forever' seems to be stored as 10000-01-01. The first time that the migrate-embargo script encounters such an item, it trhoughs an java.sql.SQLException Year out of range error. That is correct, because forever is not stored in a correct year format. But then there are some more item with 'forever' embargo. These result in a NullPointerException instead of the Year out of range When I understand correctly, embargo now functions with a date on the resource policy. How do I set those to indicate a 'forever' embargo? /dspace/dspace> bin/dspace migrate-embargo -a Failed attempting to lift embargo, item=1820/5837: java.lang.IllegalArgumentException: Embargo lift date must be in the future, but this is in the past: 2015-09-01 Failed attempting to lift embargo, item=1820/5213: java.sql.SQLException: Year out of range. Failed attempting to lift embargo, item=1820/5206: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5122: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5215: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5324: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5267: java.sql.SQLException: Year out of range. Failed attempting to lift embargo, item=1820/5456: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5340: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5452: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5455: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5522: java.lang.IllegalArgumentException: Embargo lift date must be in the future, but this is in the past: 2015-09-10 Failed attempting to lift embargo, item=1820/5755: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5763: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5880: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/5836: java.lang.IllegalArgumentException: Embargo lift date must be in the future, but this is in the past: 2015-09-01 Failed attempting to lift embargo, item=1820/5938: java.lang.NullPointerException Failed attempting to lift embargo, item=1820/6120: java.lang.IllegalArgumentException: Embargo lift date must be in the future, but this is in the past: 2015-08-31 Failed attempting to lift embargo, item=1820/6078: java.lang.NullPointerException 2015-09-18 16:40:00,736 ERROR org.dspace.embargo.EmbargoManager @ Failed attempting to lift embargo, item=1820/5837: java.lang.IllegalArgumentException: Embargo lift date must be in the future, but this is in the past: 2015-09-01 at org.dspace.embargo.EmbargoManager.getEmbargoTermsAsDate(EmbargoManager.java:160) at org.dspace.embargo.DefaultEmbargoSetter.setEmbargo(DefaultEmbargoSetter.java:81) at org.dspace.embargo.EmbargoManager.processOneItem(EmbargoManager.java:350) at org.dspace.embargo.EmbargoManager.main(EmbargoManager.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) 2015-09-18 16:40:00,925 INFO org.dspace.discovery.SolrServiceImpl @ Wrote Item: 1820/636 to Index 2015-09-18 16:40:01,123 ERROR org.dspace.embargo.EmbargoManager @ Failed attempting to lift embargo, item=1820/5213: java.sql.SQLException: Year out of range. at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:19395) at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:19668) at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3166) at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2378) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.dspace.storage.rdbms.DatabaseManager.executeUpdate(DatabaseManager.java:1174) at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:765) at org.dspace.authorize.ResourcePolicy.update(ResourcePolicy.java:478) at org.dspace.embargo.DefaultEmbargoSetter.generatePolicies(DefaultEmbargoSetter.java:127) at org.dspace.embargo.DefaultEmbargoSetter.setEmbargo(DefaultEmbargoSetter.java:89) at org.dspace.embargo.EmbargoManager.processOneItem(EmbargoManager.java:350) at org.dspace.embargo.EmbargoManager.main(EmbargoManager.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) 2015-09-18 16:40:01,182 ERROR org.dspace.embargo.EmbargoManager @ Failed attempting to lift embargo, item=1820/5206: java.lang.NullPointerException at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1908) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.dspace.storage.rdbms.DatabaseManager.executeUpdate(DatabaseManager.java:1174) at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:765) at org.dspace.authorize.ResourcePolicy.update(ResourcePolicy.java:478) at org.dspace.embargo.DefaultEmbargoSetter.generatePolicies(DefaultEmbargoSetter.java:127) at org.dspace.embargo.DefaultEmbargoSetter.setEmbargo(DefaultEmbargoSetter.java:89) at org.dspace.embargo.EmbargoManager.processOneItem(EmbargoManager.java:350) at org.dspace.embargo.EmbargoManager.main(EmbargoManager.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) .... 015-09-18 16:40:01,407 ERROR org.dspace.embargo.EmbargoManager @ Failed attempting to lift embargo, item=1820/5267: java.sql.SQLException: Year out of range. at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:19395) at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:19668) ... 2015-09-18 16:40:01,483 ERROR org.dspace.embargo.EmbargoManager @ Failed attempting to lift embargo, item=1820/5456: java.lang.NullPointerException at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1908) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608) Kind regards, Francis Brouns -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
