You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Gary Shea <sh...@gtsdesign.com> on 2004/12/06 23:01:06 UTC

more on the 'Unable to obtain goal [deploy-plugin]' problem

I read a thread on the mailing list that seemed to refer to this
problem, but nothing that seemed like a resolution.

I'm running the latest cvs (as of a couple hours ago anyway), java
1.5.0.

The error occurs in the "Build and deploy the Jetspeed 2 Maven plugin
Jetspeed 2 Maven Plugin" phase of the build.  Here's where it blows:


db.execute:
    [sql] Executing file:
/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/target/classes/plugin-resources/hsql/phase2-schema.sql
    [sql] [ERROR] Failed to execute: drop table PROFILING_RULE if exists

BUILD FAILED
File...... /home/shea/work/dev/itr-portal/jetspeed-2/maven.xml
Element... maven:reactor
Line...... 168
Column.... 40
Unable to obtain goal [deploy-plugin] --
/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/maven.xml:110:39:
<sql> java.sql.SQLException: Integrity constraint violation:
SYS_REF_RULE_CRITERION_FK_1_4 table: RULE_CRITERION in statement [drop
table PROFILING_RULE if exists]
Total time: 7 minutes 7 seconds
Finished at: Mon Dec 06 14:03:43 MST 2004



The sql in question seems inocuous enough; although I've never seen the
'if exists' before, it seemed to work in the previous 10 instances in
that same file.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org


Re: more on the 'Unable to obtain goal [deploy-plugin]' problem

Posted by Gary Shea <sh...@gtsdesign.com>.
I'm still running hsql, haven't tried anything daring like changing the
database.

I've run through 'maven allClean allBuild' a couple of times, and always
get that crash in the plugin.  I'm running maven 1.0.1, java 1.5, cvs
head.

I've assumed the hsql db file is destroyed by allClean but I'll look a
bit closer today.

After the crash in allBuild, quickStart will not run.

    Gary

On Mon, 2004-12-06 at 22:05, Roger Ruttimann wrote: 
> What database are you running?
> 
> With MySQL I run into similar issues and the only resolution was to 
> drop/create the databases (test/production) before I started a build/deploy
> 
> Roger
> 
> Gary Shea wrote:
> 
> >I read a thread on the mailing list that seemed to refer to this
> >problem, but nothing that seemed like a resolution.
> >
> >I'm running the latest cvs (as of a couple hours ago anyway), java
> >1.5.0.
> >
> >The error occurs in the "Build and deploy the Jetspeed 2 Maven plugin
> >Jetspeed 2 Maven Plugin" phase of the build.  Here's where it blows:
> >
> >
> >db.execute:
> >    [sql] Executing file:
> >/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/target/classes/plugin-resources/hsql/phase2-schema.sql
> >    [sql] [ERROR] Failed to execute: drop table PROFILING_RULE if exists
> >
> >BUILD FAILED
> >File...... /home/shea/work/dev/itr-portal/jetspeed-2/maven.xml
> >Element... maven:reactor
> >Line...... 168
> >Column.... 40
> >Unable to obtain goal [deploy-plugin] --
> >/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/maven.xml:110:39:
> ><sql> java.sql.SQLException: Integrity constraint violation:
> >SYS_REF_RULE_CRITERION_FK_1_4 table: RULE_CRITERION in statement [drop
> >table PROFILING_RULE if exists]
> >Total time: 7 minutes 7 seconds
> >Finished at: Mon Dec 06 14:03:43 MST 2004
> >
> >
> >
> >The sql in question seems inocuous enough; although I've never seen the
> >'if exists' before, it seemed to work in the previous 10 instances in
> >that same file.
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
> >
> >
> >  
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org


Re: more on the 'Unable to obtain goal [deploy-plugin]' problem

Posted by Roger Ruttimann <ro...@apache.org>.
What database are you running?

With MySQL I run into similar issues and the only resolution was to 
drop/create the databases (test/production) before I started a build/deploy

Roger

Gary Shea wrote:

>I read a thread on the mailing list that seemed to refer to this
>problem, but nothing that seemed like a resolution.
>
>I'm running the latest cvs (as of a couple hours ago anyway), java
>1.5.0.
>
>The error occurs in the "Build and deploy the Jetspeed 2 Maven plugin
>Jetspeed 2 Maven Plugin" phase of the build.  Here's where it blows:
>
>
>db.execute:
>    [sql] Executing file:
>/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/target/classes/plugin-resources/hsql/phase2-schema.sql
>    [sql] [ERROR] Failed to execute: drop table PROFILING_RULE if exists
>
>BUILD FAILED
>File...... /home/shea/work/dev/itr-portal/jetspeed-2/maven.xml
>Element... maven:reactor
>Line...... 168
>Column.... 40
>Unable to obtain goal [deploy-plugin] --
>/home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/maven.xml:110:39:
><sql> java.sql.SQLException: Integrity constraint violation:
>SYS_REF_RULE_CRITERION_FK_1_4 table: RULE_CRITERION in statement [drop
>table PROFILING_RULE if exists]
>Total time: 7 minutes 7 seconds
>Finished at: Mon Dec 06 14:03:43 MST 2004
>
>
>
>The sql in question seems inocuous enough; although I've never seen the
>'if exists' before, it seemed to work in the previous 10 instances in
>that same file.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org