Troubleshooting validation process errors

Diagnosing an issue

When you create and run a dataload job for the first time, the system uses the data from a job template to create new records on the target forms. Data management supports data updates only for the CTM:LoadPeople form.

If you try to update the data on the forms for which the data update is not supported:

• For certain forms, the system overwrites the data and replaces the earlier field values with the values provided in the update. If you want to update data on such forms, you must provide values for all the form fields irrespective of whether you want to update those fields or not.
• For the forms listed in the list of Create Only forms (see Overview-of-the-data-load-process), the data is only created and not updated. These forms are marked by a Create Only flag, which is displayed in the Steps panel of a job record when the Validate and Promote steps are created for a job.

For the validate process, when you run a dataload job, the data is automatically validated before the data is promoted. Each validate step represents the validation of data for the staging form. The validation of foundation fields for transactional records against the staging data is possible only when both are contained within the same job and are for the same company. If separate jobs are created for the foundation fields and the related transactional data, then you must promote the foundation data first, and then validate the data against the target Remedy IT Service Management forms. For the validation step to run successfully, enable the escalations on BMC Helix ITSM server.

Gathering logs and error details

The validate step error details are available in the following locations:

• Load form—Click View Data and double-click the validate step to display the staging form. If an error message is displayed, open the staging form to view the errors that are displayed in the Error_code and Error_message files. For example:
  • CTM:LoadPeopleOrganization
  • RKM:LoadKnowledgeArticleManager
  • CTM:LoadPeople
  • COM:LoadCompany
• CAI:Events form
• The Error Management console—Errors found on the staging forms are flagged.
  For more information about fixing the errors, see Managing-data-errors-from-data-load-jobs.
• ARerror.log file—Lists the errors for the validation and promotion steps.

Troubleshooting license compliance errors

Issue symptom

An error message is displayed during the Load People Promote step process.

Issue scope

When you do not have sufficient licenses.

Resolution

You can load users into the system only if you have sufficient licenses. To fix the license compliance issue, you must perform one of the following steps: 

• Add the required licenses 
• Only load those users who have sufficient licenses

Troubleshooting the issue when the dataload process stops responding during the validation step

Issue symptom

The dataload stops responding during the validation step.

Issue scope

While running a dataload job, the escalations on the BMC Helix ITSM server are disabled, which interferes with the validation step.

Resolution

Follow the steps given in Prerequisites to Updating-target-values-by-using-the-Data-Wizard.  

Additionally, enable the escalations by performing the following steps: 

1. Open the AR System Administration Console. 
2. Select System  > General  > Server Information. 
3. Clear Disable escalations.
4. Click OK. 
5. Restart BMC Helix ITSM server.

Troubleshooting validation errors related to non-CI jobs

Issue symptom

The validation errors related to non-CI jobs are displayed.

Resolution

Review the validation errors using the Error Management Console. Correct the spreadsheet or data errors and run the job again from the step where the error occurred. If you have many errors to fix and want to cancel the job (for example, Knowledge load, People load, Foundation load), make sure that:

• For the data that is not promoted to the target form, load the same data from the spreadsheet to a new job.
• If some records were already promoted, remove the promoted data from the spreadsheet and then load the rest of the data to a new job.

Troubleshooting validation errors related to CI jobs

Issue symptom

The validation errors related to CI jobs are displayed.

Resolution

The validation errors related to CI jobs cannot be fixed and re-run from the Error Management Console. The validation step waits for the reconciliation job to complete and displays the related errors. If the job is stuck in the validation step, check the reconciliation logs. Cancel the job and load the data with a new job after you fix the data or reconciliation issue.

For example, if you load a how-to knowledge article with an incorrect site information, perform the following steps if the job fails:

1. Double-click or select View on the validate error and identify the form.
   
   
2. Copy the staging form name and navigate to the form.
   
   
3. In the Job ID field, enter the required job ID and check the Error Flag marked as Yes in the Error Flag column.
   
   
4. Based on the error message, check the spreadsheet for incorrect site names.

Resolutions for common errors

The following table lists the common errors and their workaround: