Synchronization Settings - j5 - 28.0 - Administration & Configuration - Hexagon PPM

j5 Maximo Integration Configuration

Administration & Configuration

The interface has two different mechanisms for synchronization with Maximo.

The first is a full synchronization in which all locations, assets, service requests and work orders are fetched from Maximo. The full data set is processed in j5 to identify entries that should be inserted, updated or deleted and the changes are applied to the j5 database. Assets are remapped based on the changes received from Maximo. This is currently an intensive, long running task and is started manually from the Maximo console. j5 controls the memory usage and load on the Maximo server by querying and processing Maximo data in batches. Number of records to fetch in a batch for full sync sets the size of each batch that j5 processes.

If the Number of records to fetch in a batch for full sync setting is set too large, then it is possible that the individual SOAP requests will time out and the sync will fail. A SOAP time out is dependent on the number of records it is retrieving and also the performance of the Maximo instance. If the setting is too small then the initial sync may take longer than expected to run. There may be some tweaking required of this value, but j5 recommends an initial value of 100 (which is the default).

The second mechanism is an incremental synchronization with Maximo. j5 identifies the last data it received from Maximo and queries Maximo for data that has changed since the last successful synchronization. Date format for SOAP requests is used when querying Maximo for the incremental changes. For example, if the last successful synchronization was at 2018-01-01 08:45, and the changed date field in Maximo is set to "CHANGEDATE", j5 will look for "CHANGEDATE > 2018-01-01 08:45".

It is not possible for the incremental synchronization to identify entries that are deleted in Maximo. This is only handled by the full synchronization which will be necessary in the unlikely occurrence that Maximo data is removed. When an Asset is no longer needed in Maximo, the common practice is to mark equipment as DISABLED instead of removing it from the system. In this case, the equipment will be marked as disabled in the j5 Asset Register through the incremental synchronization.

The full synchronization will be typically used as the initial integration step with Maximo. The incremental synchronization will run at the configured schedule (if automatic synchronization is enabled) and be sufficient to retrieve all the changes in Maximo going forward. If for some reason the incremental synchronization is not run for a long time and the SOAP request times out due to there being too many records to fetch, then it may be required to manually run the full synchronization again to allow the incremental synchronization to succeed.