liquibase.exception.DatabaseException

ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web611

  • via GitHub by gpproton
    ,
  • via GitHub by gpproton
    ,
  • Stack trace

    • liquibase.exception.DatabaseException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) at liquibase.Liquibase.update(Liquibase.java:214) at liquibase.Liquibase.update(Liquibase.java:192) at liquibase.Liquibase.update(Liquibase.java:188) at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:141) at org.traccar.database.DataManager.<init>(DataManager.java:67) at org.traccar.Context.init(Context.java:150) at org.traccar.Main.main(Main.java:35) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325) at java.lang.Thread.run(Thread.java:745) Caused by: liquibase.exception.DatabaseException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568) ... 15 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299) ... 20 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    577 more bugmates