Error -'Database Vendor Code 229. Failed to retrieve data from the database.' When opening a layout

The error is usually caused by a new report that’s using a SQL view which doesn’t have the correct permissions assigned yet. The error message will show the report name, which points to the underlying view.
To fix it, grant the required permissions on that view in SQL. Once the permissions are applied, the report should run correctly.