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