<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: times new roman,new york,times,serif; font-size: 12pt; color: #000000'><font face="times new roman, new york, times, serif" size="3">Hi Christopher,</font><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">In general - as a developer at engine project, I would recommend to run the upgrade script on a frequent basis.</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">What troubles me with the query you sent (maybe some problematic copy paste issue?) are the following issues:</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">a. <span style="font-family: Calibri, sans-serif; font-size: 15px;">storage domains for search</span><span style="font-family: Calibri, sans-serif; font-size: 15px;"> - not sure what this is </span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><span style="font-family: Calibri, sans-serif; font-size: 15px;">b. </span><span style="font-family: Calibri, sans-serif; font-size: 15px;">storage domains with hosts view - I guess you have some underline issue at the copy paste.</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div><font face="Calibri, sans-serif"><span style="font-size: 15px;">I would appreciate if you attach engine.log (or a part of it that reflects the error you encountered)</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size: 15px;"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size: 15px;">Kind regards,</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size: 15px;">Yair</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size: 15px;"><br></span></font></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Christopher Morrissey" <Christopher.Morrissey@netapp.com><br><b>To: </b>engine-devel@ovirt.org<br><b>Sent: </b>Wednesday, November 14, 2012 12:10:14 AM<br><b>Subject: </b>[Engine-devel] Unable to view the storage domains - SQL error<br><br>
<style><!--
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal">Hi All,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I’m getting an error when trying to view the storage domains using the REST API:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><?xml version="1.0" encoding="UTF-8" standalone="yes"?></p>
<p class="MsoNormal"><fault></p>
<p class="MsoNormal"> <reason>Operation Failed</reason></p>
<p class="MsoNormal"> <detail>statementcallback; bad sql grammar [select * from (select * from storage domains for search where ( id in (select storage domains with hosts view.id from storage domains with hosts view )) order by storage name asc ) as t1 offset
(1 -1) limit 100]; nested exception is org.postgresql.util.psqlexception: error: relation "storage domains for search" does not exist position: 30</detail></p>
<p class="MsoNormal"></fault></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Also, through the web admin console, when viewing the storage domains the list never loads.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" id="DWT244">Did something change in the DB recently such that I would need to rebuild it?</p></div></blockquote><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div class="WordSection1"><p class="MsoNormal"></p>
<p class="MsoNormal" id="DWT245"></p></div></blockquote><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div class="WordSection1"><p class="MsoNormal"> </p>
<p class="MsoNormal">-Chris</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b>Chris Morrissey</b></p>
<p class="MsoNormal">Software Engineer</p>
<p class="MsoNormal">NetApp Inc.</p>
<p class="MsoNormal">919.476.4428</p>
<p class="MsoNormal"> </p>
</div>
<br>_______________________________________________<br>Engine-devel mailing list<br>Engine-devel@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/engine-devel<br></blockquote><br></div></div></body></html>