How to resolve the Error: System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName while using Database Activity

How to resolve "System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName" problem while using Database Activity

While executing workflow which is going to update some value into the database, it throws an warning Error: “System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName”.

  1. Database connect activity is getting the ProviderName property as null or empty. For resolving this, initialize ProviderName property as "System.Data.SqlClient" or mention it in connectionString
  2. If you are trying to insert or update a column value with a null value which is declared as NOT NULL in Database, either allow column to accept NULL or send a not null value (an empty string) to resolve it.
The two possible causes:
  • Database connect" activity is getting the ProviderName property as null or empty
  • the attempt to insert or update a column value with a null value which is declared as NOT NULL in Database