system.alarm.queryStatus

kevinmarchand · June 7, 2013, 1:03pm

I am trying to replace this function by the new Alarm system.

return system.alert.queryAlertStatus(system=aSys, activeAndUnacked=1, activeAndAcked=1).rowCount

By this

list = system.alarm.queryStatus(path="*FingerJoint*")

I am getting an error

[quote]java.lang.Exception: Error executing expression binding on
LAYOUT_Leftbar.Root Container.AlarmLabel.NumAlarms
at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:82)
at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.childInteractionUpdated(ExpressionPropertyAdapter.java:50)
at com.inductiveautomation.ignition.common.expressions.functions.AbstractPollingFunction.actionPerformed(AbstractPollingFunction.java:80)
at javax.swing.Timer.fireActionPerformed(Unknown Source)
at javax.swing.Timer$DoPostEvent.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.common.expressions.ExpressionException: Error executing script for runScript() expression:app.alert.activeAlerts(‘SQLTags.FingerJoint’)
at com.inductiveautomation.ignition.common.expressions.functions.ScriptFunction.execute(ScriptFunction.java:62)
at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:73)
… 18 more
Caused by: Traceback (most recent call last):
File “expression:runScript”, line 1, in
File “module:alert”, line 3, in activeAlerts
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:1132)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.coerce(PyArgumentMap.java:103)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:83)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:37)

at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryStatus(AbstractAlarmUtilities.java:43)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘FingerJoint’ into type: class [Ljava.lang.String;

at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:555)
at com.inductiveautomation.ignition.common.expressions.functions.ScriptFunction.execute(ScriptFunction.java:59)
... 20 more

Caused by: Traceback (most recent call last):
File “expression:runScript”, line 1, in
File “module:alert”, line 3, in activeAlerts
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:1132)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.coerce(PyArgumentMap.java:103)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:83)

at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:37)

at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryStatus(AbstractAlarmUtilities.java:43)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘FingerJoint’ into type: class [Ljava.lang.String;

at org.python.core.Py.JavaError(Py.java:495)
at org.python.core.Py.JavaError(Py.java:488)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:188)
at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction.__call__(ScriptManager.java:459)
at org.python.core.PyObject.__call__(PyObject.java:320)
at org.python.pycode._pyx80.activeAlerts$1(<module:alert>:4)
at org.python.pycode._pyx80.call_function(<module:alert>)
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyBaseCode.call(PyBaseCode.java:134)
at org.python.core.PyFunction.__call__(PyFunction.java:317)
at org.python.pycode._pyx9.f$0(<expression:runScript>:1)
at org.python.pycode._pyx9.call_function(<expression:runScript>)
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyCode.call(PyCode.java:18)
at org.python.core.Py.runCode(Py.java:1275)
at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:552)
... 21 more

Caused by: java.lang.ClassCastException: Cannot coerce value ‘FingerJoint’ into type: class [Ljava.lang.String;
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:1132)
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.coerce(PyArgumentMap.java:103)
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:83)
at com.inductiveautomation.ignition.common.script.builtin.PyArgumentMap.interpretPyArgs(PyArgumentMap.java:37)
at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryStatus(AbstractAlarmUtilities.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.python.core.PyReflectedFunction.call(PyReflectedFunction.java:186)
… 34 more

Ignition v7.6.0 (b1875)
Java: Oracle Corporation 1.7.0_21[/quote]

Can I get some help on this new function. thanks

Kevin.Herron · June 7, 2013, 2:22pm

The path argument is an array/list of strings, not a single string, so try this instead:

list = system.alarm.queryStatus(path=["*FingerJoint*"])

Also do yourself a favor and upgrade to 7.6.1 before you run into one of the many bugs we ironed out and wonder if you’re doing something wrong or if it’s broken.

kevinmarchand · June 7, 2013, 2:23pm

Hi Kevin,

I was able to make it work but I will do the upgrade.

thanks