Unable to creat tabel from Write SWAT Database

[Veena Choudhary]

Dear SWAT Users,

                            I am using latest version of SWAT 12.101.14 version with ArcMap 10.1. I am getting a error message whenever I try to create the SWAT database tables. The message is from ArcSWAT : The INSERT INTO statement contains the following unknown field name: PR_W11. Make sure you have typed the name correctly, and try the operation again.: IN.mWriteInputFiles.wgn.

Please help me to overcome from this error.

Thank you.

--

Regards,
Veena 

[Liem, Nguyen Duy]

Dear Veera,

Here's the solution that worked for me:
1) In your SWAT project folder, open the MS access file called SWAT2012.mdb.
2) In that file, there is a table called 'wgnrng'.  Open that table.
3) In the first column of that table (CRNAME), there are two entries 'PR_W1_' and 'PR_W2_'.  Change them to 'PR_W1' and 'PR_W2' respectively.

4) Open table called "WGEN_user". Rename all columns contain symbol 'PR_W1_' and 'PR_W2_' to 'PR_W1' and 'PR_W2'
5) Save the file and close.  When you reopen your SWAT project and try writing the SWAT tables again, it should work well (it worked for me at least).

I hope you succeed!

Liem

--
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 post to this group, send email to swat...@googlegroups.com.
Visit this group at http://groups.google.com/group/swatuser.
For more options, visit https://groups.google.com/d/optout.

--

Nguyễn Duy Liêm

Bộ môn Tài nguyên & GIS,

Khoa Môi trường & Tài nguyên,

Trường Đại học Nông Lâm TP. HCM.
Địa chỉ: phường Linh Trung, quận Thủ Đức, Tp. HCM, Việt Nam

Website:  http://gis.hcmuaf.edu.vn/ 
Email: nguyen...@gmail.com

          nguyen...@yahoo.com

Mobile: (+84) 0983-613-551

Nguyen Duy Liem

Department of Natural Resources and GIS, 

Faculty of Environment and Natural Resources

Nong Lam University- Ho Chi Minh City.
Address: Linh Trung Ward, Thu Duc District, Ho Chi Minh City, Vietnam.

Website:  http://gis.hcmuaf.edu.vn/  
Email: nguyen...@gmail.com

          nguyen...@yahoo.com

Mobile: (+84) 0983-613-551

[Zé]

Hello everyone.

Must start saying "Sorry for my poor english".

I am having this error and working hard for about 3 hours in a row.

Mister Liem, I tried to do as you say, but I got some doubt:

In the table "WGEN_user", there is a number that indicates the month just after the "_": 'PR_W1_' (January), ''PR_W1_2' (february)....

So you say to erase the last "_" ?

And as a "disembosom": please!!, everyone that got your doubts solved, come back and say here!
Your doubt may be one of somebody else!

I searched here at the forum, there is at least two orders topic and no return...

I thanks in advance.
Again, Sorry my poor english and mais disclaimer.

[Lalit Kumar Gehlot]

Hello Everyone

Just do the following:
Open SWAT2012.mdb database file >>go to Table 'wgnrng' >> In the first column of that table (CRNAME), there are two entries 'PR_W1_' and 'PR_W2_'.  Change them to 'PR_W1' and 'PR_W2' respectively.

Save the file and close.

Re-Run, Hope it will work.

Regards

Lalit Gehlot