<div dir="ltr"><div>Going to venture a guess that this --> <a href="http://gerrit.ovirt.org/#/c/11411/">http://gerrit.ovirt.org/#/c/11411/</a> is the fix for this ;)<br></div>- DHC<br></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Mon, Jan 28, 2013 at 3:40 PM, Dead Horse <span dir="ltr"><<a href="mailto:deadhorseconsulting@gmail.com" target="_blank">deadhorseconsulting@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div>Seeing this error in engine log when attempting to create a new VM from the userportal:<br>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"<br>
Where: PL/pgSQL function "fn_perms_get_vds_groups_with_permitted_action" line 3 at RETURN QUERY<br>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"<br>
Where: PL/pgSQL function "fn_perms_get_vds_groups_with_permitted_action" line 3 at RETURN QUERY<br><br>Current running engine build --> commit: <span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;text-transform:none;font-size:12px;white-space:normal;font-family:monospace;word-spacing:0px">61c11aecc40e755d08b6c34c6fe1c0a07fa94de8<br>
<br></span></div><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;text-transform:none;font-size:12px;white-space:normal;font-family:monospace;word-spacing:0px">- DHC<br>
</span><div><br></div></div>
</blockquote></div><br></div>