[Engine-devel] Unable to view the storage domains - SQL error

[Morrissey, Christopher]

Hi All,

I'm getting an error when trying to view the storage domains using the REST API:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<fault>
    <reason>Operation Failed</reason>
    <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>
</fault>

Also, through the web admin console, when viewing the storage domains the list never loads.

Did something change in the DB recently such that I would need to rebuild it?

-Chris

Chris Morrissey
Software Engineer
NetApp Inc.
919.476.4428

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/engine-devel/attachments/20121113/2de52ba3/attachment.html>