Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ValueError als ik "sqlite tests" run #165

Open
leendertvanwolfswinkel opened this issue Apr 3, 2024 · 1 comment
Open

ValueError als ik "sqlite tests" run #165

leendertvanwolfswinkel opened this issue Apr 3, 2024 · 1 comment

Comments

@leendertvanwolfswinkel
Copy link
Contributor

leendertvanwolfswinkel commented Apr 3, 2024

Onderstaande error krijg ik als ik in het tabje Checks op Sqlite tests klik. De error verschijnt als het proces klaar is (of andersom natuurlijk).

Daarna krijg ik de melding "Taak bereken ondoorlatend oppervlak model en polder onderbroken"

Daarna krijg ik een popup "OSError"

image

Daarna krijg ik nog een popup "OSError"

image

Sqlite die ik gebruik:

bwn_valkkoog.zip

De eerste error:

ValueError: cannot reindex from a duplicate axis
Traceback (most recent call last):
  File "C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python/plugins\hhnk_threedi_plugin\tasks\sqlite_test_tasks\base_sqlite_test_task.py", line 81, in finished
    raise self.exception
  File "C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python/plugins\hhnk_threedi_plugin\tasks\sqlite_test_tasks\base_sqlite_test_task.py", line 38, in run
    self.run_custom()
  File "C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python/plugins\hhnk_threedi_plugin\tasks\sqlite_test_tasks\sqlite_test_tasks.py", line 326, in run_custom
    self.gdf = self.sqlite_test.run_cross_section_no_vertex(database=self.database)
  File "C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default\python\plugins\hhnk_threedi_plugin\external-dependencies\hhnk_threedi_tools\core\checks\sqlite\sqlite_main.py", line 520, in run_cross_section_no_vertex
    cross_no_vertex.loc[:, ["distance_to_vertex"]] = nearest_point.apply(get_distance, axis=1)
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\indexing.py", line 670, in __setitem__
    iloc._setitem_with_indexer(indexer, value)
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\indexing.py", line 1642, in _setitem_with_indexer
    value = self._align_series(indexer, value)
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\indexing.py", line 1935, in _align_series
    return ser.reindex(new_ix)._values
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\series.py", line 4399, in reindex
    return super().reindex(index=index, **kwargs)
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\generic.py", line 4461, in reindex
    return self._reindex_axes(
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\generic.py", line 4481, in _reindex_axes
    obj = obj._reindex_with_indexers(
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\generic.py", line 4524, in _reindex_with_indexers
    new_data = new_data.reindex_indexer(
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\internals\managers.py", line 1276, in reindex_indexer
    self.axes[axis]._can_reindex(indexer)
  File "C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3289, in _can_reindex
    raise ValueError("cannot reindex from a duplicate axis")
ValueError: cannot reindex from a duplicate axis


Python version: 3.9.5 (tags/v3.9.5:0a7dcbd, May  3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] 
QGIS version: 3.28.5-Firenze Firenze, 50adba36f2 

Python Path:
C:/PROGRA~1/3DIMOD~1.28/apps/qgis-ltr/./python
C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python
C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python/plugins
C:/PROGRA~1/3DIMOD~1.28/apps/qgis-ltr/./python/plugins
C:\PROGRA~1\3DIMOD~1.28\apps\grass\grass82\etc\python
C:\Program Files\3DiModellerInterface 3.28\apps\qgis-ltr\resources
C:\PROGRA~1\3DIMOD~1.28\bin\python39.zip
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\DLLs
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib
C:\PROGRA~1\3DIMOD~1.28\bin
C:\Users\lvanwolfswinkel\AppData\Roaming\Python\Python39\site-packages
C:\Users\lvanwolfswinkel\AppData\Roaming\Python\Python39\site-packages\win32
C:\Users\lvanwolfswinkel\AppData\Roaming\Python\Python39\site-packages\win32\lib
C:\Users\lvanwolfswinkel\AppData\Roaming\Python\Python39\site-packages\Pythonwin
C:\PROGRA~1\3DIMOD~1.28\apps\Python39
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\win32
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\win32\lib
C:\PROGRA~1\3DIMOD~1.28\apps\Python39\lib\site-packages\Pythonwin
C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default/python
C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default\python\plugins\ThreeDiToolbox\deps
C:\Users\lvanwolfswinkel\AppData\Roaming\3Di\QGIS3\profiles\default\python\plugins\hhnk_threedi_plugin\external-dependencies
.
C:\Program Files\3DiModellerInterface 3.28\apps\qgis-ltr
C:\Program Files\JetBrains\PyCharm 2022.3.2\debug-eggs\pydevd-pycharm.egg
//corp.hhnk.nl/data/Hydrologen_data/Data/personen/sovermeen
@leendertvanwolfswinkel
Copy link
Contributor Author

Ik denk dat het probleem met de OSErrors ontstaat zodra er lagen uit de genoemde geopackages aan het QGIS project zijn toegevoegd en je dan de checks opnieuw runt. Die lagen zouden door de tool eerst moeten worden verwijderd

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant