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:[email protected]] Sent: Monday, September 16, 2013 11:17 PM To: [email protected] 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
