1. Direct Migration to JD Edwards EnterpriseOne Guide
  2. To restart workbench:

To restart workbench:

  1. Delete SQL packages. Do this before signing onto the software on the Deployment Server. Services must be down before deleting SQL packages.

    1. STRPDM

    2. Option 2

      Library: <data library>, for example CRPDTA

      Name: *ALL

      Type: *SQLPKG

    3. Option 4

    4. Click Enter.

  2. To rerun a conversion, reset the status of the conversion in Table Conversion Planner from 35, 45, or 50 to 30. If a conversion is still running when workbench is restarted, leave its status at 45.

Problem Submitting

If Table Conversion Workbench fails to submit a conversion to the server (for example, services are not running), it sets the conversion status to 50 and does not submit any more conversions.

F9843, F9843T

Table Conversion Schedule (GH9611) - lists all conversions that are run. They are conversion types 3, 31, and 32. Table Conversions that must run on the Deployment Server are flagged here.

This resides in System Local and System – 910

F98405

Workbench Status (GH961) - Table Conversion scheduler records, among others, are copied from F9843 to F98405 during Finalize Plan. The Workbench is driven off records in this table.

This resides in Planner – 910 data source.

F984052

History (GH9611) - Stores conversion history for table conversions. A new record is created in this table every time a conversion is launched. R98405A writes the status for a completed conversion to this table. Table Conversion Workbench polls this table for completion status and updates the status in F98405.

Resides in the System – 910 data source. The table is originally mapped to Planner – 910. It is copied to System – 910 and remapped during Release Master. The table must be in System – 910 so conversions on the Enterprise Server can communicate their completion status back to Table Conversion Workbench.

F986110

Submitted Reports (GH9011) - the software creates records in this table for conversions launched on the server. They can be viewed using Submitted Reports.

Resides in Server Map <xxxx> – 920 Server Map, where <xxxx> is the machine name.

F986130

Job Queues (GH9013) - Job Queues may be defined by the installer in the JDEPLAN environment. If any queues have been defined, they are copied to the System – 910 data source during Release Master. If no queues have been defined, Release Master creates default queues in the System – 910 data source. The Enterprise Server is mapped to the table in the System – 910 data source. Log into the DEP920 environment and open the Job Queues application to view queues.

Resides in System Local and System – 910.