Enterprise Dashboard shows loading and ORA-00907 is shown in the log

Document ID : KB000098200
Last Modified Date : 15/02/2019
Show Technical Document Details
After configuring the Enterprise Dashboard for Oracle, when bringing up the Enterprise Dashboard in the browser, the section 'Total Transactions/Virtual Services for non-performance VSEs' remains greyed out and shows loading.

The following error can be seen at regular intervals in the enterprise dashboard.log:
2018-04-13 03:41:23,239Z (15:41) [qtp359985955-53] ERROR com.ca.dradis.controller.LicensingController - Failed to process request:
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis 
DevTest 10.3 Enterprise Dashboard configured for Oracle.
A patch is available from support by logging a support case on support.ca.com and referring to defect DE363456

Note: If you have patch DE393024 installed, then ask refer to defect DE401879 instead.