---
title: "DataShed5 - Errors Retrieving Data"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/1063976975/DataShed5%20-%20Errors%20Retrieving%20Data"
format: markdown
---
ISSUE: - Error message appears when accessing a module in DataShed5

![image](media://4cbfd291-2c57-4aa5-8177-6cece3f66402)

REASON:

Module select is for a VIEW which includes a SELECT statement which includes all the columns from another View (e.g. Select Table1.col1, Table1.col2, View2.* FROM table1 inner join VIEW2 …..)


When we select the Module to display in DataShed we use the INFORMATION_SCHEMA.COLUMNS to get a list of the column names for the table/view in order to list column names for Sort / Display and Filter options.


If the CHILD VIEW is altered to include a new column, but the Parent View was not altered, in SQL Server Information Schema, it still has the old list of column names for the Parent View.

SOLUTION: When creating a SQL View, which is to be Registered and used in Module Select, it should always ***explicitly*** set the column names to be included.