kcsekhar25

Hello all, jasper server 8.0.1 is getting down often and coming up again due to capacity problems . error is 503. please share any inputs as early possible - it would of timely support to see what is causing the issue. ram size is: 8 gb jvm - 8 and 24 gb min and max connection pool size: 500 Regards, Chandu

Hi , facing the jboss daatsource error with driver update but i dont want to deploy the entire web-app as we have customized code and jar files and lot of config changes which gets lost if we deploy entire web-app. Error: address: ([("deployment" => "jasperserver-pro.war")]) - failure description: { "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28"], "WFLYCTL0180: Services with missing/unavailable dependencies" => [ "jboss.data-source."jboss.naming.context.java.jdbc.jasperserverAudit" is missing [jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28]", "jboss.data-source."jboss.naming.context.java.jdbc.jasperserver" is missing [jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28]" ] } wanted to use mysql jar instead of mariadb. tried changing the js-jboss7-ds.xml to mysql driver and it gives above error when tried by restarting jboss only and facing the above problem. please let me know if anyone has updated mysql jar in target files and resolved above error. any early help is super useful at present we see the connection related issues and trying to check if using mysql native driver will help. Thanks Chandu

Hi , i am exactly facing the same error as above but i dont want to deploy the entire web-app as we have customized code and jar files and lot of config changes which gets lost if we deploy entire web-app. Error: address: ([("deployment" => "jasperserver-pro.war")]) - failure description: { "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28"], "WFLYCTL0180: Services with missing/unavailable dependencies" => [ "jboss.data-source."jboss.naming.context.java.jdbc.jasperserverAudit" is missing [jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28]", "jboss.data-source."jboss.naming.context.java.jdbc.jasperserver" is missing [jboss.jdbc-driver.mysql-connector-java-commercial-8_0_28]" ] } wanted to use mysql jar instead of mariadb. tried changing the js-jboss7-ds.xml to mysql driver and it gives above error when tried by restarting jboss only and facing the above problem. please let me know if anyone has updated mysql jar in target files and resolved above error. Thanks Chandu

Hi All, i have one report which uses 2 data sources. https://community.jaspersoft.com/wiki/how-use-2-different-database-connections-and-sql-queries-same-report 1. <property name="com.jaspersoft.jrs.data.source" value="repo:/public/Samples/Data_Sources/source1"/> - used this for main report 2. <property name="com.jaspersoft.jrs.data.source" value="repo:/public/Samples/Data_Sources/source2"/> - used this for dataset 3. deployed the report into jasper server and didnot link any datasource. 4. report is running fine when we run in the system 5. report is failing when triggered through schedule and issue is report is not able to find the datasource repo:/public/Samples/Data_Sources/source1". Please help suggest as soon as possible as i am in middle of testing phase. Regards, Chandu

Thank you very much for your reply. i am just trying to figure out that can we use talend which gives jasper files as output by taking any input. can we use etl tool to take a webi report as input and migrate it to jasper report output and playing with that jasper report for more advanced stuff.

i have also done report developement in jasper for infomatica pcmr reports when we have done the migration project from informatica reprots to jasper.

Hi, Thank you very much for your reply. you said manually means, are you developing the reports in jasper from scratch.

Hi, i got rid of this problem by suing Jasper Server Adhoc Editor and was able to get this grouping. Thanks

Hi, i appreaciate you that you could able to find solution for this. i also have same requirement but did not understand how u r using label + as it is a static content which cannot be applied hyperlink and how to use html component.if you have any any process listed for this which can better explains how to use it report and the jsps. can you please share the jrxml that you have created. r u using this report in your eclipse environment?i want this report to work in jasper server. please let me know how can i achieve this. your support is highly appreciated.

Hi , i am finding noway to my below issue. my need is as follows. 1) user A will login into the server with the user id user1 user B with user2 2) i have a report with html 5 TimeSeriesLine Chart 3) now what i want is when user1 logged and runs the report it should show bar chart and for user2 it should show Pie Chart. now,how we can pass the LoggedInUserName as a parameter to the chart to change the chart type according to the user preferences. i know that we can pass LoggedInUserName to the query but here my focus is not data but on the chart type change based on user prefernces. please correct me if i am wrong and let me know if you need any more detailed information on this. Thanks chandu

Hi , i am trying to provide a hyperlink from a report to the adhoc view ediotor. i want to test a use case where a user want to go to a adhoc editor in jasperserver when he/she clicks on specific bar of the column chart or bar chart. i also want to pass parameter from report to adhoc view editor as well if possible. i was able to provide hyperlinking between a main and subreport using advanced properties and hyperlink on measures. i am trying to refer to the view using different property names as below: _flowId value as path of view in organization _resource value as path of view in organization _flowId&resource= value as path of view in organization please guide me on this how i can identify a adhoc view just like i have identified the report using the property name _report. i see that in jasper forum they are suggesting to sue url based which is not well protected and need to provide seperate security using acegi security framework,so i am not keen on this part. i tried that url based and i can navigate to adhoc view ediotr just like i go to google when i click on any bar. i want to navigate to the adhoc view ediotr in way like identifying the view and going. if any thoughts to accomplish this using javascript please do let me. your thoughts are highly appreaciated. thanks chandu

hi Giulio, i have generated a html 5 column chart in iReport and loaded to jasper server. my need is i have to navigate to adhoc designer from the report which i was able to do using hyperlink for measures and bucket values for categories but it is showing in the same page. i want to show this adhoc designer in a modal window or pop up so that the user can see the designer and close it and will be in same report page. i am using below code to navigate under properties section of categories. "function(){return window.open(http://deyar02-is005:8084/jasperserver-pro/flow.html?_flowId=adhocFlow&resource=/adhoc/Ad_Hoc_View&j_username=jasperadmin|hcl&j_password=jasperadmin)}" it is working with window.open('url'),window.alert("url") but coming in same window. please advise me on how to go about this.

hi, how to provide a pop up window using javascript in html 5 charts when clicked on a specific bar on the bar chart or column chart. how exactly we can embed javascript in html 5 based charts in iReport Pro 5.2.0. Please shed some light on this as i am finding dead roads every where. thanks in advance ilona

Hi, i have generated html 5 based bar chart from ireport and deployed in jasperserver and want to navigate to adhoc editor when clciked on any bar of chart. level 1 need:what i need is i want to provide a hyperlink on the html 5 bar chart so that it will navigate to the adhoc ediotor from where this adhoc chart has been generated in a pop up or in same window with a back button or in a new window. level 2: what i need is i want to provide a hyperlink along with a parameter on the html 5 bar chart so that it will navigate to the adhoc ediotor from where this adhoc chart has been generated in a pop up or in same window with a back button or in a new window. please guide me how to do this or let me know is it feasible or not? your support is highly appreciated. Thanks chandu

Hi all, How to embed Javascript functionality in HTML5 Charts(Bar chart in my case) to get a pop up for the Detailed Report when clicked on any Bar of the Bar Chart in jasper Server Pro-5.2.0. i am trying to develop the report from iReport Pro 5.2.0 an ddeploy into jasper server pro 5.2.0. Please advise me on the same. i attached a file on which chart i am trying to apply this functionality of javascript. Thanks Chandu

sorry. thoght as we are in same thread didn't give full information. i got it. i will post properly next time.

Hi, i reinstalled everyhting previously and working fine and gain server got down. is there any other to fix this as reinstalling things everytime ,m not sure what to say good or bad but only choice.

hey, tthanks alot. i also had same issue and implenmented your thought and worked perfect.

i tried above said things but it is getting the main report page count not sub reports page count.

my need is i have main report which contains 2 sub reports. main report m1 contains sub reports s1 and s2 and i am getting null with above solution and i tried normally it is giving page numbers seperately. how to get ordered page number for both the reports in main report like 1,2,3,4 instead of 1,2 for ist subreport and again 1,2,---10 to 2nd sub report. plz let me know.

Hi Giulio, i have 3 columns a,b,c which are bigdecimal and i want to do a/b+c. i tried many ways and deployed the report in jasper server it is getting me null. please suggest what should i do about this. whatever you mentioned above with groovy and java i tried which is getting me null.

hi , i tried the same calculation but it is showing me null. my need is i have 3 cols a and b,c which are big decimal. i want to add a+b into variable v1. v2=v1/c please guide me whee i am doing wrong

Hi all, my issue got resolved and the solution is below. use jndi datasource when working with reports using stored functions in jasper server. create a jndi datasource in jasper server with the following configuaration files needs to be chnaged according to below. before adding these in configuaration files please make sure your jasper server stopped.once changes are done restart the jasper server and create a the jndi data source in jasper server and the datasource will be created without any problems. i am providing jndi configuarations for postgresql database. 1) add the following in jasperreports-server-5.1/apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml file. <Resource name="jdbc/contract_port_api_dev22" auth="Container" type="javax.sql.DataSource" maxactive="100" maxidle="30" maxwait="10000" username="postgres" password="root" driverclassname="org.postgresql.Driver" validationquery="SELECT 1" testonborrow="true" url="jdbc:postgresql://192.168.1.53:5432/contract_port_api_dev22?defaultReadOnly=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"/> 2) add following in the file jasperreports-server-5.1/apache-tomcat/webapps/jasperserver-pro/META-INF/context.xml <Resource name="jdbc/contract_port_api_dev22" auth="Container" type="javax.sql.DataSource" maxactive="100" maxidle="30" maxwait="10000" username="postgres" password="root" driverclassname="org.postgresql.Driver" validationquery="SELECT 1" testonborrow="true" url="jdbc:postgresql://192.168.1.53:5432/contract_port_api_dev22?defaultReadOnly=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true"/> 3) add following in the file jasperreports-server-5.1/apache-tomcat/webapps/jasperserver-pro/WEB-INF/web.xml <resource-ref> <description>Postgres database</description> <res-ref-name>jdbc/contract_port_api_dev22</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> once done with above changes,restart the jasper server and createjndi datasource in the server using the service name mentioned in the web.xml that is in my case jdbc/contract_port_api_dev22.

The server has encountered an error. Please excuse the inconvenience. Error Message Error filling report Error Trace com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1206) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:875) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:831) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1658) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1022) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:897) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Sales By Customer at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) ... 9 more Caused by: org.postgresql.util.PSQLException: ERROR: transaction is read-only Where: SQL statement "delete from sales_by_cust_rpt_temp where session_id = $1 " PL/pgSQL function "sales_by_cust_rpt" line 12 at SQL statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 16 more

Hi, i hav egenerated a report in ireport professional 5.1.0 with query as below select * from stored_function($P{parameter1},$P{parameter2},$P{parameter3}); stored function is written in postgresql database. well the report works very fine in ireport pro but not in jasper server professinal 5.1.0,throwing fill data error corrected procedure but now throwing 6632 error and tried all possible solutions but not helping me to resolve the issue. anything wrong with stored function usgae in jasper server and anything needs to be confugured in jasper server. changed security-config and validation properties files but not getting closer to solve the issue. i am getting dried up with this,as i am finding it awkward because jasper server should be supportable in promoting the reportis working in ireport. Please let me know your thoughts on this. attached the report for your reference and the screenshot of the error. Thanks much