search cancel

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


Article ID: 85074


Updated On:


CA Automic Workload Automation - Automation Engine


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 '/' terminated.
20170825/104645.859 - An existing connection was forcibly closed by the remote host

  1. Create a simple SQL.VARA using:
select * from OH
  1. Press Preview

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.


OS Version: N/A


Cause type:
Root Cause: N/A


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
  1. Filter the statement.