Advertisement
mugs

liquibase - cannot insert NULL

May 25th, 2015
287
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.85 KB | None | 0 0
  1. SEVERE 5/25/15 4:09 PM: liquibase: liquibase/rice/master.xml: liquibase/rice/security.xml::NWUKFS-313::za-kfs: Change Set liquibase/rice/security.xml::NWUKFS-313::za-kfs failed.  Error: Error executing SQL INSERT INTO krim_role_mbr_t (role_mbr_id, role_id, mbr_id, mbr_typ_cd, ver_nbr, obj_id) VALUES (KRIM_ROLE_MBR_ID_S.NEXTVAL, (select ROLE_ID from KRIM_ROLE_T where ROLE_NM = 'Financial Journal Reviewer' and NMSPC_CD = 'KFS-SYS'), (select PRNCPL_ID from KRIM_PRNCPL_T where PRNCPL_NM = '10594620'), 'P', 1, '5a3c7159-c9d9-4591-b2c1-b839355960a0'): ORA-01400: cannot insert NULL into ("KULDEV_NWU"."KRIM_ROLE_MBR_T"."MBR_ID")
  2.  
  3. liquibase.exception.DatabaseException: Error executing SQL INSERT INTO krim_role_mbr_t (role_mbr_id, role_id, mbr_id, mbr_typ_cd, ver_nbr, obj_id) VALUES (KRIM_ROLE_MBR_ID_S.NEXTVAL, (select ROLE_ID from KRIM_ROLE_T where ROLE_NM = 'Financial Journal Reviewer' and NMSPC_CD = 'KFS-SYS'), (select PRNCPL_ID from KRIM_PRNCPL_T where PRNCPL_NM = '10594620'), 'P', 1, '5a3c7159-c9d9-4591-b2c1-b839355960a0'): ORA-01400: cannot insert NULL into ("KULDEV_NWU"."KRIM_ROLE_MBR_T"."MBR_ID")
  4.  
  5.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  6.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  7.     at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)
  8.     at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1189)
  9.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:518)
  10.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
  11.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:70)
  12.     at liquibase.Liquibase.update(Liquibase.java:195)
  13.     at liquibase.Liquibase.update(Liquibase.java:174)
  14.     at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:31)
  15.     at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:24)
  16.     at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:367)
  17.     at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
  18.     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
  19.     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
  20.     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
  21.     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
  22.     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
  23.     at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
  24.     at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
  25.     at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
  26.     at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
  27.     at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
  28.     at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
  29.     at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
  30.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  31.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  32.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  33.     at java.lang.reflect.Method.invoke(Method.java:606)
  34.     at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
  35.     at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
  36.     at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
  37.     at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
  38. Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KULDEV_NWU"."KRIM_ROLE_MBR_T"."MBR_ID")
  39.  
  40.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  41.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  42.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  43.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  44.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  45.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  46.     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  47.     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
  48.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  49.     at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
  50.     at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
  51.     at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
  52.     at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:310)
  53.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  54.     ... 32 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement