SSURGO Soils Database Error

[Matthew Lombardo]

Hi everyone,

Thank you for responding to my previous posts! I was able to troubleshoot with some help from internal people at UConn. I having two errors with my soil raster right now, where the error messages are below. The first problem is an error where every time QSWAT reads my SSURGO soil raster, I am told that a soil type is not contained in the swatplus_soils.sqlite file. I am troubleshooting this myself to changing the soil ID's to the most similar soil, but I'm not sure how to fix the send error codes? Can someone help me solve the second error code first, and if willing also help with the first error code? I've also attached my soil raster and a picture of my inputs on QGIS.

Error:

2025-09-06T13:27:41     CRITICAL    
             SSURGO soil 3400324 (and perhaps others) not defined in ssurgo table in database C:\Users\matth\SWATPlus\Databases\swatplus_soils.sqlite. soils_sol table incomplete.
             See QSWAT+ log messages for full list of undefined soils.

2025-09-06T13:28:05     CRITICAL    Could not create soils_sol and soils_sol_layer tables from ssurgo table in soil database C:\Users\matth\SWATPlus\Databases\swatplus_soils.sqlite: Traceback (most recent call last):
              File "C:\Users/matth/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\QSWATPlus\QSWATPlus\DBUtils.py", line 1048, in writeSoilsTable
              errorReported = not self._gv.isBatch
              ^^^^^^^^
             AttributeError: 'DBUtils' object has no attribute '_gv'

Thank you for the help!

[Chris George]

The first error I cannot comment on, but the second is a typo in
DBUtils.py. The simplest way to avoid this (pending a new release) is
for you to edit the file: you can see the path in the error message.
Open it in a text editor like Notepad, and change line 1048 to

errorReported = not self.isBatch

Thanks,
Chris

On 9/6/2025 6:43 PM, Matthew Lombardo wrote:
> Hi everyone, Thank you for responding to my previous posts! I was able
> to troubleshoot with some help from internal people at UConn. I having
> two errors with my soil raster right now, where the error messages are
> below. The first problem is

> ZjQcmQRYFpfptBannerStart
> This Message Is From an External Sender
> This message came from outside your organization.
> ZjQcmQRYFpfptBannerEnd

> --
> 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 visit https://groups.google.com/d/msgid/
> qswatplus/850cd285-2c52-4c76-ac63-8b835174d005n%40googlegroups.com
> <https://urldefense.com/v3/__https://groups.google.com/d/msgid/
> qswatplus/850cd285-2c52-4c76-ac63-8b835174d005n*40googlegroups.com?
> utm_medium=email&utm_source=footer__;JQ!!KwNVnqRv!
> AZys_F58imOuCnPsZ9JrMh5DFNeja6AAN2P0x36AZYeGrECNXd1vucJCkyi-
> ydcy2A0gql3Ht372njpaEi-9eGbLwQ$>.