You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@maven.apache.org by qwerty <le...@live.com> on 2013/09/17 05:16:54 UTC

[help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]

Hi!

In the tutorial of kuali rice the 3rd step was:
mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword] 

I got this errors:
[INFO]
------------------------------------------------------------------------
[INFO] JDBC Connection Information
[INFO]
------------------------------------------------------------------------
[INFO] URL: jdbc:mysql://localhost/rice
[INFO] Username: RICE
[INFO] Password: ****
[INFO] Driver: com.mysql.jdbc.Driver
[INFO]
------------------------------------------------------------------------
[INFO] Executing rice-impex-master.sql .........[ERROR] Failed to execute: 
CREATE VIEW KRIM_GRP_MBR_V AS 
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm


 
 



Table 'rice.krim_grp_t' doesn't exist

[ERROR] Failed to execute: 
CREATE VIEW KRIM_GRP_MBR_V AS 
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm


 
 



Table 'rice.krim_grp_t' doesn't exist
[INFO]
------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO] 
[INFO] Rice DB ........................................... SUCCESS [1.170s]
[INFO] Rice Sql .......................................... SUCCESS [1.130s]
[INFO] Rice Impex ........................................ SUCCESS [0.787s]
[INFO] Rice Impex Master ................................. FAILURE [44.893s]
[INFO] Rice Impex Server ................................. SKIPPED
[INFO] Rice Impex Server Demo ............................ SKIPPED
[INFO] Rice Impex Server Bootstrap ....................... SKIPPED
[INFO] Rice Impex Client ................................. SKIPPED
[INFO] Rice Impex Client Demo ............................ SKIPPED
[INFO] Rice Impex Client Bootstrap ....................... SKIPPED
[INFO]
------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 49.909s
[INFO] Finished at: Tue Sep 17 11:14:39 PHT 2013
[INFO] Final Memory: 33M/366M
[INFO]
------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL: Table 'rice.krim_grp_t'
doesn't exist -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:217)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
	at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
	at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
	at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
	at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
	at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing
SQL
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExecutorMojo.java:353)
	at org.apache.torque.mojo.BaseMojo.execute(BaseMojo.java:110)
	at
org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
	... 19 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'rice.krim_grp_t' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at org.kuali.db.SQLExecutor.execSQL(SQLExecutor.java:249)
	at org.kuali.db.SQLExecutor.runStatements(SQLExecutor.java:346)
	at org.kuali.db.SQLExecutor.runTransaction(SQLExecutor.java:220)
	at org.kuali.db.SQLExecutor.execute(SQLExecutor.java:190)
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExecutorMojo.java:351)
	... 22 more
[ERROR] 
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please
read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the
command
[ERROR]   mvn <goals> -rf :rice-impex-master

Please help me
Thanks in advance :)



--
View this message in context: http://maven.40175.n5.nabble.com/help-mvn-clean-install-Pdb-mysql-Dimpex-dba-password-dbapassword-tp5770840.html
Sent from the Maven - Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org

Re: [help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]

Posted by Wayne Fay <wa...@gmail.com>.
On Tue, Sep 17, 2013 at 6:59 AM, qwerty <le...@live.com> wrote:
> thank i'll just send it in kuali

For future reference, this is *always* the right first step. Contact
Maven Users only *after* working with "kuali" to ensure it is, in
fact, a Maven issue and not something specific to their application
which they know about and can help you to resolve.

Wayne

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org

RE: [help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]

Posted by qwerty <le...@live.com>.
thank i'll just send it in kuali



--
View this message in context: http://maven.40175.n5.nabble.com/help-mvn-clean-install-Pdb-mysql-Dimpex-dba-password-dbapassword-tp5770840p5770842.html
Sent from the Maven - Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org

RE: [help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]

Posted by Richard Sand <rs...@idfconnect.com>.
You're getting a database error, not a maven error. You're going to need
to pose your question to a kuali forum to get the help you need.

The specific error you're seeing is because a sql script is trying to
create a view based on a table that doesn't exist. Since the earlier
scripts succeeded I'd suspect something is wrong with the scripts
themselves or the install procedure.

HTH,

Richard

-----Original Message-----
From: qwerty [mailto:leire_4713@live.com]
Sent: Monday, September 16, 2013 11:17 PM
To: users@maven.apache.org
Subject: [help]mvn clean install -Pdb,mysql
-Dimpex.dba.password=[dbapassword]

Hi!

In the tutorial of kuali rice the 3rd step was:
mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]

I got this errors:
[INFO]
------------------------------------------------------------------------
[INFO] JDBC Connection Information
[INFO]
------------------------------------------------------------------------
[INFO] URL: jdbc:mysql://localhost/rice
[INFO] Username: RICE
[INFO] Password: ****
[INFO] Driver: com.mysql.jdbc.Driver
[INFO]
------------------------------------------------------------------------
[INFO] Executing rice-impex-master.sql .........[ERROR] Failed to execute:

CREATE VIEW KRIM_GRP_MBR_V AS
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm







Table 'rice.krim_grp_t' doesn't exist

[ERROR] Failed to execute:
CREATE VIEW KRIM_GRP_MBR_V AS
SELECT g.NMSPC_CD
, g.grp_nm
, g.GRP_ID
, p.PRNCPL_NM
, p.PRNCPL_ID
, mg.GRP_NM AS mbr_grp_nm
, mg.GRP_ID AS mbr_grp_id
FROM KRIM_GRP_MBR_T gm
LEFT JOIN krim_grp_t g
ON g.GRP_ID = gm.GRP_ID
LEFT OUTER JOIN krim_grp_t mg
ON mg.GRP_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'G'
LEFT OUTER JOIN krim_prncpl_t p
ON p.PRNCPL_ID = gm.MBR_ID
AND gm.MBR_TYP_CD = 'P'
LEFT OUTER JOIN krim_entity_nm_t en
ON en.ENTITY_ID = p.ENTITY_ID
AND en.DFLT_IND = 'Y'
AND en.ACTV_IND = 'Y'
ORDER BY nmspc_cd, grp_nm, prncpl_nm







Table 'rice.krim_grp_t' doesn't exist
[INFO]
------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Rice DB ........................................... SUCCESS
[1.170s]
[INFO] Rice Sql .......................................... SUCCESS
[1.130s]
[INFO] Rice Impex ........................................ SUCCESS
[0.787s]
[INFO] Rice Impex Master ................................. FAILURE
[44.893s]
[INFO] Rice Impex Server ................................. SKIPPED
[INFO] Rice Impex Server Demo ............................ SKIPPED
[INFO] Rice Impex Server Bootstrap ....................... SKIPPED
[INFO] Rice Impex Client ................................. SKIPPED
[INFO] Rice Impex Client Demo ............................ SKIPPED
[INFO] Rice Impex Client Bootstrap ....................... SKIPPED
[INFO]
------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 49.909s
[INFO] Finished at: Tue Sep 17 11:14:39 PHT 2013
[INFO] Final Memory: 33M/366M
[INFO]
------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL: Table 'rice.krim_grp_t'
doesn't exist -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.kuali.maven.plugins:maven-impex-plugin:1.1.14:import (install) on
project rice-impex-master: Error executing SQL
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java
:217)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java
:153)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java
:145)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(Li
fecycleModuleBuilder.java:84)
	at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(Li
fecycleModuleBuilder.java:59)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(L
ifecycleStarter.java:183)
	at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStar
ter.java:161)
	at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
	at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
	at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
	at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
	at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.
java:290)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230
)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launche
r.java:409)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing
SQL
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExec
utorMojo.java:353)
	at org.apache.torque.mojo.BaseMojo.execute(BaseMojo.java:110)
	at
org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuild
PluginManager.java:101)
	at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java
:209)
	... 19 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table
'rice.krim_grp_t' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc
essorImpl.java:57)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr
uctorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at org.kuali.db.SQLExecutor.execSQL(SQLExecutor.java:249)
	at org.kuali.db.SQLExecutor.runStatements(SQLExecutor.java:346)
	at org.kuali.db.SQLExecutor.runTransaction(SQLExecutor.java:220)
	at org.kuali.db.SQLExecutor.execute(SQLExecutor.java:190)
	at
org.apache.torque.mojo.AbstractSQLExecutorMojo.executeMojo(AbstractSQLExec
utorMojo.java:351)
	... 22 more
[ERROR]
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions,
please
read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the
command
[ERROR]   mvn <goals> -rf :rice-impex-master

Please help me
Thanks in advance :)



--
View this message in context:
http://maven.40175.n5.nabble.com/help-mvn-clean-install-Pdb-mysql-Dimpex-d
ba-password-dbapassword-tp5770840.html
Sent from the Maven - Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org