Reporter template T1-2 Job Status with List of Anomalies fails when TAGS filter used

Products

• CA Automic Dollar Universe

Issue/Introduction

Affects Release version(s): 3

Error Message :
In the server.log:
==========================
[27 Sep 2012 15:13:45] Report generation in PENDING status
[27 Sep 2012 15:13:45] Report generation in RUNNING status
[27 Sep 2012 15:13:45] Report generation started with the following parameters: COMPANY = [PRE560], NODES = [*], TAGS = [CASINO], AREA = [X], APPLICATION = [*], MU = [*], SESS = [*], UPROC = [*], LANGUAGE = [en], START_DATE = [27/06/2012 15:13:45], END_DATE = [27/09/2012 15:13:45]
[27 Sep 2012 15:13:45] Process ABORTED. Status changed to ABORTED : Error executing SQL statement for : T1-2 Job Status with List of Anomalies
==========================

Patch level detected:Reporter 3.0.9
The Reporter template T1-2 Job Status with List of Anomalies fails when TAGS filter used

Cause

Cause type:
Defect
Root Cause: Reporter SQL filter did not have the right dbType set on it and in consequence the SQL queries that implied string concatenation were built like for oracle and therefore erroneous.

Environment

OS: All
OS Version: ALL OS

Resolution

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

Fix Status: Released

Fix Version(s):
Dollar Universe Reporter v3.0.10 - Available

Additional Information

Workaround :
N/A