Traccar 3.5 on windows with sql express 2014 Wrapper error

brant.felix8 years ago

I have it connecting and authenticating to the database, it creates the tables but then errors on this...

The Wrapper log:

INFO   | jvm 1    | 2016/05/08 21:53:43 | INFO 5/8/16 9:53 PM: liquibase: C:/Program Files (x86)/Traccar/data/changelog-3.5.xml::changelog-3.5::author: Successfully released change log lock
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp: 
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: liquibase.exception.MigrationFailedException: Migration failed for change set C:/Program Files (x86)/Traccar/data/changelog-3.5.xml::changelog-3.5::author:
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error:      Reason: liquibase.exception.DatabaseException: The object 'DF_users_language' is dependent on column 'language'. [Failed SQL: ALTER TABLE [dbo].[users] DROP COLUMN [language]]
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:590)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.Liquibase.update(Liquibase.java:212)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.Liquibase.update(Liquibase.java:192)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.Liquibase.update(Liquibase.java:188)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:268)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:121)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:29)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Unknown Source)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Unknown Source)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Caused by: liquibase.exception.DatabaseException: The object 'DF_users_language' is dependent on column 'language'. [Failed SQL: ALTER TABLE [dbo].[users] DROP COLUMN [language]]
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	... 15 more
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'DF_users_language' is dependent on column 'language'.
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
INFO   | jvm 1    | 2016/05/08 21:53:43 | WrapperSimpleApp Error: 	... 20 more
STATUS | wrapper  | 2016/05/08 21:53:45 | <-- Wrapper Stopped

My Config File....

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <!-- SERVER CONFIG -->

    <entry key='web.enable'>true</entry>
    <entry key='web.port'>8082</entry>
    <entry key='web.path'>C:\Program Files (x86)\Traccar\web</entry>

    <entry key='geocoder.enable'>true</entry>
    <entry key='geocoder.type'>google</entry>

    <entry key='logger.enable'>true</entry>
    <entry key='logger.level'>all</entry>
    <entry key='logger.file'>C:\Program Files (x86)\Traccar\logs\tracker-server.log</entry>

    <!-- DATABASE CONFIG -->

    <entry key='database.driverFile'>C:\Program Files (x86)\Traccar\lib\sqljdbc42.jar</entry>
    <entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
    <entry key='database.url'>jdbc:sqlserver://Bunch-GPS01\BUNCHGPS;database=Traccar</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password'>********</entry>

    <entry key='database.checkTable'>traccar</entry>

    <entry key='database.changelog'>C:\Program Files (x86)\Traccar\data\changelog-master.xml</entry>

Am I missing something obvious?

Anton Tananaev8 years ago

It looks like an issue with Liquibase changelogs. Please try to apply changes from the commit:

https://github.com/tananaev/traccar/commit/f4a4fafb5c6eb6cdd2d219a3b31c7e232bcd0807

brant.felix8 years ago

So far this looks like my solution. Thanks so much!

brant.felix8 years ago

It seemed to be working now, but the program will take any settings with this error:

2016-05-09 05:11:34  WARN: Invalid column name 'login'. - SQLServerException (... < QueryBuilder:376 < DataManager:285 < PermissionsManager:75 < ...)
2016-05-09 05:11:34  WARN: Invalid column name 'latestPosition_id'. - SQLServerException (... < QueryBuilder:376 < DataManager:452 < ConnectionManager:55 < ...)

I suspect I have got something wrong in the traccar.xml config file? Only everything seems right?

Anton Tananaev8 years ago

There is definitely something wrong with your config. Please use original Traccar 3.5. You don't need to change any queries.

brant.felix8 years ago

Once again thanks. It works now, I much have been staring at this too long.

PS - it is possible to retrieve speed limits of roads through Traccar?

Anton Tananaev8 years ago

Currently there is no way to get speed limits in Traccar. You need access to some map data for that.