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

Document ID : KB000085945
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
Environment:
OS: All
OS Version: ALL OS
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.
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