Error: Data could not be saved. Cannot insert the value NULL into column 'PASSWORD', table 'EJDEVO.dbo.IMPORTSOURCE'; column does not allow nulls. UPDATE fails.

When trying to Edit the network directory import source for import files, this error occurs when trying to modify the path. 
Run the following statement in sql and enter the url path between the quotes.

update importsource
 set urlorpath=''

Environment

 Version 3.0, SP 9

Was this article helpful?