Hi,
We have recently started receiving a "og4j:ERROR Failed to excute sql"
error when batch importing items into our workflow (see attachment).
We've previously imported records without problems, and haven't made any
changes to our setup.
The error only appears when importing the first item to a collection,
directly after the bitstream is loaded. The importer then continues to
load the remaining records into the collection without errors. All
records appear to be successfully loaded to DSpace (including the one
with the error), but we've found that they sometimes end up in the
submitter's "unfinished submissions" rather than in the workflow.
Does anyone have any advice?
Thanks,
Donna Barber
Applications Support Librarian
University of Canterbury Library
Te Whare Wananga o Waitaha
Christchurch, New Zealand
ph: +64 3 3642987 ext 8601
Destination collections:
Owning Collection: Conference Contributions
Adding items from directory: /ir/dspace/import/education/conference
Generating mapfile: /ir/dspace/import/education/conference/map_conference
Adding item from directory 12605499
Loading dublin core from
/ir/dspace/import/education/conference/12605499/dublin_core.xml
Schema: dc Element: type Qualifier: none Value: Conference Contribution
- Paper in published proceedings
Schema: dc Element: publisher Qualifier: none Value: University of
Canterbury. School of Maori, Social and Cultural Studies in Education.
Schema: dc Element: identifier Qualifier: citation Value: Abbiss, J.
(2005) Gender identity and meaning making in specialist IT classes. Paper
presented at the Annual Meeting of the American Educational Research
Association, Montreal, Canada, April 11-15, 2005. Montreal, Canada: AERA 2005
annual meeting, April 11-15 2005. ERIC Online - Educational Resources
Information Centre, #ED490534, 14.
Schema: dc Element: title Qualifier: none Value: Gender identity and
meaning making in specialist IT classes. Paper presented at the Annual Meeting
of the American Educational Research Association, Montreal, Canada, April
11-15, 2005
Schema: dc Element: date Qualifier: issued Value: 2005
Schema: dc Element: contributor Qualifier: author Value: Abbiss, J.
Schema: dc Element: language Qualifier: iso Value: en
Schema: dc Element: rights Qualifier: none Value:
http://library.canterbury.ac.nz/ir/rights.shtml
Loading dublin core from
/ir/dspace/import/education/conference/12605499/metadata_uc.xml
Schema: uc Element: publicationid Qualifier: none Value: 12605499
Schema: uc Element: number Qualifier: none Value: 217397
Processing contents file:
/ir/dspace/import/education/conference/12605499/contents
Bitstream: 12605499_GenderIdentity.pdf
log4j:ERROR Failed to excute sql
org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: ""
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:178)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:250)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:146)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at org.apache.log4j.Category.callAppenders(Category.java:203)
at org.apache.log4j.Category.forcedLog(Category.java:388)
at org.apache.log4j.Category.info(Category.java:663)
at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:177)
at
org.dspace.workflow.WorkflowManager.startWithoutNotify(WorkflowManager.java:221)
at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:648)
at org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:506)
at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:415)
0 12605499
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech