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.