Table Conversion Workbench Architecture

The Table Conversion (TC) Workbench (P9840TC) can be run using Convert All (this should always be used when migrating from JD Edwards World to JD Edwards EnterpriseOne) or Convert Selected.

Convert All runs with two loops. The outer loop keeps running until there are no more TCs to run, and there are no more TCs in a running status. The inner loop runs through the F98405 table looking for all TCs at a status less than 60. As it reads each new record, it then checks to see if there are any TCs waiting at status 35 for dependencies. It first tries to run those (checks again if their dependencies are satisfied), before trying to run the new TC that it just read.

The Technical TCs (those that are at conversion sequence < 100) run one at a time. For TCs above sequence 100, Convert All uses the maximum batch jobs specified in the Plan (4 by default), meaning it submits up to that number of TCs at once. Convert All submits 4, then loops waiting for a job to end and submits the next job. If you set the queue to a number larger than 4, only 4 are submitted at a time.

For each TC submitted, the program first checks whether the TC has dependencies and checks the status of those dependencies. If any of the dependencies are still running (status 45), the TC is changed to status 35 (waiting for dependencies).

Convert Selected can be used to submit several TCs at once and keeps looping until they are submitted. It does not keep looping until they have run. Press Find to see if they are done.

P9840TC monitors and updates F98405 (kept locally in JDEPLAN). The TCs update F984052 (kept in System – 910). At any point in time, there are records in F98405 at status 45 for TCs that actually have completed. The TC Workbench calls a business function at various points in its loop, which compares F984052 and F98405, and updates the status in F98405 to completed (60) or failed (50). If the TC Workbench fails (for example, you cancel out of it), go to P9840TC and drill down into the TCs, and press FIND. This synchronizes F98405 with F984052. The FIND button on the TC Workbench also synchronizes F98405 and F984052.

If the Enterprise Server fails while running the TC Workbench, you might have up to 4 jobs at status 45 (running), even though they might have failed. Follow the instructions in the paragraph above to get everything back into sync. If a TC actually fails altogether on the server (for example, you cancel the job) it will never get as far as updating F984052, and the process is not able to update F98405 correctly. When you press Convert Selected or Convert All, the process does not re-submit anything that is at status 45. When restarting the TC Workbench, you need to manually check whether any of the jobs at status 45 are still running, and set the status back to 30 or 50 if you want the TC Workbench to re-submit them.

All the Table Conversions have the same job name - R98405A. When looking in the JDE.LOG for that job, there is a message stating which TC is running.