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 @ [email protected]: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
