Error with transformation in URock

[hannahzd]

Hello,

I am using the URock plug in on QGIS 3.40.9 with java version "1.8.0_461"and javac 17.0.16. The processor runs for some time however then threw up this error message:

Traceback (most recent call last):
File "JdbcPreparedStatement.java", line 256, in org.h2.jdbc.JdbcPreparedStatement.execute
java.lang.java.lang.IllegalArgumentException: java.lang.IllegalArgumentException: No transformation found from epsg:27700 to epsg:4326

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "JdbcPreparedStatement.java", line 256, in org.h2.jdbc.JdbcPreparedStatement.execute
Exception: Java Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\Users\hanna\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 534, in execute
is_rs = self._prep.execute()
^^^^^^^^^^^^^^^^^^^^
org.h2.jdbc.org.h2.jdbc.JdbcSQLNonTransientException: org.h2.jdbc.JdbcSQLNonTransientException: Exception calling user-defined function: "ST_Transform(conn21893765: url=jdbc:default:connection user=SA, POINT (531617.3468515133 105285.89022482565), 4326): No transformation found from epsg:27700 to epsg:4326"; SQL statement:

SELECT ST_X(THE_GEOM) AS LON, ST_Y(THE_GEOM) AS LAT FROM
(SELECT ST_TRANSFORM(ST_SETSRID(THE_GEOM,27700), 4326) AS THE_GEOM FROM [90105-232]

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users/hanna/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\processor\urock_processing_algorithm.py", line 454, in processAlgorithm
MainCalculation.main(javaEnvironmentPath = javaEnvVar,
File "C:\Users/hanna/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\functions\URock\MainCalculation.py", line 828, in main
saveData.saveBasicOutputs(cursor = cursor , z_out = z_out,
File "C:\Users/hanna/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\functions\URock\saveData.py", line 52, in saveBasicOutputs
cursor.execute("""
File "C:\Users\hanna\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 536, in execute
handle_sql_exception()
File "C:\Users\hanna\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init.py", line 165, in handle_sql_exception_jpype
reraise(exc_type, exc_info[1], exc_info[2])
File "C:\Users\hanna\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init.py", line 57, in reraise
raise value.with_traceback(tb)
File "C:\Users\hanna\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 534, in execute
is_rs = self._prep.execute()
^^^^^^^^^^^^^^^^^^^^
jaydebeapi.DatabaseError: org.h2.jdbc.JdbcSQLNonTransientException: Exception calling user-defined function: "ST_Transform(conn21893765: url=jdbc:default:connection user=SA, POINT (531617.3468515133 105285.89022482565), 4326): No transformation found from epsg:27700 to epsg:4326"; SQL statement:

SELECT ST_X(THE_GEOM) AS LON, ST_Y(THE_GEOM) AS LAT FROM
(SELECT ST_TRANSFORM(ST_SETSRID(THE_GEOM,27700), 4326) AS THE_GEOM FROM [90105-232]

Execution failed after 2630.48 seconds (43 minutes 50 seconds)

[j3r3m1]

27700 coordinate system seems not known by the H2GIS database system we use for most of the URock calculations. I will suggest the H2GIS community to add this EPSG code but for now you can simply transform your data into a standard UTM (32630 or 32631 I suppose based on the 27700 coordinate system location) and then run again.

By the way, 43 minutes is quite a long run. What is the vertical and horizontal resolution you have used and size of your study area ?

[j3r3m1]

An issue has been added on the H2GIS repo: orbisgis/h2gis#1448

[hannahzd]

Thank you, transforming into 32360 solved the issue. Study area is quite large - just over 1km x 1km and this was a 2m resolution run. The successful run was just under an hour.

[j3r3m1]

It should now be OK to directly run in the 27700 coordinate system (cf. orbisgis/h2gis#1448 (comment))