MSSQL erorr on traccar 4

shyy 7 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 Tananaev 7 years ago

What version of MS SQL are you using?

shyy 7 years ago

the versoin fo is SQL Server 2014- 12.0.2000.8

Fidel Garza 7 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 Tananaev 7 years ago
Fidel Garza 7 years ago

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

shyy 7 years ago

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

Fidel Garza 7 years ago
shyy 7 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 Garza 7 years ago

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

shyy 7 years ago

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

Anton Tananaev 7 years ago

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

shyy 7 years ago

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