rajasekar_1

I created one Virtual Data Source with combined 2 data sources and i published one small report with the virtual data source. When I am running the report in jasper server i am getting the following error. Error MessageError filling reportError Trace com.jaspersoft.jasperserver.api.JSException: Error filling report Arguments: at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1336) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:216) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:138) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:961) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1840) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:166) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:111) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:429) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:570) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) ... 10 more Caused by: org.teiid.jdbc.TeiidSQLException: Group does not exist: HIMES_HMC.dbo.department at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:723) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:65) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:561) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:557) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:317) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:76) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) ... 17 more Caused by: org.teiid.api.exception.query.QueryResolverException: Group does not exist: HIMES_HMC.dbo.department at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:880) at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:959) at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:359) at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:304) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:278) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:127) at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:283) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:413) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:119) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:481) at org.teiid.dqp.internal.process.PreparedStatementRequest.processRequest(PreparedStatementRequest.java:294) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:655) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:338) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245) at sun.reflect.GeneratedMethodAccessor10593.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:203) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:266) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:201) at com.sun.proxy.$Proxy231.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:689) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:555) ... 20 more

Hi I want to schedule the jasper report in jasper server, with subject name as today date..

Hi the above scenario throw the same error...

I tried followed syntax in jasper studio (Note Parameter Class is 'java.lang.String') and also tried and I have a stored procedure like by following ALTER Procedure [dbo].[sP_Name ] @Parameter varchar(50) As Begin select * from tablename where id IN (@Parameter) end[/code]while trying the above scenario i got the following error in jasper studio please provide a proper solution for this.. Thanks in advance...

I am new to Jasper Reports, How to check the logs..

There was an error on the server. Try again or contact site administrators. (Error UID: 21952b2e-bce4-489b-8ae3-5d9a48d0b377)