Incorrect syntax near 'LIMIT'. - SQLServerException

pepego2 years ago

Hi Im using MS SQL Server Express to test Traccar, but I am having problems with getting positions inserted into de database. As soon as I changed back to H2 database it worked correctly, but I need to use MS SQL server. Please find info on the log below.

2022-10-14 14:23:20  INFO: [Tfae72880] connected
2022-10-14 14:23:20  INFO: [Tfae72880: ruptela < 200.68.140.167] 00ef000311bfb84dadb14400066349b100000000c42ce3720f504840197e0000150000060007010005010001004100000000006349b22c000000c42ce3720f50484019800000130000060007010005010001004100000000006349b358000000c42ce3720f504840197c0000140000060007010005010001004100000000006349b484000000c42ce3720f504840197f0000150000060007010005010001004100000000006349b5b0000000c42ce3720f50484019820000130000060007010005010001004100000000006349b6dc000000c42ce3720f5048401982000013000006000701000501000100410000000000eb62
2022-10-14 14:23:20  INFO: [Tfae72880: ruptela > 200.68.140.167] 0002640113bc
2022-10-14 14:23:20  INFO: [Tfae72880] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-10-14 14:23:20  INFO: [Tfae72880] disconnected
2022-10-14 14:23:26  INFO: [T990e6677] connected
2022-10-14 14:23:26  INFO: [T990e6677: ruptela < 200.68.140.167] 00ef000311bfb84dadb14400066349b100000000c42ce3720f504840197e0000150000060007010005010001004100000000006349b22c000000c42ce3720f50484019800000130000060007010005010001004100000000006349b358000000c42ce3720f504840197c0000140000060007010005010001004100000000006349b484000000c42ce3720f504840197f0000150000060007010005010001004100000000006349b5b0000000c42ce3720f50484019820000130000060007010005010001004100000000006349b6dc000000c42ce3720f5048401982000013000006000701000501000100410000000000eb62
2022-10-14 14:23:26  INFO: [T990e6677: ruptela > 200.68.140.167] 0002640113bc
2022-10-14 14:23:26  INFO: [T990e6677] error - Incorrect syntax near 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < ...)
2022-10-14 14:23:26  INFO: [T990e6677] disconnected
2022-10-14 14:23:30  INFO: [T643d411f] connected
2022-10-14 14:23:30  INFO: Stopping server...
2022-10-14 14:23:39  INFO: Operating system name: Windows 10 version: 10.0 architecture: amd64
2022-10-14 14:23:39  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.4+8
2022-10-14 14:23:39  INFO: Memory limit heap: 1992mb non-heap: 0mb
2022-10-14 14:23:39  INFO: Character encoding: Cp1252 charset: windows-1252
2022-10-14 14:23:39  INFO: Version: 5.4
2022-10-14 14:23:39  INFO: Starting server...
2022-10-14 14:23:39  INFO: HikariPool-1 - Starting...
2022-10-14 14:23:40  INFO: HikariPool-1 - Added connection conn0: url=jdbc:h2:./data/database user=SA
2022-10-14 14:23:40  INFO: HikariPool-1 - Start completed.
2022-10-14 14:23:40  INFO: Set default schema name to PUBLIC
2022-10-14 14:23:40  INFO: Clearing database change log checksums
2022-10-14 14:23:40  INFO: Successfully acquired change log lock
2022-10-14 14:23:40  INFO: Successfully released change log lock
2022-10-14 14:23:40  INFO: Successfully acquired change log lock
2022-10-14 14:23:41  INFO: Reading from PUBLIC.DATABASECHANGELOG
2022-10-14 14:23:41  INFO: Reading from PUBLIC.DATABASECHANGELOG
2022-10-14 14:23:41  INFO: Successfully released change log lock
2022-10-14 14:23:41  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.
2022-10-14 14:23:42  WARN: Port disabled due to conflict - Address already in use: bind - BindException (...)
2022-10-14 14:23:43  INFO: jetty-10.0.12; built: 2022-09-14T01:54:40.076Z; git: 408d0139887e27a57b54ed52e2d92a36731a7e88; jvm 17.0.4+8
2022-10-14 14:23:43  INFO: Started o.t.w.@3f0a2cd{/,null,AVAILABLE}
2022-10-14 14:23:43  INFO: Session workerName=node0
2022-10-14 14:23:43  WARN: JAXBContext implementation could not be found. WADL feature is disabled.
2022-10-14 14:23:44  INFO: Started o.e.j.s.ServletContextHandler@5ad9c495{/,null,AVAILABLE}
2022-10-14 14:23:44  INFO: Started ServerConnector@142f4720{HTTP/1.1, (http/1.1)}{0.0.0.0:8082}
2022-10-14 14:23:44  INFO: Started Server@364ff259{STARTING}[10.0.12,sto=0] @12377ms
2022-10-14 14:23:47  INFO: user: 1, action: login, from: [0:0:0:0:0:0:0:1]
2022-10-14 14:23:52  INFO: [T9121a71f] connected
2022-10-14 14:23:52  INFO: [T9121a71f: ruptela < 200.68.140.167] 00ef000311bfb84dadb14400066349b100000000c42ce3720f504840197e0000150000060007010005010001004100000000006349b22c000000c42ce3720f50484019800000130000060007010005010001004100000000006349b358000000c42ce3720f504840197c0000140000060007010005010001004100000000006349b484000000c42ce3720f504840197f0000150000060007010005010001004100000000006349b5b0000000c42ce3720f50484019820000130000060007010005010001004100000000006349b6dc000000c42ce3720f5048401982000013000006000701000501000100410000000000eb62
2022-10-14 14:23:52  WARN: Unknown device - 863940058656177 (200.68.140.167)
2022-10-14 14:24:00  INFO: user: 1, action: create, object: device, id: 3
2022-10-14 14:24:00  INFO: user: 1, action: link, owner: user, id: 1, property: device, id: 3
2022-10-14 14:24:58  INFO: [T9121a71f] disconnected
2022-10-14 14:25:04  INFO: [Ta1e5503d] connected
2022-10-14 14:25:04  INFO: [Ta1e5503d: ruptela < 200.68.140.167] 00ef000311bfb84dadb14400066349b100000000c42ce3720f504840197e0000150000060007010005010001004100000000006349b22c000000c42ce3720f50484019800000130000060007010005010001004100000000006349b358000000c42ce3720f504840197c0000140000060007010005010001004100000000006349b484000000c42ce3720f504840197f0000150000060007010005010001004100000000006349b5b0000000c42ce3720f50484019820000130000060007010005010001004100000000006349b6dc000000c42ce3720f5048401982000013000006000701000501000100410000000000eb62
2022-10-14 14:25:04  INFO: [Ta1e5503d: ruptela > 200.68.140.167] 0002640113bc
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 13:57:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:02:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:07:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:12:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:17:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:25:05  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:22:04, lat: 25.69196, lon: -100.36912, course: 0.0
2022-10-14 14:27:07  INFO: [Ta1e5503d: ruptela < 200.68.140.167] 0031000311bfb84dadb14400016349b808000000c42ce3720f504840197f0000150000050007010005010001004100000000004c57
2022-10-14 14:27:07  INFO: [Ta1e5503d: ruptela > 200.68.140.167] 0002640113bc
2022-10-14 14:27:07  INFO: [Ta1e5503d] id: 863940058656177, time: 2022-10-14 14:27:04, lat: 25.69196, lon: -100.36912, course: 0.0
Anton Tananaev2 years ago

https://github.com/traccar/traccar/issues/4958

pepego2 years ago

Thanks for your response. Do I have to edit and compile de source code with the modifications on GitHub or are you planning on releasing a new installer? Thanks.

Anton Tananaev2 years ago

You can either compile or wait for the next release.

Emilio Villar2 years ago

Hello, I have the same problem, I have tried to update from version 5.0. The errors I get is the following:

2022-11-23 23:15:27  INFO: [T3fe4d7a2: teltonika < 18.196.213.123] 000f383636373730303536363234313334
2022-11-23 23:15:27  INFO: [T3fe4d7a2: teltonika > 18.196.213.123] 01
2022-11-23 23:15:27  INFO: [T3fe4d7a2] error - Sintaxis incorrecta cerca de 'LIMIT'. - SQLServerException (... < QueryBuilder:417 < DatabaseStorage:71 < CommandsManager:102 < …)

Will it be corrected in the next version?. Thanks.

Anton Tananaev2 years ago

Yes.