I am running a stored procedure to populate the data in a table component and I am selecting 12 database fields in the SP. I get the following error when it is setup this way:
Traceback (most recent call last):
File "<event:propertyChange>", line 9, in <module>
java.lang.ArrayIndexOutOfBoundsException: 9 >= 9
java.lang.ArrayIndexOutOfBoundsException: java.lang.ArrayIndexOutOfBoundsException: 9 >= 9
caused by ArrayIndexOutOfBoundsException: 9 >= 9
Ignition v7.7.1 (b2014092209)
Java: Oracle Corporation 1.7.0_65
full error
[code]Traceback (most recent call last):
File “event:propertyChange”, line 9, in
java.lang.ArrayIndexOutOfBoundsException: 9 >= 9
at java.util.Vector.elementAt(Unknown Source)
at javax.swing.table.DefaultTableColumnModel.getColumn(Unknown Source)
at com.inductiveautomation.factorypmi.application.components.table.HMITableColumnModel.tableChanged(HMITableColumnModel.java:124)
at javax.swing.table.AbstractTableModel.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableDataChanged(Unknown Source)
at com.inductiveautomation.ignition.client.util.gui.table.SortTableModel._sortOrig(SortTableModel.java:380)
at com.inductiveautomation.ignition.client.util.gui.table.SortTableModel.tableChanged(SortTableModel.java:228)
at javax.swing.table.AbstractTableModel.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableStructureChanged(Unknown Source)
at com.inductiveautomation.factorypmi.application.components.PMITable$DataSetTableModel.update(PMITable.java:1987)
at com.inductiveautomation.factorypmi.application.components.PMITable.setData(PMITable.java:475)
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.python.core.PyBeanProperty._doset(PyBeanProperty.java:66)
at org.python.core.PyObject.__set__(PyObject.java:3678)
at org.python.core.PyObject.object___setattr__(PyObject.java:3742)
at org.python.core.PyObject.object___setattr__(PyObject.java:3732)
at org.python.core.PyObject$object___setattr___exposer.__call__(Unknown Source)
at org.python.core.PyObjectDerived.__setattr__(PyObjectDerived.java:990)
at com.inductiveautomation.factorypmi.application.script.PyComponentWrapper.__setattr__(PyComponentWrapper.java:163)
at org.python.pycode._pyx170.f$0(<event:propertyChange>:9)
at org.python.pycode._pyx170.call_function(<event:propertyChange>)
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:568)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:168)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.access$000(ActionAdapter.java:40)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter$ActionRunner.run(ActionAdapter.java:280)
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)
java.lang.ArrayIndexOutOfBoundsException: java.lang.ArrayIndexOutOfBoundsException: 9 >= 9
at org.python.core.Py.JavaError(Py.java:495)
at org.python.core.Py.JavaError(Py.java:488)
at org.python.core.PyBeanProperty._doset(PyBeanProperty.java:68)
at org.python.core.PyObject.__set__(PyObject.java:3678)
at org.python.core.PyObject.object___setattr__(PyObject.java:3742)
at org.python.core.PyObject.object___setattr__(PyObject.java:3732)
at org.python.core.PyObject$object___setattr___exposer.__call__(Unknown Source)
at org.python.core.PyObjectDerived.__setattr__(PyObjectDerived.java:990)
at com.inductiveautomation.factorypmi.application.script.PyComponentWrapper.__setattr__(PyComponentWrapper.java:163)
at org.python.pycode._pyx170.f$0(<event:propertyChange>:9)
at org.python.pycode._pyx170.call_function(<event:propertyChange>)
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:568)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.runActions(ActionAdapter.java:168)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter.access$000(ActionAdapter.java:40)
at com.inductiveautomation.factorypmi.application.binding.action.ActionAdapter$ActionRunner.run(ActionAdapter.java:280)
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: java.lang.ArrayIndexOutOfBoundsException: 9 >= 9
at java.util.Vector.elementAt(Unknown Source)
at javax.swing.table.DefaultTableColumnModel.getColumn(Unknown Source)
at com.inductiveautomation.factorypmi.application.components.table.HMITableColumnModel.tableChanged(HMITableColumnModel.java:124)
at javax.swing.table.AbstractTableModel.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableDataChanged(Unknown Source)
at com.inductiveautomation.ignition.client.util.gui.table.SortTableModel._sortOrig(SortTableModel.java:380)
at com.inductiveautomation.ignition.client.util.gui.table.SortTableModel.tableChanged(SortTableModel.java:228)
at javax.swing.table.AbstractTableModel.fireTableChanged(Unknown Source)
at javax.swing.table.AbstractTableModel.fireTableStructureChanged(Unknown Source)
at com.inductiveautomation.factorypmi.application.components.PMITable$DataSetTableModel.update(PMITable.java:1987)
at com.inductiveautomation.factorypmi.application.components.PMITable.setData(PMITable.java:475)
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.python.core.PyBeanProperty._doset(PyBeanProperty.java:66)
… 29 more
Ignition v7.7.1 (b2014092209)
Java: Oracle Corporation 1.7.0_65
[/code]
I think this is due to one of 2 things. Either there is some limit on the number of columns allowed or I can’t reference the same column twice in the select statement. I have aliased the columns with different names but it still does not help. When adding this duplicate field (which is the 12th field) is when the error occurs. I didn’t know if it was due to a column limit or duplicate field (or something else). Please help me understand. Thanks.