Error on execute report

Dear i am using OpenMRS 1.11.6; all seem works well, but while i access the reporting i have the following error on logs: unknown column ‘this_.minimum_days_to_preserve’ in ‘field list’.

my report module is: Reporting-0.9.9.omod

Salimone

Looks like something went wrong with the “minimum_days_to_preserve” column! Do you see that column in the list when you run: describe reporting_report_request; ?

You may have to find a way to get that column re-created, probably by dropping the “reporting_report_request” table and restarting (…or even better upgrading) the reporting module. That should run the changesets in the reporting module’s liquibase file, and if that table is not found, it should be created with that column added.