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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Investigation

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.

Environment

OS Version: N/A

Cause

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

Resolution

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).

OR

2. Do not use a filter.