I has an error when I try to start traccar service the traccar database configuration is for MSSQL, can you give me a hand?
This is my configuration:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://localhost:1433;databaseName=traccar;</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'>mysecretpass</entry>
This is the log
FINEST|1243/0|Service traccar|18-09-22 16:41:11|[main] INFO liquibase.executor.jvm.JdbcExecutor - ALTER TABLE tc_notifications DROP COLUMN web
FINEST|1243/0|Service traccar|18-09-22 16:41:11|[main] ERROR liquibase.changelog.ChangeSet - Change Set changelog-4.0::changelog-4.0::author failed. Error: The object 'DF_no$
FINEST|1243/0|Service traccar|18-09-22 16:41:11|[main] INFO liquibase.executor.jvm.JdbcExecutor - select schema_name()
FINEST|1243/0|Service traccar|18-09-22 16:41:11|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
FINEST|1243/0|Service traccar|18-09-22 16:41:11|java.lang.reflect.InvocationTargetException
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at java.lang.reflect.Method.invoke(Method.java:498)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|1243/0|Service traccar|18-09-22 16:41:11|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0::changelog-4.0::author:
FINEST|1243/0|Service traccar|18-09-22 16:41:11| Reason: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQ$
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.Liquibase.update(Liquibase.java:202)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.Liquibase.update(Liquibase.java:179)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.Liquibase.update(Liquibase.java:175)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.traccar.database.DataManager.<init>(DataManager.java:88)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.traccar.Context.init(Context.java:361)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at org.traccar.Main.main(Main.java:35)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| ... 6 more
FINEST|1243/0|Service traccar|18-09-22 16:41:11|Caused by: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL:$
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| ... 15 more
FINEST|1243/0|Service traccar|18-09-22 16:41:11|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_notifications_web' is dependent on column 'web'.
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:734)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
FINEST|1243/0|Service traccar|18-09-22 16:41:11| ... 20 more
It's a known issue. Please use search.
Can you share the link? because I can't find it
I has an error when I try to start traccar service the traccar database configuration is for MSSQL, can you give me a hand?
This is my configuration:
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> <entry key='database.url'>jdbc:sqlserver://localhost:1433;databaseName=traccar;</entry> <entry key='database.user'>sa</entry> <entry key='database.password'>mysecretpass</entry>This is the log