This page explains how to troubleshoot errors with
[manual file import](https://docs.cloud.google.com/migration-center/docs/import-data-tables).

## Errors reference

The following tables describe the possible errors you might find with
manual file import, and the possible error messages.

### Blocking errors

The following errors prevent you from uploading your infrastructure data.

| Error message | Error explanation |
|---|---|
| Import job `JOB_NAME` contains no files | You didn't upload any files. |
| Import job `JOB_NAME` has mixed format files. | You uploaded mixed files formats. |
| File `FILE_NAME` with format `FORMAT` size `SIZE` is over the allowed limit: `LIMIT_VALUE` | You uploaded a file that is too large. |
| Missing required file "vmInfo" | You didn't upload the required vmInfo file. |

### vmInfo file

| Column | Error case | Error message | Import behavior |
|---|---|---|---|
| Any column | Unexpected column | Unable to find column mapping for `COLUMN_NAME` | The cell is ignored. |
| MachineId | Missing column | Missing field(s) which can uniquely identify the Asset | **Every row shows the error message, and the row is not parsed.** |
| MachineId | Empty UUID | Missing field(s) which can uniquely identify the Asset | **The row is not parsed.** |
| PrimaryMACAddress | None, `AA-BB-CC-DD-EE-FF` or `AA:BB:CC:DD:EE:FF` formats | Unexpected MAC address `INPUT_MAC`, want pattern "\^(\[0-9A-Fa-f\]{2}\[:-\]){5}(\[0-9A-Fa-f\]{2})$" | The cell is ignored. |
| TotalDiskAllocatedGiB | Non float | Invalid syntax | The cell is ignored. |
| TotalDiskAllocatedGiB | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| TotalDiskUsedGiB | Non float | Invalid syntax | The cell is ignored. |
| TotalDiskUsedGiB | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| TotalDiskUsedGiB | Not higher than Allocated | "TotalDiskUsedGiB" is higher than "TotalDiskAllocatedGiB" | The cell is ignored. |
| AllocatedProcessorCoreCount | Non int | Invalid syntax | The cell is ignored. |
| AllocatedProcessorCoreCount | Negative int | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| MemoryGiB | Non float | Invalid syntax | The cell is ignored. |
| MemoryGiB | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| CreateDate | Empty string | Empty timestamp | The cell is ignored. |
| CreateDate | Wrong format | Unexpected timestamp format `INPUT_VALUE`, want "2006-01-02 15:04:05-07:00" | The cell is ignored. |
| IsPhysical | Not in {"","0","false","False","FALSE"} | Physical machines are not supported yet | **The row is not parsed.** |
| Source | AWS/Azure only (none for manual) |   | **The row is not parsed.** |

### diskInfo file

| Column | Error case | Error message | Import behavior |
|---|---|---|---|
| Any column | Unexpected column | unable to find column mapping for `COLUMN_NAME` | The cell is ignored. |
| MachineId | Missing column | Missing field(s) which can uniquely identify the Asset | **Every row shows the error message, and the row is not parsed.** |
| MachineId | Empty UUID | Missing field(s) which can uniquely identify the Asset | **The row is not parsed.** |
| SizeInGib | Non float | Invalid syntax | The cell is ignored. |
| SizeInGib | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| UsedInGib | Non float | Invalid syntax | The cell is ignored. |
| UsedInGib | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| UsedInGib | Not higher than Size | "UsedInGib" is higher than "SizeInGib" | The cell is ignored. |

### perfInfo file

| Column | Error case | Error message | Import behavior |
|---|---|---|---|
| Any column | Unexpected column | unable to find column mapping for `COLUMN_NAME` | The cell is ignored. |
| MachineId | Missing column | Missing field(s) which can uniquely identify the Asset | **Every row shows the error message, and the row is not parsed.** |
| MachineId | Empty UUID | Missing field(s) which can uniquely identify the Asset | **The row is not parsed.** |
| TimeStamp | Empty string | empty timestamp | **The row is not parsed.** |
| TimeStamp | Wrong format | Unexpected timestamp format `INPUT_VALUE`, want "2006-01-02 15:04:05-07:00" | **The row is not parsed.** |
| CpuUtilizationPercentage | Non float | Invalid syntax | The cell is ignored. |
| CpuUtilizationPercentage | X \< 0 \|\| X \> 100 | Invalid percentage `INPUT_VALUE` | The cell is ignored. |
| MemoryUtilizationPercentage | Non float | Invalid syntax | The cell is ignored. |
| MemoryUtilizationPercentage | X \< 0 \|\| X \> 100 | Invalid percentage `INPUT_VALUE` | The cell is ignored. |
| UtilizedMemoryBytes | Non float | Invalid syntax | The cell is ignored. |
| UtilizedMemoryBytes | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| DiskReadOperationsPerSec | Non float | Invalid syntax | The cell is ignored. |
| DiskReadOperationsPerSec | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| DiskWriteOperationsPerSec | Non float | Invalid syntax | The cell is ignored. |
| DiskWriteOperationsPerSec | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| NetworkBytesPerSecSent | Non float | Invalid syntax | The cell is ignored. |
| NetworkBytesPerSecSent | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |
| NetworkBytesPerSecReceived | Non float | Invalid syntax | The cell is ignored. |
| NetworkBytesPerSecReceived | Negative float | Unexpected negative value `INPUT_VALUE` | The cell is ignored. |

### tagInfo file

| Column | Error case | Error message | Import behavior |
|---|---|---|---|
| Any column | Unexpected column | Unable to find column mapping for `COLUMN_NAME` | The cell is ignored. |
| MachineId | Missing column | Missing field(s) which can uniquely identify the Asset | **Every row shows the error message, and the row is not parsed.** |
| MachineId | Empty UUID | Missing field(s) which can uniquely identify the Asset | **The row is not parsed.** |
| Key | Invalid according to GCP guidelines | Key `INPUT_VALUE` was converted to `OUTPUT_VALUE` according to GCP guidelines | The converted name is used for the key. |
| Key | Already exists | Key `INPUT_VALUE` already exists | **The label is not parsed.** |
| Value | Invalid according to GCP guidelines | Value `INPUT_VALUE` was converted to `OUTPUT_VALUE` according to GCP guidelines | The converted name is used for the value. |