search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.55k stars 2.99k forks source link

GRASS/Processing fails importing from geopackage on server location #46311

Open T3xtM4rk3r opened 2 years ago

T3xtM4rk3r commented 2 years ago

What is the bug or the crash?

Hello everyone,

our GIS data is located on a server adressed as \\xxxx-server\ using the explorer etc.

When using v.what.rast the following error occurs when importing the raster data from a geopackage 

C:\Windows\System32>r.in.gdal` input="GPKG:\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxxx\IxxxxA-gsm_\grundlagen.gpkg:dtm_germany_20m" band=1 output="rast_61a74edfa78133" --overwrite -o

ERROR 4: sqlite3_open(\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxxx\IxxxxA-gsm_\grundlagen.gpkg) failed: unable to open database file

ERROR: Unable to open datasource <GPKG:\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxxx\IxxxxA-gsm_\grundlagen.gpkg:dtm_germany_20m>

To me it looks like the double \ at the beginning of the path gets lost when the information is transferred to r.in.gdal, a former v.in.ogr works fine.

C:\OSGeo4W\bin>v.in.ogr min_area=0.0001 snap=-1.0 input="\\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxx\IxxxA-gsm_\feflow.gpkg" layer="nodes_all" output="vector_61a752f7c29362" --overwrite -o

Steps to reproduce the issue

Hard to reproduce if the server configuration isn't the same

Versions

QGIS version | 3.22.1-Białowieża | QGIS code revision | 663dcf8fb9 -- | -- | -- | -- Qt version | 5.15.2 Python version | 3.9.5 GDAL/OGR version | 3.4.0 PROJ version | 8.2.0 EPSG Registry database version | v10.038 (2021-10-21) GEOS version | 3.10.0-CAPI-1.16.0 SQLite version | 3.35.2 PDAL version | 2.3.0 PostgreSQL client version | 13.0 SpatiaLite version | 5.0.1 QWT version | 6.1.3 QScintilla2 version | 2.11.5 OS version | Windows 10 Version 2009   |   |   |   Active Python plugins AnotherDXF2Shape | 1.2.3 contour | 2.0.8 coordinate_capture | 0.2 qlyrx | 0.3.3 slyr_community | 3.2.0 SpreadsheetLayers | 2.0.1 db_manager | 0.1.20 grassprovider | 2.12.99 MetaSearch | 0.3.5 processing | 2.12.99 sagaprovider | 2.12.99

Supported QGIS version

New profile

Additional context

No response

gioman commented 2 years ago

C:\Windows\System32>r.in.gdal` input="GPKG:\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxxx\IxxxxA-gsm_\grundlagen.gpkg:dtm_germany_20m" band=1 output="rast_61a74edfa78133" --overwrite -o

@T3xtM4rk3r not sure if you are speaking about Processing or the GRASS plugin, anyway you should also check if this happens using directly GRASS on Windows (so without using QGIS as interface).

T3xtM4rk3r commented 2 years ago

The error ocurred when using the GRASS v.what.rast module from the Processing Toolbox in QGIS. As far as I understand, therefore, a point layer and a raster layer are loaded in a grass database, prior to sampling the raster data at the point locations. The point layer gets imported just fine, but the raster layer import fails. I will try using GRASS directly tomorrow.

T3xtM4rk3r commented 2 years ago

Hello,

when using the latest Grass build directly the import is successful 

(Thu Dec  2 08:33:59 2021)                                                      
r.in.gdal input=GPKG:\\xxxx-server\GIS\xxxx_GmbH\Projekte\xxxx\IxxxxA-gsm_\grundlagen.gpkg:dtm_germany_20m output=dtm_germany_20m band=1

Importing raster map <dtm_germany_20m>...
(Thu Dec  2 08:34:04 2021) Command finished (4 sec)

As i mentioned the difference here is the double \ after the GPKG: bit which Grass in this case directly inherits from the windows explorer used to select the appropriate geopackage.