Return
-
Title
Adding Oracle ASM components to Service Builder results in Invalid query. Mismatched input error -
Description
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
-
Cause
Query not support condition Where is_rac "equals" true in the service builder. While adding Oracle > Clusters and ASM Clusters. -
Resolution
WORKAROUND
- Make sure the login ID is part of the Cartridge Developers group
- Configuration | Definitions | Select All Definitions | search for string "system:oracle.AsmClusters” |
- Click ASM Clusters -> click Edit
- Under the the Section: Where: Path is_rac, hit the minus red icon to delete the condition.
- Save
- Repeat steps 3 – 5 for “system:oracle.Clusters
- 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.
-
Defect ID
FOG-770