8:00 – 4:00 VISIBILITY

• Working on VSS. I’m assuming that the problem has to do with the putting of large result xml in the database.
  • Added a PublishTest class. If run standalone, it will create a table (visibility_dev2.huge_table) of varchars, ints and floats that defaults to 300 columns by 1000 rows
  • got the error we saw yesterday: 13227 [main] ERROR com.fgm.ScriptEngineServer.PublishSupportObject  – Packet for query is too large (13226095 > 1048576). You can change this value on the server by setting the max_allowed_packet’ variable.
    • The above causes the sf.publishXml(“/hugetable.xml”, xmlStr); to fail, at the INSERT command in PublishSupportObject.publish()
    • XML is valid if written to a file.
    • Looks like the first thing to try is to set the packet size to 16,777,216 and see if that works