Thank you both a lot for your help. I changed the logging level to DEBUG
and see that the query:
insert into bitstreamformatregistry () values ()
was causing the error. After a little more research I found out that in the
dspace.cfg file I set the value db.schema = dspace. That schema existed but
I guess it wasnt the correct one. So after commenting out that line
everything worked fine.
Thanks,
Yunus
On Sat, Oct 27, 2012 at 10:33 PM, Hilton Gibson <[email protected]>wrote:
> Here is the section where it errors.
> ###
> <!-- Loads bitstream format and Dublin Core type registries -->
> <target name="load_registries" description="Load initial contents of
> registries">
>
> <!-- first import the bitstream registry -->
> <java classname="org.dspace.administer.RegistryLoader"
> classpathref="class.path" fork="yes" failonerror="yes">
> <sysproperty key="log4j.configuration"
> value="file:config/log4j-console.properties" />
> <sysproperty key="dspace.log.init.disable" value="true" />
> <sysproperty key="dspace.configuration" value="${config}" />
> <arg value="-bitstream" />
> <arg
> value="${dspace.dir}/config/registries/bitstream-formats.xml" />
> </java>
> ###
> Did you modify any of the above registeries?
>
> On 27 October 2012 21:24, Hilton Gibson <[email protected]> wrote:
>
>> Hi Yunus
>>
>> This the error: "dspace-1.8.2-build/build.xml:826: Java returned: 1"
>> I use exactly the same as you and it works, see: http://ar1.sun.ac.za
>> Let me check the build XML, to see if there is a clue.
>> Meanwhile, check: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Dspace to
>> see if you recognise anything that may cause this problem.
>>
>>
>> On 27 October 2012 20:18, Yunus Acikoz <[email protected]> wrote:
>>
>>> Hello,
>>>
>>> I'm getting the following error on Ubuntu 12.04 while building Dspace
>>> with 'ant fresh_install'. All the previous steps are successful, it fails
>>> at the load_registries step. I'm using Oracle java 6 version 1.6.0_37,
>>> postgresql 9.1, tomcat 7, maven 3.0.4, ant 1.8.4 and I have the 1.8.2
>>> release of dspace. I kept searching for a similar case but I couldn't find
>>> any solution.
>>>
>>> load_registries:
>>> [java] 2012-10-27 18:01:08,295 INFO
>>> org.dspace.core.ConfigurationManager @ Loading system provided config
>>> property (-Ddspace.configuration): config/dspace.cfg
>>> [java] 2012-10-27 18:01:08,301 INFO
>>> org.dspace.core.ConfigurationManager @ Using default log4j provided log
>>> configuration,if unintended, check your dspace.cfg for (log.init.config)
>>> [java] Error:
>>> [java] - ERROR: syntax error at or near ")"
>>> [java] 2012-10-27 18:01:08,762 FATAL
>>> org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
>>> [java] org.postgresql.util.PSQLException: ERROR: syntax error at or
>>> near ")"
>>> [java] at
>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
>>> [java] at
>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
>>> [java] at
>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>>> [java] at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>>> [java] at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>>> [java] at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>>> [java] at
>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>> [java] at
>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>> [java] at
>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>>> [java] at
>>> org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
>>> [java] at
>>> org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
>>> [java] at
>>> org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
>>> [java] at
>>> org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
>>> [java] at
>>> org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
>>> [java] at
>>> org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
>>> [java] at
>>> org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
>>>
>>> BUILD FAILED
>>> /home/ubuntu/dspace-1.8.2-release/dspace/target/dspace-1.8.2-build/build.xml:826:
>>> Java returned: 1
>>>
>>> Thanks,
>>> Yunus Acikoz
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> WINDOWS 8 is here.
>>> Millions of people. Your app in 30 days.
>>> Visit The Windows 8 Center at Sourceforge for all your go to resources.
>>> http://windows8center.sourceforge.net/
>>> join-generation-app-and-make-money-coding-fast/
>>> _______________________________________________
>>> Dspace-general mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/dspace-general
>>>
>>>
>>
>>
>> --
>> *Hilton Gibson*
>> Systems Administrator
>> JS Gericke Library
>> Room 1025D
>> Stellenbosch University
>> Private Bag X5036
>> Stellenbosch
>> 7599
>> South Africa
>>
>> Tel: +27 21 808 4100 | Cell: +27 84 646 4758
>> http://library.sun.ac.za
>> http://scholar.sun.ac.za
>>
>>
>
>
> --
> *Hilton Gibson*
> Systems Administrator
> JS Gericke Library
> Room 1025D
> Stellenbosch University
> Private Bag X5036
> Stellenbosch
> 7599
> South Africa
>
> Tel: +27 21 808 4100 | Cell: +27 84 646 4758
> http://library.sun.ac.za
> http://scholar.sun.ac.za
>
>
------------------------------------------------------------------------------
WINDOWS 8 is here.
Millions of people. Your app in 30 days.
Visit The Windows 8 Center at Sourceforge for all your go to resources.
http://windows8center.sourceforge.net/
join-generation-app-and-make-money-coding-fast/
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
