Definition

EndDefinition

Notes

• Integration logs are stored in EVO_DATA5000X databases.  See Different platform accounts.

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.  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

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.
           

Errors

List of errors occurring during integration.

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

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.

How to purge integration logs

      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.

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