Greetings,
am making a toDataSet Call…works with some data but not with other data.
I may be just not seeing something but both arrays look ok. The mixed unicode/string does not appear to cause any problems as it works ok in many other cases.
Code Snippet:
print headers
print plot
return system.dataset.toDataSet(headers, plot) #this is line 183 mentioned in the error
Why does this work
headers=[‘Cell’, ‘Long’, ‘Short’, ‘Planned’, ‘Other’, ‘CO’]
plot=[[‘Total’, 18.583333333333336, 4.383333333333334, 0, 0, 7.55], [u’Carton_Erector’, 18.583333333333336, 4.383333333333334, 0, 0, 0]]
But not This
headers=[‘Cell’, ‘Long’, ‘Short’, ‘Planned’, ‘Other’, ‘CO’]
plot=[[‘Unknown’, 416.93333333333334, 0, 0, 0, 0], [‘Total’, 448.7, 25.249999999999996, 0, 0, 8.933333333333334], [u’Carton_Erector’, 25.0, 16.450000000000003, 0, 0, 0], [u’Palletiser’, 0, 0.31666666666666665, 0, 0, 0], [u’Packer’, 6.766666666666667, 8.483333333333333, 0, 0, 0]]
ERROR [ClientSystemUtilities$3$1-AWT-EventQueue-1] Error running function from fpmi.system.invokeAsynchronous
Traceback (most recent call last):
File “event:actionPerformed”, line 38, in doLater
File “module:app.downtime”, line 183, in summary
TypeError: Unable to convert row 1, column 2 to type class java.lang.Integer
at org.python.core.Py.TypeError(Py.java:235)
at com.inductiveautomation.ignition.common.script.builtin.DatasetUtilities.toDataSet(DatasetUtilities.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:186)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:204)
at org.python.core.PyObject.__call__(PyObject.java:404)
at org.python.core.PyObject.__call__(PyObject.java:408)
at org.python.pycode._pyx51.summary$1(<module:app.downtime>:183)
at org.python.pycode._pyx51.call_function(<module:app.downtime>)
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._pyx57.doLater$1(<event:actionPerformed>:39)
at org.python.pycode._pyx57.call_function(<event:actionPerformed>)
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyBaseCode.call(PyBaseCode.java:301)
at org.python.core.PyBaseCode.call(PyBaseCode.java:114)
at org.python.core.PyFunction.__call__(PyFunction.java:307)
at org.python.core.PyFunction.__call__(PyFunction.java:302)
at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:566)
at com.inductiveautomation.factorypmi.application.script.builtin.ClientSystemUtilities$3.run(ClientSystemUtilities.java:314)
at java.lang.Thread.run(Thread.java:744)
Ignition v7.6.4-rc3 (b2013110714)
Java: Oracle Corporation 1.7.0_51