Scenario 4: Reset integration with Data Lake

M3 Graphical Lot Tracker has been deployed and data transfers occur frequently. Trace data is synchronized to Infor Data Lake. Trace data in Infor Data Lake needs to be reset, as it is out of synchronization with the data in M3 Graphical Lot Tracker. The most common reason for out of synchronization data is when data in M3 Graphical Lot Tracker has significantly changed due to a Data Refresh operation, or because of full reload from M3 Business Engine. However, it could also be due to an Infor Data Lake issue.

To reset the GLT database synchronization data, and to purge the M3 Graphical Lot Tracker trace objects in Infor Data Lake, complete these steps:

  1. In M3 Business Engine, select Menu > Administration Tools > Graphical Lot Tracker Administration.
    The application management pages are displayed.
    Note: Only users with the IFS role 'M3 GLT Administrator' can access the application management pages.
  2. Select Data Lake Import Settings to turn off and reset the synchronization to Data Lake for the affected table or tables:
    1. From the Dialog, select the tables for the reset:
      • Trace table
      • Trace Step table
      • Trace Relation table
      Note: After a full reload or a data refresh operation, the reset is performed automatically by the system. In such case, tables are not selected for synchronization in the dialog, and this step can be skipped.
    2. Click Reset to reset the synchronization status to Data Lake for the selected tables. To discard changes, click Cancel.
    3. Click Reset in the Confirmation Dialog to start the reset process for the selected table or tables. To discard changes, click Cancel.
  3. Go to Data Fabric and purge the M3 Graphical Lot Tracker trace objects:
    1. GLT_Trace
    2. GLT_TTraceRelation
    3. GLT_TTraceStep
    Note: You must also clean the Compass cache. See Infor Data Fabric documentation > Deleting data from Data Lake.
  4. In M3 Business Engine, select Menu > Administration Tools > Graphical Lot Tracker Administration.
    The application management pages are displayed.
  5. Select Data Lake Import Settings to specify these configuration options required for the data synchronization.
    1. From the Dialog, select one or more tables:
      • Trace table
      • Trace Step table
      • Trace Relation table
    2. Click Save to enable synchronization to Data Lake for selected tables. To discard changes, click Cancel.
    3. Click Start Import in the Confirmation Dialog to start synchronization for the selected table or tables. To discard changes, click Cancel.
  6. Synchronization to Infor Data Lake begins. This process can be monitored in System Log panel. The process name is 'pDataLake'.
  7. Go to Data Fabric and validate the M3 Graphical Lot Tracker trace objects:
    1. GLT_Trace
    2. GLT_TTraceRelation
    3. GLT_TTraceStep
    See Infor Data Fabric documentation > Viewing data in Data Lake.
    See Infor Data Fabric documentation > Querying the Data Lake.