Preview SQL_SEC VARA with no CONN object causes forced trace

Document ID : KB000095059
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
SEC_SQL Variable Object is created. The SQL Statement is already entered in the according field, but no Connection Object is supplied in field Connection. Please see the screenshots below for an examples from AWI and Java GUI.
 
User-added image

User-added image

If you click Preview now, the following happens in different versions and interfaces:

V11 and below, Java GUI:
No preview is displayed, but also no error message. On WP, a forced trace is created. All further attempts to make a preview fail with error message:
 
U00020306 It is only possible to get one preview at a time.

The Java GUI must be restarted to make previews work again.

V12.0.3, Java GUI:
In the Message list, the following error messages appear:

03.11.2017 09:49:51    U00015006 System forced memory trace dump.
03.11.2017 09:49:51    U00005118 Program error: Database access via key 'EH_AH_Idnr' with value 0 in module 'UCDVAR_R'.
03.11.2017 09:49:51    U00011801 Error in Server routine 'UCDVAR_R', Server: 'SO12#W03' AE system: 'SO12'.
 
On WP, a forced trace is created. All further attempts to make a preview fail with error message:
 
U00020306 It is only possible to get one preview at a time.

The Java GUI must be restarted to make previews work again.

V12.0.3, AWI:
The behavior is mostly like in the Java GUI. However, after the first attempt to make a Preview, the Preview-Button is grayed out.
You must log out of the AWI and in again to make previews work again.

V12.1 and above, AWI:
Here it works as expected. When you click Preview an error message is displayed because of the missing Connection Object.
 
Object '' with type 'CONN' does not exist in client '00022'.
Cause:
An error has been fixed where a PREVIEW of a variable with type SEC_SQL results in a forced trace if no connection is set. Error message is:
U00005118 Program error: Database access via key 'EH_AH_Idnr' with value 0 in module 'UCDVAR_R'.
Resolution:
Install the fixed version or a newer one:
 
AE Server, Initialdata and Automic.Web.Interface or Java GUI
  • Automation Engine 12.0.4 - Available
  • Automation Engine 11.2.8 - Planned release date: 2018-06-05