RTPPM - About ProductionPath Table

[CB_10149096]

Hello everyone. I have trouble to manage Job Order Model in thingworx.  The error massage is

"EQ_Nukon6[JobOrderModel_MainService] Parameters - OldValue: OldValue,NewValue: 3,newValueTimestamp: Fri May 17 2024 08:44:45 GMT-0000 (UTC) : equipmentUID - 244 did not return any ProductionPathsUID"

I looked up the documentation and KPI's page says that we can manage this table.

I'm asking that while we set up equipment assignment in RTPPM's setting page, do thingworx manage the connection  betweetn tables or do we do it manually.

[mstarnaud · Accepted solution]

Hi CB

There are 2 tables in the database to manage paths for job orders : Production Path, which is like a group of equipments, and RoutingItem which is the list of equipments inside the groups. The "groups" will share job orders, if the equipments are in different "groups" then it will create a separate job order for each group. So if you have 2 production lines with 3 equipments each, normally you end up with 2 production paths and 6 routing items.

We only have 1 officially supported way to manage them : the Excel config import. See documentation here, in particular the "Production Paths" and "Routing Items" sections. Sadly there is no screen to manage this configuration.

When the RTPPM models run (like when receiving a job order name in the tag), they will check what the current equipment is, find its settings in the Routing Item table and also get its parent Production Path. Then it will check the job order list to see if the job order name already exists on that path, it will create it if necessary.

The error that you got, it's because it looked at the Routing Item & Production Path combination and found that the equipment (uid=244) wasn't listed on any path (missing Routing Item).