Format of Table Column not Changing

Archived Topics
1

I have a table with two columns that are being populated from a SQL query. The first column is an integer and the second is a concatenated string from various columns of joined tables.

The problem is when the fpmi window is opened I receive the following error:

com.inductiveautomation.factorypmi.common.xmlserialization.SerializationException: Error invoking [PMITable]PMITable[Table].setColumnAttributesData(DataSet [2R ⅹ 21C])

I found that if I try to change the number format of the second column from the default #,##0.## to any other number format it will default back to #,##0.##.

In order for the number format to be changed I had to add a column heading in my SQL query. (I added as " " to my select query). Then when I changed the number format of the second column the number format saved. I changed the format of the column to 0 and saved the project and the previous error of serialization exception has gone away.

I am not sure how changing the number format of a column of strings made this error go away.

2

What version are you running? Can you post the stack trace associated with that error, or if your Gateway has internet access can you hit the “Send to Inductive Automation” button?

3

com.inductiveautomation.factorypmi.common.xmlserialization.SerializationException: Error invoking [PMITable]PMITable[Table].setColumnAttributesData(DataSet [2R ⅹ 21C]) at com.inductiveautomation.factorypmi.common.xmlserialization.deserialization.handlers.ObjectDeserializationHandler.endSubElement(ObjectDeserializationHandler.java:82) at com.inductiveautomation.factorypmi.common.xmlserialization.deserialization.handlers.ComponentDeserializationHandler.endSubElement(ComponentDeserializationHandler.java:83) at com.inductiveautomation.factorypmi.common.xmlserialization.deserialization.XMLDeserializer$Parser.endElement(XMLDeserializer.java:317) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at com.inductiveautomation.factorypmi.common.xmlserialization.deserialization.XMLDeserializer.deserialize(XMLDeserializer.java:140) at com.inductiveautomation.factorypmi.application.model.WindowController.deserializeWindow(WindowController.java:619) at com.inductiveautomation.factorypmi.application.model.WindowController._loadWindow(WindowController.java:324) at com.inductiveautomation.factorypmi.application.model.WindowController.getWindow(WindowController.java:368) at com.inductiveautomation.factorypmi.application.FPMIApp.openWindow(FPMIApp.java:813) at com.inductiveautomation.factorypmi.application.FPMIApp.openWindow(FPMIApp.java:794) at com.inductiveautomation.factorypmi.designer.model.ObjectHolder.openWindow(ObjectHolder.java:2197) at com.inductiveautomation.factorypmi.designer.navtree.ProjectBrowserPanel.mousePressed(ProjectBrowserPanel.java:488) 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) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor567.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.inductiveautomation.factorypmi.common.xmlserialization.deserialization.handlers.ObjectDeserializationHandler.endSubElement(ObjectDeserializationHandler.java:69) ... 42 more Caused by: java.lang.NullPointerException at com.inductiveautomation.factorypmi.application.components.PMITable.addTableEditors(PMITable.java:277) at com.inductiveautomation.factorypmi.application.components.PMITable.setColumnAttributesData(PMITable.java:905) ... 46 more
FactoryPMI v3.3.0 (build 2430)
Java: Sun Microsystems Inc. 1.6.0_07

4

Oh and I did click the send to Inductive Automation before I posted the original message.

5

Ok thanks. I think I see what the problem is, but I’m having trouble reproducing it. You seem to be able to: want to step me through exactly how I could re-create this?

6

Ok this is what I did to reproduce it.

  1. Create a new window.
  2. Create a table on the window.
  3. Creating a binding to a SQL query on the table that will concatenate a string with a selected value. I used this:
SELECT Brewhopid,'1st -- ' + addition
FROM tblBrewHop
  1. Save your project

you should receive the error posted previously.

7

Thanks - the cause of this has been fixed, and will be available in 3.3.0. Until then, make sure that all of your columns have actual names (using the AS clause if necessary). That is, they aren’t empty string.