[Dspace-tech] Unable to create collections in new installation Dspace 1.5.2

[Brouns, Francis]

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 @ f...@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)

[Stuart Lewis]

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

> ------------------------------------------------------------------------------
> 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
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Brouns, Francis]

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:s.l...@auckland.ac.nz]
Verzonden: zondag 11 oktober 2009 10:14
Aan: Brouns, Francis
CC: dspac...@lists.sourceforge.net
Onderwerp: Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2

[Brouns, Francis]

Hi Stuart,

During installation errors occurred while setting up the database (although ANT reports a succesfull build). The tables WorkflowItem and TasklistItem were not created because Oracle tripped over a empty line in the create table statement. After the DBA manually added the tables, the errors below no longer occurred.

Thanks,

Francis


-----Oorspronkelijk bericht-----
Van: Stuart Lewis [mailto:s.l...@auckland.ac.nz]
Verzonden: zondag 11 oktober 2009 10:14
Aan: Brouns, Francis
CC: dspac...@lists.sourceforge.net
Onderwerp: Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2