column "prf" does not belong to table .:rte file print error on Subbasin: 1

835 views
Skip to first unread message

Pouya Khalili

unread,
Mar 22, 2020, 3:47:47 AM3/22/20
to SWAT-user
Hi all,

Does anyone know how to solve this error in the write swat database tables files?
column "prf" does not belong to table .:rte file print error on Subbasin: 1

Thanks

GIS Quest

unread,
May 25, 2020, 9:43:59 AM5/25/20
to SWAT-user
If you got the solution, can u please help me?
thank you.
Message has been deleted

kindl...@gmail.com

unread,
Jan 17, 2021, 5:50:10 PM1/17/21
to SWAT-user

Hi All,

Has anyone found the solution for this? 

I tried 'database update' and then create the rte table. I did not receive any error but when I checked rte file additional parameters can be found in lines (line 26-30, see attached picture).
  
I think the problem is not fixed, and I would greatly appreciate it if users can provide me with suggestions.

Thank you! 
rte file error.jpg

Natalja C.

unread,
Jan 18, 2021, 2:21:49 AM1/18/21
to SWAT-user
Hello,
Could you show where exactly you are getting this error. I think you are talking about ArcSWAT interface and not swat.
Best,
Natalja
Message has been deleted

kindl...@gmail.com

unread,
Jan 18, 2021, 4:16:19 PM1/18/21
to SWAT-user
Hi Natalja,

Yes, this is about the ArcSWAT interface, and I am sorry if this is not the right place to post. I was following the thread to see if the original author or others could solve this error.

I am trying to set up a SWAT model using ArcGIS 10.5 and ArcSWAT 2012.10.5.24. 

I have successfully set up several SWAT models in the past using ArcGIS 10.3 and ArcSWAT2012.10.3.19., and this is the first time I encountered this error.

First, I received this error (column "prf" does not belong to table .:rte file print error on Subbasin: 1) when I tried to 'Write SWAT input tables.' 

Then, I tried 'database update' and then recreated the rte table (The approach I tried above was a suggestion I found on the ArcSWAT forum.)

Then, when I checked created *.rte files, four additional parameters can be found in lines (line 26-30, see attached picture).

After that, I was able to run the simulation without any issue, but I was wondering whether those additional parameters are supposed to be in the rte file or not. 

I said those four parameters were additional because when I used arcswat 2012.10.3.19 those four parameters were not in the SWAT2012.mdb file and were not written in the *.rte files.
 
I checked the SWAT2012.mdb stored in the ArcSWAT Databases folder (D:\SWAT\ArcSWAT\Databases; I installed ArcSWAT2012.10.5.24 on my D drive), and I found that below 'CH_EQN' there were 16 additional parameters in the 'rterng' tab.  

I guess that additional parameters were written in the *.rte file because they were in the arcswat 2012.10.5.24's SWAT2012.mdb. 

I checked the SWAT release note and I did not find any description about adding parameters in rte tab or file, so I am wondering whether I installed arcswat correctly or not.

I would appreciate it if you can provide me with any suggestions or comments as to how to solve this error.

Thank you.
Vincent
SWAT2012.mdb_2012.10.5.24.jpg
rte file error.jpg
SWAT2012.mdb_2012.10.3.19.jpg

Setareh Amini

unread,
Feb 17, 2022, 1:39:48 PM2/17/22
to SWAT-user
Dear Mr. Khalili,

Did you solve this problem? I have faced the same error and it would be my pleasure to guide me.

Thanks 
Setareh Amini

jorge.rd...@gmail.com

unread,
Dec 24, 2022, 10:31:13 AM12/24/22
to SWAT-user
Hi everybody how are you?

I have the same problem, someone was able to solve it, if you could guide me on how to solve it?

My SWAT worked very well on its own, I formatted my PC because it needed maintenance and I installed the same operating system (Windows 10), the same version of ArcMap (10.6) and its corresponding version, and run SWAT, with any project, in different zones gives me the same error and I don't know what it is due to if I did the installation correctly.

Greetings.

Ms. GIS

unread,
Jan 1, 2023, 5:04:08 AM1/1/23
to SWAT-user
don't use an old swat2012 database. The problem was able to solve it.

Vào lúc 22:31:13 UTC+7 ngày Thứ Bảy, 24 tháng 12, 2022, jorge.rd...@gmail.com đã viết:

Smriti Shrestha

unread,
Apr 14, 2023, 12:30:09 PM4/14/23
to SWAT-user
Hi everybody how are you?

I have the same problem, if someone was able to solve it, could you please guide me on how to solve it?

Nancy B. Sammons

unread,
Apr 17, 2023, 11:36:20 AM4/17/23
to Smriti Shrestha, SWAT-user

Smriti Shrestha:

Please review the link I have included from the ArcSWAT Google group.   

 

https://groups.google.com/g/arcswat/c/zbmCcci478o/m/yFVRpwPcAQAJ

 

Nancy

 

From: swat...@googlegroups.com <swat...@googlegroups.com> On Behalf Of Smriti Shrestha
Sent: Monday, April 10, 2023 2:26 AM
To: SWAT-user <swat...@googlegroups.com>
Subject: [SWAT-user:12454] Re: column "prf" does not belong to table .:rte file print error on Subbasin: 1

 

You don't often get email from shrestha...@gmail.com. Learn why this is important

--
You received this message because you are subscribed to the Google Groups "SWAT-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to swatuser+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/swatuser/3222e563-600a-4b6d-8e41-a350052f5b42n%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages