Use of same escape character for Column separator and Substitute character causes System failure

book

Article ID: 84967

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
N/A

For a SQL Job, in the SQL tab, both Column separator and Substitute character are filled with a "," (comma):
 

<Please see attached file for image>

0EMb0000001UwVp.png

If a SQL statement is executed using those default values, the job does not finish and the DB Service Agents spikes to 100% CPU. The Job becomes unresponsive and must be canceled manually.

Cause

Cause type:
Defect
Root Cause: The SQL Agent gets into an endless loop if the Column separator and the Substitute character are the same.

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.0 – Available
Automation Engine 12.0.2 – Available
Automation Engine 11.2.5 - Available

Additional Information

Workaround :
Use another character such as the " ;" (semi-colon) for either the Column separator value or the Substitute character value.

Attachments

1558693264177000084967_sktwi1f5rjvs16m4z.png get_app