Created attachment 1371204 [details]
image describe about policy options

Description of problem:

Getting error "PG::UndefinedColumn: ERROR: column policy_events.availability_zone_id does not exist" while performing policy_event on nova's timeline. 

Version-Release number of selected component (if applicable):

5.8.2.3.20171016155816_aaec796

How reproducible:

Always

Steps to Reproduce:

1. Login to Operational portal of CloudForms.

2. Navigate to Compute -> Clouds -> Availability Zones -> Monitoring ->  Timelines -> Select Policy Event -> Select all -> Both (radio button) --(Refer policy.png)

3. Click on apply. 

4. You will get above mentioned error.

Actual results:

Not able to get policy event on nova timeline.

Expected results:

CloudForms should display policy event on nova timeline.

Additional info:

evm.log:

[----] I, [2017-12-21T13:36:04.217479 #2217:3bd8564]  INFO -- :   Parameters: {"tl_show"=>"policy_timeline", "tl_categories"=>["Authentication Validation", "CFME Operation", "Company Tag", "Compliance", "Container Operation", "Datastore Operation", "Host Operation", "Orchestration Lifecycle", "Provider Operation", "Service Lifecycle", "VM Configuration", "VM Lifecycle", "VM Operation"], "tl_timerange"=>"weeks", "tl_timepivot"=>"ending", "tl_result"=>"both", "tl_range_count"=>"1", "tl_date"=>"Fri Dec 22 2017 00:00:00 GMT+0530 (IST)", "tl_typ"=>"Daily", "tl_days"=>"7", "miq_date"=>"12/22/2017", "id"=>"39000000000001"}
[----] F, [2017-12-21T13:36:04.230975 #2217:3bd8564] FATAL -- : Error caught: [ActiveRecord::StatementInvalid] PG::UndefinedColumn: ERROR:  column policy_events.availability_zone_id does not exist
LINE 1: ...CT  "policy_events".* FROM "policy_events" WHERE (policy_eve...
                                                             ^
: SELECT  "policy_events".* FROM "policy_events" WHERE (policy_events.availability_zone_id = 39000000000001) ORDER BY timestamp ASC LIMIT $1