[katello .2.2] Product Content on Activation Keys is not loading

Mario_Gamboa · July 8, 2015, 4:39am

I make a fresh install to get the new foreman 1.8.2 but when i create the
Activation key and i want to force into the product content the repos the
only i get is the loading message and is in a loop nothing happen.

Looking into the production log is looks like ok is connected to the
database and suppose is give the result but nothing happen in the gui

Any log can i share for diagnostic this issue?

Mario_Gamboa · July 8, 2015, 5:05am

this what happen when click product contents

2015-07-08 05:02:23 [D] Cache read:
https://172.25.176.121/katello/api/v2/activation_keys/1/products?enabled=true&full_result=true&include_available_content=true&organization_id=1
2015-07-08 05:02:23 [I] Processing by
Katello::Api::V2::ProductsController#index as JSON
2015-07-08 05:02:23 [I] Parameters: {"enabled"=>"true",
"full_result"=>"true", "include_available_content"=>"true",
"organization_id"=>"1", "api_version"=>"v2", "activation_key_id"=>"1"}
2015-07-08 05:02:23 [D] User Load (0.3ms) SELECT "users".* FROM "users"
WHERE "users"."id" = $1 LIMIT 1 [["id", 3]]
2015-07-08 05:02:23 [D] Setting current user thread-local variable to Admin
User
2015-07-08 05:02:23 [D] Cache read: idle_timeout
2015-07-08 05:02:23 [D] Katello::ActivationKey Load (0.4ms) SELECT
"katello_activation_keys".* FROM "katello_activation_keys" WHERE
"katello_activation_keys"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] Organization Load (0.3ms) SELECT "taxonomies".*
FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND
"taxonomies"."id" = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "taxonomies".* FROM
"taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND
"taxonomies"."id" = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] (0.2ms) SELECT id FROM "katello_products" WHERE
"katello_products"."organization_id" = 1
2015-07-08 05:02:23 [D] Katello::MarketingProduct Load (0.3ms) SELECT
"katello_products".* FROM "katello_products" WHERE
"katello_products"."type" IN ('Katello::MarketingProduct') AND
"katello_products"."cp_id" IN ('1436273363624', '1436273648779',
'1436273768622')
2015-07-08 05:02:23 [D] Katello::Product Load (0.2ms) SELECT
"katello_products".* FROM "katello_products" WHERE
"katello_products"."cp_id" IN ('1436273363624', '1436273648779',
'1436273768622') AND (type != 'Katello::MarketingProduct')
2015-07-08 05:02:23 [D] Katello::Product Load (0.5ms) SELECT
"katello_products".* FROM "katello_products" WHERE "katello_products"."id"
IN (1, 2, 3) ORDER BY id = 1 DESC, id = 2 DESC, id = 3 DESC
2015-07-08 05:02:23 [D] Katello::Provider Load (0.2ms) SELECT
"katello_providers".* FROM "katello_providers" WHERE
"katello_providers"."id" IN (1)
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "taxonomies".* FROM
"taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND
"taxonomies"."id" = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] Katello::KTEnvironment Load (0.4ms) SELECT
"katello_environments".* FROM "katello_environments" WHERE
"katello_environments"."organization_id" = 1 AND
"katello_environments"."library" = 't' LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "taxonomies".* FROM
"taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND
"taxonomies"."id" = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentView Load (0.3ms) SELECT
"katello_content_views".* FROM "katello_content_views" WHERE
"katello_content_views"."default" = 't' AND
"katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentViewVersion Load (0.4ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentView Load (0.2ms) SELECT
"katello_content_views".* FROM "katello_content_views" WHERE
"katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.4ms) SELECT
"katello_repositories".* FROM "katello_repositories" WHERE
"katello_repositories"."content_view_version_id" = 1 AND
"katello_repositories"."environment_id" = 1 AND
"katello_repositories"."product_id" = 1 AND (url IS NOT NULL) ORDER BY
katello_repositories.name ASC
2015-07-08 05:02:23 [D] Katello::PulpSyncStatus Load (0.4ms) SELECT
"katello_task_statuses".* FROM "katello_task_statuses" WHERE
"katello_task_statuses"."type" IN ('Katello::PulpSyncStatus') AND
"katello_task_statuses"."uuid" = '559bcba8433d3414df4a9169' LIMIT 1
2015-07-08 05:02:23 [D] Katello::PulpSyncStatus Load (0.5ms) SELECT
"katello_task_statuses".* FROM "katello_task_statuses" WHERE
"katello_task_statuses"."type" IN ('Katello::PulpSyncStatus') AND
"katello_task_statuses"."uuid" = '559bcba8433d3414df4a9172' LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.5ms) SELECT
"katello_repositories".* FROM "katello_repositories" WHERE
"katello_repositories"."content_view_version_id" = 1 AND
"katello_repositories"."environment_id" = 1 AND
"katello_repositories"."product_id" = 1 ORDER BY katello_repositories.name
ASC
2015-07-08 05:02:23 [D] ForemanTasks::Task::DynflowTask Load (0.6ms)
SELECT "foreman_tasks_tasks".* FROM "foreman_tasks_tasks" INNER JOIN
"foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" =
"foreman_tasks_tasks"."id" WHERE "foreman_tasks_tasks"."type" IN
('ForemanTasks::Task::DynflowTask') AND "foreman_tasks_tasks"."label" =
'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 1 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] ForemanTasks::Task::DynflowTask Load (0.6ms)
SELECT "foreman_tasks_tasks".* FROM "foreman_tasks_tasks" INNER JOIN
"foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" =
"foreman_tasks_tasks"."id" WHERE "foreman_tasks_tasks"."type" IN
('ForemanTasks::Task::DynflowTask') AND "foreman_tasks_tasks"."label" =
'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 2 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 1 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 2 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 1 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 2 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 1 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "foreman_tasks_tasks".*
FROM "foreman_tasks_tasks" INNER JOIN "foreman_tasks_locks" ON
"foreman_tasks_locks"."task_id" = "foreman_tasks_tasks"."id" WHERE
"foreman_tasks_tasks"."type" IN ('ForemanTasks::Task::DynflowTask') AND
"foreman_tasks_tasks"."label" = 'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 2 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] (0.7ms) SELECT COUNT() FROM
"katello_repositories" INNER JOIN "katello_content_view_versions" ON
"katello_content_view_versions"."id" =
"katello_repositories"."content_view_version_id" INNER JOIN
"katello_content_views" ON "katello_content_views"."id" =
"katello_content_view_versions"."content_view_id" WHERE
"katello_repositories"."product_id" = 1 AND
"katello_content_views"."default" = 't'
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.5ms) SELECT
"katello_repositories".* FROM "katello_repositories" WHERE
"katello_repositories"."content_view_version_id" = 1 AND
"katello_repositories"."environment_id" = 1 AND
"katello_repositories"."product_id" = 2 AND (url IS NOT NULL) ORDER BY
katello_repositories.name ASC
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."default" = 't'
AND "katello_content_views"."organization_id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM "katello_content_view_versions"
INNER JOIN "katello_content_view_environments" ON
"katello_content_view_environments"."content_view_version_id" =
"katello_content_view_versions"."id" WHERE
"katello_content_view_versions"."content_view_id" = 1 AND
"katello_content_view_environments"."environment_id" = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views"."id" = 1 LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.5ms) SELECT
"katello_repositories".* FROM "katello_repositories" WHERE
"katello_repositories"."content_view_version_id" = 1 AND
"katello_repositories"."environment_id" = 1 AND
"katello_repositories"."product_id" = 2 ORDER BY katello_repositories.name
ASC
2015-07-08 05:02:23 [D] ForemanTasks::Task::DynflowTask Load (0.4ms)
SELECT "foreman_tasks_tasks".* FROM "foreman_tasks_tasks" INNER JOIN
"foreman_tasks_locks" ON "foreman_tasks_locks"."task_id" =
"foreman_tasks_tasks"."id" WHERE "foreman_tasks_tasks"."type" IN
('ForemanTasks::Task::DynflowTask') AND "foreman_tasks_tasks"."label" =
'Actions::Katello::Repository::Sync' AND
"foreman_tasks_locks"."resource_id" = 3 AND
"foreman_tasks_locks"."resource_type" = 'Katello::Repository' ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT "katello_content_views".*
FROM "katello_content_views" WHERE "katello_content_views

ehelms · July 8, 2015, 11:19am

Can you check the browsers web console for errors when you access that tab?
We had a previously reported error that was fixed for 2.2.2. What version
of ruby193-rubygem-katello are you running?

···

On Jul 8, 2015 1:05 AM, "Mario Gamboa" wrote:

this what happen when click product contents

2015-07-08 05:02:23 [D] Cache read:
https://172.25.176.121/katello/api/v2/activation_keys/1/products?enabled=true&full_result=true&include_available_content=true&organization_id=1
2015-07-08 05:02:23 [I] Processing by
Katello::Api::V2::ProductsController#index as JSON
2015-07-08 05:02:23 [I] Parameters: {“enabled”=>“true”,
“full_result”=>“true”, “include_available_content”=>“true”,
“organization_id”=>“1”, “api_version”=>“v2”, “activation_key_id”=>“1”}
2015-07-08 05:02:23 [D] User Load (0.3ms) SELECT “users”.* FROM “users"
WHERE “users”.“id” = $1 LIMIT 1 [[“id”, 3]]
2015-07-08 05:02:23 [D] Setting current user thread-local variable to
Admin User
2015-07-08 05:02:23 [D] Cache read: idle_timeout
2015-07-08 05:02:23 [D] Katello::ActivationKey Load (0.4ms) SELECT
"katello_activation_keys”.* FROM “katello_activation_keys” WHERE
"katello_activation_keys".“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] Organization Load (0.3ms) SELECT “taxonomies”.*
FROM “taxonomies” WHERE “taxonomies”.“type” IN (‘Organization’) AND
"taxonomies".“id” = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “taxonomies”.* FROM
"taxonomies" WHERE “taxonomies”.“type” IN (‘Organization’) AND
"taxonomies".“id” = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] (0.2ms) SELECT id FROM “katello_products"
WHERE “katello_products”.“organization_id” = 1
2015-07-08 05:02:23 [D] Katello::MarketingProduct Load (0.3ms) SELECT
"katello_products”.* FROM “katello_products” WHERE
"katello_products".“type” IN (‘Katello::MarketingProduct’) AND
"katello_products".“cp_id” IN (‘1436273363624’, ‘1436273648779’,
‘1436273768622’)
2015-07-08 05:02:23 [D] Katello::Product Load (0.2ms) SELECT
"katello_products".* FROM “katello_products” WHERE
"katello_products".“cp_id” IN (‘1436273363624’, ‘1436273648779’,
‘1436273768622’) AND (type != ‘Katello::MarketingProduct’)
2015-07-08 05:02:23 [D] Katello::Product Load (0.5ms) SELECT
"katello_products".* FROM “katello_products” WHERE “katello_products”.“id"
IN (1, 2, 3) ORDER BY id = 1 DESC, id = 2 DESC, id = 3 DESC
2015-07-08 05:02:23 [D] Katello::Provider Load (0.2ms) SELECT
"katello_providers”.* FROM “katello_providers” WHERE
"katello_providers".“id” IN (1)
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “taxonomies”.* FROM
"taxonomies" WHERE “taxonomies”.“type” IN (‘Organization’) AND
"taxonomies".“id” = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] Katello::KTEnvironment Load (0.4ms) SELECT
"katello_environments".* FROM “katello_environments” WHERE
"katello_environments".“organization_id” = 1 AND
"katello_environments".“library” = ‘t’ LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “taxonomies”.* FROM
"taxonomies" WHERE “taxonomies”.“type” IN (‘Organization’) AND
"taxonomies".“id” = 1 ORDER BY title LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentView Load (0.3ms) SELECT
"katello_content_views".* FROM “katello_content_views” WHERE
"katello_content_views".“default” = ‘t’ AND
"katello_content_views".“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentViewVersion Load (0.4ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::ContentView Load (0.2ms) SELECT
"katello_content_views".* FROM “katello_content_views” WHERE
"katello_content_views".“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.4ms) SELECT
"katello_repositories".* FROM “katello_repositories” WHERE
"katello_repositories".“content_view_version_id” = 1 AND
"katello_repositories".“environment_id” = 1 AND
"katello_repositories".“product_id” = 1 AND (url IS NOT NULL) ORDER BY
katello_repositories.name ASC
2015-07-08 05:02:23 [D] Katello::PulpSyncStatus Load (0.4ms) SELECT
"katello_task_statuses".* FROM “katello_task_statuses” WHERE
"katello_task_statuses".“type” IN (‘Katello::PulpSyncStatus’) AND
"katello_task_statuses".“uuid” = ‘559bcba8433d3414df4a9169’ LIMIT 1
2015-07-08 05:02:23 [D] Katello::PulpSyncStatus Load (0.5ms) SELECT
"katello_task_statuses".* FROM “katello_task_statuses” WHERE
"katello_task_statuses".“type” IN (‘Katello::PulpSyncStatus’) AND
"katello_task_statuses".“uuid” = ‘559bcba8433d3414df4a9172’ LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.5ms) SELECT
"katello_repositories".* FROM “katello_repositories” WHERE
"katello_repositories".“content_view_version_id” = 1 AND
"katello_repositories".“environment_id” = 1 AND
"katello_repositories".“product_id” = 1 ORDER BY katello_repositories.name
ASC
2015-07-08 05:02:23 [D] ForemanTasks::Task::DynflowTask Load (0.6ms)
SELECT “foreman_tasks_tasks”.* FROM “foreman_tasks_tasks” INNER JOIN
"foreman_tasks_locks" ON “foreman_tasks_locks”.“task_id” =
“foreman_tasks_tasks”.“id” WHERE “foreman_tasks_tasks”.“type” IN
(‘ForemanTasks::Task::DynflowTask’) AND “foreman_tasks_tasks”.“label” =
‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 1 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] ForemanTasks::Task::DynflowTask Load (0.6ms)
SELECT “foreman_tasks_tasks”.* FROM “foreman_tasks_tasks” INNER JOIN
"foreman_tasks_locks" ON “foreman_tasks_locks”.“task_id” =
“foreman_tasks_tasks”.“id” WHERE “foreman_tasks_tasks”.“type” IN
(‘ForemanTasks::Task::DynflowTask’) AND “foreman_tasks_tasks”.“label” =
‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 2 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 1 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 2 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 1 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 2 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 1 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “foreman_tasks_tasks”.*
FROM “foreman_tasks_tasks” INNER JOIN “foreman_tasks_locks” ON
"foreman_tasks_locks".“task_id” = “foreman_tasks_tasks”.“id” WHERE
"foreman_tasks_tasks".“type” IN (‘ForemanTasks::Task::DynflowTask’) AND
"foreman_tasks_tasks".“label” = ‘Actions::Katello::Repository::Sync’ AND
"foreman_tasks_locks".“resource_id” = 2 AND
"foreman_tasks_locks".“resource_type” = ‘Katello::Repository’ ORDER BY
started_at DESC LIMIT 1
2015-07-08 05:02:23 [D] (0.7ms) SELECT COUNT() FROM
"katello_repositories" INNER JOIN “katello_content_view_versions” ON
"katello_content_view_versions".“id” =
“katello_repositories”.“content_view_version_id” INNER JOIN
"katello_content_views" ON “katello_content_views”.“id” =
“katello_content_view_versions”.“content_view_id” WHERE
"katello_repositories".“product_id” = 1 AND
"katello_content_views".“default” = 't’
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“default” = 't’
AND “katello_content_views”.“organization_id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT “katello_content_views”.*
FROM “katello_content_views” WHERE “katello_content_views”.“id” = 1 LIMIT 1
2015-07-08 05:02:23 [D] CACHE (0.0ms) SELECT
"katello_content_view_versions".* FROM “katello_content_view_versions"
INNER JOIN “katello_content_view_environments” ON
"katello_content_view_environments”.“content_view_version_id” =
“katello_content_view_versions”.“id” WHERE
"katello_content_view_versions".“content_view_id” = 1 AND
"katello_content_view_environments".“environment_id” = 1 ORDER BY
katello_content_view_environments.environment_id DESC,
katello_content_view_versions.id DESC LIMIT 1
2015-07-08 05:02:23 [D] Katello::Repository Load (0.5ms) SELECT
"katello_repositories".* FROM "katello_r

Mario_Gamboa · July 9, 2015, 11:46pm

Hi this is what i get from the web console

"Error: product.available_content is undefined
$scope.isAnyAvailableContent/<@https://172.25.176.121/assets/bastion_katello/bastion_katello-ee12c1ee51eaac15da7f7d401951bd41.js:38:19978
forEach@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:5:21583
$scope.isAnyAvailableContent@https://172.25.176.121/assets/bastion_katello/bastion_katello-ee12c1ee51eaac15da7f7d401951bd41.js:38:19935
@https://172.25.176.121/assets/bastion_katello/bastion_katello-ee12c1ee51eaac15da7f7d401951bd41.js:38:20339
resourceFactory/</Resource[name]/promise<@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:11:12172
qFactory/defer/deferred.promise.then/wrappedCallback@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:13900
qFactory/ref/<.then/<@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:15319
$RootScopeProvider/this.$get</Scope.prototype.$eval@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:22494
$RootScopeProvider/this.$get</Scope.prototype.$digest@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:20539
$RootScopeProvider/this.$get</Scope.prototype.$apply@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:22921
done@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7:22754
completeRequest@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7:26322
createHttpBackend/</xhr.onreadystatechange@https://172.25.176.121/assets/bastion/bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7:27252
" bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8:5768
consoleLog/<() bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
$ExceptionHandlerProvider/this.$get</<()
bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7
qFactory/defer/deferred.promise.then/wrappedCallback()
bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
qFactory/ref/<.then/<() bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
$RootScopeProvider/this.$get</Scope.prototype.$eval()
bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
$RootScopeProvider/this.$get</Scope.prototype.$digest()
bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
$RootScopeProvider/this.$get</Scope.prototype.$apply()
bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:8
done() bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7
completeRequest() bastion-b162d954f470b4e7df7f9c7b139cdd4d.js:7
createHttpBackend/</xhr.onreadystatechange()

The version of ruby katello is ruby193-rubygem-katello-2.2.2-2.el6.noarch

Gabriel_Rosca · July 11, 2015, 1:16pm

I have the same problem … Looks like this bug :

http://projects.theforeman.org/issues/10575#note-7

Gabriel

Mario_Gamboa · July 13, 2015, 5:26am

I looking already in the bug gabriel and i already have patch the version
is 2.2.2 but i still now i create a new machine now with centos 7 instead
of centos 6 but when i try to looking again into the activation key the
product content still same issue is only just show loading and in the web
console i get this

This site makes use of a SHA-1 Certificate; it's recommended you use
certificates with signature algorithms that use hash functions stronger
than SHA-1.[Learn More] products
Empty string passed to getElementById().
application-6ce5ef9cee5ab43827e0aff41052e468.js:16:0
Empty string passed to getElementById().