When I am working on Program Membership Analysis Report in RCE, when a field "Lifecycle Status" is added to the report, there is an error popping up which says an unknown column "lead_dim.X_1717_Lifecycle_status" in field list.
And when I remove the field"Lifecycle Status" from the report, the report runs normally and shows me the results as usual. I also noted that the error is not just with Program Membership Analysis Report but also with any report which has this field and when used in the report.
Can anyone please tell me what could be the problem and how to resolve this.