Adding Oracle ASM components to Service Builder results in Invalid query. Mismatched input error (4266173)

Invalid query. Mismatched input ‘equals’ expecting ‘)’ in query ‘DBO_xxxx’ where (is_rac equals ‘true’) Getting an error when trying to query for the entities to pull them into a Service. For example when trying to query for Clusters to add to a Service get the error. the error occurs on each of these categories

• ASM Clusters

• Clusters See the attachment

WORKAROUND

1. Make sure the login ID is part of the Cartridge Developers group
2. Configuration | Definitions | Select All Definitions | search for string "system:oracle.AsmClusters” |
3. Click ASM Clusters -> click Edit
4. Under the the Section:  Where: Path is_rac, hit the minus red icon to delete the condition.
5. Save
6. Repeat steps 3 – 5 for “system:oracle.Clusters
7. Return to Service Builder to test using default queries.

STATUS

This issue has been logged as FOG-770 and is waiting for fix in a future release of the Oracle cartridge.