Conversion from type 'DBNULL' to type 'String' is not valid.: IN, mWriteInputFiles.mgt

1,357 views
Skip to first unread message

Madusanka Thilakarathne

unread,
Jan 2, 2014, 7:55:53 AM1/2/14
to swat...@googlegroups.com
I am using SWAT to simulate streamflow.

When writing input tables (management),
This error occurred.

Is there anyone who got this ?

Thanks and Happy new year for all

Fillipe Tesch

unread,
Mar 30, 2014, 6:33:33 PM3/30/14
to swat...@googlegroups.com
I'm having the same problem.

I'm stuck on this step.

Anyone else can help?

Zhiqiang Yu

unread,
Mar 31, 2014, 4:06:49 PM3/31/14
to swat...@googlegroups.com
ArcSWAT is trying to convert DBNULL to a String. DBNULL is usually related to an empty value in the database. So, try to open the project access database and check any empty fields and give some value and then try to write the input tables again.

Good luck.

zohreh rajaee

unread,
Jul 17, 2015, 7:27:07 AM7/17/15
to swat...@googlegroups.com
Hello
I have the same problem. Also  I got this error when  I was writing my database tables in the ArcSWAT interface. "
Conversion from type 'DBNULL' to type 'String' is not valid.: IN, mWriteInputFiles.mgt
This topic is a duplicate of another discussion.
You were redirected here from a duplicate topic.
 please guide me.
"
Please guide me.

Emad Mahjoobi

unread,
May 7, 2016, 1:27:16 AM5/7/16
to SWAT-user
Hi Zohreh

I'm having the same problem.
I'm stuck on this step.
Could I possibly ask you a favor to guide me through this issue?!

Emad Mahjoobi

unread,
May 7, 2016, 1:29:30 AM5/7/16
to SWAT-user
Hi Fillipe

I'm having the same problem.
I'm stuck on this step.
Could I possibly ask you a favor to guide me through this issue?!

Emad

Emad Mahjoobi

unread,
May 7, 2016, 1:30:27 AM5/7/16
to SWAT-user
Hi  Madusanka

I'm having the same problem.
I'm stuck on this step.
Could I possibly ask you a favor to guide me through this issue?!

Emad



Arcadius Degan

unread,
Feb 16, 2017, 6:17:40 AM2/16/17
to SWAT-user
Hello everybody
I had the same stuck issue. Had someone finally resolve it?
if yes could him please share it with us?
regards
Arcadius

Bankim Joshi

unread,
Jul 23, 2017, 3:01:20 AM7/23/17
to SWAT-user
Dear Zhiqiang Yu
 
I have checked all my database file, i.e. mgt1rng, mgt2rng , mgtdate, mgrscs all data have value that means no empty field, though errornoccurs, Here is the screenshot.
thanks and regards
Bankim joshi
error3.png

P Dutta

unread,
Mar 6, 2018, 2:29:58 AM3/6/18
to SWAT-user
Hi,
How did you solve the error "Conversion from type 'DBNULL' to type 'String' is not valid.: IN, mWriteInputFiles.mgt"?
I am facing the same one......... Please guide me.

Chinmaya Panda

unread,
Mar 7, 2018, 2:04:28 AM3/7/18
to SWAT-user
Check your text file for precipitation, temp and others and make sure that there should not any blank space between them. You please check the last data of your text file.Any space after or before can cause the error.

nesarna...@gmail.com

unread,
Jan 30, 2019, 1:29:02 AM1/30/19
to SWAT-user
you have to check database/crop table, maybe few empty cells there and also maybe the last column OpSchedule is missed, mine was like that.
Reply all
Reply to author
Forward
0 new messages