Troubleshooting Guide
The following guide can be used to troubleshoot your mapping and dataset conversion configuration. If you come across any errors or failures, you can follow this guide in a top-down approach to try and identify the issue.
General Troubleshooting
Duplicate Assets
Duplicate assets can cause issues in conversions. The Validator function can be used to check for duplicates. To run the Validator, select an asset group and click Validate from the toolbar. Duplicate assets are indicated by a Critical severity flag and must be fixed before running the conversion.
Check the Source Data:
As the output data is dependent on the source data, users should always check that the source data is as expected in the source application.
For example, check the following is correct in the source data:
- the name
- the number of records
- the data in the columns
With larger datasets, it is good practice to download the csv and check it in Excel. Filter columns and values to ensure you have full visibility of the data.
Manage Complexity
Inserting multiple complex source dataset mappings often leads to problems that are hard to troubleshoot. It is not advisable to mix two types of source dataset mappings. For example, one Horizontal mapping and one Horizontal to Vertical mapping in one dataset results in a very complex variable/valuelist level mapping. It is better to split these mappings into parallel datasets then combine the outputs.
Failed Conversions
Check the status of the conversion. From the toolbar, Data>View conversions can be used to view details of previous and current conversion tasks.
Generally, the following can cause a conversion task to fail:
- Empty datasets (i.e. no data)
- Datasets with no Variables (no Variables are referenced by the dataset)
- Duplicate column names within a CSV.
When viewing the conversion tasks logs, the following errors may cause the conversion to fail:
- ASG001: Asset group is missing the Standard Name
- ASG002: Asset group is missing the Standard Version
- DOM0013: Sort Output rows is missing variables or has incorrect variables
- DOM0014: Deduplicate/Sort Output rows is missing variables or has incorrect variables
- DOM0015: Incorrect Pivot Variable
- VAR0027: Copy Mapping has invalid variable references
Uploading Data
The following must be considered when uploading data:
- Do not use create asset group function, go to an existing Asset Group and select Data>Upload>select file.
- Uploads can take a while, especially if they are large or if you’re overwriting existing data.
- CSV files must use UTF-8 encoding
- Non UTF-8 characters within a CSV file may cause the upload to stop at that row (tip: use an UTF-8 editor like Notepad++ or a conversion tool like StatTransfer to force UTF-8 character encoding).
Dataset Troubleshooting
Scenario: The Dataset outputs no rows or an incorrect number of rows.
Check the following Dataset Mapper Properties:
Source Dataset Identifier:
Ensure that you have populated the Source Dataset Identifier property with the correct reference to a Source Dataset.

Source Dataset - Include Row Mappings:
If you are using the Include Rows mapping at the source Dataset level then you can check if the condition here is correct. For example, you may want to include rows where a source Variable is NOT equal to blank. If this column in the source dataset is blank, then this will cause the whole dataset to have no rows.

Source Dataset - Pivot Variable:
If you are using the Pivot functionality by specifying the Pivot Variable at the Source Dataset level, ensure that you have selected the correct variable. It must be in the same Dataset as the source Dataset and there should be values on that variable to facilitate the pivot process.
Double check the mappings on the Values as blank pivot Values will not create a row on output. So if some or all of the Value mappings are correct, the dataset will have fewer or no rows on output.
Variable Troubleshooting
Scenario: Columns in your target Dataset are not correct or are blank
Check the following Dataset Mapper Properties:
Source Type - Source Variable
Source columns are mapped from Variable properties using Source Type > Source Variable. If the output column is blank, check that the value entered as the Source Variable matches a column in the source dataset.

Source Type - Source Variable (Multi-stage mappings)
For SDTM mappings, there can be multiple stages to convert raw data to SDTM ( for example,
- Source Data > VEDC
- VEDC > SDTM+
- SDTM+ > SDTM
If an output column is blank, check the direct source mapping. Continue working backwards in the chain until you find where the issue is.
Source Type - Function
When using a Function mapping, ensure that you are using the correct Parameters for that Function. When working with Functions, please refer to Functions documentation. You can also see examples of some common functions in the Quickstart Guide - Example Mappings.
Dataset Lookup: Source
When using the Dataset Lookup mapping, if you get unexpected or blank outputs, check that the When conditions are correct. Check the data in your source and the lookup data to make sure that source and lookup variables are in the same format.