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 | 3 months ago
  1. 0

    GitHub comment 2440#254041246

    GitHub | 3 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 | 11 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

    Common Problems - JIRA Enterprise Message Handler - Plugin People WIki

    atlassian.net | 4 months ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("jiradb"."AO_78C957_NOTIFICATION_HIST"."ID")
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