Skip to main content
G
GABRYEL2577012-Amethyst
12-Amethyst
July 13, 2023
Solved

Thingworx RTPPM KPI is not calculating OEE

  • July 13, 2023
  • 1 reply
  • 2092 views

I have six WorkUnits configured in RTPPM, but the only one who calculate the OEE is the Machine1, all the others machines don't calculate and i don't know why because it looks like the rest is normal.

 

This is the most current error:

 

[PTC.SCA.SCO.MnfgCommonEquipmentUtilsThing].[SetUserDefaultSelectedEquipmentsBySolution_EQT]: Returned the following error : JavaException: com.thingworx.common.exceptions.ModelAccessException: [2,000] Error occurred while accessing the model provider.

 

I will be greatful if someone can help me.

 

 

 

 

Best answer by mstarnaud

Hi GM

 

About the error message in your first post, I suspect it's simply not related to this issue.

 

So the first thing to notice is that all 3 of the KPIs are at 0%. This makes me suspect that the TimesliceSchedule table in the database is missing the records for this equipment, this will also result in the equipment having no record in the Timeslice table. Please refer to this link to see the query to insert the missing records. Because the Timeslices (containing the numbers to get the KPIs) will not be calculated if those records are missing, and the KPIs use the calculated Timeslice values.

 

Queries to check, if you need help : 

SELECT * FROM equipmnt -- find the UID of your equipment
SELECT * FROM timeslice WHERE equipmentuid = ..... -- write the Uid here, I'm guessing this will give no result.
SELECT * FROM timesliceschedule WHERE equipmentuid = ..... -- write the Uid here, I'm guessing this will give no result.

 

There are a few Articles in the knowledge base relating to the Performance and Quality KPIs failing to calculate. However in those cases the Availability% would still get calculated, which is not your scenario here. Here's some Articles about this, in case you need them : 

https://www.ptc.com/en/support/article/CS363687

https://www.ptc.com/en/support/article/CS362880

1 reply

G
GABRYEL2577012-AmethystAuthor
12-Amethyst
July 13, 2023

This is the images where the Machine1 is working but Machine2 not.Machine1.pngMachine2.png

mstarnaud
mstarnaud16-PearlAnswer
16-Pearl
July 13, 2023

Hi GM

 

About the error message in your first post, I suspect it's simply not related to this issue.

 

So the first thing to notice is that all 3 of the KPIs are at 0%. This makes me suspect that the TimesliceSchedule table in the database is missing the records for this equipment, this will also result in the equipment having no record in the Timeslice table. Please refer to this link to see the query to insert the missing records. Because the Timeslices (containing the numbers to get the KPIs) will not be calculated if those records are missing, and the KPIs use the calculated Timeslice values.

 

Queries to check, if you need help : 

SELECT * FROM equipmnt -- find the UID of your equipment
SELECT * FROM timeslice WHERE equipmentuid = ..... -- write the Uid here, I'm guessing this will give no result.
SELECT * FROM timesliceschedule WHERE equipmentuid = ..... -- write the Uid here, I'm guessing this will give no result.

 

There are a few Articles in the knowledge base relating to the Performance and Quality KPIs failing to calculate. However in those cases the Availability% would still get calculated, which is not your scenario here. Here's some Articles about this, in case you need them : 

https://www.ptc.com/en/support/article/CS363687

https://www.ptc.com/en/support/article/CS362880

    G
    GABRYEL2577012-AmethystAuthor
    12-Amethyst
    July 14, 2023

    Hi mstarnaud!

     

    You were right, my timeslice table was empty, i tried to write the Workunits one at time in the KPI query. I wrote "Machine1" and executed, "Machine2" and executed... instead "Machine1,Machine2,Machine3..." and I don't know why but it worked for me.

     

    Thank you for the support!

    Terms & ConditionsAccessibility statement