Skip to main content

Error: 'Merge Task KPIs unknown job code' when importing data from FactoryMaster

Written by Charnjit Singh Dharival

Full error message:

Orchestrate Data Flow Import has failed. The detailed information is as follows:

Merge Task KPIs: Unknown Job Code: [job code number]

Import command: EXEC [wf].[per_Merge_TaskKPIs]


Solution 1

Please check for any labour or machine resource groups which are empty and require resources to be added to them.

Also, within FactoryMaster, zoom into the operation the job code in the error message refers to and complete the following steps:

  1. Select production

  2. select works order enquiry

  3. Hit enter and select the relevant works order

  4. Press F5 to zoom in and select the relevant operation

  5. Select the field in the Resource Code column and press F5

  6. One of the resource codes is set to No within the Include In Schedule column.

Solution 2

If this does not resolve the issue, please try one of the following:

  1. Change the completed works order operation back to 'in progress' status and apply a set & op time

  2. Change the 'operation' on the components records to an operation that does appear in the 'active operations' table

  3. Issue stock to the components so they are no longer outstanding

The orchestrate views exclude 'complete' operations as they are no longer needed for scheduling. The offending operation may have no set or op time associated, meaning it essentially does not do anything and is also excluded from scheduling.

Did this answer your question?