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

Oracle Community | user1116922 | 4 years ago
  1. 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
  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

    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
  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-06550: line 21, column 7: PLS-00905: object OWF_MGR.WF_QUEUE is invalid ORA-06550: line 21, column 7: PL/SQL: Statement ignored

      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. oracle.apps.fnd
      WfFrame.actionPerformed
      1. oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.execute(SQLProcessor.java:955)
      2. oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.processLine(SQLProcessor.java:2046)
      3. oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.executeSQLFile(SQLProcessor.java:2298)
      4. oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.runSQLFile(SQLProcessor.java:359)
      5. oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.runSQLFile(SQLProcessor.java:329)
      6. oracle.apps.fnd.wf.install.db.WorkflowCA.handleSQL(WorkflowCA.java:5551)
      7. oracle.apps.fnd.wf.install.db.WorkflowCA.executeProcess(WorkflowCA.java:3502)
      8. oracle.apps.fnd.wf.install.db.WorkflowCA.schemaCreation(WorkflowCA.java:2123)
      9. oracle.apps.fnd.wf.install.db.WfFrame.actionPerformed(WfFrame.java:2051)
      9 frames
    4. oracle.ewt.button
      PushButton.processActionEvent
      1. oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
      1 frame
    5. oracle.ewt.lwAWT
      LWButton.processActionEvent
      1. oracle.ewt.lwAWT.LWButton.processActionEvent(Unknown Source)
      1 frame
    6. oracle.ewt.button
      PushButton.processEventImpl
      1. oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
      1 frame
    7. oracle.ewt.lwAWT
      LWComponent.processEvent
      1. oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
      2. oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
      2 frames
    8. oracle.ewt.button
      PushButton.activate
      1. oracle.ewt.button.PushButton.activate(Unknown Source)
      1 frame
    9. oracle.ewt.lwAWT
      AbstractButton.processMouseEvent
      1. oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
      2. oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
      2 frames
    10. Java RT
      Container.processEvent
      1. java.awt.Component.processEvent(Component.java:5282)
      2. java.awt.Container.processEvent(Container.java:1966)
      2 frames
    11. oracle.ewt.lwAWT
      LWComponent.processEventImpl
      1. oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
      1 frame
    12. oracle.ewt.button
      PushButton.processEventImpl
      1. oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
      1 frame
    13. oracle.ewt.lwAWT
      LWComponent.processEvent
      1. oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
      2. oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
      2 frames
    14. Java RT
      EventDispatchThread.run
      1. java.awt.Component.dispatchEventImpl(Component.java:3984)
      2. java.awt.Container.dispatchEventImpl(Container.java:2024)
      3. java.awt.Component.dispatchEvent(Component.java:3819)
      4. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
      5. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
      6. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
      7. java.awt.Container.dispatchEventImpl(Container.java:2010)
      8. java.awt.Window.dispatchEventImpl(Window.java:1791)
      9. java.awt.Component.dispatchEvent(Component.java:3819)
      10. java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
      11. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      12. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      13. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
      14. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
      15. java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
      15 frames