liquibase.exception.DatabaseException: ORA-01400: cannot insert NULL into ("TRACCAR"."SERVER"."ID") INFO | jvm 1 | 2016/10/16 12:18:15 | WrapperSimpleApp Error: [Failed SQL: INSERT INTO TRACCAR.server (registration, latitude, longitude, zoom) VALUES (1, 0, 0, 0)]

GitHub | gpproton | 2 months ago
  1. 0

    GitHub comment 2440#254041246

    GitHub | 2 months ago | gpproton
    liquibase.exception.DatabaseException: ORA-01400: cannot insert NULL into ("TRACCAR"."SERVER"."ID") INFO | jvm 1 | 2016/10/16 12:18:15 | WrapperSimpleApp Error: [Failed SQL: INSERT INTO TRACCAR.server (registration, latitude, longitude, zoom) VALUES (1, 0, 0, 0)]
  2. 0

    Error in Mirroring site to target sytem in WCS

    Oracle Community | 1 year ago | Sremugaan
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SITESUSER.I1435333282413) violated
  3. 0

    During the migration of Confluence from a server to another server I faced the following errors, and managed to resolve them dropping a table and a sequence. h2. Migration process applied - export full XML backup from source installation + data directory - install confluence on new server - import source backup in new confluence using normal import tool h2. Error / Issue description * After migrating, no plugin would not update (the "update" box is shown and either the progress bar would get stuck or finish correctly, but after a full Confluence stop/start it would show that the plugin is still in the same version). * In the log, I identified 2 oracle errors : ORA-01400 (regarding the table) and ORA-00955 (regarding the sequence associated to this table). * The table identified by ORA-01400 was empty. h2. Solution applied * Look in the logs and identify the Table and it's Sequence (look for ORA-00955 error for the Sequence number) . * Stop confluence * Drop the culprit table & sequence : {noformat} select * from AO_6384AB_FEATURE_METADATA_AO DROP TABLE AO_6384AB_FEATURE_METADATA_AO; DROP SEQUENCE AO_6384AB_FEATURE_M675681913; COMMIT; {noformat} * Start confluence * Check : ** if logs still show the same error ** if Confluence filled correctly the table after the restart ** if plugins update correctly h2. Error logs h3. ERROR : ORA-01400 The culprit table is empty and needs to be reconstructed. {noformat} 2016-03-02 11:25:07,717 ERROR [localhost-startStop-1] [atlassian.event.internal.AsynchronousAbleEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.config.lifecycle.events.ApplicationStartedEvent@407a742d] from the invoker [SingleParameterMethodListenerInvoker{method=public void com.atlassian.confluence.plugins.featurediscovery.PluginModuleEventListener.onApplicationStart(com.atlassian.config.lifecycle.events.ApplicationStartedEvent), listener=com.atlassian.confluence.plugins.featurediscovery.PluginModuleEventListener@1cc7b1ba}] java.lang.RuntimeException: There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options - minor version:1 - major version:12 Driver: - name:Oracle JDBC driver - version:12.1.0.2.0 java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFPROD"."AO_6384AB_FEATURE_METADATA_AO"."ID") at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1$1.run(AsynchronousAbleEventDispatcher.java:48) at com.google.common.util.concurrent.MoreExecutors$SameThreadExecutorService.execute(MoreExecutors.java:253) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:107) at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) at com.atlassian.confluence.event.TimingEventPublisher.publish(TimingEventPublisher.java:73) at com.atlassian.config.lifecycle.DefaultLifecycleManager.startUp(DefaultLifecycleManager.java:43) at com.atlassian.config.lifecycle.LifecycleServletContextListener.contextInitialized(LifecycleServletContextListener.java:17) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: {noformat} And the sequence error : {noformat} 2016-03-03 09:50:30,209 ERROR [active-objects-init-system tenant-0] [net.java.ao.sql] handleUpdateError Exception executing SQL update <CREATE SEQUENCE "AO_6384AB_FEATURE_M675681913" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object {noformat} h2. References this solution was inspired by the following 2 pages : * https://confluence.atlassian.com/confkb/unable-to-install-add-ons-in-upm-due-to-duplicate-key-value-in-ao_6384ab_feature_metadata-table-741999240.html ==> confirmed that I could "safely" delete this table. * https://confluence.atlassian.com/confkb/comments-and-likes-fail-with-internal-server-error-319390100.html ==> confirmed that I could "safely" delete this table, and shown that the "Sequence" also needed to be dropped.

    Atlassian JIRA | 9 months ago | Corentin Mehat
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFPROD"."AO_6384AB_FEATURE_METADATA_AO"."ID")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Changing JBoss BRMS (Drools) to use Oracle 11g: Unable to build package

    Stack Overflow | 4 years ago | ScreamingMage
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DROOLS"."PM_WS_DEFAULT_NAMES"."ID")
  6. 0

    Error While trying to do Full Deployment - cannot insert NULL into ("PROD"."DPS_SEG_LIST"."ASSET_VERSION")

    Oracle Community | 2 years ago | 1023071
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PROD"."DPS_SEG_LIST"."ASSET_VERSION") **** Error Sat May 16 12:29:59 IST 2015 1431759599935 /atg/userprofiling/PersonalizationRepository_production **** Error Sat May 16 12:29:59 IST 2015 1431759599935 /atg/userprofiling/PersonalizationRepository_production

    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.SQLIntegrityConstraintViolationException

      ORA-01400: cannot insert NULL into ("TRACCAR"."SERVER"."ID") INFO | jvm 1 | 2016/10/16 12:18:15 | WrapperSimpleApp Error:

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
      9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
      10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
      11. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
      12. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
      13. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
      13 frames
    3. Liquibase Core
      Liquibase.update
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
      4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273)
      5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
      6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
      7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
      8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
      9. liquibase.Liquibase.update(Liquibase.java:214)
      10. liquibase.Liquibase.update(Liquibase.java:192)
      11. liquibase.Liquibase.update(Liquibase.java:188)
      11 frames
    4. org.traccar.database
      DataManager.<init>
      1. org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:141)
      2. org.traccar.database.DataManager.<init>(DataManager.java:67)
      2 frames
    5. org.traccar
      Main.main
      1. org.traccar.Context.init(Context.java:150)
      2. org.traccar.Main.main(Main.java:35)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    7. Java Service Wrapper
      WrapperSimpleApp.run
      1. org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame