Setup for parallel processing

This appendix describes the additional setup that is required to run the CI Process (tccri7203m000) session using parallel processing.

Parallel Processing Configuration (ttaad7520m000)

Prerequisites

None

Actions

In the Parallel Processing Configuration (ttaad7520m000) session, configure the CI Process (tccri7203m000) session for parallel processing. Enter the number of servers that must be used, and specify the mode.

Setup of the currency-initialization environment

Prerequisites

Sharing of standard CI tables is according to "Setting Up the Currency-Initialization Environment."

Actions

The companies that will be converted according to the CI-Cluster Companies (tccri7502m000) session, must share these tables:

  • CI Conversion Tables by Cluster Companies (tccri725)
  • CI Cluster Conversion Tables Update Groups (tccri726)
  • Conversion Progress Log (tccri730)

For the complete list of shared tables, see "Setting Up the Currency-Initialization Environment."

CI Conversion Tables by Cluster Companies (tccri7125m000)

Prerequisites

  • CI cluster setup is completed.
  • CI tables and CI table fields setup is completed.
  • Customized tables and table fields are specified.

Actions

Run the CI Conversion Tables by Cluster Companies (tccri7125m000) session to generate data for each company in a cluster. This session lists all CI tables of the CI Tables (tccri7522m000) session. Tables are listed if the following applies:

  • CI table has conversion by DLL.

  • CI table has CI fields defined.

    Note: Tables are only listed for the physical company.

To generate the data in this session, use the Update CI Conversion Tables by Cluster Companies command on the appropriate menu. This will start the Update CI Conversion Tables by Cluster Companies (tccri7225m000) session. Update CI Conversion Tables by Cluster Companies (tccri7225m000)

After you have generated the data, tables such as Integration Transactions (tfgld482) and Reconciliation Data (tfgld495) can be split. To do so, on the appropriate menu, use the Wizard Split Table by Conditions command.

Wizard Split Table by Conditions

Use the Wizard Split Table by Conditions to split the conversion of one table into multiple conversions. LN will generate multiple table sequences that have a range condition. Each range can be used to execute the table conversion with parallel processes. You must use the wizard to split large tables, such as Integration Transactions (tfgld482), Reconciliation Data (tfgld495), and Finalized Transactions (tfgld106).

Example 1

To split the Integration Transactions (tfgld482) table or the Reconciliation Data (tfgld495) table, start the wizard, and then enter the default number of split values. We recommend that you enter a number that matches the number of servers that will be used. After you have entered the number, the wizard generates the split values. You can modify these values, but if the table field shown in the wizard is a GUID, we recommend that you leave the split values intact. Click Update, and the ranges will be generated.

Example 2

To split the Finalized Transactions (tfgld106) table, start the wizard, and then do either of the following:

  • Enter the default number of split values. (recommended)
  • Leave the default number of split values zero and enter split values manually.

The wizard will access the finalized transactions table, and determine the documents at which the table conversion will be split. Click Update, and the ranges will be generated.

Calculation of the conversion weight

After using the wizard, the table is split. Calculation of the conversion weight can be time consuming. Therefore, this calculation is not done in the wizard. After you have split all applicable tables, run the Update CI Conversion Tables by Cluster Companies (tccri7225m000) session, and select Update CI Conversion Tables by Cluster Companies and Calculate Conversion Weight.

CI Cluster Conversion Tables Update Groups (tccri7126m000)

Prerequisites

  • CI cluster setup is completed.
  • CI tables and CI table fields setup is completed.
  • Customized tables and table fields are specified.
  • CI process is executed at least once for the given conversion cluster (trial or real conversion mode).

Action

None

Explanation

This session lists the companies in an update group of a given conversion cluster, company, table, conversion, conversion phase, update group. The data displayed is created in the CI Process (tccri7203m000) session.

Update CI Conversion Tables by Cluster Companies (tccri7225m000)

Prerequisites

  • CI cluster setup is completed.
  • CI tables and CI table fields setup is completed.
  • Customized tables and table fields are specified.

Action

Use this session to generate the data for CI Conversion Tables by Cluster Companies (tccri7125m000).

Select the cluster that specifies the data for the internal currency conversion. The Company field displays the key company of the selected cluster.

Explanation

Initial setup

If you run this session for a selected cluster for the first time, select Initialize CI Conversion Tables by Cluster Companies. Click Update to generate the data. This initialization step will calculate the conversion weight for all data. Depending on the size of the tables, this process may take a considerable amount of time.

Synchronize with CI tables

To restart the update or if, for example, data in CI Tables (tccri7522m000) has changed, select Initialize CI Conversion Tables by Cluster Companies (Net Change). This option will add missing data in CI Conversion Tables by Cluster Companies, and remove data that is no longer present in CI tables.

Update existing data in CI Conversion Tables by Cluster Companies (tccri7125m000)

To recalculate conversion priorities, select Update CI Conversion Tables by Cluster Companies (tccri7225m000). Selecting Reset Conversion Weight will nullify all existing conversion weights. Selecting Calculate Conversion Weight enables the calculation of conversion weight, but only if the conversion weight is zero.

Note: Usually, it will be sufficient to calculate the conversion weight just once. You will need to manually fine-tune the values only if this is required.

CI Conversion Tables by Cluster Companies (tccri7125m000)

Prerequisites

Run this session if one or more of these applies:

  • Data was generated as a result of running the Update CI Conversion Tables by Cluster Companies (tccri7225m000) session.
  • CI tables data was generated as a result of running the Initialize CI Tables and CI Fields Tables (tccri7221m000) session.
  • Data was manually changed in the CI Tables (tccri7522m000) session.

Action

Run this session to check the integrity of the data in CI Conversion Tables by Cluster Companies (tccri7125m000).

Explanation

We recommend that you run the Check Data in CI Conversion Tables by Cluster Companies (tccri7425m000) session before you run the CI Process (tccri7203m000) session in parallel processing mode.

Select the cluster for which the data must be checked. LN performs these checks:

  1. Is the required data present?

    Each combination of CI table and cluster company must exist. Data of shared tables that have standard conversion rules defined, is only for the physical company. If data is missing, the CI table and company will be printed on the report. Message on the report: Table is not defined in the CI Conversion Tables by Cluster and Companies (tccri725) table, but table is defined in the CI Tables (tccri722) table.

  2. Are all CI tables present in the CI Tables (tccri7522m000) session?

    If a CI table is present in CI Conversion Tables by Cluster Companies (tccri7125m000), the table must also exist in CI Tables (tccri7522m000). Message on the report: Table is not defined in the CI Tables (tccri722) table, but table is defined in the CI Conversion Tables by Cluster Companies (tccri725) table.

  3. Is the phase of each entry in CI Conversion Tables by Cluster Companies (tccri7125m000) consistent with CI Tables (tccri7522m000)?

    Message on the report: The value of the Phase field is Pre/Main/Post. This value is inconsistent with the DLL Execution before/after Conversion field in the CI Tables (tccri722) table.

  4. Are all conversion weights entered?

    Each table that has a conversion weight equal to zero, will be printed on the report. Message on the report: The value of the Conversion Weight field is 0.

To correct errors:

  1. Start the Update CI Conversion Tables by Cluster Companies (tccri7225m000) session, and do the following as applicable:
    • For errors reported by checks 1, 2, and 3, select Initialize CI Conversion Tables by Cluster Companies (Net Change).
    • For errors reported by check 4, select Update CI Conversion Tables by Cluster Companies and Calculate Conversion Weight.
  2. Click Update.

Print Progress Log (tccri7430m000)

Prerequisites

The CI Process (tccri7203m000) session was run in trial or real mode.

Action

Print a progress log to report the conversion of tables. The report shows the amount of time spent on each CI table per company. In addition, it shows the server process that converted the data.