[Qgis-user] QGIS w/ Oracle 19c

[Burt, William WLRS:EX]

Hello QGIS users! I am wondering if anyone has any experience with this issue I am having working with Oracle DB and QGIS.
When new layers are added from Oracle via the QGIS Browser panel I get an error message in QGIS:
No transform is available between NAD83 / BC Albers and EPSG:4326 - WGS 84.
Unknown error (code 4096)

Some details:

  1.  I am certain the root of the issue is not QGIS as I get the error message on both current and older versions of QGIS that were working fine a few months ago.
  2.  Our enterprise Oracle db was recently upgraded to 19c. This may or may not be the cause but seems re
  3.  The error is only thrown for data with BC Albers coordinate systems. WGS 84 datasets work fine
  4.  Datasets where the URI is defined by .qqz or data added via our SLYR plugin via .lyr .lyrx  all work fine.
  5.  Dataset can be made to work if the assigned CRS is changed to EPSG:3005 - NAD83/BC Albers from the auto detected crs: NAD83 / BC Albers

This leads me to think that the CRS metadata is being delivered to QGIS differently than before. Below is the WKTEXT for SRID 3005 from the Oracle medadata table MDSYS.CS_SRS (I can't tell if this has changed from the older Oracle and I don't see why it would):

PROJCS["NAD83 / BC Albers",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Albers_Conical_Equal_Area"],PARAMETER["Latitude_Of_Origin",45],PARAMETER["Central_Meridian",-126],PARAMETER["Standard_Parallel_1",50],PARAMETER["Standard_Parallel_2",58.5],PARAMETER["False_Easting",1000000],PARAMETER["False_Northing",0],UNIT["Meter",1],AXIS["Easting",EAST],AXIS["Northing",NORTH]]

Thank you,

Will
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240624/c552096a/attachment.htm>