# Data Upload Errors, Warnings and Infos Explained
URL: https://docs.valsight.ai/data-upload-errors-warnings-and-infos-explained/
Description: On this page you'll find the meaning of the different Error, Warning and Info Messages when Uploading Data to Valsight.
On this page you'll find the meaning of the different Error, Warning and Info Messages when [Uploading Data to Valsight](#).

## Overview

<table class="confluenceTable">
<colgroup>
<col/>
<col/>
</colgroup>
<tbody>
<tr>
<th>
<h4 id="DataUploadErrors,WarningsandInfosExplained-Message">Message</h4>
</th>
<th>
<h4 id="DataUploadErrors,WarningsandInfosExplained-Severity">Severity</h4>
</th>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-Tablestillinuse" rel="nofollow">Table is still in use</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-duplicatetable" rel="nofollow">Duplicate table</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-emptytable" rel="nofollow">Empty table</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Warn.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094215064.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-Columnstillinuse" rel="nofollow">Column is still in use</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-DuplicateColumn" rel="nofollow">Duplicate Column</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-wrongparent" rel="nofollow">Wrong parent or child</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-conflictinglinkedattributes" rel="nofollow">Conflicting linked attributes</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-Invalidvalue" rel="nofollow">Invalid value</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-EmptyCell" rel="nofollow">Empty Cell</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Error.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094207687.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-DuplicateRow" rel="nofollow">Duplicate Row</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Warn.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094215064.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-AddedRows" rel="nofollow">Added Rows</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Info.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094218965.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-DeletedRows" rel="nofollow">Deleted Rows</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Info.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094218965.png"/>
</a></td>
</tr>
<tr>
<td>
<p><a href="#DataUploadErrors,WarningsandInfosExplained-ChangedValues" rel="nofollow">Changed Values</a></p>
</td>
<td><a href="#" rel="nofollow">
<img alt="Info.png" src="/api/asset/projects-models-simulations/data-import-export/data-upload-import-export-overview/images/5094218965.png"/>
</a></td>
</tr>
</tbody>
</table>

### **Table is still in use** Error.png

This error appears when a newly uploaded Excel document does not contain worksheets that are currently being referenced in our model. To resolve this you can either add the required worksheets to the new Excel document or remove the reference to the old worksheets inside of the model.

To identify where a table is used, navigate to the Valsight settings > Projects > choose the Project > Show Data Sources > Usage report (> Details).

**Example:**

Our current document 'Base data.xlsx' contains the following worksheets:

![Base Data sheets.png](./images/5094207400.png)

All of these worksheets are being referenced in multiple places inside our model. For example in the base data submodel.

![reference base data in model v2.15.png](./images/5094207636.png)

Our new data source only contains the following Worksheets:

![DemoContent4 sheets.png](./images/5094207424.png)

If we try to upload this document the [data upload wizard](#) will show the error ‘table is still in use’. To fix this we can either copy the worksheets from the old into the new Excel document or remove all references to the old worksheets inside our model.

![table still in use error v2.15.png](./images/5094207532.png)

Make sure to also add the contents of a worksheet when you are adding missing worksheets to your new Excel document. Otherwise, the error will persist.

### **Duplicate table** Error.png

There is more than one sheet (Excel) or table (database) with the same name. To resolve this rename the sheets or tables in question and reupload the file or reimport the database again.

### **Empty table** [Warn.png](#DataUploadErrors,WarningsandInfosExplained-DuplicateRow)

A sheet (Excel) or table (database) has column headers but is otherwise empty. Delete it from the document or add rows to resolve this error.

### **Column is still in use** Error.png

Similar to “[Table is still in use](#)”, this error appears when a column that is referenced inside the model isn't part of the new Excel document. To resolve this you can either add the required columns to the new Excel document or remove the reference to the old columns inside of the model.

**Example:**

Our new file does not contain the column 'Volume' which is referenced in our submodel.

![base data missing volume with worksheets cropped.png](./images/5094204495.png)
![reference base data in model v2.15.png](./images/5094207636.png)

If we try to upload it the error 'column still in use' will appear. To resolve it, we can either add 'Volume' back to our file or remove the reference from the submodel.

![column still in use error v2.15.png](./images/5094204476.png)

### **Duplicate column** Error.png

You will receive this error if your Excel document contains a column two or more times. Remove the redundant columns to fix the error.

**Example:**

Our new data source contains the column "Billed Days" twice.

![excel duplicate column.png](./images/5094211531.png)

When we try to upload said data source, we'll receive the error "Duplicate column". The data upload wizard also shows which sheet and column are affected. Just delete the highlighted, redundant column and you are good to go.

![duplicate column v2.15.png](./images/5094211498.png)

### **Wrong parent or child** Error.png

This error appears when the hierarchy of a level (Paris) and its parent (Germany) is not the same as specified in the dimension management. In this example, the parent of Paris is France and not Germany.

![image2020-11-2\_14-28-10.png](./images/5094191164.png)

Try to sort out if you have to change your excel file or database to match with the dimension management or vice versa.

![image2020-11-2\_14-27-57.png](./images/5094191179.png)

### **Conflicting linked attributes** Error.png

Similar to [Wrong parent or child](#), this error appears if the linked attributes that are used in the excel file or database are not the same as in the dimension management.

In the example below, "Auto2" has a linked Color "Blau" in the excel file, but "Rot is linked in the dimension management.

![image2020-11-2\_14-34-25.png](./images/5094191174.png) vs ![image2020-11-2\_14-34-42.png](./images/5094191159.png)

### **Invalid value** Error.png

This error appears when the dimensions or level values in Valsight don't match with the ones in the uploaded Excel document. Edit the [dimension and hierarchy management](#) to match your base data to fix the issue.

**Example:**

The Excel document containing our base data is referencing the level value 'Service 3' in lines 7 and 13.

![Service 3 in Excel.png](./images/5094207616.png)

When we try to upload our base data we get the error 'Invalid Value'. The [data upload wizard](#) also shows us which values are affected. Here we can see that lines 7 and 13 in the column 'Product' are affected.

![Invalid values v2.15 service3.png](./images/5094207548.png)

If we check inside the [dimension management](#) we'll see that the level value 'Service 3' is missing. Once we add the value the upload will work as intended.

![Dimensions missiong service 3 v2.15.png](./images/5094207590.png)

'Invalid values' also appear, when whole dimensions or hierarchies are missing. In addition to that, it appears when hierarchies aren't set up correctly (e.g. 'ProductGroup' containing the values for Products and vice versa).

### **Empty cell** Error.png

This error appears if the uploaded Excel documents contain cells without a value in them. Fill in all missing values in the document to fix the error.

**Example:**

Our Excel document is missing two values in the columns "TotalRevenue" and "BilledDays".

![Excel Empty Cell.png](./images/5094215046.png)

Once we upload the file we receive the error "Empty Cell" along with the position it is in. Fill in the missing values to resolve the error.

![Empty Cell v2.15.png](./images/5094215217.png)

### Duplicate row Warn.png

This warning appears if your Excel document contains a row multiple times. Discard the redundant rows to remove it.

**Example:**

Our Excel file contains the last row twice.

![Duplicate Row Excel.png](./images/5094215177.png)

When we upload the file we'll get the warning "Duplicate Rows" as well as the information on which rows are the duplicated ones.

![Duplicate Row v2.15.png](./images/5094215160.png)

Even though you can still upload an Excel file with duplicate rows, we advise against it since it might lead to unintended consequences while building your model.

### **Added rows** Info.png

This message appears if new rows were added to your data source. It also shows you, which rows were added specifically.

**Example:**

We added a new row (row 5) to our Excel file.

![excel added rows.png](./images/5094218618.png)

Once we upload our new file the data upload wizard will show us which rows were added.

![added rows v2.15.png](./images/5094218589.png)

### **Deleted rows** Info.png

This message appears if rows were deleted from your data source. It also shows you, which rows were deleted specifically.

**Example:**

We now deleted the previously added row 5 from our Excel file.

![Excel deleted rows.png](./images/5094218658.png)

Once we upload the file the data upload wizard will show us which rows were deleted.

![deleted rows v2.15.png](./images/5094218853.png)

### **Changed values** Info.png

This message appears when values in your newly uploaded Excel file change compared to the existing data source. It also shows you which values have changed specifically.

**Example:**

We changed the values in rows 27, 28, and 29 of our Excel file.

![excel changed values.png](./images/5094215471.png)

Once we upload the file, the data upload wizard will show us which rows were modified.

![changed values v2.15.png](./images/5094215458.png)