Error when defining slope

[katie]

Hello there. I'm setting up my model and am in the process of trying
to define my slope. When I click on "Reclassify", I get the following
pop-up:

"Cannot open database 'CREAT TABLE[SlopeRemap] ( {OID] AUTOINCREMENT
NOT NULL ,[SlopeLo] DOUBLE, [SlopeHi] DOUBLE ,[SlopeClass] DOUBLE,
[SlopeName] TEXT(12));'. It may not be a database that our application
recognizes, or the file may be corrupt."

Any idea on what is causing this and how to go around this? After this
window is dismissed, I get an unhandled exception has occurred error.

Thanks,
Katie

[Pier Andrea Marras]

Hello! Did you solve this problem?

Thank you

P.

[Naresh Pai]

Try redoing the watershed delineation with DEM raster in integer (not float) format.

Naresh

[Zhiqiang Yu]

Hi Ketie,

Not sure what version of ArcSWAT you are using. 

Apparently it's a bug. In ArcSWAT 2009 doc P433, the definition of table SlopeRemap  could be found: this table contains the reclass table for the multiple slope classes. This table has four columns: SlopeLo, SlopeHi, SlopeClass and SlopeName. This part of your error message "CREAT TABLE[SlopeRemap] ( {OID] AUTOINCREMENT 

NOT NULL ,[SlopeLo] DOUBLE, [SlopeHi] DOUBLE ,[SlopeClass] DOUBLE, [SlopeName] TEXT(12))" is a SQL which is used to create this table in project database. However, from the error message, this SQL is used as a table name and try to this table. It certainly will crush. 

It should be easy to fix this bug. Please consider to report this to ArcSWAT team. Before they fix this, a possible solution would be: Try to create this table yourself in the database manually before soil reclassification. Use the table structure corresponding to the version of ArcSWAT you are using.

Best Wishes

Zhiqiang