<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif"><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">Hi,</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">

<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">Foreman guys say this is probably an oVirt side issue..</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">

<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">I was successfully able to hook up my foreman server to the oVirt datacenter using the compute resources section. It detected the available datacenters and logged in fine. Logs showed code 200, I can view the VMs available, power them on and shut them down from the foreman UI.</div>

<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px"><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">But when I go to hosts-&gt;New Host and select oVirt I get the error:</div>

<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px"><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">Error loading virtual machine information: Internal Server Error</div>

<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px"><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">Logs are showing:</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px">

<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-size:13px;font-family:arial,sans-serif"><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">

Operation FAILED: statementcallback; bad sql grammar select * from (select * from vds groups view where ( vds group id in (select vds groups storage domain.vds group id from  vds groups storage domain   left outer join storage pool with storage domain on vds groups storage domain.storage pool id=storage pool with storage <a href="http://domain.id/" target="_blank" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;text-decoration:none">domain.id</a>    where  (  storage pool with storage <a href="http://domain.name/" target="_blank" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;text-decoration:none">domain.name</a> like &#39;%dc_01%&#39; or  storage pool with storage domain.description like &#39;%dc_01%&#39; or  storage pool with storage domain.comment like &#39;%dc_01%&#39; ) ))  order by name asc ) as t1 offset (1 -1) limit 100; nested exception is org.postgresql.util.psqlexception: error: column storage pool with storage domain.comment does not exist</div>

<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">  position: 421</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">  Rendered common/500.html.erb (5.2ms)</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">

Completed 500 Internal Server Error in 150ms (Views: 6.0ms | ActiveRecord: 0.3ms)</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><br></div></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">

<span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:tahoma,sans-serif">CentOS 6.4 - Foreman 1.2</span><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline">CentOS 6.4 - oVirt 3.3 Nightly</font></div>

<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><br></font></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">

<font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline">Any suggestions?</font></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><br>

</font></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline">Thanks,</font></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">

<font face="tahoma, sans-serif" style="margin:0px;padding:0px;border:0px;vertical-align:baseline">Andrew.</font></div></div></div>
</div>