This object is in archive! 
My own sqlitedb maps are not working
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
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
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
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
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
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
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
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
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
Replies have been locked on this page!