I am getting this error all the time. I have clipped the DEM, NLCD and SURRGO using the same extent.
Traceback (most recent call last):
File "actions\import_gis.py", line 140, in insert_default
File "actions\import_gis.py", line 1031, in insert_hrus
ValueError: Soil "3025703" does not exist in your soils_sol table. Check your project in GIS and make sure all soils from the gis_hrus table exist in soils_sol.