1. Study Setup Guide
  2. Set up data transformations
  3. FAQs
  4. What does this transformation validation error message mean?

What does this transformation validation error message mean?

The validation error messages you may see are, in alphabetical order:

  • DME_XFMVAL_AUTH_YES_ERR: One or more source tables is blinded and the target table is not blinded. You must either set the target table's Authorize flag to Yes if you know that it will not contain any of the sensitive, blinded data from the source tables, or go back to the clinical data model and set the target table's blinding attributes appropriately. Special privileges are required for either action.

  • DME_XFMVAL_COL_DATATYPE_ERR: The data type of the source and target columns must be the same.

  • DME_XFMVAL_COL_LEN_TRUNC_ERR: To prevent data loss, the target column must have a length equal to or greater than the source columns.

  • DME_XFMVAL_COL_NOSRC_ERR: Mapping required. Add one or more source columns or specify a constant value or mark as Not Used.

  • DME_XFMVAL_COL_NOTRGT_ERR: Each column mapping must have one target column.

  • DME_XFMVAL_COL_SRC_TRGT_SAME: A column cannot be mapped to itself.

  • DME_XFMVAL_ERROR_NOT_FOUND: All mappings are valid.

  • DME_XFMVAL_MOD_CYLIC_TAB_ERR: This model has circular table mappings.

  • DME_XFMVAL_MOD_SRC_NOTFOUND: A model mapping must have at least one source model.

  • DME_XFMVAL_MOD_SRC_TRGT_SAME : A model cannot be mapped to itself.

  • DME_XFMVAL_MOD_TAB_INVALID: A model mapping must have valid table mappings.

  • DME_XFMVAL_MOD_TAB_NOTFOUND: A model mapping must have at least one table mapping.

  • DME_XFMVAL_MOD_TRGT_NOT_ONE: A model mapping must have one target model.

  • DME_XFMVAL_NOTNULLCOL_HARDCOD: Not null columns in the target table must be mapped to either a source column or a constant value.

  • DME_XFMVAL_NOTNULLCOL_NOMAPERR: Mapping required. Not null columns in the target table cannot be left unmapped.

  • DME_XFMVAL_PRMCOLS_HARDCOD: All primary key columns in the target table cannot be mapped to a constant value.

  • DME_XFMVAL_PRMCOLS_UNMAPPED: Mapping Required. All primary key columns in the target table are unmapped.

  • DME_XFMVAL_PRMCOL_HARDCOD_ERR: Primary key column in the target table cannot be mapped both to source column or to a constant value simultaneously.

  • DME_XFMVAL_PRMCOL_MAP_ERR: Primary key column in the target table must be either mapped to source column or to a constant value.

  • DME_XFMVAL_PRMCOL_NOMAPERR: Mapping Required. Primary key column in the target table cannot be left unmapped.

  • DME_XFMVAL_TAB_DIR_MULTSRC_ER: Table mappings of type Direct can have only one source table.

  • DME_XFMVAL_TAB_JOIN_ONESRC_ERR: Table mappings of type Join must have at least two source tables.

  • DME_XFMVAL_TAB_NOCOLMAP_ERR: Table mappings must have at least one column mapping.

  • DME_XFMVAL_TAB_NOSRC_ERR: Each table mapping must have at least one source table.

  • DME_XFMVAL_TAB_NOTRGT_ERR: Each table mapping must have one target table.

  • DME_XFMVAL_TAB_SRC_TRGT_SAME: A table cannot be mapped to itself.

  • DME_XFMVAL_TAB_UNION_ONESRC_ER: Table mappings of type Union must have at least two source tables.

  • DME_XFMVAL_XFORM_TYPE_ERR : Incorrect Table Map Type. It can be Direct, Join, Union, Pivot or Unpivot.

Parent topic: FAQs