Aparna_MU

Hi We are using MySQl database version 5.7.1 and the reports created in Jasper Studio 6.1.0 which have been published to the Jasper Server version 6.1.0 are giving the following error when launched: Error MessageError filling report Error Tracecom.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1266) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : REP0080 at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) ... 11 more Caused by: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:266) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302) at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:106) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) ... 16 more Caused by: org.mariadb.jdbc.internal.common.QueryException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:858) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:907) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:282) ... 20 more Error Messagenet.sf.jasperreports.engine.JRException: Error executing SQL statement for : REP0080 Error Tracenet.sf.jasperreports.engine.JRException: Error executing SQL statement for : REP0080 at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:266) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302) at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:106) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) ... 16 more Caused by: org.mariadb.jdbc.internal.common.QueryException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:858) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:907) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:282) ... 20 more Error Messagejava.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by Error Tracejava.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:266) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302) at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:106) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.mariadb.jdbc.internal.common.QueryException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:858) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:907) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:282) ... 20 more Error Messageorg.mariadb.jdbc.internal.common.QueryException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by Error Traceorg.mariadb.jdbc.internal.common.QueryException: In aggregated query without GROUP BY, expression #5 of SELECT list contains nonaggregated column 'ta_prod_db.field_data_field_receipt_date.field_receipt_date_value'; this is incompatible with sql_mode=only_full_group_by at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:858) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:907) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:282) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302) at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:106) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) --------- Please not that the report worked fine on test server with existing select statement. We also tested by running the SELECT from comand line on the database server and after removing value of 'only_full_group_by' for sql_mode, the SELECT statement gave expected results on the database server. However when the report is run from Jasper Server it continues to give the same error. I have republished the report layout. But error is still there. Can anyone please help in sorting out this issue? Thanks

Hi Is there a tutorial available for integration of Drupal and Jasperserver? Requirement is to use Single Sign-On. A user will log in to the web application in Drupal and will have a screen to select report to run. On selection of the report he will provide relevant parameter values and then launch the report which will be processed by Jasperserver and the output will be provided on screen as per the user requirement, i.e. either a PDF or Excel file. Has anyone already done this? Thanks for help.

I checked the ljasperserver file under the following path: C:Jaspersoftjasperreports-server-cp-6.1.0apache-tomcatwebappsjasperserverWEB-INFlogs Contents of the file: 2015-10-02 14:16:39,411 ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failedorg.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Invalid bean definition with name 'springConfiguration' defined in null: Cannot register bean definition [Generic bean: class [org.springframework.beans.factory.config.PropertiesFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] for bean 'springConfiguration': There is already [Generic bean: class [org.springframework.beans.factory.config.PropertiesFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] bound.Offending resource: ServletContext resource [/WEB-INF/applicationContext_old.xml]at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:68)at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:85)at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:72)at org.springframework.beans.factory.xml.AbstractBeanDefinitionParser.parse(AbstractBeanDefinitionParser.java:82)at org.springframework.beans.factory.xml.NamespaceHandlerSupport.parse(NamespaceHandlerSupport.java:73)at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1432)at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1422)at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:187)at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.doRegisterBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:147)at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:101)at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:495)at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:391)at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:335)at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303)at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:125)at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:94)at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130)at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539)at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451)at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245)at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)at java.util.concurrent.FutureTask.run(FutureTask.java:262)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)2015-10-02 14:16:39,454 ERROR JNDIResourceProvider,localhost-startStop-1:75 - error closing contextjavax.naming.OperationNotSupportedException: Context is read onlyat org.apache.naming.NamingContext.checkWritable(NamingContext.java:961)at org.apache.naming.NamingContext.close(NamingContext.java:761)at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72)at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56)at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163)at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92)at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89)at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23)at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245)at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)at java.util.concurrent.FutureTask.run(FutureTask.java:262)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)

Hi I referred to the following article on wiki: http://community.jaspersoft.com/wiki/error-when-deploying-jrxml-file-uses-oracle-stored-procedure I have followed all the required steps in this article to get rid of the error 'cannot parse jrxml in JasperServer 6.1.0 CP'. However, after making changes to the following: 1) .WEB-INFclassesjasperreports.properties 2) .WEB-INFflowsqueryBeans.xml to include "plsql" 3) WEB-INFapplicationContext.xml and restarting jasperserver I'm now getting log in related error. I cannot launch log in screen for JasperServer. Please help. Kind regards, Aparna

This occurs for only one file. I can upload other jrxml fiels which contain plain SQL query. Will it be due to usage of stored procedure?

Hi I have a report created in jaspersoft studio 6.1.0 using a stored procedure. The report works fine in jaspersoft studio and I can get output as desired. However, there is an issue when I try to upload the file to Jasper Server. I get the following error: The selected JRXML could not be parsed. You might have selected the wrong file. Can someone please advise on how to tackle this? Thanks

I know to add a field. But the field should be showing a value selected from a column in the database table. E.g. When i run my report with Report parameter id as 'REP001' it calls a specific main procedure which call another procedure for REP001. It processes data and inserts it into a table from where I pick up data and display in my report. Thus, if REP001 is employee records by location, REP002 will show employee records by gender etc as an example. Now the title of the report should be 'Employee data by location' for REP001 and 'Employee data by gender' for REP002 depending on which rep id I'm passing as a parameter value. I thought of creating a table with structure report_id, report_name, report_title...and so on and of picking up title from this table and displaying it in the report. As I'm calling my stored procedure in 'Dataset and Query dialog', I don't know where to put my SELECT statement for selection of title from database table. Can you help?

Hi I'm using Jaspersoft studio 6.1.0 community version. I have a report which calls a stored procedure. Now, I want to populate its title dynamically by selecting report_name from a database table by passing parameter as report_id. How to achieve this? Thanks, Aparna

Problem solved. I could keep the scheduled date as timestamp. But, changed the expression to the following: $F{Event_Scheduled_Date}.getTime() >= TODAY().getTime() ? "*" : " " This worked.

Hi I am trying to create a variable in Jaspersoft Studio 6.1.0 where I want to achieve the following: if date_opened >= from_date_param and <= to_date_param then "New" else "Old" What syntax to use for this? And what should be the data type for date_opened, From_Date_Param and To_Date_Param? Thanks and kind regards, Aparna

data type of $F{Event_Scheduled_Date} is java.sql.Timestamp

Hi I am using Jaspersoft Studio 6.1.0. Community version. How to compare dates using greater than or equal to operators? E.g. in iReports I'm able to use the following expression: $F{Event_Scheduled_Date} >= TODAY() ? "*" : "" However, when I use th same in Jaspersoft Studio, while running the report I get the following error. The operator >= is undefined for the argument type(s) java.lang.String, java.lang.String What syntax should I use to get the results? Thanks and kind regards, Aparna

Hi I am new to Jasper Reports and have followed some tutorials to learn how to plot markers for latitude and longitude on a map in the report. This part works fine in iReports 5.6.0 and after publishing to Jasper Server v6. My requirement is that I want to plot e.g. number of cases that were recorded at different locations on the map. For instance there are 20 cases recorded at location A, 34 cases recorded at location B, 56 cases recorded at location C and so on. How to achieve this? Thanks in advance for expert advice. Kind rgds, Aparna