Going to venture a guess that this --> http://gerrit.ovirt.org/#/c/11411/is the fix for this ;) - DHC On Mon, Jan 28, 2013 at 3:40 PM, Dead Horse <deadhorseconsulting@gmail.com>wrote:
Seeing this error in engine log when attempting to create a new VM from the userportal: 2013-01-28 15:35:47,158 ERROR [org.ovirt.engine.core.bll.GetClustersWithPermittedActionQuery] (ajp--127.0.0.1-8702-5) Query GetClustersWithPermittedActionQuery failed. Exception message is PreparedStatementCallback; bad SQL grammar [select * from fn_perms_get_vds_groups_with_permitted_action(?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vds_groups" Where: PL/pgSQL function "fn_perms_get_vds_groups_with_permitted_action" line 3 at RETURN QUERY 2013-01-28 15:36:16,726 ERROR [org.ovirt.engine.core.bll.GetClustersWithPermittedActionQuery] (ajp--127.0.0.1-8702-7) Query GetClustersWithPermittedActionQuery failed. Exception message is PreparedStatementCallback; bad SQL grammar [select * from fn_perms_get_vds_groups_with_permitted_action(?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "vds_groups" Where: PL/pgSQL function "fn_perms_get_vds_groups_with_permitted_action" line 3 at RETURN QUERY
Current running engine build --> commit: 61c11aecc40e755d08b6c34c6fe1c0a07fa94de8
- DHC