Skip to end of metadata
Go to start of metadata

Problem

Trying to start a OEE Run and getting this logs in the GW

MESOEEManager26Jul2021 14:50:35Error creating response segment for operations response (908d6087-49b9-4a4f-b151-f37715569243).




java.lang.IllegalStateException: Could not get script
at com.sepasoft.production.common.model.mesobject.objects.script.BaseMESScript.getScript(BaseMESScript.java:70)
at com.sepasoft.production.common.model.mesobject.core.MESObjectEvent.getScript(MESObjectEvent.java:41)
at com.sepasoft.production.common.model.mesobject.core.MESObjectEvent.hasScript(MESObjectEvent.java:61)
at com.sepasoft.production.mes.manager.MESObjectEventManager.executeEvent(MESObjectEventManager.java:209)
at com.sepasoft.production.mes.manager.MESObjectEventManager.executeEvent(MESObjectEventManager.java:159)
at com.sepasoft.production.mes.manager.MESObjectManager.executeEvent(MESObjectManager.java:3537)
at com.sepasoft.production.mes.manager.MESOperationsManager$ActiveOperation.beginSegment(MESOperationsManager.java:8696)

Solution

in the DB Browser: Site first then Enterprise

delete from MESArtifact where ArtifactUUID in (select ArtifactRefUUID from MESArtifactProperty where MESObjectUUID in (select BaseMESScriptUUID from MESScript));

delete from MESArtifactProperty where MESObjectUUID in (select BaseMESScriptUUID from MESScript);

delete from MESObjectLink where MESObjectUUID in (select BaseMESScriptUUID from MESScript);

truncate table MESScript;

delete from MESChangeLog where MESObjectUUID not in (select MESObjectUUID from MESObjectLink union select MESObjectUUID from MESResponseObjectLink);

then restart both Servers (Production Module is enough)