What I have is a simple app that gets parameters from the bookmark. The parameters are read in the post open event, where the bookmark is parsed and the variables are assigned to the bind variables that the datasource needs. The only other component created in Formspider is the datasource definition existing of a query using a table function with a bind variable. No panels, other than what default is created, no single change in the xml for that. My intention is to have nothing on screen. (currently is does show the default main panel).
From the logging I made I can see that my table function is called when I issue
yet my excel file still contains 0 bytes. Even when the queries return 0 rows, the table function does return results. I can see that results are returned, at least, for every pipe row command I dump what is returned in the log table and what is in the log table looks valid.
my understanding of api_datasource.printToExcel is that there does not need to be data on screen.
In the server.log I found this NPE: [#|2013-03-06T09:13:07.386+0100|SEVERE|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=24;_ThreadName=Thread-3;|java.lang.NullPointerException|#]
With a little help from Ibrahim we found that the issue could be caused by ojdbc6.jar. A little test showed that the error did no longer popup after switching to ojdbc5.jar For me now: problem solved, thanks Ibrahim.
answered 06 Mar '13, 08:53
and make sure, that your DISPLAY environment variable is not set to an inaccessible display like :1.0 when your VNC is running on :2.0
befor you start tomcat. First, I corrected the DISPLAY environment variable to point to the correct screen number, PrintToExcel worked nicely. Then I shut down tomcat and did unset DISPLAY before restarting. PrintToExcel still working.
answered 27 Nov '14, 12:12