Opened 14 months ago

Last modified 14 months ago

#22851 new defect

Error while opening .gpkg file

Reported by: michalgw98@… Owned by: Don-vip
Priority: normal Milestone:
Component: Plugin opendata Version:
Keywords: template_report Cc:


What steps will reproduce the problem?

The error occurs during the opening of .gpkg file. The file can I tried to open can be downloaded here:

What is the expected result?

Open file

What happens instead?


Please provide any additional information below. Attach a screenshot if possible.

Build-Date:2023-03-02 13:34:23

Identification: JOSM/1.5 (18678 en) Windows 10 64-Bit
OS Build number: Windows 10 Pro 2009 (19045)
Memory Usage: 232 MB / 3936 MB (64 MB allocated, but free)
Java version: 17.0.6+10-LTS, Azul Systems, Inc., OpenJDK 64-Bit Server VM
Look and Feel:
Screen: \Display0 1920×1080 (scaling 1.50×1.50)
Maximum Screen Size: 1920×1080
Best cursor sizes: 16×16→48×48, 32×32→48×48
System property file.encoding: Cp1250
System property sun.jnu.encoding: Cp1250
Locale info: en_PL
Numbers with default locale: 1234567890 -> 1234567890
VM arguments: [, --add-modules=java.scripting,java.sql,javafx.controls,,javafx.swing,javafx.web, --add-exports=java.base/, --add-exports=java.desktop/com.sun.imageio.plugins.jpeg=ALL-UNNAMED, --add-exports=java.desktop/com.sun.imageio.spi=ALL-UNNAMED, --add-opens=java.base/java.lang=ALL-UNNAMED, --add-opens=java.base/java.nio=ALL-UNNAMED, --add-opens=java.base/jdk.internal.loader=ALL-UNNAMED, --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED, --add-opens=java.desktop/javax.imageio.spi=ALL-UNNAMED, --add-opens=java.desktop/javax.swing.text.html=ALL-UNNAMED, --add-opens=java.prefs/java.util.prefs=ALL-UNNAMED,\AppData\Local\JOSM\JOSM.exe]

+ Mapillary (2.1.2)
+ apache-commons (36034)
+ apache-http (35924)
+ buildings_tools (36011)
+ ejml (35924)
+ geotools (36028)
+ imagery_offset_db (35978)
+ jackson (36034)
+ jaxb (35952)
+ jna (36005)
+ jts (36004)
+ mapwithai (789)
+ opendata (36025)
+ plbuildings (1.8.1)
+ terracer (35978)
+ todo (123)
+ utilsplugin2 (36011)

Map paint styles:

Last errors/warnings:
- 00000.331 W: extended font config - overriding 'filename.Myanmar_Text=mmrtext.ttf' with 'MMRTEXT.TTF'
- 00000.333 W: extended font config - overriding 'filename.Mongolian_Baiti=monbaiti.ttf' with 'MONBAITI.TTF'
- 00002.477 E: Windows-ROOT not found. Cause: Windows-ROOT KeyStore not available
- 00003.558 W: Update plugins - You updated your JOSM software. To prevent problems the plugins should be updated as well.  Update plugins now?
- 00083.316 E: Handled by bug report queue: java.lang.RuntimeException: Unable to obtain connection: [SQLITE_NOTADB]  File opened that is not a database file (file is not a database). Cause: org.sqlite.SQLiteException: [SQLITE_NOTADB]  File opened that is not a database file (file is not a database)

No data collected.

Warning issued by: BugReportExceptionHandler#handleException

Thread: main-worker-0 (22) of main
java.lang.RuntimeException: Unable to obtain connection: [SQLITE_NOTADB]  File opened that is not a database file (file is not a database)
	at org.geotools.jdbc.JDBCDataStore.createConnection(
	at org.geotools.jdbc.JDBCDataStore.createTypeNames(
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.importData(
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.realRun(
	at org.openstreetmap.josm.gui.PleaseWaitRunnable.doRealRun(
	at java.base/java.util.concurrent.Executors$ Source)
	at java.base/ Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$ Source)
	at java.base/ Source)
Caused by: org.sqlite.SQLiteException: [SQLITE_NOTADB]  File opened that is not a database file (file is not a database)
	at org.sqlite.core.DB.newSQLException(
	at org.sqlite.core.DB.newSQLException(
	at org.sqlite.core.DB.throwex(
	at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
	at org.sqlite.core.NativeDB.prepare(
	at org.sqlite.core.DB.prepare(
	at org.sqlite.jdbc3.JDBC3Statement.execute(
	at org.sqlite.SQLiteConfig.apply(
	at org.sqlite.SQLiteConnection.<init>(
	at org.sqlite.jdbc3.JDBC3Connection.<init>(
	at org.sqlite.jdbc4.JDBC4Connection.<init>(
	at org.sqlite.JDBC.createConnection(
	at org.sqlite.SQLiteDataSource.getConnection(
	at org.sqlite.SQLiteDataSource.getConnection(
	at org.geotools.jdbc.JDBCDataStore.createConnection(
	... 19 more

Attachments (0)

Change History (1)

comment:1 by gaben, 14 months ago

Component: CorePlugin opendata
Owner: changed from team to Don-vip

The db file seems invalid:

sqlite-tools-win32-x86-3410200> .\sqlite3.exe '.\Rejestr parków.GPKG'
SQLite version 3.41.2 2023-03-22 11:56:21
Enter ".help" for usage hints.
sqlite> PRAGMA integrity_check;
Parse error: file is not a database (26)

SHA1 hash of the Rejestr parków.GPKG file is 5e05fd26b3e727585bceaf937dd87d087d11838b.

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain Don-vip.
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from Don-vip to the specified user.
Next status will be 'needinfo'. The owner will be changed from Don-vip to michalgw98@….
as duplicate The resolution will be set to duplicate. Next status will be 'closed'. The specified ticket will be cross-referenced with this ticket.
The owner will be changed from Don-vip to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.