Integration Logs


Caution: If you inadvertently perform a purge of integration logs, you cannot undo the action. The EasyVista team will not resolve any issues related to the deletion of data and its impact on your platform.
Definition

An integration log is a text file generated by the smoScheduler scheduler once an integration model has run. It provides a report on the integration of data in the Service Manager database and displays the list of errors that require corrective action.

EndDefinition

Notes

Caution

  • If you inadvertently purge integration logs, you cannot undo the action.

Best Practice

  • Display the list of errors to identify the multilingual labels that the integration was unable to update in the related tables.
  • Create a scheduled task on each platform environment to purge integration logs automatically on a regular basis. Open url.png See the procedure.
    • Use the dedicated parent query called Integration log.
    • In Other Parameters, the Delete integration logs older than X days parameter enables you to specify the number of days after which integration logs should automatically be deleted.

Menu access

Administration > Integration > Integration Log

Screen description

        Integration log.png

Details

Integration Model: Name of the integration model.

Status: Status of the integration, automatically updated at the end of the integration processing.

  • The Failed status means that data was not integrated. The blocking points will be listed in the Errors tab.
  • The Succeeded (Warning Messages) status means that the integration was performed. The points to be checked will be listed in the Errors tab.

Start Date: Start date/time of the integration.

Duration (H:M:S): Duration of the integration in hours/minutes/seconds/milliseconds.

Connector: Name of the connector used for integrating data.

Unique Key Field: List of fields used as the unique key in the integration model.

Data Type: Source of the third-party data:

  • CSV: Text file in CSV format.
  • datasource: Database.

Qty Records: Total number of records processed during integration.

Support Person: Name of the user who ran the integration.

Qty Inserted Records: Number of new records added to the Service Manager database during integration.

  • Select the Records tab to display the list of records in each of the connector tables.

Qty Updated Records: Number of records modified in the Service Manager database during integration.

  • Select the Records tab to display the list of records in each of the connector tables.

Records

Number of records added and updated in each connector table used by the integration model.

  • To see the details of records, click the Added or Updated link.
             List records added.png

Errors

List of errors occurring during integration.

  • The row number refers to the row in the data file used for the integration.
             Integration errors.png

Procedures and Wizards

How to consult an integration log

1. Select Administration > Integration > Integration Log in the menu.

2. Click the log file.
The details of the log will appear.

3. Display the list of updated records in each connector table used by the integration model by clicking the Added or Updated link in the Records tab.

4. View the integration errors in the Errors tab.

Best Practice icon.png If there are too many errors, restore the Service Manager database using the backup. Correct the source data and run the integration again.

How to purge integration logs

     Open url.png See the detailed procedure: How to create a purge

Step 1: Specify the period after which integration logs should be purged

1. Select Administration > Parameters > Other Parameters in the menu.

2. In the {ADMIN} Delete integration logs older than X days parameter, specify the number of days after which integration logs should automatically be deleted.
 

Step 2: Create the new purge

1. Select Administration > Purge > Purge Archives in the menu.

2. Click + New.
 

Step 3: Specify the information on the purge

1. Specify the information on the purge and click Next.

  • Enter a name for the purge.

    example  Deletion of integration logs

  • Select the parent query called Integration log.

2. Select the fields to be displayed in the CSV file generated by the purge and click Next.

3. Specify the frequency of the purge and click Next.

Best Practice icon.png  

  • Before moving on to the next step, test the purge by clicking Test to check the number of records that will be deleted.
  • Enter a date earlier than the current date in order to run the purge immediately after saving the scheduled task.

4. (optional) Specify the recipients of the notification email and click Next.

5. Click Finish.

The purge is now operational. The integration logs will automatically be deleted based on the period specified in Other Parameters.

Wizards

Empty All Integration Logs

Tags:

Shortcuts

Powered by XWiki © EasyVista 2022