Thanks for your reply Tim. I re-ran index-init which fixed the problem with searching for Subjects and Types.
However, I'm getting the same error (looking for the cwf_ table) when attempting to remove groups from the workflow section when assigning roles to collections. Having added manually, the cwf_collectionrole table, I started getting a nullpointerexception. After removing it again (on your advice) I now get the 'table does not exist' error. I've checked the xmlui.xconf file and it seems fine but will turn on debugging and see if that throws anything up. It is also possible that I have missed something in the install (although I don't think I did) but I'm now due to start updating another of our test dspace installs to 1.8 so I'll see if the problem comes up again. We plan to merge our 3 dspace installations into one. Best regards 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: Tim Donohue [mailto:[email protected]] Sent: 03 April 2012 20:51 To: Wellaway, Ian Cc: [email protected] Subject: Re: [Dspace-tech] Oracle DB error in Dspace 1.8.2 when searching by Subjects or Typev 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#Confi > gurableWorkflow-cwfcollectionrole > <https://wiki.duraspace.org/display/DSDOC18/Configurable+Workflow#Conf > igurableWorkflow-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
