Traccar With SQL Server. Service stops when open browser 8082.

Firoz6 years ago

released change log lock

FINEST|4820/0|Service traccar|18-09-03 01:06:47|java.lang.reflect.InvocationTargetException
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at java.lang.reflect.Method.invoke(Unknown Source)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0::changelog-4.0::author:
FINEST|4820/0|Service traccar|18-09-03 01:06:47|     Reason: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.Liquibase.update(Liquibase.java:202)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.Liquibase.update(Liquibase.java:179)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.Liquibase.update(Liquibase.java:175)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.traccar.database.DataManager.<init>(DataManager.java:88)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.traccar.Context.init(Context.java:361)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at org.traccar.Main.main(Main.java:35)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	... 6 more
FINEST|4820/0|Service traccar|18-09-03 01:06:47|Caused by: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	... 15 more
FINEST|4820/0|Service traccar|18-09-03 01:06:47|Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_notifications_web' is dependent on column 'web'.
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7347)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:734)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
FINEST|4820/0|Service traccar|18-09-03 01:06:47|	... 20 more
INFO|wrapper|Service traccar|18-09-03 01:06:47|calling onStop
INFO|wrapper|Service traccar|18-09-03 01:06:47|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|18-09-03 01:06:47|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|18-09-03 01:06:47|Win service stop - after shutdown
INFO|wrapper|Service traccar|18-09-03 01:06:47|Win service stop - before notify
INFO|wrapper|Service traccar|18-09-03 01:06:47|Win service terminated
Anton Tananaev6 years ago

Have you tried searching before asking for help?

https://www.traccar.org/forums/topic/mssql-erorr-on-traccar-4/

Firoz6 years ago

Great Anton it worked you are genius., by the way, I tried spending 1 day but you saved my week/month. thanks a lot.