Hi Sean, Thanks for your reply.
I did run the update scripts. Part of our upgrading process was to switch from Postgres to Oracle (should have mentioned this) which I have down and I ran the scripts accordingly. There is no mention of a cwf_collectionrole in the upgrade scripts (1.6-1.7 and 1.7-1.8) but only in the xmlworkflow scripts. Even then, there is no sql to create the cwf_collectionrole table in oracle, only in postgres. Could this be an oversight do you think? Thanks Ian ------------ Ian Wellaway Senior System Support & Development Officer - Academic Systems (Room 911) Wednesdays only & Technical Developer, Open Exeter - Infrastructure Systems (Room 54) Monday - Tuesday, Thursday - Friday Exeter IT Laver Building University of Exeter EX4 4QE UK tel +44 1392 722852 -----Original Message----- From: Sean Carte [mailto:[email protected]] Sent: 26 March 2012 10:37 To: [email protected] Subject: Re: [Dspace-tech] Error with workflow in DSpace 1.8.2 On 26 March 2012 11:05, Wellaway, Ian <[email protected]> wrote: > After updating from 1.6.2 to 1.8.2, I get the following error when > attempting to remove a group from any of the three workflow roles when > editing a collection (Accept/Reject, Accept/Reject/Edit Metadata Step, > Edit Metadata Step): > > > > java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not > exist During your upgrades, did you update your database for each version? e.g.: 8. Update the Database. You will need to run the 1.6.x to 1.7.x database upgrade script. For PostgreSQL: psql -U [dspace-user] -f [dspace-source]/dspace/etc/postgres/database_schema_16-17.sql [database name] (Your database name is by default 'dspace'). Example: psql -U dspace -f [dspace-source]/dspace/etc/postgres/database_schema_16-17.sql dspace For Oracle: Execute the upgrade script, e.g. with sqlplus, recording the output: 1. Start SQL*Plus with sqlplus [connect args] 2. Record the output: SQL> spool 'upgrade.lst' 3. Run the upgrade script SQL> @[dspace-source]/dspace/etc/oracle/database_schema_16-17.sql 4. Turn off recording of output: SQL> spool off 9. Generate Browse and Search Indexes. It's always good policy Sean -- Sean Carte esAL Library Systems Manager +27 72 898 8775 +27 31 373 2490 fax: 0866741254 http://esal.dut.ac.za/ ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
