WP crash executing a Precondition containing a DB VARA

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

A Precondition was set on a Task in a Workflow that contained a wrong condition.

The condition compared the result of an SQL select statement in a DB VARA with a number.

IF {VARA.SQL.TO.DB.SERVICE} > 0

  FINALLY run task

where VARA.SQL.TO.DB.SERVICE contains:

select * from TABLE...

If the VARA contains a select count statement this works correctly:

select count(*) from TABLE...

e 

Cause

This is a defect, the WP should not crash

Resolution

Workaround 

Fix the statement in the DB VARA

Solution

This issue will be fixed in a future version

Additional Information

The reference for the fix is DE165628