write SWAT database table error (Number of query values and destination fields are not the same)

Chris Yeo

unread,

May 27, 2021, 12:32:04 PM5/27/21

to ArcSWAT

Dear all,

I am a new SWAT user, so still struggling the SWAT Database Tables.

After creating HRUs, I have been trying to build up the Database Tables. However, for the soil data, I got the issue showing "Number of query values and destination fields are not the same.: IN.mWriteInputFiles.sol" I have tried to fix it for a long time, but I can't do it.

Kindly ask you to help😑

Chris

Screenshot 2021-05-26 172945.png

Nancy B. Sammons

unread,

May 27, 2021, 2:33:55 PM5/27/21

to Chris Yeo, ArcSWAT

Chris:

One thing to check…Ensure there are no empty (blank) fields in your table.

Nancy

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/73b0c4f6-2b94-4ef7-8aff-a3dcb9038065n%40googlegroups.com.

Aradhana Thakur

unread,

May 27, 2021, 2:46:16 PM5/27/21

to Nancy B. Sammons, Chris Yeo, ArcSWAT

Hii,

Which soil map you are using? If FAO thn copy paste soil database into arcswat\database\swat2012.mdb\usersoil.

May be it will solve your problem.

To view this discussion on the web visit https://groups.google.com/d/msgid/arcswat/BYAPR04MB53521A76AF976BFD4185C0A0B6239%40BYAPR04MB5352.namprd04.prod.outlook.com.

Laura Marcela Hernandez Julio

unread,

Nov 4, 2021, 8:23:12 AM11/4/21

to ArcSWAT

Hi Chris!! I'm facing the same problem and i've checked if i do have blank spaces but i don't, did you solve it?

I need to solve it asap

Este correo no representa opinión o consentimiento oficial de la Universidad del Norte, por lo que esta no adquiere ninguna responsabilidad por su contenido, salvo en el caso de funcionarios en ejercicio de atribuciones reglamentarias. Puede provenir de una cuenta ofrecida a funcionarios o estudiantes, como parte del ejercicio educativo, evento en el cual tanto el mensaje como sus anexos son estrictamente confidenciales. Ha sido analizado con software antivirus; no obstante, no se garantiza que sea seguro o no contenga errores o virus, por lo que la Universidad del Norte no se hace responsable de su transmisión.

Message has been deleted

Laura Marcela Hernandez Julio

unread,

Nov 8, 2021, 8:25:59 AM11/8/21

to ArcSWAT

Hello!! I solved the problem. You have to check the number of columns and rows of your usersoil database. The original one have 152 columns (if you check from excel the final column is EV) and 4932 rows. Maybe you're adding more that 4932 rows to your database. What i did was to replace 3 rows with my information to keep the real number of rows allow.

Regards

El sábado, 6 de noviembre de 2021 a las 8:33:32 UTC-5, Laura Marcela Hernandez Julio escribió:

Hello!! I solved the problem. You have to check the number of columns and rows of your usersoil database. The original one have 152 row (if you check from excel the final row is EV) and 4932 columns. Maybe you're adding more that 152 rows to your database. What i did was to replace 3 rows with my information to keep the real number of rows allow.

Regards

Kelly Oliveira

unread,

Jul 27, 2023, 3:17:15 PM7/27/23

to ArcSWAT

Hi.

I solved it changing the language definition to English (EUA) and the Regional data format to English (EUA) too.