Focal Point
[SOLVED] Error creating active pdf or flex output file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/860109663

February 10, 2010, 10:45 AM
Clinton Side-Kick
[SOLVED] Error creating active pdf or flex output file
Dear all,
I have previously worked on a couple of procedures that create various active output results, FLEX, APDF, Active dashboards.
Got side-trackted for a couple of days on other projects and now when I started working on these again, I receive the following result:

0 NUMBER OF RECORDS IN TABLE= 18 LINES= 5
InvocationTargetException : ibi.ntj2c.ntjprerr: CALLPGM execution error CPJAVA: Error in processing EXECUTE command for Class ibi.jsflex.IBIRunJSCOMFlex

This result is from the following example:
TABLE FILE CAR
SUM SALES 
BY COUNTRY
ON TABLE PCHOLD FORMAT FLEX
ON TABLE SET STYLE *
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=LINE,$
TYPE=REPORT,OBJECT=LEGEND,LEGEND-VIEW=DOCKING,POSITION-POINT=BOTTOM-CENTER,$
TYPE=REPORT,OBJECT=LEGEND,LEGEND-VIEW=FLAT,$
ENDSTYLE
END  


I have followed some suggestions on techsupport for similar cases, un-installed all recent Java JRE updates, re-installed jdk 1.6.0_03, re-installed WebFOCUS Client... all to no avail.

Any one else run into something similar?

Kind regards,

This message has been edited. Last edited by: Clinton Side-Kick,


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991
February 11, 2010, 01:36 AM
Clinton Side-Kick
TexasStingray, thx for testing.
The problem was correctly identified as related to the JSCOM3 Listener settings (thanks to Yoshiko @ IB who pointed me back to the WF & RC Inst & Conf doc).
Although my JSCOM3 Listener was started, for some reason the Maximum Java Heap Size field was empty.

For future reference, here are the steps to follow:

Procedure: How to Verify or Enable the JSCOM3 Listener
JSCOM3 is a listener installed with the WebFOCUS Reporting Server that is used when the
server creates Active Report Flash/Flex, graphics, accesses data sources through JDBC, or
launches other Java processes. It normally uses the fourth port used by the server. By
default, this is port 8123. Although not all WebFOCUS functionality requires JSCOM3, it is
a good idea to ensure it is available.
1. If it is not open, open the server Web Console and log on if security is enabled.
2. On top, click Workspace and then Configuration.
3. On the left, expand Java Services and click JSCOM3.
A popup window appears.
4. Ensure that the Stop option appears in the popup window.
If the Stop option appears, then JSCOM3 is started. You can optionally click Properties
if you wish to change any default settings. You can proceed to Stopping the WebFOCUS
Reporting Server on page 71.
If the Start option appears, then JSCOM3 did not start. JSCOM3 cannot start unless
your search PATH contains the jvm.dll file for your Java release.The jvm.dll file is installed
with the Java JDK/JRE in the jre\bin\client directory. For example:
C:\Program Files\Java\jre1.5.0_09\bin\client
The exact JDK directory varies depending on your Java release. For a different JDK
release, substitute accordingly. If JSCOM3 does not start, add this directory to your
PATH.
If you are planning to run Active Report Flash/Flex, ensure that enough memory for Java
to compile Flash/Flex files is allocated to the JSCOM3 service. Perform the following
steps to set the maximum Java heap size:
a. Open the Web Console and navigate to Workspace Configuration.
b. Right-click Java Services in the left pane and select Properties from the context menu.
c. Click the JVM Settings tab.
d. In the Maximum Java Heap Size field, enter an appropriate value in Megabytes (Mb).
Note: 512 Mb should be a sufficient value, however this depends on how much
memory is available on the machine that is hosting the server.
e. Click Save and Restart Java Services.
5. If it is not installed, install a Java JDK on the WebFOCUS Reporting Server machine.
Note: If you plan to install WebFOCUS Client on the same machine, you can install
WebFOCUS Client first. During the WebFOCUS Client installation, you can then choose
to install the Java JDK. You can then complete this procedure after the WebFOCUS Client
installation completes.
6. After the Java JDK is installed, go to the Windows Control Panel and open the System
folder.
7. On the Advanced tab, click the Environment Variables button.
8. In the bottom System variables frame, select PATH.
9. Click Edit.
10. Look for the directory containing jvm.dll and if it does not appear, add it. For example:
C:\Program Files\Java\jre1.5.0_06\bin\client
If you are using a different JDK, substitute accordingly.
Note: Use semicolons to separate paths. Do not put any spaces between the semicolons
and the paths.
11. Click OK to close out.
12. Restart the WebFOCUS Reporting Server through the Window Start menu so that a
command window opens. Then ensure that the JSCOM3 listener starts by looking for a
line similar to the following:
JSCOM3 listening on tcp port 8123
In some environments, you need to reboot before the server finds the jvm.dll file.

I trust this will be usefull for someone else too.


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991