Hi Stuart, Thanks for the tip. At that moment we had not yet run any of the advanced installation jobs. Because this was a clean installation and no collections or items existed yet, I did not realise the script needed to run beforehand. I'll give it a try.
Best regards, Francis -----Oorspronkelijk bericht----- Van: Stuart Lewis [mailto:[email protected]] Verzonden: zondag 11 oktober 2009 10:14 Aan: Brouns, Francis CC: [email protected] Onderwerp: Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2 Hi Francis, The error message suggests this is related to the browse indexes not existing ("table does not exist: SELECT bi_item.* FROM bi_item" - bi = briwse index). Have you tried running [dspace]/bin/index-init ? This will create the browse indexes. Thanks, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ On 10/10/2009, at 1:17 AM, Brouns, Francis wrote: > Hi all, > > We just installed Dspace 1.5.2 (new installation) using Oracle as > database. Ant reports a succesfull build, although there are errors > during database setup (indexes of the Eperson table are not created, > and the tables WorkflowItem and TasklistItem are not created). > However, I can create an admin (using bin/create-administrator). > When I try to log in as administrator, database errors occur (table > or view does not exist), but in the end I'm logged in. I can create > a community, when I create a collection, the collection is not > displayed. During these actions a lot of errors are displayed. > > We are running Oracle 10.1.2.0.2 on a separate database. Dspace > 1.5.2 is installed on a SLES10 server. We used a 10.2x jdbc driver. > > I've never used Oracle before and would appreciate any tips in > solving these errors. > > Kind regards, > Francis Brouns > Open Universiteit Nederland > > - 2009-09-22 13:35:28,760 WARN > org.dspace.app.webui.servlet.DSpaceServlet @ > fbr > @ou.nl:session_id > = > 62B16CBE37149831A0840EE1109D3984 > :ip_addr=145.20.44.48:database_error:java.sql.SQLException\colon; > ORA-00942\colon; table or view does not exist > java.sql.SQLException: ORA-00942: table or view does not exist > at oracle.jdbc.driver.DatabaseError.throwSqlException > (DatabaseError.java:112) > > - 2009-09-22 13:37:49,812 ERROR org.dspace.browse.BrowseDAOOracle @ > caught exception: > java.sql.SQLException: ORA-00942: table or view does not exist > at oracle.jdbc.driver.DatabaseError.throwSqlException > (DatabaseError.java:112) > > - 2009-09-22 13:37:49,813 ERROR > org.dspace.app.webui.servlet.AbstractBrowserServlet @ caught > exception: > org.dspace.browse.BrowseException: java.sql.SQLException: ORA-00942: > table or view does not exist > at org.dspace.browse.BrowseDAOOracle.doCountQuery > (BrowseDAOOracle.java:190) > > - 2009-09-22 13:37:49,864 WARN > org.dspace.app.webui.servlet.InternalErrorServlet > @ :session_id=62B16CBE37149831A0840EE1109D3984:internal_error:-- URL > Was: http://145.20.184.70:8080/jspui/browse?type=dateissued > -- Method: GET > -- Parameters were: > -- type: "dateissued" > org.dspace.browse.BrowseException: java.sql.SQLException: ORA-00942: > table or view does not exist > at org.dspace.browse.BrowseDAOOracle.doCountQuery > (BrowseDAOOracle.java:190) > > - 2009-09-22 13:38:33,405 ERROR > org.dspace.app.webui.components.RecentSubmissionsManager @ caught > exception: > org.dspace.browse.BrowseException: problem with query: SELECT /*+ > FIRST_ROWS(n) */ rec.*, ROWNUM rnum FROM (SELECT bi_item.* FROM > bi_item, (SELECT communities2item.item_id FROM communities2item > WHERE communities2item.community_id=? ) mappings WHERE > bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC ) rec WHERE > rownum<=? > at org.dspace.browse.BrowseDAOOracle.doQuery(BrowseDAOOracle.java: > 396) > at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198) > > - 2009-09-22 13:38:33,405 ERROR > org.dspace.app.webui.servlet.DSpaceServlet @ caught exception: > org.dspace.plugin.PluginException: > org.dspace.app.webui.components.RecentSubmissionsException: > org.dspace.browse.BrowseException: problem with query: SELECT /*+ > FIRST_ROWS(n) */ rec.*, ROWNUM rnum FROM (SELECT bi_item.* FROM > bi_item, (SELECT communities2item.item_id FROM communities2item > WHERE communities2item.community_id=? ) mappings WHERE > bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC ) rec WHERE > rownum<=? > at > org.dspace.app.webui.components.RecentCommunitySubmissions.process > (RecentCommunitySubmissions.java:85) > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart > your > developing skills, take BlackBerry mobile applications to market and > stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
