joseng62

Hi rtumminelli, The given error you share may be anything io related. Harddrives, permissions, file locations, workspace might be missing etc. Best is the check the official log files for more detialed stack traces. 1) When the Execption is raised in the studio and exepction dialog box is displayed, which gives you the last stack trace. When you click on the Details button the whole stack stace is supplied, maybe share the whole stack trace ? 2) The jasperstudio is build on a eclipse IDE and your may scruitinised the IDE log file to obtain possible additional information. Below is an example of where Eclipse log file may be found. I may confirm that option 1 work for me. C:Users<myusername>JaspersoftWorkspace.metadata/.log Eclipse Log File can be read by, Eclipse Log File Location is: <workspace_location>/.metadata/.logIn Eclipse IDE: Window -> Show View -> Other -> General -> Error LogIn Eclipse IDE: Help -> About Eclipse -> Installation Details -> Configuration -> View Error LogHope this assist your troubleshooting ! Best of luck.

Hi im9ajey, Best resource is the offical documentation and then trail and error working through it. Use a rest api tool like postman or resteasy to get quick feedback cycles. So section • 3.1 Overview of REST Authentication • 3.4 The login Service is important there are mutiple ways to login in or maintain web session. Section • 4.3 Accept HTTP Headers • 4.4 Content-Type HTTP Headers is for the headers you need to work with. Section • 12 THE reports SERVICE for generating the report. You will always need to make sure you provide login credentials with each request of maintain cookie session . For report you may do a plain url string request with applicable headers or Hit the url endpoint with a json/xml body with applicable headers. Use this to check that your jasperserver is responding atleast. Note in my examples {{you need to replace these values with your own}} It requires not credenitals so should work if not block by firewall or something simliar. GET {{protocol}}://{{host}}:{{port}}/jasperserver/rest_v2/serverInfo Here is an example of login services request. You postman and resteasy should automatically maintain cookie session for you. So you just need to log in once and then you may make follow up rest request to the server without providing credential each time. The jasperserver session timeout applies in this case or you my make use of the logout service. I used jasperadmin in this case so you would not have any permission issues, but you may use any other user that has permissions. GET {{protocol}}://{{host}}:{{port}}/jasperserver/rest_v2/login?j_username=jasperadmin&j_password=jasperadmin Here is an example of full string url request. GET {{protocol}}://{{host}}:{{port}}/jasperserver/rest_v2/reports/{{folderPathInJasperRepoToReport}}/{{reportUniqueIDName}}.html?relativeStartDate=1999-01-01&Status=OPEN&Type=Invoice" So this examle has 3 input controls, it depends on the reports Input controls required. Here is an example with json payload : POST {{protocol}}://{{host}}:{{port}}/jasperserver/rest_v2/reportExecutions Headers : Content-Type : application/json X-REMOTE-DOMAIN : 1 Accept : application/json Body : {"reportUnitUri":"/{{folderPathInJasperRepoToReport}}/{{reportUniqueIDName}}", "outputFormat": "html", "async": false, "ignorePagination": false, "parameters": {"option": [ {"name":"relativeStartDate","value":["2012-01-01"]}, {"name":"relativeEndDate","value":["2012-12-30"]}, {"name":"Status","value":["OPEN"]}, {"name":"Type","value":["Invoice"]} ]} } Hope this helps. Best of Luck !

Hi vermaravi. Not able to give you solution but a bit of guidance. Main problem is : "NullPointerException" Something is not defined of does not exist. Might have something to do with your datasource. You making use of adhoc report, maybe the domain is not correctly defined. com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource Also you might have more stack strace logs in the jasperserver.log file that gives you more pinpointed log issues.

@All of you who responed. I really appraicte the quick responses and postive attitude. Thank you and I will follow your stipulated guidance.

Hi Cup of Java, Maybe have a look at the 'Styles' when designing the report in jasper studio. When create a style, you may then right click on the style and add a conditiuonal Style. With the conditional style you may add logic in tthe conditional expression section. This might be what you are looking for. I hope so. Best of luck

Hi raghu176.dvg So I am not sure of your are able to run the sql create command on the jasperserver side. The jasperserver side runs sql protection , i.e. blocking the use of some sql keywords form being executed as it is a security concern. If you are able to run the create sql by updating the property files which on the jasperserver side handels the sql validation. Then you need to seperate the sql demand. You will need to use one of the components i.e. a list to link a dataset that executes the linked sql query. You will also need to ensure the component that executes the create table is set in a band that only executes once. The other option you have is to create something like a store procedure which you create a temp table in the store procedure logic. Then from the temp table with another component 'subreport', 'table','list','crosstab' etc select from the temp. Possible just requires some correct sequence of execution of components.

Hi Enke, hope you solved your problem by now. If not, in your log file the clear issues is "Cannot load JDBC driver class 'org.postgresql.Driver' java.lang.ClassNotFoundException: org.postgresql.Driver" So classpath problems with your postgressql driver. Either it is not loading or maybe the incorrect version etc. You may assign the correct version to your user envirnoment classpath and start up or in apache-tomcat/lib just drop the approriate driver jar for the given postgress. Should solve our problem. ​​​​​​​

I don't agree with this from a community point of view. Not fair on the open source community. Tibco should atleast have previos minor version of the same major version available for download. Upgrading to newer versions takes time. Security cannot always pratically be address, it takes planning and time based on your current eco system of software. I dont think this was well thought through. Open source community always has to mitigate security concerns as it is not always possible to upgrade to new lib or software at the time. It feels like Tiboc is trying to recoup more sales and now we need to go through to a contact person for getting hold on previous versions ? Why, so you may cross sell. That is not acceptable from an open source point of view. How has it become the concern of Tibco for security if the softare utilized is under open source liscensing ? Tibco may not be held liable, so why? Like all other software providers, just give the users warning about security concerns and then we may make the infromed decision to continue on with mitigation. This is a terrible decision and will only have a negative impact... Why dont Tibco just with each new version release, inform us that Tibco will be removing download support for the oldest version currnetly availaible downloadable software. Thus giving user time to upgrade based on Tibcos new decision. I hope Tiboc changes their mind on this.

Hi eldonlee, When ever you get "please contact site administrator as shown", best is the go to the jasperserver logs and see exactly what is causing the issues. It may be anything, it may be that there is an issues with the datasource connection, or a resource is missing or a jrxml design issues etc. Log file would be found in WEBSERVER_install_directroy/webapps/jasperserver/WEB-INFlogsjasperserver.log (This is the application log) If you dont see anything in the jasper logs, best to then refer to the webserver logs. So that would depends on which webserver you are running, but Tomcat is the most used, so WEBSERVER_install_directroy/logs Best to view catalina.2020-**-**.log (* = relevant month and day) or there should be a catalia.out Issues muight be server never started up properly, or not correctly loaded some of the classes, or there was a database connection issue etc. Best of luck. Hope you get it resolved

Hi Michel, Just trying to assist where possible. I noticed the log file is in french and I do not understand french but made use of google translate. You have 2 GRAVE in your log and the first grave states to refer to the container log. As a listner did not want to start. In most cases these are ports already being used also in most cases the first error is the cause of all the trailing errors. So resolve this one first and retry the server. Also you need to look into the container logs, I may only assume your are making us of docker or some other simliar container tech. So you have to look into those log files for more info, not enough info given in this log. Hope this help, it is the most I may give with the information at had.

Hi jphayes, Man you need to give us more info on this one. Best is to check the log files apache_install_directory/apache-tomcat/webapps/jasperserver/WEB-INF/logs/jasperserver.log. I mean the java class could be missing on server level or it could be a custom class or a java lib being utilised in the given report, so it is on report level. There are mutiple ways to resolve this, but generally when you deploy the report onto jasperserver you need to link the dependencies to the given report based on what it uses. i.e. input controls, subreports, custom java classes. Youy may only make use of the java class if you uploaded onto the jasperserver first. Easy to fix all of this, just need to make sure that is your actual problem. Are you making us of custom input controls ? Are us using the correct java version ? Is the mentioned report designed in jasperstudio and does it work in jasperstudio when you preview ? Hope all of this helps you to get to an answer, if not post the errors in the log and lets see if we may figure this out.

Hi Paulina, you need to elaborate a bit more on this one. In normal cases when making use of a subdataset, you need to link the parameter between you're main report and the subdataset. So ensure the paramter is created in your main report and create another paramter in the subreport. Same datatypes, if not then you need to convert it into the relevant datatype in the expression section when linking the paramterers. The linking process is simliar for table, subreports, crosstabe and datasets, have a look at this one You mentioned from java, so when you say this, are you stating your report will be compiled in java, I will assume this if your are making use an ArrayList. Or Did you create a custom java servlet / class and want to pass parameters to the custom class ? I hope all this helps. If not just write back with some more info and I'll respond soon enough.

Hi rafael. Can you get to tomcat ? example http://yourserveraddress:portno exmaple http:localhost:8080 Best to confirm that is up and running first. Sometime tomcat start up successfully but when jasperserver gives issues. So it helps to pin point the issue. Also did you have a browse in your log files In path: Apache_tomcat_installed_dir/apache-tomcat/logs you may look at the catalina.out so see any errors occuring. 2nd log file is in the Apache_tomcat_installed_dir/apache-tomcat/webapps/jasperserver/WEB-INF/logs/jasperserver.log Your issues may be anything, best to look into the log files first, might be port classes or permissions issues, java version etc.. If you still no able to sort it out, just post the url and the relevant errors, maybe I might be able to assist further. Jusr whitewash sensative info before posting... Hope this helped.

Hi tiamtienkam, So what value is the phantomjs variable assign on run time ? I do not see the path declaration on your properties file example above, only assignment. I mean you're stack strack is says nullpointer so something is missing. This this only happen with reports with images, when you export? You have to start canceling out possbile issues, but confirm that they work. It could be phatom it could be pdf exporter, it could be that an element in the report being exported resolves to null at export time. The exepction could be handled on report execution time but not by the exporter. You will have to start pinpointing by elimenating possbile culprits. Did you get the stack trace from the jasperserver log file? You might get a more detailed stack trace that would be helpfull. Hope this helped a bit.

Hi James, I can only assume you are making use of the proffesional version in this case. Regardless, there could be numerouse ways to solve this, but I do not think any easy one. If you do thave the proffesional one, best to reach out to jasper support. One could do some old reverse engineering and go identify the jsp's involved in created the slideout container/page what ever that is. Some one that has some html experience and back end development figure this out. When you do find the relevant jsp, you could introduce custom code to inject the print icon. Or you could add a print icon in the report and link a href to it, the href would then execute a REST api call or another custom class that would do the required work for you. You would need to familiase yourself with the jasper rest api, which you send a request to the server for a pdf export or other formats and be able to prinit of from there. Hope this helps. Bit hard to give exact answer.

Hi sebouhh, It is a bit hard to not the make assumption. So your Web application I assume is Tomcat Apache. Do you only have jasperserver deployed on it ? On can set the webserver memory requirement through JAVA OPTS and how you do it is depened on the webserver and the java version being used. JAVA has garabage collection options and these depends on the given java versions being used. So normal for apache tomcat you can add a file setenv.bat or .sh for linux and set the java opts in the given file. So as example for open java 1.8 here is a memory option. set JAVA_OPTS=-Xms2048m -Xmx8192m -Xss20m Which means min 2GB for the webserver and the applications running on it and 8GB max, when requuired. The garabage collection should clear this up after awhile. If not, then there is most likely something wrong. Best is to setup the diagnostic via js.diagnostic.properties, hook into it with a java monitoring tool i.e. visualvm and analyse what is happening. Hope this all helps. Best of luck.

Hi Hlynch, Yes there is. I worked in the REST API for schedule job today actually. Best reference is the official documentation : JasperReports-Server-REST-API-Reference Chapter 16 The job Services. Listing Report Jobs : is helpfull to do a get on a report that has schedule jobs linked to it. So for reference : You can maybe manually create a schedule job. Then do a GET to get the job id Then do Viewing a Job Definition Here you make use of the id and this will return a payload which you can then use as reference. I must say schedule jobs description strucutres are the most complicated of all the REST strucutres. Content-Type : application/job+xml or application/job+json Content : A well-formed XML or JSON job descriptor. The request can include either a complete descriptor such as the result of a GET request described in 16.3, “Viewing a Job Definition,” on page 132, or it can be a minimally sufficient descriptor as shown in 16.4, “Scheduling a Report,” on page 136. Note as in documentation : Do a PUSH to create a schedule. Do a POST to update with version property. Ussually it is the otherway around, but not in this case. Example of one of the GET GET : https://localhost:8443/jasperserver/rest_v2/jobs?reportUnitURI=path_to_your_given_report_onjasperrepo HEADER : Accpet : application/json This will return a json payload on a 200. If you need more, let me know. All of this should be enought to get to going.

Hi tetsuphyxia, So I looked into if there is a current lib that can assist you with this, but my search has resulted with no given lib, execpt that you would need to write a custom class to handle this for you. Seem that SimpleDateFormat or DateTimeFormatter would not be able to give you your final annswer. So write that jar which would return a result, deploy jar to you're jasperstudio, call you class in a textfield and pass the new SimpleDateFormat("d").format(new java.util.Date() to you jar. Seems to be the only way. Hope this helps Best of luck

Hi ReachMe, You can have a look at the document "TIBCO JASPERREPORTS® SERVER REST API REFERENCE". Section "CHAPTER 13 THE reportExecutions SERVICE" I think this is the only way, besides making use of visualise.js (js lib for enterprise jaspersoft) Make a report request first via a POST Example : https://localhost:8443/jasperserver/rest_v2/reportExecutions Headers X-REMOTE-DOMAIN : 1 Content-Type : application/json Body { "reportUnitUri" : "path_to_report_on_server/myfirstreport", "outputFormat" : "html", "parameters" : { "option":[ { "name":"myInputControl_1", "value":["HelloValue"] }, { "name":"myInputControl_2", "value":["DAILY","WEEKLY","MONTHLY"] } ] } } If 200, you will received a xml response with a requestId in it. You will then make use of this requestid <requestId>2f373725-5190-43a3-8ea4-a8fa96f52a05</requestId> Then you need to do a GET request with the requestid https://localhost:8443/jasperserver/rest_v2/reportExecutions/2f373725-5190-43a3-8ea4-a8fa96f52a05 if 200, you will receive a xml response, look into the <export> tag and look for the <id > <exports> <export> <attachments>…</attachments> <id>fdd2322d-2e48-4a63-a661-8155501a19fe</id> You will required the id to do another GET reqeust. You need the requestid and the id above. https://localhost:8443/jasperserver/rest_v2/reportExecutions/2f373725-5190-43a3-8ea4-a8fa96f52a05/exports/fdd2322d-2e48-4a63-a661-8155501a19fe/outputResource if 200, then you will get response with the report. So in this scenario a html document Hope this helps you out.

So this should be possible. Define a string parameter in your jrxml. Set the given parameters as your datasource query and set the query string on run time. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/using-parameters-queries Here is an example of a jrxml. I am running on a oracle db datasource, but hard seleting via dual. So in your java code via the jasper java api just figure out to set the given parameter. <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 --> <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 name" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="af88d3eb-c1fe-4d76-9a0c-e7394dc2ddb4"> <property name="ireport.zoom" value="3.4522712143931042"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="wbmsresourcesdatasourcesdataAdaptersDev12pdb1.xml"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="style1" isPdfEmbedded="true"/> <parameter name="sqlQueryToInject" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["Select * FROM (select 10 as age , 'Green' as Name from DUAL union select 15 as age , 'Red' as Name from DUAL union select 25 as age , 'Yellow' as Name from DUAL union select 2 as age , 'Blue' as Name from DUAL )"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[ $P!{sqlQueryToInject} ]]> </queryString> <field name="AGE" class="java.math.BigDecimal"/> <field name="NAME" class="java.lang.String"/> <group name="Group1"> <groupExpression><![CDATA[$F{AGE}]]></groupExpression> <groupHeader> <band height="30"/> </groupHeader> </group> <background> <band splitType="Stretch"/> </background> <detail> <band height="50"> <textField> <reportElement x="100" y="0" width="100" height="30" uuid="571c1a0b-812d-43dd-b756-b62289273805"/> <textFieldExpression><![CDATA[$F{AGE}]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="0" width="100" height="30" uuid="a6870cc0-efed-46c4-98be-44100faa40b8"/> <textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

Hi shanti.kala, So first of all you are not making use if custom jsp for input controls ? If you are, there might be an issues in your jsp file. Also when you get issues like these, always make use of the developer console in your browser. Most browser already have this tool available. Example in chrome, you can just hit F12 to open the console. So when you load the page, you would most likely see some javascript or css files not loading or being blocked. Try to force reload the page by pressing ctrl+F5. Also you could have a look at the jasperserver log files. Ultimatly I think this is some sort of random bug that occurs based on a combitaion of software setup on the system jasper is running on. As I am also getting this issues with one of my server setup on my local windows, but the same version server running on someone else system is not giving the issues. You could clear the browser cache. I do know this tend to be an issues as well if you access different type of jasperservers in the same browser sessions. Could also be something to do with the custom themes, if you have it set. If you are making use of the "overrides_custom.css" file, then there might be an issues in the syntax. I have a suspions from my side that either it is security software that is blocking file from time to time, or it is a permissions issues or my hardrive has issues, as there is io expection in the jasperserver logs when this occurs. Also might be the database permission not setup correctly. As jasper serverwould load the elements from the databases if not cached in the browser already. Hope this help. Kind Regards joseng62

Hi maduraipandian. Quite hard to assist. The stack strack is a limited explanation. I can only guess that you are making use of fetching data from a webservice. So your datasource is most likely from a webservice, it might not be the main report making use of it, it might be another component that makes use of the given datasource. So due to utilizing a differrent jasperstuiod version it is highly likely that the Web service datasource extention is not installed onto the given jasperstudio. Have a look at this https://community.jaspersoft.com/project/web-service-data-source This would explain the null pointer as the java compiler cannot find something that does not exist ​​​​​​. Or maybe you do have this setup but maybe the schema definition in the report is not correct. Or maybe the datasource is not defined. Also somethime when you run the report a default datasource is not set, make sure if you have all of the above setup, that you select the correct datasource when previewing the report. Hope this all help. Regards joseng62

Hi fillipedesenvolvedor. So it is hard to derive from the image, where your supbreport is being called, created ? First make sure your subreport does not have page margins, the margins might cause unexpected outcome displayed. Ensure you subreport witdh is not more that your main report. The placement and alignment of your text field/components in your subreport also has an effect. You need to get all of this set correctly and aligned for your disired outcome. Hope this helps. Regards joseng62

You could add it to your webserver lib directroy. WEBSERVER_install_PATHlib You will notice that the postgres and maria db driver are already avaiable in the given directory. Restart server after deploy. It could be then added to your servers classpath on start up. "Is this jar stored on the file system somewhere? I logged into the running container and searched for it but couldn't locate it. Is this jar stored in the database?" - Yes correct, save in your jasper's database "According to Jasper Reports documentation, the jar should be placed at /buildomatic/conf_source/db/oracle/native.jdbc but I didn't place it there nor updated the default_master.properties file. But still everything was working fine." - This is no install time when you want your jasperserver to run on a oracle database instead of default postgress Hope this all helps. Good Luck

Hi pierugo.massolo. You will have to give us more info than that. Have you loaded the ojdbc7.jar onto the jasperserver ? When you create a datasource, do you have the option to select the Oracle driver from the drop down list ? Did you type in the credentials and conneciton details and then when you test the connection it give you the error ? Also you can you have a look at the jasperserver logs, which will give you much more info that the above message. WEB_SERVER_PATHwebappsjasperserverWEB-INFlogsjasperserver.log You will get a more detailed stack trace error, with more specific reason.