Hi,
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
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
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.
Can anyone help get rid of this error? 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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
