Error if exceeds 9999 lines in editable table

Archived Topics
1

I have a table populated by a query that returns 11762 rows. If I edit a value in the new editable table I get the following error. If I change the query to return the Top 9999 rows, then I don’t get this error and I am able to edit the table cells.

java.lang.UnsupportedOperationException: Optimized datasets don’t support access of data directly.
at com.inductiveautomation.factorypmi.application.gateway.OptimizedDataSet.getData(OptimizedDataSet.java:97)
at com.inductiveautomation.factorypmi.application.components.PMITable$DataSetTableModel.setValueAt(PMITable.java:1812)
at com.inductiveautomation.factorypmi.application.components.table.SortTableModel.setValueAt(SortTableModel.java:306)
at javax.swing.JTable.setValueAt(Unknown Source)
at javax.swing.JTable.editingStopped(Unknown Source)
at javax.swing.AbstractCellEditor.fireEditingStopped(Unknown Source)
at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(Unknown Source)
at javax.swing.DefaultCellEditor.stopCellEditing(Unknown Source)
at javax.swing.JTable$GenericEditor.stopCellEditing(Unknown Source)
at javax.swing.plaf.basic.BasicTableUI$Handler.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(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)
FactoryPMI v3.3.0 (build 2430)
Java: Sun Microsystems Inc. 1.6.0_10

2

Looks like we’ve got some gremlins lurking in the new editable table feature. This will be fixed in 3.3.1, which I expect we’ll release next week to address the various issues that have surfaced with the editable table.

3

They’ve discovered that data get serialized (encoded) more efficiently at the 10k row threshold. Nice catch on the bug! Good time to find more to report for 3.3.1. Hint, hint…