---
title: "\"Error occurred retrieving data\" message when viewing tables"
canonical: "https://servicedesk.maxgeo.com/space/DS/1125712052/%22Error%20occurred%20retrieving%20data%22%20message%20when%20viewing%20tables"
format: markdown
---
**Reason:** Base table has had columns added/removed. The table display sort order in DataShed5 no longer matches the table format.

![image](media://ca06eb54-2c06-4363-9a59-bd9119f749fc)


**Solution:** Delete all records from tblSYSTableView and tblSYSTableDisplay in the MDS


```sql
delete from tblsysTableDisplay
delete from tblsysTableView
```


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.