traccar 6.2 impossibile export report

Deborah4 months ago

hello,

please note that in Traccar 6.2 it is impossible to export the report (I tried daily summary). It gives an unreachable site error.
While if I try to send it by e-mail, the server crashes

Hendry Moronta4 months ago

What operating system and database engine do you use?

Deborah4 months ago

I use ubuntu server 24.04 x64 and the default h2 database.
I used to use 6.0 before and it worked fine

Anton Tananaev4 months ago

What's the error in the logs?

Deborah4 months ago
2024-06-02 15:17:04  INFO: user: 102, report: events, from: 2024-06-01 09:17, to: 2024-06-02 15:17, devices: [169, 2, 72, 138, 106, 3, 5, 201], groups: []
2024-06-02 15:17:27  INFO: user: 1, report: summary, from: 2024-06-02 00:00, to: 2024-06-02 23:59, devices: [3], groups: []
2024-06-02 15:17:27  INFO: you may change the SPI on file: META-INF/services/org.jxls.util.ServiceFactory
2024-06-02 15:17:27  INFO: you may change the SPI on file: META-INF/services/org.jxls.util.JxlsConfigProvider
2024-06-02 15:17:27  INFO: Loading transformer by class org.jxls.transform.poi.PoiTransformer
2024-06-02 15:17:27  INFO: Stopping server...
Anton Tananaev4 months ago

Looks like the service was stopped.

Deborah4 months ago

yes, this interrupts itself when I press the 'export' button in reports

Anton Tananaev4 months ago

I don't think that's possible. Check systemd logs.

Deborah4 months ago

Below are the logs while I had the problem and of the following restart. I do not see any significant errors.
web side I have a CONNECTION_REFUSED error

2024-06-02 15:31:13  INFO: Update summary generated
2024-06-02 15:31:13  INFO: Successfully released change log lock
2024-06-02 15:31:13  INFO: Command execution complete
2024-06-02 15:31:14  INFO: jetty-11.0.21; built: 2024-05-14T03:19:28.958Z; git: 996cd61addad9cb033e0e3eba6fa3f0fa3dc270d; jvm 21.0.3+9-Ubuntu-1ubuntu1
2024-06-02 15:31:14  INFO: Started o.t.w.@6191e1a3{/,null,AVAILABLE}
2024-06-02 15:31:14  INFO: Session workerName=node0
2024-06-02 15:31:14  WARN: JAXBContext implementation could not be found. WADL feature is disabled.
2024-06-02 15:31:15  INFO: Started o.e.j.s.ServletContextHandler@59965fa7{/,null,AVAILABLE}
2024-06-02 15:31:15  INFO: Started ServerConnector@7c266454{HTTP/1.1, (http/1.1)}{0.0.0.0:8082}
2024-06-02 15:31:15  INFO: Started Server@469e2759{STARTING}[11.0.21,sto=0] @5441ms
2024-06-02 15:31:19  WARN: Error loading timezone aliases: inStream parameter is null
2024-06-02 15:31:21  INFO: user: 102, action: login, from: 192.168.0.23
2024-06-02 15:31:29  INFO: user: 1, report: summary, from: 2024-06-02 00:00, to: 2024-06-02 23:59, devices: [2], groups: []
2024-06-02 15:31:29  INFO: you may change the SPI on file: META-INF/services/org.jxls.util.ServiceFactory
2024-06-02 15:31:29  INFO: you may change the SPI on file: META-INF/services/org.jxls.util.JxlsConfigProvider
2024-06-02 15:31:29  INFO: Loading transformer by class org.jxls.transform.poi.PoiTransformer
2024-06-02 15:31:29  INFO: Stopping server...
2024-06-02 15:31:56  INFO: Operating system name: Linux version: 6.8.0-31-generic architecture: amd64
2024-06-02 15:31:56  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Ubuntu version: 21.0.3+9-Ubuntu-1ubuntu1
2024-06-02 15:31:56  INFO: Memory limit heap: 1958mb non-heap: 0mb
2024-06-02 15:31:56  INFO: Character encoding: UTF-8
2024-06-02 15:31:56  INFO: Version: 6.2
2024-06-02 15:31:56  INFO: Starting server...
2024-06-02 15:31:57  INFO: HikariPool-1 - Starting...
2024-06-02 15:31:57  INFO: HikariPool-1 - Added connection conn0: url=jdbc:h2:./data/database user=SA
2024-06-02 15:31:57  INFO: HikariPool-1 - Start completed.
2024-06-02 15:31:57  INFO: Set default schema name to PUBLIC
2024-06-02 15:31:57  INFO: Clearing database change log checksums
2024-06-02 15:31:57  INFO: Successfully acquired change log lock
2024-06-02 15:31:57  INFO: Successfully released change log lock
2024-06-02 15:31:59  INFO: Reading from PUBLIC.DATABASECHANGELOG
2024-06-02 15:31:59  INFO: Reading from PUBLIC.DATABASECHANGELOG
2024-06-02 15:31:59  INFO: Reading from PUBLIC.DATABASECHANGELOG
2024-06-02 15:31:59  INFO: UPDATE SUMMARY
2024-06-02 15:31:59  INFO: Run:                          0
2024-06-02 15:31:59  INFO: Previously run:              47
2024-06-02 15:31:59  INFO: Filtered out:                 0
2024-06-02 15:31:59  INFO: -------------------------------
2024-06-02 15:31:59  INFO: Total change sets:           47

2024-06-02 15:31:59  INFO: Update summary generated
2024-06-02 15:31:59  INFO: Successfully released change log lock
2024-06-02 15:31:59  INFO: Command execution complete
2024-06-02 15:32:00  INFO: jetty-11.0.21; built: 2024-05-14T03:19:28.958Z; git: 996cd61addad9cb033e0e3eba6fa3f0fa3dc270d; jvm 21.0.3+9-Ubuntu-1ubuntu1
2024-06-02 15:32:00  INFO: Started o.t.w.@6191e1a3{/,null,AVAILABLE}
2024-06-02 15:32:01  INFO: Session workerName=node0
2024-06-02 15:32:01  WARN: JAXBContext implementation could not be found. WADL feature is disabled.
2024-06-02 15:32:01  INFO: Started o.e.j.s.ServletContextHandler@59965fa7{/,null,AVAILABLE}
2024-06-02 15:32:01  INFO: Started ServerConnector@7c266454{HTTP/1.1, (http/1.1)}{0.0.0.0:8082}
2024-06-02 15:32:01  INFO: Started Server@469e2759{STARTING}[11.0.21,sto=0] @5439ms
2024-06-02 15:32:04  INFO: user: 102, report: events, from: 2024-06-01 09:32, to: 2024-06-02 15:32, devices: [169, 2, 72, 138, 106, 3, 5, 201], groups: []
2024-06-02 15:32:09  INFO: user: 102, action: login, from: 192.168.0.23
Anton Tananaev4 months ago

And systemd logs?

Deborah4 months ago

hello,

I reinstalled traccar from scratch and it now works.
Thanks for your help, I don't know what happened