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

Document ID : KB000085074
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
  1. 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
  1. Filter the statement.