When configuring a CA Identity Manager PX Policy, Policy Xpress crashes with an error:
ERROR MESSAGE: Echec de l'exécution de la requête
; Failed to execute prepared statement: SELECT '30/09/2020 11:01:18' on data source: java:/iam/im/jdbc/jdbc/iam_custom. Exception: ORA-00923: FROM keyword not found where expected
; ORA-00923: FROM keyword not found where expected
; ORA-00923: FROM keyword not found where expected
The query runs OK against Oracle for iSQL
Release : 14.3 CP2
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
in iSQL the end of each query is closed with a semi-colon ";" but CA Identity Manager (IM) does not need the character. Omitting the character allows the query to execute as expected.