I found the problem! The loader program is a perl script that runs in /dspacehome. In /dspacehome was an old copy of dspace.cfg. The correct dspace.cfg is in /dspace/config/ where it belongs. For an unexplained reason, the import program was at first using using /dspacehome/dspace.cfg, then changed to /dspace/config/dspace.cfg. I moved it to NOTdspace.cfg, item gets loaded, and nothing gets written to the dsapce.log.
Before change: 2010-10-11 11:32:26,456 INFO org.dspace.core.ConfigurationManager @ Loading from classloader:file:/dspacehome/dspace.cfg 2010-10-11 11:32:26,488 INFO org.dspace.core.ConfigurationManager @ Using dspace provided log configuration (log.init.config) 2010-10-11 11:32:26,488 INFO org.dspace.core.ConfigurationManager @ Loading: /dspace/config/log4j.properties 2010-10-11 11:32:30,051 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from EPERSON where email = ? " with parameters:[email protected] Marvin On 10/11/2010 11:41 AM, Marvin Weaver wrote: > > > I turned debug on for dspace code. This is what gets written to > dspace.log. > Below is an sql query showing the user is in eperson. > > 2010-10-11 11:32:30,051 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from EPERSON where email = ? " with > parameters:[email protected] > > SQL> select * from eperson where email = '[email protected]'; > > EPERSON_ID EMAIL > ---------- > ---------------------------------------------------------------- > PASSWORD > ---------------------------------------------------------------- > FIRSTNAME > ---------------------------------------------------------------- > LASTNAME > CAN_LOG_IN > ---------------------------------------------------------------- > ---------- > REQUIRE_CERTIFICATE SELF_REGISTERED > ------------------- --------------- > LAST_ACTIVE > --------------------------------------------------------------------------- > > SUB_FREQUENCY PHONE > ------------- -------------------------------- > NETID > ---------------------------------------------------------------- > LANGUAGE > ---------------------------------------------------------------- > [email protected] > 1f91fd370a52b828da2b85b863e17c70 > dspace > dspace > 1 > 0 0 > > > > en > > > SQL> > > Marvin > > On 10/11/2010 10:26 AM, TAYLOR Robin wrote: >> Hi Marvin, >> >> Is it practical to set debugging on in the logs ? Is could you do so >> and then look to see what the actual query is in dspace.log, you >> should see something like "Running query ... with parameters: ...". >> >> Cheers, Robin. >> >> >> Robin Taylor >> Main Library >> University of Edinburgh >> Tel. 0131 6513808 >> >>> -----Original Message----- >>> From: Marvin Weaver [mailto:[email protected]] >>> Sent: 11 October 2010 14:20 >>> To: [email protected] >>> Subject: Re: [Dspace-tech] eperson column and 1.6.2 importer >>> >>> Not really. I had had my script working on 1.5.2 with no >>> errors. The user [email protected] is able to manually go >>> through the add item workflow steps successfully, it's just >>> when I run the batch import script that I get the error and I >>> don't know what is missing. I've also write permissions in >>> all the administrator groups. The error again is: >>> /dspace/bin/import -a -e [email protected] -c 123456789/62 -s >>> /dspace/import/cit_100-1065 -m /dspace/mapfiles/cit_100-1065 >>> >>>> Exception: No such column EPERSON_ID >>>> java.lang.IllegalArgumentException: No such column EPERSON_ID >>>> at >>> org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:509) >>>> at >>> org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManag >>> er.java:1182) >>>> at >>> org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterato >>> r.java:151) >>>> at >>> org.dspace.storage.rdbms.DatabaseManager.querySingleTable(Data >>> baseManager.java:410) >>>> at >>> org.dspace.storage.rdbms.DatabaseManager.findByUnique(Database >>> Manager.java:550) >>>> at >>> org.dspace.eperson.EPerson.findByEmail(EPerson.java:161) >>>> at >>> org.dspace.app.itemimport.ItemImport.main(ItemImport.java:381) >>>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess >>> orImpl.java:39) >>>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth >>> odAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) >>>> >>>> I created an administer group for each collection and >>> [email protected] >>>> as a member to each. >>>> I went to Administer Authorization Policies and granted >>> add to every >>>> administrator group, anonymous, and administrator. >>> Marvin >>> >>> >>> >>> On 10/8/2010 5:44 PM, [email protected] wrote: >>>> Hi Marvin >>>> >>>> Did the wiki page link help ? >>>> >>>> Cheers >>>> >>>> hg >>>> >>>> On 08/10/2010 20:48, Marvin Weaver wrote: >>>>>> There is, and always was. I pasted it into the email >>> to the list and the space got lost. >>>>>> Originally, the email address had turned into a >>> hyperlink in my mail box. Sorry. >>>>>> /dspace/bin/import -a [email protected] -c >>> 123456789/62 -s /dspace/import/cit_100-1065 -m >>> /dspace/mapfiles/cit_100-1065 >>>>>> Marvin >>> >>> -------------------------------------------------------------- >>> ---------------- >>> Beautiful is writing same markup. Internet Explorer 9 >>> supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, >>> and DOM L2& L3. >>> Spend less time writing and rewriting code and more time >>> creating great experiences on the web. Be a part of the beta today. >>> http://p.sf.net/sfu/beautyoftheweb >>> _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >>> ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
