Reporter template T1-2 Job Status with List of Anomalies fails when TAGS filter used
book
Article ID: 85945
calendar_today
Updated On:
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