I have an Appointment BO which is naturally a member of the Appointments group. I added a reference attribute to the BO, called Initiative. I'm getting the following error when I try to run a query based on Appointment.
Internal error. Error reading business object. Unknown column 'Appointment.Initiative_RID' in 'on clause'
The odd thing is that I have 2 similar reference attributes, but the others don't give me trouble. I tried deleting the attribute and everything works. But when I recreate, same issue. I tried testing with no previous data thinking it was a corrupted database, but same issue. I tried "Rebuild Cross-Reference Rules" not knowing what that feature does exactly, but it sounds impressive. No luck.