I've created a view joining 2 tables (1:M). This view is well recognized with QGIS 3.0 & GDAL 2.2.4 (OsGeo4W)
When I use this view in mapserver : CONNECTIONTYPE OGR CONNECTION "mygeopackage.gpkg" DATA "v_my_view" I get msOGRFileOpen(): OGR error. GetLayer(v_my_view) failed for OGR connection. Check logs. Here my log(debug 5 & "CPL_DEBUG" "ON"). ... msOGRFileOpen(mygeopackage.gpkg)... ... OGROPen(/my_path/mygeopackage.gpkg) ... msConnPoolRegister(v_my_view,mygeopackage.gpkg,0x1dfd3c0) ... msOGRFileOpen(): OGR error. GetLayer(v_my_view) failed for OGR connection. Check logs. ... GetLayer(v_my_view) failed for OGR connection `mygeopackage.gpkg'. ... msConnPoolRelease(v_my_view,mygeopackage.gpkg,0x1dfd3c0) ... msConnPoolClose(mygeopackage.gpkg,0x1dfd3c0) ... msDrawMap(): Image handling error. Failed to draw layer named 'v_my_view'. ... freeLayer(): freeing layer at 0x1e02ac0. Then, when I write this view as a table (well recognized with QGIS 3.0 & GDAL 2.2.4 (OsGeo4W)) , everything is fine with Mapserver. Seem like my view is crashing my OGR connection. The only difference between my view and my tables is that my view do not have gpkg_rtree_index associated? I've tried from spatialite gui to Select gpkgAddSpatialIndex(...). But I received this error : cannot create AFTER trigger on view: v_my_view I use Mapserver 7.03 on RedHat. I don't know which version of gdal is used with Mapserver...sorry Pierre -- Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users