Resolving the bad data

To resolve the bad parameter data, use any combination of these approaches:

• Edit the record and remove any invalid characters.
• Suppose the format is not correct. For example, the date is not in the invariant format. For these situations, modify and save the value.
• Use an SQL script, to correct the values in a bulk fashion.
• Change the parameter definition such that the data type is no longer a double (5) or a date (7). For example, if a parameter has a value of 5 in the TYPE_DATA column, then change the value to string (8). You can use SQL code to change the value. Or, you can change the parameter value within the Optiva user interface.

If the parameter is a date type, it must be in the ISO-8601 format. (Microsoft calls this date style "sortable".) Numeric parameter values must only contain a period; commas must be omitted.

The Script Library (TPDATAVALIDATION) can accommodate customized field validations (such as additional fields being validated, different report styles, etc.). Before you upgrade to another version of Optiva, keep backup copies of this Script Library. This ensures that you preserve your customized validations.