MSSQL erorr on traccar 4

shyy6 years ago

I installed traccar 4 on new server.
it was runing fine with the h2 db .
I tryed to connect the server to my mssql DB (it is runing fine with oher server on 3.17) and im getting this error on the wrapper log file

FINEST|5912/0|Service traccar|18-08-07 11:16:16|[main] ERROR liquibase.changelog.ChangeSet - Change Set changelog-4.0::changelog-4.0::author failed.  Error: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]

and the traccar service is stoped

can you please advice ?
Thanks
shay

Anton Tananaev6 years ago

What version of MS SQL are you using?

shyy6 years ago

the versoin fo is SQL Server 2014- 12.0.2000.8

Fidel Garza6 years ago

Same Problem SqlExpress

FINEST|684/0|Service traccar|18-08-10 19:14:12|     Reason: liquibase.exception.DatabaseException: The object 'DF_notifications_web' is dependent on column 'web'. [Failed SQL: ALTER TABLE tc_notifications DROP COLUMN web]

Operating System 6.3.17134
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000

Anton Tananaev6 years ago
Fidel Garza6 years ago

Thanks Anton. I downloaded new changelog-4.0.xml. And paste in shema folder . Now working OK.

shyy6 years ago

can you please send the link for the new changelog-4.0.xml ?

Fidel Garza6 years ago
shyy6 years ago

Thanks ,
I downloaded new changelog-4.0.xml. And paste in shema folder and now new error

INFO|6104/0|Service traccar|18-08-12 07:26:38|Caused by: liquibase.exception.SetupException: Error parsing line 8 column 17 of schema/changelog-4.0.xml: cvc-elt.1: Cannot find the declaration of element 'html'.

can you advice ?

Fidel Garza6 years ago

You make a restore of database to point before first atttemp to upgrade ??

shyy6 years ago

it is new server and new database , i don't have any old DB to restore

Anton Tananaev6 years ago

Have you looked at your xml file? Why does it have "html" element?

shyy6 years ago

Anton, you are the best .
Apparently I downloaded the wrong file .Now it is up and running correctly
Thanks :)