My own sqlitedb maps are not working

Václav Hanuš shared this question 7 months ago
Answered

Hi,

I have created about 30 sqlitedb maps 6 years ago, but now they don't work. when I try to add them, it is ending with "unknown error". Last time I used them was half an year ago. I'm using Locus Pro 3.30.2 and still the same phone with the same Android version (Oneplus X, OxygenOS 3.1.4, Android 6.0.1)

I'm also using another sqlitedb map, but that one is working ok, so it NOT like "all sqlitedb files are not working".

One of the problematic map is here (5MB)

https://drive.google.com/file/d/1Z2VoO0GjAN-eA2YP4t_MFgotrBNtp9UO/view?usp=sharing


Thanks in advance,

Vašek

Best Answer
photo

Dear Václav,

thank you for info about SDcard. Locus works with sqlite db files (format of map file) in Read-Only mode (due to restriction on Android system). In normal situation does not influence it the usage of sqlite db maps. Unfortunately your maps have defined custom parametr that always try to write data in the disk and that cause the issue. (this is also the reason why any other maps work properly from the Sdcard) There are two solutions:

1. Copy all problematic map into internal memory

2. Change map (db) parameters. Please see the steps below in case that you're familiar with CMD or any DB editor.


Thank you

Best regards

Petr

Comments (7)

photo
1

Hello Vašek,

The map itself is OK (I successfully loaded and displayed it).

What does exactly mean "when I try to add them, it is ending with "unknown error""? When exactly is the error message shown? During start of Locus or when you select map in Menu > Maps > Offline

Thank you

BR Petr

photo
1

Hi Petr,

so I tried more. And problem is just when the file is in sd card (tried several directories, even directory with other sqlitedb maps which are working!). Once is in internal storage, it is working ok!

I following these steps:Maps > Offline > External maps > I choose file or dir with those problematic maps. Then it says in green text "process successful", but map is NOT added to Offline maps. When I hit + button and go again to External map, I can see that file or dir. After restart Locus, during initializing, there is error message with that error - see attached file (it says "problem with adding the map", Error: unkown problem".

I have set of 30 maps (one of them was that example) and all of them are not working from sd card, just from internal storage.

But I have also another self created sqlitedb map and that one is working from sd card properly. So it is not global problem with all sqlitedb files from sd card.


BR,Vašek

photo
1

Dear Václav,

thank you for info about SDcard. Locus works with sqlite db files (format of map file) in Read-Only mode (due to restriction on Android system). In normal situation does not influence it the usage of sqlite db maps. Unfortunately your maps have defined custom parametr that always try to write data in the disk and that cause the issue. (this is also the reason why any other maps work properly from the Sdcard) There are two solutions:

1. Copy all problematic map into internal memory

2. Change map (db) parameters. Please see the steps below in case that you're familiar with CMD or any DB editor.


Thank you

Best regards

Petr

photo
1

Thank you, Petr!

So I've changed that journal mode to delete and problem is solved. Thank you!

Vašek

photo
1

Great! I'm glad that's solved.

BR Petr

photo
1

Dear Gents

I have opened my sqlitedb raster maps by mentioned utility SQL expert. I can not see that mentioned parameter PRAGMA schema.journal_mode even in other tabs. Can anybody advise me where to look for such parameter?

Many thanks

Kindest regards

Andy

photo
1

Dear Andrej

the PRAGMA <statement> is possible to change via command line. So if you use SQLite Expert run command in SQL tab. However it seems that the SQLite Expert Professional can change some PRAGMA parameters in tab Database or Schema.

BR Petr

photo