Red Hat Bugzilla – Bug 1460158
Validation failed: Status is not included in the list
Last modified: 2018-03-06 09:54:15 EST
This looks like an Automate issue. If the root cause turns out to be a Providers issue just punt it back to me.
A hotfix is possible and we are working on putting a PR together which would then need to be back-ported to 5.7.
We have identified that the MiqProvisionRequestTemplate instance in the miq_requests table in the db has a value of "Denied" for the status column which is causing the issue. The code change will ensure that this value is not copied when the miq_requests record is copied to the miq_request_tasks table.
There are two possible work-arounds:
1) Recreate the catalog item. (Customer has verified this is working)
2) Reset the status column to "Ok" for all MiqProvisionRequestTemplate records in the miq_requests table. If needed this could be performed with a Rails console command like this: "MiqProvisionRequestTemplate.update_all(:status => "Ok")"
My concern is that the root cause is unclear as to how this template record would end up with a denied status. We have not experienced this issue before and may be related to custom automation logic. (For example, the service approval workflow.)
My suggestion is that we drop the severity of this issue as the customer appears to be working now and has a work-around and we continue to work with them to try to identify the root cause. We will also have a PR to prevent this issue going forward at the time of service ordering.
New commit detected on ManageIQ/manageiq/master:
Author: Drew Bomhof <email@example.com>
AuthorDate: Fri Jul 28 17:30:30 2017 -0400
Commit: Drew Bomhof <firstname.lastname@example.org>
CommitDate: Mon Jul 31 09:51:57 2017 -0400
Force status removal and default value
When we copy the MiqRequest to MiqRequestTask there is a case where status was not passing
validation if it was originally set to 'Denied'
This addresses that issue by removing the status column at copy and then setting the default value to 'Ok' in
app/models/miq_request.rb | 14 +++++++++++---
app/models/miq_request_task.rb | 1 +
spec/models/miq_request_spec.rb | 15 +++++++++++++++
3 files changed, 27 insertions(+), 3 deletions(-)
Fixed in 188.8.131.52.20171024163837_ef71ea6