Symptoms

During the Data Set update from the Database, the following issue appeared:
Data provider or other service returned an E_FAIL status

Cause

One of the known reasons for this behavior is that the datatype in the Database Column type is set to varchar(max):

Resolution

The column type should be limited (varchar(255) or less) or a different type should be used (nvarchar(max) or text for example).