Error getting SRS from Database

[andreasborgardt]

Hi,

i'm runnig Postgresql 13.8 with PostGIS 3.1.4 on Debian 8.4. When I try to use your Plugin the following error occurs in QGIS.

QGIS-Log:

File "C:\Users/........../AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\db\postgresql.py", line 157, in srs
cursor.execute(SQL)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

         During handling of the above exception, another exception occurred:
         
         Traceback (most recent call last):
          File "C:\Users/aborgardt/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\citydb_explorer_dockwidget.py", line 130, in _database_connection
          self.srs = self.db_interface.srs
          File "C:\Users/........../AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\db\postgresql.py", line 159, in srs
          raise PostgreSQLInterfaceException("Error getting SRS from Database")
         3dcitydb-qgis-explorer-master.db.postgresql.PostgreSQLInterfaceException: Error getting SRS from Database

Importer/Exporter-Log:

[15:33:43 INFO] SRID: 25832 (Projected)
[15:33:43 INFO] gml:srsName: urn:ogc:def:crs,crs:EPSG::25832,crs:EPSG::7837

The table database_srs ist filled. It seems to be everything alright...

Best Andreas

[muratkendir]

@andreasborgardt It seems like project variables confused about path at:
"C:\Users/aborgardt/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\citydb_explorer_dockwidget.py"

Did you tried to use on a new project created on Debian system or do you using an existing project, which created on a windows machine?

Note: I tested same extension on Ubuntu without any connection problem.