liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist

JIRA | Damian Golda | 7 years ago
  1. 0

    OracleSampleChangeLogRunnerTest.testRunChangeLog (and others) throws: liquibase.exception.MigrationFailedException: Migration failed for change set changelogs/common/schema.tests.changelog.xml::13::nvoxland: Reason: liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist at liquibase.changelog.ChangeSet.execute(ChangeSet.java:235) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:25) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.runCompleteChangeLog(AbstractSimpleChangeLogRunnerTest.java:128) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRunChangeLog(AbstractSimpleChangeLogRunnerTest.java:118) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2 at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:58) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:88) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:894) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:881) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:211) ... 24 more Caused by: java.sql.SQLException: ORA-01418: specified index does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645) at liquibase.executor.core.jdbc.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:79) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:51) ... 28 more I can't find the reason...

    JIRA | 7 years ago | Damian Golda
    liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist
  2. 0

    OracleSampleChangeLogRunnerTest.testRunChangeLog (and others) throws: liquibase.exception.MigrationFailedException: Migration failed for change set changelogs/common/schema.tests.changelog.xml::13::nvoxland: Reason: liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist at liquibase.changelog.ChangeSet.execute(ChangeSet.java:235) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:25) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.runCompleteChangeLog(AbstractSimpleChangeLogRunnerTest.java:128) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRunChangeLog(AbstractSimpleChangeLogRunnerTest.java:118) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2 at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:58) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:88) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:894) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:881) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:211) ... 24 more Caused by: java.sql.SQLException: ORA-01418: specified index does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645) at liquibase.executor.core.jdbc.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:79) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:51) ... 28 more I can't find the reason...

    JIRA | 7 years ago | Damian Golda
    liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist
  3. 0

    getting error while Installing Oracle Warehouse Builder Workflow

    Oracle Community | 4 years ago | user1116922
    java.sql.SQLException: ORA-06550: line 21, column 7: PLS-00905: object OWF_MGR.WF_QUEUE is invalid ORA-06550: line 21, column 7: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    activiti + oracle db | Activiti Forums

    activiti.org | 4 months ago
    java.sql.SQLException: ORA-00955: name is already used by an existing object  
  6. 0

    JDBC connect string and Oracle synonyms

    Stack Overflow | 6 years ago | javaExpert
    java.sql.SQLException: ORA-00942: table or view does not exist

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01418: specified index does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.execute
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
      8. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679)
      9. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)
      9 frames
    3. liquibase.executor.core
      JdbcExecutor.execute
      1. liquibase.executor.core.jdbc.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:79)
      2. liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:51)
      3. liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:88)
      3 frames
    4. Liquibase Core
      Liquibase.update
      1. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:894)
      2. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:881)
      3. liquibase.changelog.ChangeSet.execute(ChangeSet.java:211)
      4. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:25)
      5. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39)
      6. liquibase.Liquibase.update(Liquibase.java:112)
      6 frames
    5. liquibase.dbtest
      AbstractSimpleChangeLogRunnerTest.testRunChangeLog
      1. liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.runCompleteChangeLog(AbstractSimpleChangeLogRunnerTest.java:128)
      2. liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRunChangeLog(AbstractSimpleChangeLogRunnerTest.java:118)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. JUnit
      OldTestClassRunner.run
      1. junit.framework.TestCase.runTest(TestCase.java:164)
      2. junit.framework.TestCase.runBare(TestCase.java:130)
      3. junit.framework.TestResult$1.protect(TestResult.java:110)
      4. junit.framework.TestResult.runProtected(TestResult.java:128)
      5. junit.framework.TestResult.run(TestResult.java:113)
      6. junit.framework.TestCase.run(TestCase.java:120)
      7. junit.framework.TestSuite.runTest(TestSuite.java:228)
      8. junit.framework.TestSuite.run(TestSuite.java:223)
      9. org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
      9 frames
    8. JUnit4 Runner
      JUnit4TestReference.run
      1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
      1 frame
    9. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
      5 frames