After enabling the inventory plug-in on the satellite server not able to access All Hosts page on the Satellite server.

Solution Verified - Updated -

Issue

  • After installing the inventory upload plug-in on the Satellite server when trying to access the All Hosts page on the Satellite WebUI getting following error:

    Oops, we're sorry but something went wrong PG::UndefinedTable: ERROR: relation "insights_hits" does not exist LINE 8: WHERE a.attrelid = '"insights_hits"'::regclas... ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod, c.collname, col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation WHERE a.attrelid = '"insights_hits"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum
    

Environment

  • Red Hat Satellite 6.7
  • Red Hat Insights

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In