java.sql.SQLException: ORA-00955: name is already used by an existing object  

activiti.org | 3 months ago
  1. 0

    activiti + oracle db | Activiti Forums

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

    Error on exporting shapefiles to Oracle database

    GitHub | 3 years ago | sbalasub
    java.sql.SQLException: ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 17 ORA-06512: at "MDSYS.CHK_SDO_DIMNAME", line 11 ORA-04088: error during execution of trigger 'MDSYS.CHK_SDO_DIMNAME' ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 43 ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
  3. 0

    Error setting up sample data for Oracle DB

    symmetricds | 9 years ago | tbahm
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("SYMMETRIC"."SYM_TRIGGER"."TRIGGER_ID")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

    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-00955: name is already used by an existing object  

      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. Commons DBCP
      DelegatingStatement.execute
      1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
      2 frames
    4. Activiti - Engine
      CommandContextInterceptor.execute
      1. org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:1015)
      2. org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:966)
      3. org.activiti.engine.impl.db.DbSqlSession.executeMandatorySchemaResource(DbSqlSession.java:796)
      4. org.activiti.engine.impl.db.DbSqlSession.dbSchemaCreateEngine(DbSqlSession.java:773)
      5. org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:831)
      6. org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1100)
      7. org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
      8. org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
      9. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:60)
      9 frames
    5. Activiti - Spring
      SpringTransactionInterceptor$1.doInTransaction
      1. org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
      1 frame
    6. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
      1 frame
    7. Activiti - Spring
      SpringTransactionInterceptor.execute
      1. org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
      1 frame
    8. Activiti - Engine
      ProcessEngineConfigurationImpl.buildProcessEngine
      1. org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)
      2. org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:75)
      3. org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:311)
      3 frames
    9. Activiti - Spring
      ProcessEngineFactoryBean.getObject
      1. org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:60)
      2. org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)
      3. org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
      3 frames
    10. Spring Beans
      DefaultListableBeanFactory.preInstantiateSingletons
      1. org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
      2. org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
      3. org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
      6. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
      7. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
      8. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
      9. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
      10. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
      11. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
      12. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
      13. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
      14. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
      15. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
      16. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609)
      16 frames
    11. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)
      2 frames
    12. Spring
      ContextLoaderListener.contextInitialized
      1. org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
      2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
      3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
      3 frames
    13. Glassfish Core
      HostConfig$DeployWar.run
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
      2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
      3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      4. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
      5. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
      6. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
      7. org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:977)
      8. org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1655)
      8 frames
    14. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      3. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      5. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      6. java.lang.Thread.run(Thread.java:662)
      6 frames