[How to tune up jasperserver]

The attributes of the SwapFileVirtualizer are:

public static final int DEFAULT_MAX_SIZE = 200;
public static final int DEFAULT_BLOCK_SIZE = 4096;
public static final int DEFAULT_MIN_BLOCK_GROW_COUNT = 100;

public SwapFileVirtualizerFactory() {
        // default values
        maxSize = DEFAULT_MAX_SIZE;
        tempDirectory = System.getProperty("java.io.tmpdir");
        blockSize = DEFAULT_MIN_BLOCK_GROW_COUNT;
        minBlockGrowCount = DEFAULT_MIN_BLOCK_GROW_COUNT;
}

 

So directory is not right. tempDirectory is correct, and the default is the Java temp directory.

 

Sherman

Jaspersoft

[JasperServer Cache Issue]

You could create a bean or a custom data source for JasperServer that caches the data.

 

Have a scheduled report that uses your data source that runs daily that will reload the data into memory.

 

Other reports using the data source will use the cached data.

 

Sherman

Jaspersoft

[Postgresql as data source and jasperserver 3.7]

We have lots of people with Postgres working. What is the problem?

 

 

Sherman

Jaspersoft

[JasperServer reports are very slow!!!]

Make MaxPermSize=128M.

 

The exported content is held in the JVM. Do you see the JVM consume up to the full 2 GB when you are trying to get the Excel file?

 

 

Sherman

Jaspersoft

[JasperServer Scheduler Issues...]

How long does a report on Solaris take to run compared to Linux?

 

Have a look at this: http://www.jaspersoft.com/configuring-report-scheduler particularly the job misfire threshold.

 

 

Sherman

Jaspersoft

 

 

[How to hide currency format in Ad Hoc designer]

Change the file /WEB-INF/Bundles/adhoc_masks.properties

 

The lines starting with "ADH_100_MASK" are the ones to look at.

 

There are other files /WEB-INF/Bundles/adhoc_masks_<region>.properties for localizing the display.

 

Sherman

Jaspersoft

[can not find scriptlet.jar in jasperserver/samples]

It is in the unit tests under src/test/resources/jars. There is no source /tools/fckeditor/editor/images/smiley/msn/thumbs_down.gif

 

 

Sherman

Jaspersoft

[How to Integrate Jasperserver\'s UI in webpages]

You can do this with an iFrame where the JasperServer screen is in the iFrame.

 

You probably will need to do some single sign on between your web site and JasperServer.

 

If you add "decorate=no" to the URL that goes to JasperServer, you will not see JasperServer menus and other surrunding content.

 

You can also integrate via web services. There are example PHP and JSP applications in the JasperServer source distribution that do this.

 

Sherman

Jaspersoft

[deploying to JasperServer-Pro 3.7]

Exactly. You have to upgrade 1 version at a time.

 

Sherman

Jaspersoft

[Reports available by Role?]

You are after repository permissions, which can be set by role and user. Have a look in the JasperServer user guide for details.

 

Sherman

Jaspersoft

[JS 3.0 Community will work on Oracle 11?]

Yes - no change there.

 

Sherman

Jaspersoft

[Need to close the Jasperserver Window]

Just call the URL in PHP or Javascript - ie. whereever you are doing the logout.

 

Sherman

Jaspersoft

[Error in JS-Pro when publishing report]

OK - I checked into this further.

 

Looks like there is a bug related to the issue outlined here: http://www.oreillynet.com/cs/user/view/cs_msg/83590

 

We need to import org.apache.commons.io.* into the UploadMultipartFilter class.

 

Is the file particularly large? That may be causing commons.io to create the temp file and run into the problem.

 

Sherman

Jaspersoft

 

 

[Call JasperReports from URL]

Try URLs like:

 

Run without prompts by providing the parameter:

 

http://robot:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&ParentFolderUri=%2Freports%2Fsamples&decorate=no&reportUnit=%2Freports%2Fsamples%2FEmployeeAccounts&j_username=jasperadmin&j_password=jasperadmin&EmployeeID=sarah_id

 

Run with prompt for parameters:

 

http://robot:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&ParentFolderUri=%2Freports%2Fsamples&decorate=no&reportUnit=%2Freports%2Fsamples%2FEmployeeAccounts&j_username=jasperadmin&j_password=jasperadmin

 

 

Sherman

Jaspersoft

[QueryExecuterFactory not invoked on JasperServer]

For a queryExecuter to work so that it picks up the queryString in the JRXML, you need to make sure that you do not set the JRParameter.REPORT_DATA_SOURCE in the parameter map. If you set REPORT_DATA_SOURCE, the queryString in the JRXML will be ignored.

 

 

A lot of report data sources cannot be used in query input controls, because they lack result set field types and possible additional data that some data sources which is in the field description tag in JXML. If a data source type can be used in a query input control, the way to make it appear on the query maintenance screen for query input controls is as you found: adding the queryLanguage into the queryBeans.xml.

 

Sherman

Jaspersoft

 

[Day Light saving and Jasperserver Time Zone]

I would have expected the daylihgt saving changes not to have an effect.

I don't know exact what is happening here, but try changing the time zone on the schedules. You may need to set up a new time zone for French Daylight Savings.

 

Sherman

Jaspersoft

[How to pass runtime Data source information]

You will need to change the OlapModelController to get the data source info parameter out of the HttpRequest.

 

Add the parameter into the ExecutionContext that is passed to:

        OlapModel model = getOlapConnectionService().initializeOlapModel(executionContext, olapUnit, sess);

 

In the OlapConnectionServiceImpl.getMondrianConnectProperties, get the data source value and inject it into:

                connectProps.put(RolapConnectionProperties.Jdbc.toString(),
                        jdbcDataSource.getConnectionUrl());
                String driverClassName = jdbcDataSource.getDriverClass();
                connectProps.put(RolapConnectionProperties.JdbcDrivers.toString(),
                        driverClassName);

or

                connectProps.put(RolapConnectionProperties.DataSource.toString(),
                        jndiURI);
 

 

Sherman

Jaspersoft

 

[Error in JS-Pro when publishing report]

Looks like a bad install. You are missing a file WEB-INF/lib/commons-io-1.1.jar.

 

Sherman

Jaspersoft

[Jasperserver and cascading input control error]

Was there an exception logged on the server?

 

Sherman

Jaspersoft

[Need to close the Jasperserver Window]

Sounds like you need some logic on your application's log out process that calls the JasperServer logout. You can do this with the following HTTP request:

 

http://yourServer/jasperserver/exituser.html

 

Sherman

Jaspersoft

[report export error after update JasperReports]

The JExcelApiExporter provides a better result than the XlsExporter. In JasperServer, the JExcelApiExporter is used.

 

Sherman

Jaspersoft

[displaying summary & detail reports headers]

You can now define multiple instances of the same band, and use a printWhenExpression to select what displays. In your cases, I would make the printWhenExpression select on whether the type of report was detail or summary.

 

Sherman

Jaspersoft

[3 of 9 barcode font error in pdf export]

You are missing a font on the server. In HTML, the browser substitutes missing fonts, but not in PDF. Have a look at Matt's great explanation at http://mdahlman.wordpress.com/2009/05/13/fonts-in-jasperserver/

 

Sherman

Jaspersoft

 

[LDAP problem in Jasperserver 3.7.0]

The HeartbeatBean is not essential to the running of JasperServer.

 

What exception were you getting before you set the enabled and permissionGranted properties to false?

 

Sherman

Jaspersoft

[Integrate Applet in JasperServer]

The Spring Security API call:

 

Authentication current = SecurityContextHolder.getContext().getAuthentication();

 

will get you the currently logged in user.

 

 

Sherman

Jaspersoft