Bug 2232559

Summary: {Sat6.11/RHCloud/Bug} foreman-rake command to clean insights status fails
Product: Red Hat Satellite Reporter: achadha
Component: RH Cloud - InventoryAssignee: Shimon Shtein <sshtein>
Status: NEW --- QA Contact: Satellite QE Team <sat-qe-bz-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.11.1CC: aruzicka, peter.vreman
Target Milestone: UnspecifiedKeywords: EasyFix
Target Release: Unused   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description achadha 2023-08-17 11:24:50 UTC 
The below foreman-rake command to clean insights status

# foreman-rake rh_cloud_insights:clean_statuses SEARCH="params.host_registration_insights=f"
API controllers newer than Apipie cache! Run apipie:cache rake task to regenerate cache.
rake aborted!
ScopedSearch::QueryNotSupported: external method 'search_by_params' failed with error: undefined method `subtree_ids' for nil:NilClass
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:420:in `rescue in to_ext_method_sql'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:417:in `to_ext_method_sql'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:217:in `sql_test'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:562:in `sql_test'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:509:in `to_single_field_sql'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:521:in `to_sql'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:54:in `build_find_params'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/query_builder.rb:22:in `build_query'
/usr/share/gems/gems/scoped_search-4.1.9/lib/scoped_search/definition.rb:328:in `block in register_named_scope!'
/usr/share/foreman/app/models/host.rb:15:in `method_missing'
/usr/share/gems/gems/foreman_rh_cloud-5.0.46/app/services/foreman_rh_cloud/insights_status_cleaner.rb:4:in `clean'
/usr/share/gems/gems/foreman_rh_cloud-5.0.46/lib/tasks/insights.rake:18:in `block (2 levels) in <top (required)>'
/usr/share/gems/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
~~~