Resolving validation errors in FastMap

Applies to: All deployment types

Before FastMap can import data into the IBM OpenPages® application, you must resolve all validation errors that are displayed in the FastMap validation dialog box.

You resolve these errors by opening the FastMap template in Microsoft Excel and modifying the data.

When finished, you must resubmit the updated template to FastMap for another validation check. If errors are still found, you must repeat the resolution process until all validation errors are resolved. After all validation errors are resolved, FastMap is ready to import the data into the OpenPages application.

Validation errors

Validation errors and warnings are displayed in the FastMap validation dialog box after validation completes.

If the FastMap validation process completes with:

  • No validation errors - a status message is displayed indicating the number of objects to be imported.
  • Warnings - you can load your data or correct the warnings and revalidate.
  • Errors - a "Validation Failed" status is displayed along with information about the error.

Table 1 lists some of the most common messages that might be displayed in a FastMap Import window.

Table 1. FastMap import validation error information
This column... Displays this... Possible values...
Type The category of the message.
  • Error
  • Warning
Description The type of error, and the name of the missing or invalid object field or invalid value. See Validation messages.
Sheet The name of the object type worksheet. For example, Processes or Risks.
Row The row within the Excel worksheet that contains the error. The index number corresponding to a row, for example, 2.
Column Index The column index within the Excel worksheet that contains the error. The index letter corresponding to a column, for example, N.
Column Header The name of the column within the Excel worksheet that contains the error. The localized label of a field name, for example, Domain.

For example, if the following validation message was displayed in the table on the FastMap Import window:


Error Required property is missing value.(Domain) Processes 2 N Domain

You would open the data load template, and enter the missing value (such as Financial Management) in row 2 under the Domain column (N) on the Processes worksheet.

Validation messages

The following tables list FastMap validation messages and what a user can do to resolve the issues.

Messages are listed in alphabetical order.

Table 2. FastMap validation error messages
Message Cause Resolution
Column heading could match multiple properties This error can happen when a field's label or a custom column heading is the same as a FastMap column heading. The reserved headings are:
  • Delete
  • Parent Path
  • Parent Object Types
  • Parent Objects
  • Folder Path
  • Tags
 Set useSystemNames to TRUE in the definition worksheet. For more information, see Parameters for importing and exporting data.
Currency field is missing currency code. A local amount is entered but the Local Code field is blank. Make sure that a value is set for Local Code in currency fields.
Currency field is missing local amount. A local code is entered but the Local Amount field is blank. Make sure that a value is set for Local Amount in currency fields.
Exchange rate for base currency can only be set to 1. The Local Code and Base Code fields are set to the same value but the Exchange Rate field is set to a value other than 1. If the Local Code and Base Code values are the same, set the Exchange Rate field to a value of 1.
Import of Signature Objects not supported. Signature objects are not supported for import. Remove Signature objects from the worksheet.
Invalid boolean format. Value must be either true or false. An invalid Boolean value is specified. Ensure that the Boolean value is set to either true or false.
Invalid classifier format. Values in classifier fields or classifier target fields were exported, edited, and reimported. Remove the value from the spreadsheet or re-export and import the data. Do not edit classifier fields or classifier target fields after you export them.
Invalid currency code. An invalid value was entered for a currency code. Ensure the 3-letter ISO currency code is spelled correctly and is valid.
Invalid date format. The cell contents for a Date field are not recognized. Format the cell in Excel as Date to resolve the issue.

If you leave the format as either General or Text, the text in the cell must match the inputDateFormat parameter. You can set the date format on the Definition worksheet to values such as dd/mm/yy.
Invalid decimal format. A non-numeric value was entered for a decimal field. Make sure that decimal fields have a numeric value.
Invalid decimal range. The numeric value that is entered is outside the minimum or maximum range defined for that field. Make sure that the specified value is within the numeric range that is defined for that field.
Invalid Exchange Rate. The exchange rate is 0 or negative. Make sure that the exchange rate value is greater than 0 (zero).
Invalid group. An invalid value was entered for a Group field. Ensure that the name of the group is spelled correctly and is valid.
Invalid Integer format A non-numeric value was entered for a numeric value. Make sure that the field has a numeric value.
Invalid Integer range. The numeric value that is entered is outside the minimum or maximum range defined for that field. Make sure that the specified value is within the numeric range that is defined for that field.
Invalid Object Profile. Unable to properly validate spreadsheet. A value for the profile is specified that is not recognized. Ensure that the name of the profile is spelled correctly and is valid.
Invalid parent resource provided. The value of the parentResource parameter is invalid. Make sure that the full path of the specified parent object is correct.
Invalid Property Type. The column header is not recognized as a property by FastMap.

Possible causes:

  • The field is misspelled in the column heading on the worksheet
  • The field is missing from the view of the profile that is used to import data. The view is specified by viewName on the Definition worksheet. The default is Admin.
 Ensure that the column header is spelled correctly. If so, make sure that the property is present in your profile's Admin view.
Note: If you do not want the column to be processed, you can list it under the ignoreColumns parameter on the Definition worksheet.
Invalid URL. An invalid URL was entered for a URL field. Ensure that the URL is correct and fully qualified.
Invalid user. An invalid value was entered for a User field. Ensure that the name of the user is spelled correctly and is valid.
Invalid user/group. An invalid value was entered for a User/Group selector. Ensure the name of the user or group is spelled correctly and is valid.
Locale is invalid. The locale value that is specified is not recognized. Ensure that the value of the locale is spelled correctly and is valid.
Missing currency code column. The local code column is missing and a local amount is specified. Make sure that the local Currency code column is present in your worksheet and has a value for this record.
Missing local amount column. The local amount column is missing and a local code is specified. Make sure that the local Amount column is present in your worksheet and has a value for this record.
Multiple resources found with the same key value. When using Key fields, a key is specified that is not unique and FastMap cannot determine which resource to update. Make sure the value that is specified for each Key is unique.
Name cannot be blank.
  • An object type that is not configured for auto-naming has an empty Name or Name.ID field.
  • The Name or Name.ID column is missing from the worksheet.
  • The source environment does not use the System Fields:Title field but the target environment does. When the Title field is disabled, the worksheet uses a Name column. When the Title field is enabled, the worksheet uses Name.ID and Name.Title columns.
Note: This error does not occur if auto-naming is enabled for an object type.
 Make sure the Name or Name.ID column is present in your worksheet and has a value in it for this record.

If your target environment uses the Title field, make sure that the worksheet contains the Name.ID and Name.Title columns and that the Name.ID field has a value.
Name contains illegal characters. The Name contains backslashes or forward slashes. Remove any backward slash (\) or forward slash (/) marks from the name of the object.
Name exceeds maximum characters in bytes. The Name is longer than 252 characters or bytes for multi-code locales. Make sure that the name of the object is shorter than 252 characters or bytes.
Object cannot be associated to a parent of this type. A parent-child relationship does not exist between the object types that were specified. Either enable an association between the object types that you want to associate or modify the worksheet to reflect object types that have a child-parent association already configured.
Parent not specified. A parent is not specified for a new object and the allowOrphans setting is not set to true.

The objects being updated do not need to have a parent specified.

 Ensure that all three parent fields are present and populated correctly.
Parent Resource content type not recognized. Check that it is viewable in your profile. The object type of the resource that is specified by the parentResource parameter is not recognized. Ensure that the object type is spelled correctly. If it is, make sure that the object type is present in your profile's Admin view.
Parent Resource not found. A parent is specified in your spreadsheet, but FastMap cannot find it in the IBM OpenPages repository. Make sure that the Parent Path is pointing to the proper folder location and that the Parent Objects value is the proper name of the object.
Property value exceeds maximum characters. A text field contains more characters than is allowed in the OpenPages application. Modify the text field so it does not exceed the character or byte limit.
Required property is missing value. A required field for the object type is missing a value.

Possible causes:

  • The column is present on the worksheet and the cell is missing a value
  • The column for the required field is missing.
 Make sure that you have a value set for all properties that are required on the object.
System error. Any unexpected error occurred. Similar to a Requested operation cannot be completed system error message. Contact IBM® Support.
Text field formatted as number in spreadsheet. A text property value is formatted as a number or a date in the spreadsheet.

A Text field in OpenPages is formatted in the worksheet cell as Number or Date.

In OpenPages, the Excel formatting cannot be retained for the field.

 Change the format of the cells in Excel to Text.
The file exceeds the maximum number of rows allowed for import. The total number of rows in the workbook is greater than the value set in the Maximum Workbook Rows setting. For more information, see Limiting the rows for import. Modify the worksheet so it does not exceed the row limit or change the value of the setting.
The value entered is not a valid selection for this field. The value for a single select drop-down field is not a valid value.

The value must be in the proper locale of the user for it to be recognized.

 Ensure that the value is typed correctly and is in the correct locale.
The values entered are not valid selections for this field. The value for a multi-select drop-down field is not a valid value.

The value must be in the proper locale of the user for it to be recognized.

 Ensure that the value is typed correctly and is in the correct locale.
User must be assigned to the {0} profile to load this file. You don't have access to the profile that is required to import the file. To see which profile is required, see the profileName parameter on the Definition worksheet.

Contact your administrator for assistance.

This validation check is enabled when /Applications/GRCM/FastMap/Enforce Profile is true.
Table 3. FastMap validation warning messages
Message Cause Resolution
Full import will result in objects being deleted. When setting fullImport to 'true', FastMap identifies objects to be deleted. Informational message, no action required.
Invalid Content Type The worksheet name is not recognized by FastMap as a valid object type in the system.

Possible causes:

  • The object type is misspelled on the worksheet tab.
  • The object type is missing from the profile being used to import data.

    Although FastMap imports the workbook, the invalid worksheet is ignored.

  • In an English locale, the locale in the Excel worksheet was changed to something other than en_US after the data was exported to Excel. An error is issued when the data is imported with FastMap.
Make sure that the object type is spelled correctly on the tab of the worksheet.

FastMap treats each worksheet in the workbook as a content type sheet.

Note: If you do not want the worksheet to be processed, you can list it under the ignoreSheets parameter on the Definition worksheet.
Property is read only. A value was entered for a field that is read only in the view of the profile that is used for import. The view is specified by viewName on the Definition worksheet. The default is Admin.

Although FastMap imports the data, the read-only field is ignored.

 Remove the columns from your worksheet.

You can also specify the ignoreReadOnlyWarnings parameter so that these messages do not occur. However, these fields will not be updated when importing.
Record conflicts with more recent updates and will be ignored. A record's last modified date is more recent than the value from the exportDate parameter. See Conflicts with recent updates warning message for details.

Conflicts with recent updates warning message

If you are unable to import changes, this warning message might be displayed: Record conflicts with more recent updates and will be ignored. You need to check the timestamp value for the exportDate parameter on the Definition worksheet in the template. The warning message is displayed whenever you try to import a template and the data for an object has been updated since the specified export timestamp.

Important: If you are certain that the changes you want to import are current for all objects in the workbook, you can remove the export timestamp from the template following this procedure.

Procedure

  1. Open the FastMap template in Excel.
    1. If necessary, unhide the Definition worksheet. For more information, see Unhiding a FastMap Definition worksheet.
    2. Remove the exportDate parameter.
    3. Save the change.
  2. Resubmit the template for import.