QSWAR+ Errors

Zoe Nikolaou

unread,

Mar 21, 2022, 8:57:52 AM3/21/22

to QSWAT+

When i press read in HRUs the following error occured:

"No data for landuse WTR"

I must modify the sqlite database ?

Also when i upload the user soil file the following error occured:

Could not write to table Liopetri_usersoil in database C:/SWAT/test6\test6.sqlite from file //10.0.1.250/ATLANTiS/liopetri/like_example/Liopetri_usersoil.csv: Traceback (most recent call last):

File "C:\Users/ZoeNikolaou/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QSWATPlus3_9\QSWATPlus\DBUtils.py", line 2667, in importCsv cursor.execute(sql, tuple(line)) sqlite3.IntegrityError: UNIQUE constraint failed: Liopetri_usersoil.SNAM

Any help ?

Thanks in advance

Henrike Vogelsang

unread,

Jul 21, 2022, 9:54:09 AM7/21/22

to QSWAT+

Hi everyone,

I get the same error message. Did you solve the problem or did anyone else?

Thanks!

Chris George

unread,

Jul 21, 2022, 1:42:22 PM7/21/22

to Henrike Vogelsang, QSWAT+

Do you have WTR as a landuse in your lookup table, instead of WATR?

It looks like your usersoil csv file has a repeated name in the SNAM column.

Chris

On 7/21/2022 2:54 PM, 'Henrike Vogelsang' via QSWAT+ wrote:
> Hi everyone,
>
> I get the same error message. Did you solve the problem or did anyone else?
>
> Thanks!
>
> znic...@gmail.com schrieb am Montag, 21. März 2022 um 13:57:52 UTC+1:
>
> When i press read in HRUs the following error occured:
>
> "No data for landuse WTR"
>
> I must modify the sqlite database ?
>
> Also when i upload the user soil file the following error occured:
>
> Could not write to table Liopetri_usersoil in database
> C:/SWAT/test6\test6.sqlite from file
> //10.0.1.250/ATLANTiS/liopetri/like_example/Liopetri_usersoil.csv

> <http://10.0.1.250/ATLANTiS/liopetri/like_example/Liopetri_usersoil.csv>:

> Traceback (most recent call last):
>
> File
> "C:\Users/ZoeNikolaou/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QSWATPlus3_9\QSWATPlus\DBUtils.py",
> line 2667, in importCsv cursor.execute(sql, tuple(line))
> sqlite3.IntegrityError: UNIQUE constraint failed: Liopetri_usersoil.SNAM
>
> Any help ?
>
> Thanks in advance
>

> --
> You received this message because you are subscribed to the Google
> Groups "QSWAT+" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to qswatplus+...@googlegroups.com
> <mailto:qswatplus+...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/qswatplus/bdcb8942-679c-4285-b076-dad2375eabdfn%40googlegroups.com
> <https://groups.google.com/d/msgid/qswatplus/bdcb8942-679c-4285-b076-dad2375eabdfn%40googlegroups.com?utm_medium=email&utm_source=footer>.

Reply all

Reply to author

Forward