[JasperReports Server CE 8.0 failing to startup]

Hi, what commands did you perform to deploy?

Are you trying to deploy it from sources or you're using TIB_js-jrs-cp_8.0.0_bin.zip?

[Jasper Installation Error version 7.5]

Are you installing on clear env or you already had JRS installed there? Can you check if the user that is used for installation has access to that files C:UsersAdministrator.jrsks and .jrsksp

Did you try to start the installer as an administrator?

[Error upgrading community server from 7.2 to 7.5]

Can you please provide exact steps on how did you perform your upgrade? Can you clarify the next points?:

1. what OS type
2. what App Server was used
3. what steps did you take
4. which user was used to perform install/upgrade and under which user your app server starts
5. did you check the latest Upgrade Guide with updated information?

[How to add a new user using WSUser value = binding.putUser(user) ? And What is binding here and How to get the instance of this binding ?]

didn't you forget to set: user.setPassword("xyz")?

[How to create custom reports ?]

Hi,  why can't you set report permissions in repository for each user/user_role? Is that an option?

[How to add a new user using WSUser value = binding.putUser(user) ? And What is binding here and How to get the instance of this binding ?]

Hi, can you try something like this: 

 

        WSUser user = new com.jaspersoft.jasperserver.ws.authority.WSUser();

        user.setUsername(name);

        user.setPassword(name);

        user.setTenantId(tenantId);

        user.setEnabled(enabled);

        user.setFullName("Service User");

 

You're doing

 

WSRole role = new WSRole();
 role.setRoleName("ROLE_USER");
 role.setTenantId(null);
 user.setRoles(new WSRole[] {role});

 

but ROLE_USER is assigned automatically to every user. What version of JRS you're using? Maybe it would be easier to use REST webservices?

http://community.jaspersoft.com/documentation/jasperreports-server-web-service-guide (chapter 4.2.1)

[not able to login with LDAP user to jasoper server]

Did you change anything in applicationcontext-securyty.xml? Or all chnages were in applicationContext-externalAuth-LDAP-mt.xml? Can you attach your sample ldif?

[COULD NOT RESERVE ENOUGH SPACE FOR OBJECT HEAP]

This is because tomcat is deployed as Windows service, and your java_opts can be overriden by service properties. Try something like this:

http://www.12robots.com/index.cfm/2010/10/8/Giving-more-memory-to-the-Tomcat-Service-in-Windows

[not able to login with LDAP user to jasoper server]

File applicationcontext-security.xml has a bunch of non-ldap related properties, so you need that file, but all Ldap related properties should go now in applicationContext-externalAuth-LDAP-mt.xml

[WHERE TO PUT .JASPER FILE?]

Your flow can be:

1. create via REST2 new jrxml file in JRS repository. to do that use 2.2.4 PUT request, but inside String resource-descriptor just put your jrxml data

2. create new datasource (if needed)

3. create new jasperreport that uses your previously uploaded jrxml. check especially 2.2.1, there you can find sample resource descriptor for jasperreport or datasource, which you can take as the reference for creating new reports via webservices (2.2.4) (just put your properties/datasource repo path/jrxml repo path/) 

4. after jasperreport was created, then you can run it as said in 3.1.1 (JRS will automatically compile jasperreport)

Also if you consistently run few reports, maybe it would be easier to define them in JRS using WebGUI or uploading the report from iReport into JRS repositor, otherwise you will have to use REST services to create jrxml/create datasource/create report/run report

 

 

[WHERE TO PUT .JASPER FILE?]

Please, check the webservices guide at:

http://community.jaspersoft.com/documentation/jasperreports-server-web-service-guide

chapter 3 is what you're looking for

[WHERE TO PUT .JASPER FILE?]

What version of JRS are you using and what webservices?

Via "REST 2" webservices we can upload jrxml files and run those reports via webservices, for that purpose you will not use GUI, you just need started JRS. The responce for REST 2 request you can get different formats (like html, doc, pdf...). For previous versions you can ue SOAP requests to get html export of your jrxml report

[WHERE TO PUT .JASPER FILE?]

Hi, for standart cases in JRS you will have to use only jrxml files, it should be enough to run the reports from JRS (also by webservices)

[not able to login with LDAP user to jasoper server]

Hi, Sathya, do such steps: 

1. find such file <js-install-folder>/samples/externalAuth-sample-config/sample-applicationContext-externalAuth-LDAP-mt.xml

2. Stop your server.

3. Copy it into <tomcat>/webapps/jasperserver/WEB-INF/ and rename to applicationContext-externalAuth-LDAP-mt.xml

4. Edit that file with your settings and start your server

For more info check chapter 3 at Auth Cookbook http://community.jaspersoft.com/documentation/jasperreports-server-authentication-cookbook-0

Thanks, Yuriy

[How to create an Excel data source in JasperReports Server?]

Hi, here are the proper steps to resolve this issue:

1. Get your xls file (data should be stored in columns, smth like JR table report) and rename it to xls_data.xml

2. Upload it to the server with the name xls_data into /reports folder

3. Create xls_data_provider.xml, like:

<?xml version="1.0" encoding="UTF-8"?>

<xlsDataAdapter class="net.sf.jasperreports.data.xls.XlsDataAdapterImpl">

<name>ExcelData</name>

 <fileName>repo:/reports/xls_data</fileName>

<useFirstRowAsHeader>true</useFirstRowAsHeader>

<queryExecuterMode>false</queryExecuterMode>

<datePattern>yyyy-MM-dd HH:mm:ss</datePattern>

<columnNames>city</columnNames>

<columnNames>country</columnNames>

<columnNames>state</columnNames>

<columnIndexes xmlns:xsi="http: //www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.Integer">0</columnIndexes>

<columnIndexes xmlns:xsi="http: //www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.Integer">1</columnIndexes>

<columnIndexes xmlns:xsi="http: //www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.Integer">2</columnIndexes>

</xlsDataAdapter>

 

Note that all your xml-tags should be in CamelCase as it is defined in net.sf.jasperreports.data.xls.XlsDataAdapterImpl. Also note that your xls data file should contain the first row with column names and those names should be the same as defined in <columnNames> tags

 

4. Upload your xls_data_provider.xml as xls_data_provider into the /reports folder

5. Create report in iReport or JSS using XLS file (the original one). After all fields were added view report as xml and add few more lines:

 

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ec8d891c-4188-4de7-b77f-71d1440b831f">

<property name="net.sf.jasperreports.data.adapter" value="repo:/reports/xls_data_provider "/>

<queryString language="xls">

<![CDATA[]]>

</queryString>

<field name="city" class="java.lang.String"/>

<field name="country" class="java.lang.String"/>

6. In JRS goto Add new report and use previously created jrxml, don't select any datasource in wizard

It's done, now you should be able to run report.

[Jasperserver Analysis has a problem with DB2 Data Source]

Hi, it will be easier if You would send us schema. And is that error the only You get in log? If there is more - send it too

 

Yuriy Savochenko

QA Engineer

[js-import error: Could not find the main class:]

It can be problem because You don't have JAVA_HOME enviroment variable set. This is required for normal work

[Reports Unavailable with JaspersSoft portlet. - please help.]

in JasperServer we need to change folowwing:

 

1. open <js-tomcat>/webapps/jasperserver/WEB-INF/applicationContext-security-web.xml

find property <property name="trustedIpAddress"> and set the value to the host 127.0.0.1 or set host from which js will allow to connect

2. find report.scheduler.web.deployment.uri property in the js.quartz.properties file at <js-tomcat>/webapps/jasperserver/WEB-INF. Set the right host and port, for ex.

http://localhost:8080/jasperserver

 

This was about JasperServer setup. We should setup portal too:

 

1. Edit <liferay>/<liferay-tomcat>/webapps/JasperReportsServer-portlet-4.0.0/WEB-INF/portlet.xml and set URL for jasperserver_repository_ws_url, for ex:

 

<init-param>

<name>jasperserver_repository_ws_url</name>

<value>http://localhost:8080/jasperserver/services/repository</value>

</init-param>

 

If You have JasperServer Comunity edition then no Organization will be added. But you should login as admin user in Liferay. The default user in liferay is test@liferay.com/test. Anyway after adding js portlet to portal liferay logged in user should be added to JS users and ROLE_PORTLET should be added as well. You should setup permissions for that user and role.

 

Yuriy Savochenko

Qa Engineer

 

[viewasdashboard in combination with FusionCharts]

 I can't reproduce it on our sample reports with Fusion chart. Can You try sample reports: Flash Chart report, Flash Map report, these are shipped with sample data and can be found at /organization_1/reports/samples.

It can be smth with the your report desigh

[Reports Unavailable with JaspersSoft portlet. - please help.]

Are You sure that jasper portlet was connected to Jasper Server? Can You check the logs of Jasper Server after portal was started? If everything ok with connection then there should be messages like

 

"WARN LoggerListener,http-8080-5:60 - Authentication event"

[viewasdashboard in combination with FusionCharts]

Which version of JS-pro you're using?

[Translate input controls]

JasperServer 4.1 supports Multi-Lingual Input controls (i18n for IC labels)

[Internationalization for options in a list of values - Input control]

This feature is added in JasperServer 4.1.

[js-export scheduled reports issue]

 Hi, when You're doing the export, you can do it in different ways. Common way:

js-export.sh --everything --output-zip js-4.1-export.zip

Note parameter "--everything" will export all resources from repository

If You're doing in another way with another parameters then don't forget to add such parameter:

--report-jobs and after add comma separated list of repository report unit and folder URIs for which report unit jobs should be exported. For a folder URI, this option exports the scheduled jobs of all reports in the folder and recursively in all subfolders.

For ex: js-export --report-jobs /reports/samples/AllAccounts

Yuriy Savochenko

QA Engineer

 

 

[Internationalization for options in a list of values - Input control]

Hi, i18n feature is new for 4.1. Since 4.1 we have sample report that shows how it works - it's Department report in Samples. There You can find different types of input controls, including IC with List of Values. In case of that report - $R{Department} input control has List Of Values. When defining the List Of Values - the Name should be like $R{key}.

Try to edit Department sample report and check how it's implemented there.

Note: bundles can be attached to the reports or i18n keys can be added to jasperserver bundles.

 

Hope it will help :)

 

Yuriy Savochenko

 

QA engineer