Setting up initial load data

The steps here are necessary to complete to set up and start an initial data load from M3 BE.

The amount of time to complete the steps may vary from a few hours to days depending on the number of transactions to trace in the M3 Stock Transaction Table (MITTRA).

Note: A load based on 22 000 000 MITTRA transactions (excluding internal stock movements) executed in 10 hours.
  1. Open Microsoft SQL Server Manager Studio and go to SQL Server Agent > Job Activity Monitor
  2. Right click "Trace-M3TEnnnPPP_All_Data" job and select "Start Job at Step".
  3. Start the job at Step ID 1 (Master Data). The job will fetch M3 master and order data and then do a number of iterations retriving and processing transaction data.
  4. To monitor the process, click the System Log tab in the configuration tool, or run the following SQL command:

    SELECT * FROM [Trace-M3TEnnnPPP]..SSystemLog ORDER BY timestamp DESC

  5. Set up a backup schedule for the Trace databases.