BUG? Cannot print preview from related tab panel in 3.5

Classic Servoy
1

I cannot print preview a form showing in a tab panel - this worked in 3.1.6, and doesn’t in 3.5.1

Master form has one record loaded via method in the table company_staff

Tab panel shows the table for company_staff_fax and shows FAX record entries correctly.

There is a PRINT button on the fax form with the following method:

controller.showPrintPreview(true)

It gives me the following error as a pop-up in servoy:

Cannot Print Preview
java.lang.IllegalStateException: Relation values not set for related foundset fs_company_staff_to_fax

The server log shows the following:

2007-10-22 10:08 	AWT-EventQueue-0 	ERROR 	com.servoy.j2db.util.Debug 	Throwable
java.lang.IllegalStateException: Relation values not set for related foundset fs_company_staff_to_fax
     at com.servoy.j2db.dataprocessing.RelatedFoundSet.e(Unknown Source)
     at com.servoy.j2db.dataprocessing.FoundSet.copyCurrentRecordFoundSet(Unknown Source)
     at com.servoy.j2db.dataprocessing.z.copyCurrentRecordFoundSet(Unknown Source)
     at com.servoy.j2db.a.printPreview(Unknown Source)
     at com.servoy.j2db.FormController.a(Unknown Source)
     at com.servoy.j2db.FormController.a(Unknown Source)
     at com.servoy.j2db.FormController.access$200(Unknown Source)
     at com.servoy.j2db.FormController$JSForm.js_showPrintPreview(Unknown Source)
     at inv3.invoke()
     at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:550)
     at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:466)
     at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254)
     at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2031)
     at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:94)
     at com.servoy.j2db.scripting.e.call(Unknown Source)
     at com.servoy.j2db.develop.debugger.k.a(Unknown Source)
     at com.servoy.j2db.develop.debugger.k.executeFunction(Unknown Source)
     at com.servoy.j2db.FormController.a(Unknown Source)
     at com.servoy.j2db.FormController.executeFunction(Unknown Source)
     at com.servoy.j2db.FormController.actionPerformed(Unknown Source)
     at com.servoy.j2db.FormController$a.actionPerformed(Unknown Source)
     at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
     at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
     at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
     at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(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)
2007-10-22 10:08 	AWT-EventQueue-0 	ERROR 	com.servoy.j2db.util.Debug 	copyCurrentRecordFoundSet RelatedFoundSet = FoundSet[Table:fs_company_fax,Size: 2,Relation: fs_company_staff_to_fax,CachedRecords: 0,SELECTED INDEX: 0]
2007-10-22 10:08 	AWT-EventQueue-0 	ERROR 	com.servoy.j2db.util.Debug 	copyCurrentRecordFoundSet PlaceholderKey = fs_company_fax#fscompanyfax27661:RK:fs_company_staff_to_fax
2007-10-22 10:08 	AWT-EventQueue-0 	ERROR 	com.servoy.j2db.util.Debug 	copyCurrentRecordFoundSet creationSqlSelect = SELECT fs_company_fax#fscompanyfax27661.374=fs_company_faxid<4,0,0> FROM fs_company_fax#fscompanyfax27661 SEARCH ((fs_company_fax#fscompanyfax27661.374=fs_company_faxid<4,0,0>)=(${fs_company_fax#fscompanyfax27661:PK}))

The same button and method work fine IF the fax form is opened directly and not in a tab panel.

Any ideas?

NCM
FSCI

2

can you make a reproducable test case for this and add it to our support system?

3

Submitted to support

It was reproduced even in my simple example. I’ve tried it in servoy 3.1.6 and 2.2.7 and it works as intended - with same OS, Java, etc.

Thanks!

NCM
FSCI

4

NCM,

This issue has been fixed in release 3.5.3.

Rob

5

Is there an ETA on 3.5.3? We’re still waiting on this fix…as we have many places where tab panel forms need to be printed.

We have a very un-elegant work around duplicating all affected forms, loading the form using converttodataset, then showing the preview of this duplicate form.

The big issue here is that we can’t even get it to print if we show the form and do a print preview. We had to create additional forms, with unrelated foundsets, load the record to print, etc.

Thanks!

NCM