Intelligent form fails when creating an entity with no errors in API log
Symptoms
An iForm fails when creating entities. However, all the entities are created and there are no errors in API log. The only error is in UI.
Error/warning messages
Error in UI:
Create Changepoint Request failed
Error in connector log:
....Error: Keyword not supported: 'provider'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)...
Reason
One of the connections strings in table "ConnectorSettings_BusinessUnit" in the Infiniti database is not in correct form.
Resolution
Remove the provider parameter from the connection string (highlighted by red font):
"Provider...SqlOledb... ;Password=... ; ...;"
After that the connection string should look like:
"Password=... ; ...;"