We had a problem similar to this as well and were able to delete them by shutting down Continuum and going into the build directory folder and deleting the projects from there, then they would remove from the GUI. FYI, Our problem occurred because I refreshed the page before the projects were all completely added, at least that's how I was able to re-create it.
On 5/13/06, Wayne Fay <[EMAIL PROTECTED]> wrote:
Based on the error below, it looks like the deletes aren't cascading properly. You could probably log in to the database and blow away individual projects if you dug around and figured out how tables and foreign keys are linked up. This seems to be a bug, I'd file it in JIRA. "Delete a project" was just not tested enough before release, apparently. Wayne On 5/13/06, Brian E. Fox <[EMAIL PROTECTED]> wrote: > Somehow I have a bunch of projects that got duplicated but I can't > remove them. Here's the error, is there anything I can do other than > blow away the db and start over? > > ognl.MethodFailedException: Method "removeProject" failed for object > [EMAIL PROTECTED] > [javax.jdo.JDOUserException: One or more instances could not be deleted > NestedThrowables: > javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM > BUILDDEFINITION WHERE ID = ? > NestedThrowables: > SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of > foreign key constraint 'PROJECT_BUILP8_FK2' for key (86). The statement > has been rolled back.]
-- Adam Altemus
