Previewing a SQL Variable object fails with U0000062 Cannot continue after connection interruption

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
Error: U0000062 Cannot continue after connection interruption.

After defining a very simple SQL Variable (SQL.VARA) statement, if the object is previewed the following error messages are displayed.
 

Error: U0000062 Cannot continue after connection interruption.

20170825/104645.547 - U2012011 Using existing database connection to vwgsup14:1521 (user uc4).
20170825/104645.547 - U2012042 Query '2069881/1': 'select OH_NAME from OH'
20170825/104645.828 - U2012044 Number of returned lines: '10988' for RunID '2069881/1'.
20170825/104645.828 - U2012036 Query with RunID '2069881' ended normally.
20170825/104645.859 - U2000010 Connection to Server '/192.168.115.179:10501' terminated.
20170825/104645.859 - java.io.IOException: An existing connection was forcibly closed by the remote host

Investigation:

1. Create a simple SQL.VARA using:

select * from OH

2. Press Preview

Results:

Actual:  The above error message is displayed.

Expected:  The results of the select should be diplayed.

If a more complex statement is defined in the SQL.VARA object, such as:
 

select OH_NAME from OH where OH_NAME like 'CONN%'

The preview button will work and will display the correct results.

Environment

OS Version: N/A

Cause

Cause type:
Other
Root Cause: 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.0 - Available

Additional Information

Workaround :

1. Modify the simple SQL statement so that it is more complex to avoid the error

OR

2. Filter the statement.