the following exception was recorded when we go to URL http://servername:8080/bpel-console/
org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Failed to execute query
With the root cause:
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
See full exception below. After enabling SQL logging, the SQL query causing the problem was found to be:
select distinct e.PROCESS_DEFINITION_ID from BPAF_EVENT as e
Oracle does not support the "AS" keyword in the format used by the BPEL-Console. The code is executing a native hibernate query against ORACLE which is not supported, see .
Search on "Oracle Feature" F312