I’m setting up a new machine in the Transaction Group. After getting everything setup the group started and ran for a while before throwing an error. From the gateway:
java.lang.IllegalArgumentException: There is already a scheduled task for sql bridge.easton_v2.swager5.mainexec
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine.register(BasicExecutionEngine.java:407)
at com.inductiveautomation.factorysql.groups.AbstractGroup.startExecution(AbstractGroup.java:360)
at com.inductiveautomation.factorysql.ProjectRunner.loadGroupResource(ProjectRunner.java:286)
at com.inductiveautomation.factorysql.ProjectRunner.lambda$onResourcesModified$2(ProjectRunner.java:174)
at java.base/java.util.ArrayList.forEach(Unknown Source)
at com.inductiveautomation.factorysql.ProjectRunner.onResourcesModified(ProjectRunner.java:174)
at com.inductiveautomation.ignition.gateway.project.ProjectLifecycle$LifecycleResourceListener.resourcesModified(ProjectLifecycle.java:176)
at com.inductiveautomation.ignition.common.project.AbstractProject.notifyResourceListeners(AbstractProject.java:351)
at com.inductiveautomation.ignition.common.project.AbstractProject.updateEffectiveState(AbstractProject.java:153)
at com.inductiveautomation.ignition.common.project.RuntimeProject.applyChange(RuntimeProject.java:274)
at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.lambda$updateOrStartAffectedProjects$5(ProjectLifecycleFactory.java:185)
at java.base/java.util.ArrayList.forEach(Unknown Source)
at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.updateOrStartAffectedProjects(ProjectLifecycleFactory.java:165)
at com.inductiveautomation.ignition.gateway.project.ProjectLifecycleFactory$1.projectUpdated(ProjectLifecycleFactory.java:143)
at com.inductiveautomation.ignition.gateway.project.BaseProjectManager.doProjectUpdatedNotification(BaseProjectManager.java:1055)
at com.inductiveautomation.ignition.gateway.project.BaseProjectManager.lambda$fireProjectUpdated$25(BaseProjectManager.java:1005)
at com.inductiveautomation.ignition.gateway.project.BaseProjectManager.lambda$submitToQueue$22(BaseProjectManager.java:983)
at com.inductiveautomation.ignition.common.util.ExecutionQueue$PollAndExecute.run(ExecutionQueue.java:239)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
8.1.37 (b2024013011)
Azul Systems, Inc. 17.0.9
I did have the timestamp data going to the wrong DB field at first, but even after correcting that problem the group still won’t start. It almost seems like the system is still trying to complete an old (now defunct) database request.
Any thoughts as to what might be the hangup? I have deleted all the tags with the exception of the tag required to trigger the group. I have stopped and restarted the Group with each change with the appropriate saves.
Thanks,
Cj