Advertisement
mugs

identifier 'KULUSERMAINT.KULUSER_MAINT_PK' must be declared

Mar 19th, 2015
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 6.66 KB | None | 0 0
  1. refresh-rice-db:
  2.      [echo]
  3.      [echo] Importing Rice tables into the database using the information shown below:
  4.      [echo]
  5.      [echo] DB Driver = oracle.jdbc.OracleDriver
  6.      [echo] DB URL    = jdbc:oracle:thin:@localhost:1521:XE
  7.      [echo] Username  = kfs_za
  8.      [echo] Password  = ${rice.server.datasource.password} (not shown)
  9.      [echo]
  10.      [echo] DB Admin URL   = jdbc:oracle:thin:@localhost:1521:XE   (used for creating/recreating schema/user)
  11.      [echo] Admin Username = kuluser_admin
  12.      [echo] Admin Password = ${rice.server.impex.admin.password} (not shown)
  13.      [echo]        
  14.      [java] Buildfile: /home/mugo/dev/opencollab/kfs-core-za/work/db/kfs-db/db-impex/impex/build.xml
  15.      [java]
  16.      [java] inittasks:
  17.      [java]
  18.      [java] drop-schema:
  19.      [java]
  20.      [java] inittasks:
  21.      [java]
  22.      [java] oracle-drop-schema:
  23.      [java]      [echo] DECLARE temp NUMBER; BEGIN temp := kulusermaint.kuluser_maint_pk.drop_user( 'kfs_za' ); END;
  24.      [java]       [sql] Executing commands
  25.      [java]       [sql] Failed to execute:  DECLARE temp NUMBER; BEGIN temp := kulusermaint.kuluser_maint_pk.drop_user( 'kfs_za' ); END;
  26.      [java]
  27.      [java] BUILD FAILED
  28.      [java] /home/mugo/dev/opencollab/kfs-core-za/work/db/kfs-db/db-impex/impex/build.xml:520: The following error occurred while executing this line:
  29.      [java] /home/mugo/dev/opencollab/kfs-core-za/work/db/kfs-db/db-impex/impex/build.xml:546: The following error occurred while executing this line:
  30.      [java] /home/mugo/dev/opencollab/kfs-core-za/work/db/kfs-db/db-impex/impex/build.xml:479: java.sql.SQLException: ORA-06550: line 1, column 36:
  31.      [java] PLS-00201: identifier 'KULUSERMAINT.KULUSER_MAINT_PK' must be declared
  32.      [java] ORA-06550: line 1, column 28:
  33.      [java] PL/SQL: Statement ignored
  34.      [java]
  35.      [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  36.      [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
  37.      [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
  38.      [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
  39.      [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
  40.      [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
  41.      [java]     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
  42.      [java]     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
  43.      [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
  44.      [java]     at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)
  45.      [java]     at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)
  46.      [java]     at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
  47.      [java]     at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:773)
  48.      [java]     at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:749)
  49.      [java]     at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1041)
  50.      [java]     at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:983)
  51.      [java]     at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:651)
  52.      [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
  53.      [java]     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  54.      [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  55.      [java]     at java.lang.reflect.Method.invoke(Method.java:606)
  56.      [java]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  57.      [java]     at org.apache.tools.ant.Task.perform(Task.java:348)
  58.      [java]     at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)
  59.      [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
  60.      [java]     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  61.      [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  62.      [java]     at java.lang.reflect.Method.invoke(Method.java:606)
  63.      [java]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  64.      [java]     at org.apache.tools.ant.Task.perform(Task.java:348)
  65.      [java]     at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396)
  66.      [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
  67.      [java]     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  68.      [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  69.      [java]     at java.lang.reflect.Method.invoke(Method.java:606)
  70.      [java]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  71.      [java]     at org.apache.tools.ant.Task.perform(Task.java:348)
  72.      [java]     at org.apache.tools.ant.Target.execute(Target.java:435)
  73.      [java]     at org.apache.tools.ant.Target.performTasks(Target.java:456)
  74.      [java]     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
  75.      [java]     at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
  76.      [java]     at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
  77.      [java]     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:440)
  78.      [java]     at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
  79.      [java]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
  80.      [java]     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  81.      [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  82.      [java]     at java.lang.reflect.Method.invoke(Method.java:606)
  83.      [java]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  84.      [java]     at org.apache.tools.ant.Task.perform(Task.java:348)
  85.      [java]     at org.apache.tools.ant.Target.execute(Target.java:435)
  86.      [java]     at org.apache.tools.ant.Target.performTasks(Target.java:456)
  87.      [java]     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
  88.      [java]     at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
  89.      [java]     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  90.      [java]     at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
  91.      [java]     at org.apache.tools.ant.Main.runBuild(Main.java:851)
  92.      [java]     at org.apache.tools.ant.Main.startAnt(Main.java:235)
  93.      [java]     at org.apache.tools.ant.Main.start(Main.java:198)
  94.      [java]     at org.apache.tools.ant.Main.main(Main.java:286)
  95.      [java]
  96.      [java] Total time: 2 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement