U0003516 UCUDB: Affected lines in function 'UPDATE' = '-1'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

U0003516 UCUDB: Affected lines in function 'UPDATE' = '-1'

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

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.