Seeding application processing generates information about each executed, seeding job Recent Seeds Information, Seeding Report. These reports help you in understanding the seeding job's status and outcome.
Recent Seeds Information
The Recent Seeds tab (located in the My Templates page) displays a summary about each of the last fifteen seeding jobs that were executed using the seeding template that currently displays in the Template Builder tab.
The table provides the following information per seeding job entry:
- Seed column:
- 1st line: ID of the seeding job. Also, when the clock icon appears to the left of the ID, it indicates that the seeding job was a scheduled seeding job (in contrast to a manually initiated seeding job)
- 2nd line: Creation <date> <time> of the seeding job
- Source column:
- 1st line: Name of the service used as the seeding source.
- 2nd line: ID of the service used as the seeding source.
- Backup column:
- Since the Live service data is always used for ServiceNow seeding jobs, two dash characters (--) display to indicate that column info is not applicable.
Note Using a backup of service data is not supported for ServiceNow seeding jobs. - Destination column: Name of the service used as the destination, whose table records had their data modified by the seeding job
- Status column (status of the seeding job):
- Progress bar - a progress bar displays while the seeding job is currently processing. The progress bar annotates both the percent of processing completed and the current processing step.
- Completed Successfully - all object/table records were successfully seeded.
- Aborted - seeding processing aborted.
- Completed with Errors - the seeding job completed, however, processing failed to insert some portion of object/table records (and/or delete some portion of object records, when using the Clean and insert seeding method).
- Failed - the seeding job failed due to error(s).
- Duration column: The amount of time taken by the seeding job
- Seeding job summary, as reported by the following columns:
- Method column - the type of seeding method used
- Success column- the number of table records successfully seeded into the destination. Displayed in parentheses, the number of table records successfully deleted, when using the Clean and insert seeding method
- Error column- the number of table records that failed to be seeded into the destination. Displayed in parentheses, the number of table records that failed to be deleted, when using the Clean and insert seeding method
- Seeding Report: Provides access to the seeding job's Seeding Report. Click to view detailed information about the seeding job, including any failures.
Seeding Report
The Summary tab provides an information overview about the seeding job, including a summary of any failed records and the reason they failed. The tab also provides the duration of the seeding job along with a breakdown of the time taken for each of the job's phases. Hover your mouse over the duration timeline to highlight each phase. You can download a full log to help troubleshoot).
The Summary tab provides an information overview about the seeding job, including a summary of any failed records and the reason they failed. The tab also provides the duration of the seeding job along with a breakdown of the time taken for each of the job's phases. Hover your mouse over the duration timeline to highlight each phase. You can download a full log to help troubleshoot.
The Insert & Update Errors tab provides information about the tables that failed. You can view when the error occurred, and the error message for each table to identify and fix the cause of the issue.
Click the download icon to download a log file containing seeding job results.
The log file can contain these seeding result entries:
- Seeding Result: Error - The Seeding application failed to insert a new record or failed to update an existing record
- Seeding Result: Duplicate - This result is not an error. The Seeding application identified that the record already exists in the destination and, therefore, when the seeding job uses the Incremental seeding method, the record is not re-inserted
- Seeding Result: Skipped - The Seeding application skipped inserting the record. Because the Seeding application could not also insert the record's parent record, therefore, the application did not try to insert the record.
- Seeding Result: Success - The Seeding application successfully inserted a new record or successfully updated an existing record