maven-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Sand <rs...@idfconnect.com>
Subject RE: [help]mvn clean install -Pdb,mysql -Dimpex.dba.password=[dbapassword]
Date Tue, 17 Sep 2013 04:49:01 GMT
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


Mime
View raw message