Syntax Error in INSERT INTO Statement.:IN,mWriteInputFiles.Sol

Joseph Kyags

unread,

Jan 31, 2016, 10:55:42 AM1/31/16

to ArcSWAT

Dear All SWAT users

I kingly request for help with regards to this Error Syntax Error in INSERT INTO Statement.:IN,mWriteInputFiles.Sol, i can progress to next level.

thanks in advance

Writing Soil Input Error.jpg

issam achour

unread,

Jun 20, 2016, 9:06:09 AM6/20/16

to ArcSWAT

same problem help us plllllllllllllease

Teresa Heidemann

unread,

Jul 21, 2016, 5:22:09 AM7/21/16

to ArcSWAT

Hey Joseph,

did you solve your problem? I keep getting the exact same error messages..

I have checked my .sol and usersoil table in the SWAT2012 database over and over again, but cant find any empty fields or obvious format problems.

Hope to hear from you,

Teresa

Joseph Kyags

unread,

Jul 21, 2016, 5:33:44 AM7/21/16

to Teresa Heidemann, ArcSWAT

Dear Teresa

In your project folder there is SWAT2012 MS database file, if you open MS file and navigate to user soils table, you might have some negative values somewhere

I know that arcSWAT also does not accept empty spaces (put 0 instead).

Save your changes and write the soil files again hope that helps.

Joseph Kyagulanyi

Hydrologist/GIS Engineer

Air Water Earth Environmental and Civil Engineering Consultants

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To post to this group, send email to arc...@googlegroups.com.
Visit this group at https://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/d/optout.

Teresa Heidemann

unread,

Jul 21, 2016, 6:07:16 AM7/21/16

to ArcSWAT, heidema...@gmail.com

Dear Joseph,

thanks a lot for your quick reply!!

I have checked all the values but cant find any empty or negative value fields (I attached a link to google drive where you can find my SWAT2012.mbd). As I have been making quite a few changes to the data there are a lot of different (user)soil versions so don`t let that confuse you.. I would really appreciate your help, if you have a minute and could have a quick look into my data?

Thank you in advance!

Teresa

https://drive.google.com/file/d/0Bw8YSiHZkm2XZi11NkpCdlhUMGc/view?usp=sharing

Shehnaj Pathan

unread,

Jan 25, 2017, 12:36:56 PM1/25/17

to ArcSWAT, heidema...@gmail.com

I am having this error in ARC SWAT 2012. How to solve it?? Plz reply as soon as possible, bcz my xms r coming.

1.png

7.png

Shahid Baloch

unread,

Sep 20, 2018, 12:34:34 AM9/20/18

to ArcSWAT

Hi,

I am getting error "the field is too small to accept the amount of data you attempted to add. try inserting or pasting less data .: in ,mwriteinputfiles.sol". I have replaced all empty cell with zeros and also followed " https://zhiqiangyu.wordpress.com/2016/01/20/arcswat-error-try-inserting-or-pasting-less-data-in-mwriteinputfiles-sol/" but still getting the attached error any solution?

Error1.png

Joy Liu

unread,

Mar 26, 2019, 11:50:37 AM3/26/19

to ArcSWAT

圖片1.png

Hi, I have this question, too!

But I can not delete or edit the field, how can you do it?

THANKS A LOT

Joy Liu

Joseph Kyags於 2016年7月21日星期四 UTC+8下午5時33分44秒寫道：

Message has been deleted

Subhadeep Mandal

unread,

Oct 1, 2019, 6:44:44 AM10/1/19

to ArcSWAT

Solution: For syntax error in mWriteInputFiles.sol, Check 'usersoil' database table in SWATmdb. In that table, there are some columns exist with partially filled data. Either delete them or add values according your judgement. This cause syntax error.

Message has been deleted

Daniela Ribeiro

unread,

Sep 22, 2020, 10:29:29 PM9/22/20

to ArcSWAT

Hello, everyone.

I'm with the same problem as you. It appears: Syntax error in mWriteInputFiles.sol

I tried to complet the empty columns with zero and I saved the SWAT2012mdb.

But now I need to know where I can write this inside the SWAT Project. Was it in the beggining of the projet?

Or it updates automatically?

Because it still appears the same error....and just put the "zero" in the empty cells didn't resolve the problem....

Thanks in advance.

ramesh...@gmail.com

unread,

Dec 3, 2020, 12:51:14 AM12/3/20

to ArcSWAT

HI Daniel

Were you able to solve this issue?

Rasika

Abbie

unread,

Dec 3, 2020, 12:36:01 PM12/3/20

to ArcSWAT

I had this same issue, and the only fix I could find was in this thread:

https://groups.google.com/g/arcswat/c/y8tYHXSNNto/m/YPIRxA-4AwAJ

I had to download an older version of the SSURGO soils (which is linked in one of the responses), because the most recent version from 2020 seems to have some issues. Maybe this will work for you too

On Tuesday, September 22, 2020 at 9:29:29 PM UTC-5 danielarr...@gmail.com wrote:

ramesh...@gmail.com

unread,

Dec 3, 2020, 7:02:47 PM12/3/20

to ArcSWAT

Thanks so much for the response. I'll try that.

Rasika

ramesh...@gmail.com

unread,

Dec 3, 2020, 7:08:20 PM12/3/20

to ArcSWAT

That totally worked. Thanks so much for directing me there.

Rasika

On Thursday, December 3, 2020 at 11:36:01 AM UTC-6 Abbie wrote:

ay.r...@gmail.com

unread,

Mar 4, 2021, 6:27:24 PM3/4/21

to ArcSWAT

I am having the same problem. Can you please suggest to me the probable cause of this? and solution?

I have checked the user soil for empty or negative values but I see no issue with it.

kyong...@gmail.com

unread,

May 14, 2021, 1:16:01 PM5/14/21

to ArcSWAT

I solved this issue by using the swatvssurgo2019 version. However, I don't understand why swat ssurgo 2020 version caused this issue.

Kyongho

hafez ahmad

unread,

Sep 5, 2024, 2:38:57 PM9/5/24

to ArcSWAT

Nancy B. Sammons

unread,

Sep 6, 2024, 8:17:48 AM9/6/24

to hafez ahmad, ArcSWAT

I have also included the link for the 2019 SSURGO soils.

https://drive.google.com/file/d/1dL7a1BXYfhT3CAimji8yTMwBrtIZKmwQ/view?usp=sharing

From: Nancy B. Sammons
Sent: Friday, September 6, 2024 7:15 AM
To: 'hafez ahmad' <wfahydrol...@gmail.com>; ArcSWAT <arc...@googlegroups.com>
Subject: RE: [ArcSWAT:13619] Re: Syntax Error in INSERT INTO Statement.:IN,mWriteInputFiles.Sol

Hafez:

I was not able to click and see the file that you are using. I have attached the soil for 2019 which has helped others with this problem. I hope it does you as well.

Nancy

From: arc...@googlegroups.com <arc...@googlegroups.com> On Behalf Of hafez ahmad
Sent: Wednesday, September 4, 2024 11:20 AM
To: ArcSWAT <arc...@googlegroups.com>
Subject: Re: [ArcSWAT:13619] Re: Syntax Error in INSERT INTO Statement.:IN,mWriteInputFiles.Sol

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

On Friday, May 14, 2021 at 12:16:01 PM UTC-5 kyong...@gmail.com wrote:

I solved this issue by using the swatvssurgo2019 version. However, I don't understand why swat ssurgo 2020 version caused this issue.

Kyongho

On Thursday, March 4, 2021 at 3:27:24 PM UTC-8 ay.r...@gmail.com wrote:

I am having the same problem. Can you please suggest to me the probable cause of this? and solution?

I have checked the user soil for empty or negative values but I see no issue with it.

On Thursday, December 3, 2020 at 6:08:20 PM UTC-6 ramesh...@gmail.com wrote:

That totally worked. Thanks so much for directing me there.

Rasika

On Thursday, December 3, 2020 at 11:36:01 AM UTC-6 Abbie wrote:

I had this same issue, and the only fix I could find was in this thread:

https://groups.google.com/g/arcswat/c/y8tYHXSNNto/m/YPIRxA-4AwAJ

I had to download an older version of the SSURGO soils (which is linked in one of the responses), because the most recent version from 2020 seems to have some issues. Maybe this will work for you too

On Tuesday, September 22, 2020 at 9:29:29 PM UTC-5 danielarr...@gmail.com wrote:

Hello, everyone.

I'm with the same problem as you. It appears: Syntax error in mWriteInputFiles.sol

I tried to complet the empty columns with zero and I saved the SWAT2012mdb.

But now I need to know where I can write this inside the SWAT Project. Was it in the beggining of the projet?

Or it updates automatically?

Because it still appears the same error....and just put the "zero" in the empty cells didn't resolve the problem....

Thanks in advance.

Em terça-feira, 1 de outubro de 2019 às 07:44:44 UTC-3, smswa...@gmail.com escreveu:

Solution: For syntax error in mWriteInputFiles.sol, Check 'usersoil' database table in SWATmdb. In that table, there are some columns exist with partially filled data. Either delete them or add values according your judgement. This cause syntax error.

On Tuesday, 26 March 2019 21:20:37 UTC+5:30, Joy Liu wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/abddbf8e-bf26-47e6-bd3b-6c1b683e787an%40googlegroups.com.

Mamadou SARRA

unread,

Sep 15, 2024, 10:19:18 AM9/15/24

to Nancy B. Sammons, hafez ahmad, ArcSWAT

Hello, can anyone help me?
I am facing this problem "Error:- No value given for one or more required parameters" that Nancy had answered, but I don't know how to check the properties of the sol file as well as the source of the information concerned.

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/BN0P223MB0056D16E71DEAB7BB578344CB69E2%40BN0P223MB0056.NAMP223.PROD.OUTLOOK.COM.

Mamadou SARRA

unread,

Sep 19, 2024, 3:53:53 PM9/19/24

to Nancy B. Sammons, hafez ahmad, ArcSWAT

🙋

Mamadou SARRA a réagi depuis Gmail

Reply all

Reply to author

Forward