search cancel

Specific filters on Activity Window causes ‘U00020568 Runtime error in object 'XACTIVITIES(GET)' error


Article ID: 87291


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
U00020568 Runtime error in object 'XACTIVITIES(GET)'

If a specific filter on the activity window is set.  An error occurs instead of displaying the activity window.


Using Automic version 11.2.

If following filter is set within the Activity Window filter criteria:

Objects: Everything except "Event","Report","Schedule"
Static: Everything except "Waiting for Predecessor", "Ended_Cancel"

The following error message is displayed.

Error: U00020568 Runtime error in object 'XACTIVITIES(GET)', line '00323'. DS return
code: '0000003590': 'U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ',
'42000', 'Incorrect syntax near the keyword 'or'.''. Error occurred in UCDSFUN
at position: 'DS_ACTIVITIES16'.

The Activity Window will not open until another filter or no filter is set.


Cause type:
Root Cause: An activity window with a filter where only a few stati are deactivated causes a runtime error in object 'XACTIVITIES(GET)’.


OS Version: N/A


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

Fix Status: Released

Fix Version(s):
Component(s): AE Server and Initialdata

Automation Engine 12.1.0 - Available
Automation Engine 12.0.3 - Available
Automation Engine 11.2.6 - Available

Additional Information

Workaround :
  1. Use another filter (add additional objects or stati to your filter).
  1. Do not use a filter.