Symptoms
When attempting a DB Load, it aborts and you see the following line:
U0003516 UCUDB: Affected lines in function 'UPDATE' = '-1'
Cause
This is caused by the setting "no count" being active on the database engine (not the specific database). In SQL Server, this can be confirmed from within the management studio by going to properties --> connections on the database itself. You will see the "no count" selected within the default connection options.
Resolution
Automic requires count in order to check its installation procedures. Please have your DBA remove this setting from the default connection options.