[GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

[DAmico, Ellen]

-----Original Message-----
From: grass-user <grass-user-bounces at lists.osgeo.org> On Behalf Of Helmut Kudrnovsky
Sent: Friday, August 07, 2020 8:32 AM
To: grass-user at lists.osgeo.org
Subject: Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS



>I am getting this error:

>

>Process ended with non-zero return code 3221225785. See errors in the

(error)



>>it's a dll mixing/mismatch due to more of the same dll  in your %PATH%.

I went through as suggested and excluded the sqlite dlls found and that did not help.



>>which library errored the message above? (sqlite? gdal?)



The library that errored is sqlite.



>g.run_command(r'C:\OSGeo4W64\apps\grass\grass78\bin\g.proj.exe',

georef=geotiff, location = >locationGeonet)



>>really an unusual way to invoke g.proj. never saw this working.

I am trying to get a model that I did NOT write to work this is how they do it.  Perhaps there is a better way.



>I think this is a conflict with the sqlite3.dll as is suggested the

>below

wiki but the solutions there have >not worked for me.

>

>https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgrass

>wiki.osgeo.org%2Fwiki%2FWinGRASS_errors&data=02%7C01%7CDAmico.Ellen

>%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976a

>acbeca6a7%7C0%7C0%7C637324003812775461&sdata=s8uZGsVa%2Fif7EKaoiBhz

>pBx8Wy5OpIZRlWcQ8F1mjpQ%3D&reserved=0



which solutions did you try?

I tried everything suggested in the link for #1 and #16 which are both about sqlite conflicts.



>>just open a normal windows console and type:



>>C:\Users\yourusername>where "$path:sqlite3*"



>>it's checking sqlite3 in your %PATH%



>>report back in your case.



I checked out the dll's previously following the original link I sent with my question.  I tried to do the one by one exclusion and none helped.

When I run the where from the windows console I get this:

[cid:image001.png at 01D66C98.D8A81050]



When I do it from the OSGGeo4W Shell.  I get this:

[cid:image002.png at 01D66C98.D8A81050]





>>when I open the OSGeo4W shell, I get



>>C:\>where "$path:sqlite3*"

>>C:\Program Files\QGIS 3.4\bin\sqlite3.dll C:\Program Files\QGIS 3.4\bin\sqlite3.exe



>>is there a windows console availabe in the Spyder/ Anaconda framework? if yes, then type where "$path:sqlite3*" and report back.

There is not.



>have you seen:



>>https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOSGeo%2Fgrass%2Fissues%2F679&data=02%7C01%7CDAmico.Ellen%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%>>7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812775461&sdata=r%2B3UD8sQn8t%2BgcXZXTR50FGRoV29QvnODiD77A1vFqY%3D&reserved=0<https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOSGeo%2Fgrass%2Fissues%2F679&data=02%7C01%7CDAmico.Ellen%40epa.gov%7Ce28ddeb63b4e45dced4d08d83acde1bd%25%3e%3e7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812775461&sdata=r%2B3UD8sQn8t%2BgcXZXTR50FGRoV29QvnODiD77A1vFqY%3D&reserved=0>



>>?



I have not.  But that does seem to be my exact error.  I wonder if I switch to miniconda instead of Anaconda that will help.  Thanks for sending it.



>>and the mentioned thread:



>>https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F53682315%2Ferror-on-libcurl-dll-when-using-gdal-of-osgeo4w-in-django&data=02%7C01%7CDAmico.Ellen%40epa.gov%>>7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812785429&sdata=AnOizoWcJzI6cY3WqhLQ42Pxx%2BSiYg2Y0PC%2FdFZgMDA%3D&reserved=0<https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F53682315%2Ferror-on-libcurl-dll-when-using-gdal-of-osgeo4w-in-django&data=02%7C01%7CDAmico.Ellen%40epa.gov%25%3e%3e7Ce28ddeb63b4e45dced4d08d83acde1bd%7C88b378b367484867acf976aacbeca6a7%7C0%7C0%7C637324003812785429&sdata=AnOizoWcJzI6cY3WqhLQ42Pxx%2BSiYg2Y0PC%2FdFZgMDA%3D&reserved=0>



Thank you.

Ellen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20200807/e0683912/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9581 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20200807/e0683912/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 7033 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20200807/e0683912/attachment-0003.png>