Hi Ian, The only thing I can think of is that you've somehow enabled the "Configurable Reviewer Workflow" in DSpace 1.8, even though it sounds like you didn't mean to.
By default, DSpace 1.8 ships with the "Configurable Reviewer Workflow" feature disabled. So, you have to manually go in and enable it as described here: https://wiki.duraspace.org/display/DSDOC18/Configurable+Workflow#ConfigurableWorkflow-InstructionsforEnablingConfigurableReviewerWorkflowinXMLUI So, if you check your xmlui.xconf file, you should make sure that the "XMLWorkflow" aspect is *commented out*. Instead, you should just use the aspect named "Original Workflow": <aspect name="Original Workflow" path="resource://aspects/Workflow/" /> Let us know if this fixes things. You should not create the "cwf_*" table(s) unless you actually want to use the Configurable Workflow feature. If this doesn't fix things, you may want to look around to see if any other odd errors or messages are appearing in your logs. It could be possible that you accidentally overlooked a step in your upgrade to DSpace 1.8. More info on finding errors in logs (and even turning on debugging) is at: https://wiki.duraspace.org/display/DSPACE/Troubleshoot+an+error - Tim On 3/28/2012 11:01 AM, Wellaway, Ian wrote: > Hieveryone, > > (This is a similar issue to one I posted about a few days ago) > > I’ve just switched one of our test versions of DSpace to Oracle and > upgraded to 1.8.2. I now get the following error when attempting to > search by Subjects or Type: https://eric-dev.exeter.ac.uk/repository: > > java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist > > I looked at this further and found some more information by turning on > Tracing for the database and scanning through the output trace files. > > In the trace output the following was identified... > > The following statement encountered an error during parse: > > SELECT * FROM cwf_collectionrole WHERE collection_id=:"SYS_B_0" AND > role_id= :1 Error encountered: ORA-00942 > > This appears to be attempting to select data from a table that does not > exist. When I looked into the table I came across the following link > which indicates that the table is related to Workflow processes. > > https://wiki.duraspace.org/display/DSDOC18/Configurable+Workflow#ConfigurableWorkflow-cwfcollectionrole > <https://wiki.duraspace.org/display/DSDOC18/Configurable+Workflow#ConfigurableWorkflow-cwfcollectionrole> > > This suggests that the cwf_collectionrole table relates to the new xml > wokflow but I’ve never enabled this, having preferred to stick to the > original workflow. > > Please can anyone help with this? I’m tempted to add the cwf... table to > the db anyway to see what happens. The rest of the site seems to work fine. > > Thanks > > Ian > > PS. Please ignore my previous question regarding a stream corrupted > exception. This appears to be something to do with our tomcat > installation which we are looking at separately. > > ------------ > > 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 > > > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
