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

book

Article ID: 87291

calendar_today

Updated On:

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.

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

Environment

OS Version: N/A

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
  1. Do not use a filter.