Add back removed entities
If you are receiving the error 'Sorry, an unexpected error has occurred' when building reports, please ensure you have not removed any entities from the report.
If you have, please add these back in and try again.
Find the broken entity and re-add it
If all the entities are still present:
Open the report in Edit mode.
Remove one entity from the report and refresh the results.
If the report does not run, add the entity and its fields back in and remove the next entity.
If the report runs, add the entity and fields back in and Refresh the Results again.
Save the report again once it runs.
This resolves a corruption with the report. Removing the broken entity and adding it back updates the report with a clean copy of the entity and resolves the issue.
Field not part of the entity you report on
You may also experience this issue if you run a report on a form after applying a search. This can happen if one of the fields on the search is not part of the entity you are reporting on.
To resolve this, check the fields in the search criteria on the form against the fields in the entity when in the report builder and add in an entity that contains the field.
Example
An example of this is searching for payments where the first name is John, then clicking Report. This will open the report builder with the payment entity, but when you run the report it will try to filter on FirstName = John. The Payment Entity does not contain FirstName, as this is pulled from the contact entity. To allow the report to run you will need to add the contact entity.
If you're still unable to resolve the issue please reach out to us via the Digital Assistant and we'll be able to investigate the problem further.