ORA-00907:DevTest 10.3 Enterprise Dashboard configured to use Oracle database throws errors

Document ID : KB000097646
Last Modified Date : 29/05/2018
Show Technical Document Details
Issue:
DevTest 10.3 Enterprise Dashboard configured to use Oracle 11G database, getting below error:  ORA-00907: missing right parenthesis 

2018-05-16 17:01:47,354Z (13:01) [qtp833320357-20] WARN groovy.sql.Sql - Failed to execute: SELECT * FROM(SELECT comp_uuid, metric_class, SUM(metric_value) AS metric_sum, MAX(metric_value) AS metric_max FROM (SELECT metric_uuid, reg_uuid, comp_uuid, metric_class, metric_tm, metric_value, metric_typ,(SELECT count(m.comp_uuid) FROM metric m JOIN component c ON m.comp_uuid = c.comp_uuid JOIN comp_attr attr ON c.comp_uuid = attr.comp_uuid WHERE (m.metric_uuid = outer_m.metric_uuid) AND ( (m.metric_tm > attr.start_tm AND m.metric_tm <= attr.end_tm) or (m.metric_tm > attr.start_tm AND attr.end_tm is null) ) ) AS perf_mode FROM metric outer_m)AS metric WHERE metric_tm > :start AND metric_tm < :end AND ( metric_class = 'com.itko.lisa.coordinator.VirtualServiceCoordinator.global.transactionsInLastHour' OR metric_class = 'com.itko.lisa.coordinator.VirtualServiceEnvironmentImpl.models.maxNumberOfDeployedModelsLastHour' ) AND perf_mode = :performanceOnly GROUP BY comp_uuid, metric_class) AS vsetotals JOIN component ON vsetotals.comp_uuid = component.comp_uuid because: ORA-00907: missing right parenthesis 

2018-05-16 17:01:47,368Z (13:01) [qtp833320357-20] ERROR com.ca.dradis.controller.LicensingController - Failed to process request: 
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
Environment:
DevTest 10.3 
Oracle 11G or 12C Database
Resolution:
Please open a ticket with CA Support.  We have a patch for this issue.

Note: please reference DE363456 in the description when requesting the patch.