Exception Management Guide

10.5
- 10.5.5
- 10.5.4
- 10.4.0

Back Next

Validation Errors in Exception Tasks

The Analyst tool displays a validation error if you try to enter a data value that is not valid for the column that stores it. You cannot enter a string data value to a numeric column. You cannot enter a data value to a column if the value is longer than the maximum character length in the column.

The Analyst tool can also display validation errors during find and replace operations. You cannot replace a value with another value if the replacement value is not valid in the destination column.

Example: City Names in India

You are a data steward in a multinational organization, and you work on an exception task that identifies older city names in India. You use a list of current and older city names to update the records in the task. For each city, you use the Replace All option to update the name. You use the default option to replace the values in all string data.

One of the columns that contains a city name specifies a maximum character length that cannot accommodate the current name. For example, the name Thiruvananthapuram replaces the name Trivandrum in the Indian state of Kerala. When the Analyst tool tries to update the name in the column, the operation fails and the Analyst tool displays an error.

Rename Saved Search

Table of Contents

Exception Management Guide

Exception Management Guide

Validation Errors in Exception Tasks

Validation Errors in Exception Tasks

Example: City Names in India