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

Document ID : KB000087291
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
  1. Do not use a filter.