You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com> on 2007/04/02 16:38:16 UTC

Cannot delete project

Hi, I am trying to delete a project from the Continuum Web-App GUI, and
I receive the following error.  What may I do to solve this?  Thanks.
ognl.MethodFailedException: Method "removeProject" failed for object
org.apache.maven.continuum.DefaultContinuum@xxxxx
[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 (395). The statement
has been rolled back.] at
ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at 


This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]

RE: Cannot delete project

Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Could you please tell me how to access this table?

Here is what I see when I open the client:

APP
NULLID
SQLJ
...
SYSSTAT

Which Object should I select to reach the relevant tables?  Thanks. 

-----Original Message-----
From: Wayne Fay [mailto:waynefay@gmail.com] 
Sent: Monday, April 02, 2007 11:22 AM
To: continuum-users@maven.apache.org
Subject: Re: Cannot delete project

I would probably just connect directly to the database using Squirrel
and delete the offending records. And if/when you hit FK errors, go
into each FK table in turn and delete the related row(s), etc.

Someone else might have other advice, but this is what I'd probably do
in this situation.

Wayne

On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> I just tried this, and I have an empty set of goals now.  However, I
am
> still unable to delete the project.  Is there anything else I may do?
> Thanks.
>
> -----Original Message-----
> From: Wayne Fay [mailto:waynefay@gmail.com]
> Sent: Monday, April 02, 2007 11:01 AM
> To: continuum-users@maven.apache.org
> Subject: Re: Cannot delete project
>
> Quoting Emmanuel from a previous thread:
>
> "It's a known bug in 1.0.3 that appear sometimes. If you remove first
> build definitions on your projects, you'll can after remove your
> projects."
>
> Wayne
>
> On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
> <am...@deloitte.com> wrote:
> > Hi, I am trying to delete a project from the Continuum Web-App GUI,
> and
> > I receive the following error.  What may I do to solve this?
Thanks.
> > ognl.MethodFailedException: Method "removeProject" failed for object
> > org.apache.maven.continuum.DefaultContinuum@xxxxx
> > [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 (395). The
> statement
> > has been rolled back.] at
> > ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at
> >
> >
> > This message (including any attachments) contains confidential
> information intended for a specific individual and purpose, and is
> protected by law.  If you are not the intended recipient, you should
> delete this message.
> >
> >
> > Any disclosure, copying, or distribution of this message, or the
> taking of any action based on it, is strictly prohibited. [v.E.1]
> >
>

RE: Cannot delete project

Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
Thanks, I will try this. 

-----Original Message-----
From: Wayne Fay [mailto:waynefay@gmail.com] 
Sent: Monday, April 02, 2007 11:22 AM
To: continuum-users@maven.apache.org
Subject: Re: Cannot delete project

I would probably just connect directly to the database using Squirrel
and delete the offending records. And if/when you hit FK errors, go
into each FK table in turn and delete the related row(s), etc.

Someone else might have other advice, but this is what I'd probably do
in this situation.

Wayne

On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> I just tried this, and I have an empty set of goals now.  However, I
am
> still unable to delete the project.  Is there anything else I may do?
> Thanks.
>
> -----Original Message-----
> From: Wayne Fay [mailto:waynefay@gmail.com]
> Sent: Monday, April 02, 2007 11:01 AM
> To: continuum-users@maven.apache.org
> Subject: Re: Cannot delete project
>
> Quoting Emmanuel from a previous thread:
>
> "It's a known bug in 1.0.3 that appear sometimes. If you remove first
> build definitions on your projects, you'll can after remove your
> projects."
>
> Wayne
>
> On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
> <am...@deloitte.com> wrote:
> > Hi, I am trying to delete a project from the Continuum Web-App GUI,
> and
> > I receive the following error.  What may I do to solve this?
Thanks.
> > ognl.MethodFailedException: Method "removeProject" failed for object
> > org.apache.maven.continuum.DefaultContinuum@xxxxx
> > [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 (395). The
> statement
> > has been rolled back.] at
> > ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at
> >
> >
> > This message (including any attachments) contains confidential
> information intended for a specific individual and purpose, and is
> protected by law.  If you are not the intended recipient, you should
> delete this message.
> >
> >
> > Any disclosure, copying, or distribution of this message, or the
> taking of any action based on it, is strictly prohibited. [v.E.1]
> >
>

Re: Cannot delete project

Posted by Wayne Fay <wa...@gmail.com>.
I would probably just connect directly to the database using Squirrel
and delete the offending records. And if/when you hit FK errors, go
into each FK table in turn and delete the related row(s), etc.

Someone else might have other advice, but this is what I'd probably do
in this situation.

Wayne

On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> I just tried this, and I have an empty set of goals now.  However, I am
> still unable to delete the project.  Is there anything else I may do?
> Thanks.
>
> -----Original Message-----
> From: Wayne Fay [mailto:waynefay@gmail.com]
> Sent: Monday, April 02, 2007 11:01 AM
> To: continuum-users@maven.apache.org
> Subject: Re: Cannot delete project
>
> Quoting Emmanuel from a previous thread:
>
> "It's a known bug in 1.0.3 that appear sometimes. If you remove first
> build definitions on your projects, you'll can after remove your
> projects."
>
> Wayne
>
> On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
> <am...@deloitte.com> wrote:
> > Hi, I am trying to delete a project from the Continuum Web-App GUI,
> and
> > I receive the following error.  What may I do to solve this?  Thanks.
> > ognl.MethodFailedException: Method "removeProject" failed for object
> > org.apache.maven.continuum.DefaultContinuum@xxxxx
> > [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 (395). The
> statement
> > has been rolled back.] at
> > ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at
> >
> >
> > This message (including any attachments) contains confidential
> information intended for a specific individual and purpose, and is
> protected by law.  If you are not the intended recipient, you should
> delete this message.
> >
> >
> > Any disclosure, copying, or distribution of this message, or the
> taking of any action based on it, is strictly prohibited. [v.E.1]
> >
>

RE: Cannot delete project

Posted by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com>.
I just tried this, and I have an empty set of goals now.  However, I am
still unable to delete the project.  Is there anything else I may do?
Thanks. 

-----Original Message-----
From: Wayne Fay [mailto:waynefay@gmail.com] 
Sent: Monday, April 02, 2007 11:01 AM
To: continuum-users@maven.apache.org
Subject: Re: Cannot delete project

Quoting Emmanuel from a previous thread:

"It's a known bug in 1.0.3 that appear sometimes. If you remove first
build definitions on your projects, you'll can after remove your
projects."

Wayne

On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Hi, I am trying to delete a project from the Continuum Web-App GUI,
and
> I receive the following error.  What may I do to solve this?  Thanks.
> ognl.MethodFailedException: Method "removeProject" failed for object
> org.apache.maven.continuum.DefaultContinuum@xxxxx
> [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 (395). The
statement
> has been rolled back.] at
> ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at
>
>
> This message (including any attachments) contains confidential
information intended for a specific individual and purpose, and is
protected by law.  If you are not the intended recipient, you should
delete this message.
>
>
> Any disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited. [v.E.1]
>

Re: Cannot delete project

Posted by Wayne Fay <wa...@gmail.com>.
Quoting Emmanuel from a previous thread:

"It's a known bug in 1.0.3 that appear sometimes. If you remove first
build definitions on your projects, you'll can after remove your
projects."

Wayne

On 4/2/07, Morgovsky, Alexander (US - Glen Mills)
<am...@deloitte.com> wrote:
> Hi, I am trying to delete a project from the Continuum Web-App GUI, and
> I receive the following error.  What may I do to solve this?  Thanks.
> ognl.MethodFailedException: Method "removeProject" failed for object
> org.apache.maven.continuum.DefaultContinuum@xxxxx
> [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 (395). The statement
> has been rolled back.] at
> ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:796) at
>
>
> This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message.
>
>
> Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]
>