Syntax Error or Access Rule Violation detected by database ((conn=5423583) exist in table cmdb_par10

[vasant Cool]

When I try to use a filter condition in the status(hardware_status) or Filter Out a field. I am getting the below error.

How to fix this error ?

Syntax Error or Access Rule Violation detected by database ((conn=5423583) Key 'bahstrry_sys_created_on' doesn't exist in table 'cmdb_par10')

[Ranjith95]

@Julie Gordon  - I faced similar issue for cmdb_ci_server table, i have removed the user preference (cmdb_ci_server.db.order and value sys_created_on),to resolve the same either try to check and delete the user preference (sys_user_preference.list) which is related to your table ,or need to address the index issue.

Mostly it will be resolved by removing user preference related to that table if user doesn't require that.

Thanks