jsasidharan

While trying to run the report on Jasper Server 6.3.0, the below error is thrown 2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:206 - JDBC timezone parameter is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:207 - JDBC timezone property is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:213 - JDBC parameters timezone parameter is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:225 - JDBC parameters timezone property is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:232 - parameters timezone null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:238 - JDBC fields timezone parameter is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:250 - JDBC fields timezone property is null2017-02-14 16:42:12,362 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:257 - fields timezone null2017-02-14 16:42:12,363 ERROR Validator,pool-6-thread-5:499 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632) Please help.

Yes. I was using JDK 1.8. I changed to JDK 1.7 and it is working fine. Thank you.

Hi, I downloaded source code from jasper technical support site and started building it using the document. while doing the step js-ant build-pro I am getting the below error.. I am using Apache Maven 3.3.9 and java version 1.8. Please help. [java] [ERROR] Internal compiler error [java] org.aspectj.apache.bcel.classfile.ClassFormatException: File: 'java/lang/CharSequence.class': Invalid byte tag in constant pool: 18 [java] at org.aspectj.apache.bcel.classfile.ClassParser.readConstantPool(ClassParser.java:192) [java] at org.aspectj.apache.bcel.classfile.ClassParser.parse(ClassParser.java:131) [java] at org.aspectj.weaver.bcel.BcelWorld.lookupJavaClass(BcelWorld.java:397) [java] at org.aspectj.weaver.bcel.BcelWorld.resolveDelegate(BcelWorld.java:362) [java] at org.aspectj.weaver.World.resolveToReferenceType(World.java:384) [java] org.aspectj.apache.bcel.classfile.ClassFormatException: Invalid byte tag in constant pool: 18 at org.aspectj.weaver.World.resolve(World.java:278) [java] [java] at org.aspectj.weaver.World.resolve(World.java:192) [java] at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:95) [java] at org.aspectj.apache.bcel.classfile.Constant.readConstant(Constant.java:135) at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:41) [java] [java] at org.aspectj.weaver.bcel.BcelObjectType.ensureGenericSignatureUnpacked(BcelObjectType.java:733) at org.aspectj.apache.bcel.classfile.ConstantPool.<init>(ConstantPool.java:45) [java] [java] at org.aspectj.weaver.bcel.BcelObjectType.getDeclaredInterfaces(BcelObjectType.java:226) [java] at org.aspectj.apache.bcel.classfile.ClassParser.readConstantPool(ClassParser.java:186) [java] at org.aspectj.weaver.ReferenceType.getDeclaredInterfaces(ReferenceType.java:569) [java] at org.aspectj.weaver.ResolvedType.getDirectSupertypes(ResolvedType.java:66) at org.aspectj.apache.bcel.classfile.ClassParser.parse(ClassParser.java:131) [java] [java] at org.aspectj.weaver.ResolvedType.collectInterTypeMungers(ResolvedType.java:1191) at org.aspectj.weaver.bcel.BcelWorld.lookupJavaClass(BcelWorld.java:397) [java] [java] at org.aspectj.weaver.ResolvedType.getInterTypeMungersIncludingSupers(ResolvedType.java:1172) [java] at org.aspectj.weaver.ResolvedType.checkInterTypeMungers(ResolvedType.java:1240) at org.aspectj.weaver.bcel.BcelWorld.resolveDelegate(BcelWorld.java:362) [java] [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:691) at org.aspectj.weaver.World.resolveToReferenceType(World.java:384) [java] [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:559) at org.aspectj.weaver.World.resolve(World.java:278) [java] [java] at org.aspectj.weaver.World.resolve(World.java:192) [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.doPendingWeaves(AjLookupEnvironment.java:404) at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:95) [java] [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.completeTypeBindings(AjLookupEnvironment.java:200) at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:41) [java] [java] at org.aspectj.weaver.bcel.BcelObjectType.ensureGenericSignatureUnpacked(BcelObjectType.java:733) at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:616) [java] [java] at org.aspectj.weaver.bcel.BcelObjectType.getDeclaredInterfaces(BcelObjectType.java:226) [java] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:357) at org.aspectj.weaver.ReferenceType.getDeclaredInterfaces(ReferenceType.java:569) [java] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:371) [java] at org.aspectj.weaver.ResolvedType.getDirectSupertypes(ResolvedType.java:66) [java] [java] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performCompilation(AjBuildManager.java:1003) [java] at org.aspectj.weaver.ResolvedType.collectInterTypeMungers(ResolvedType.java:1191) at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performBuild(AjBuildManager.java:267) [java] [java] at org.aspectj.weaver.ResolvedType.getInterTypeMungersIncludingSupers(ResolvedType.java:1172) at org.aspectj.ajdt.internal.core.builder.AjBuildManager.batchBuild(AjBuildManager.java:181) [java] [java] at org.aspectj.ajdt.ajc.AjdtCommand.doCommand(AjdtCommand.java:112) at org.aspectj.weaver.ResolvedType.checkInterTypeMungers(ResolvedType.java:1240) [java] [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:691) [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:559) at org.aspectj.ajdt.ajc.AjdtCommand.runCommand(AjdtCommand.java:60) [java] [java] at org.aspectj.tools.ajc.Main.run(Main.java:355) [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.doPendingWeaves(AjLookupEnvironment.java:404) at org.aspectj.tools.ajc.Main.runMain(Main.java:234) [java] [java] at org.codehaus.mojo.aspectj.AbstractAjcCompiler.execute(AbstractAjcCompiler.java:360) [java] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134) [java] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207) [java] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) [java] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.completeTypeBindings(AjLookupEnvironment.java:200) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) [java] [java] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116) at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:616) [java] [java] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:357) [java] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80) [java] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:371) [java] at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performCompilation(AjBuildManager.java:1003) [java] [java] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128) [java] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performBuild(AjBuildManager.java:267) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307) [java] [java] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.batchBuild(AjBuildManager.java:181) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193) [java] [java] at org.aspectj.ajdt.ajc.AjdtCommand.doCommand(AjdtCommand.java:112) [java] at org.aspectj.ajdt.ajc.AjdtCommand.runCommand(AjdtCommand.java:60) [java] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106) at org.aspectj.tools.ajc.Main.run(Main.java:355) [java] at org.aspectj.tools.ajc.Main.runMain(Main.java:234) [java] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863) [java] [java] at org.codehaus.mojo.aspectj.AbstractAjcCompiler.execute(AbstractAjcCompiler.java:360) [java] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288) [java] at org.apache.maven.cli.MavenCli.main(MavenCli.java:199) [java] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134) [java] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [java] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) [java] [java] at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116) [java] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) [java] [java] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80) [java] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) [java] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) [java] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) [java] at org.codehaus.classworlds.Launcher.main(Launcher.java:47) [java] [java] [ERROR] ABORT [java] [ERROR] Failed to execute goal org.codehaus.mojo:aspectj-maven-plugin:1.2:compile (default) on project ji-common: Compiler errors : [java] [ERROR] error at (no source information available) [java] [ERROR] /opt/JasperReports-Server-6.3.0-src/jasperserver-pro/common/src/main/java/com/jaspersoft/ji/engine/ProEngineService.java:0::0 Internal compiler error [java] [ERROR] org.aspectj.apache.bcel.classfile.ClassFormatException: File: 'java/lang/CharSequence.class': Invalid byte tag in constant pool: 18 [java] [ERROR] at org.aspectj.apache.bcel.classfile.ClassParser.readConstantPool(ClassParser.java:192) [java] [ERROR] at org.aspectj.apache.bcel.classfile.ClassParser.parse(ClassParser.java:131) [java] [ERROR] at org.aspectj.weaver.bcel.BcelWorld.lookupJavaClass(BcelWorld.java:397) [java] [ERROR] at org.aspectj.weaver.bcel.BcelWorld.resolveDelegate(BcelWorld.java:362) [java] [ERROR] at org.aspectj.weaver.World.resolveToReferenceType(World.java:384) [java] [ERROR] at org.aspectj.weaver.World.resolve(World.java:278) [java] [ERROR] at org.aspectj.weaver.World.resolve(World.java:192) [java] [ERROR] at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:95) [java] [ERROR] at org.aspectj.weaver.bcel.BcelGenericSignatureToTypeXConverter.classTypeSignature2TypeX(BcelGenericSignatureToTypeXConverter.java:41) [java] [ERROR] at org.aspectj.weaver.bcel.BcelObjectType.ensureGenericSignatureUnpacked(BcelObjectType.java:733) [java] [ERROR] at org.aspectj.weaver.bcel.BcelObjectType.getDeclaredInterfaces(BcelObjectType.java:226) [java] [ERROR] at org.aspectj.weaver.ReferenceType.getDeclaredInterfaces(ReferenceType.java:569) [java] [ERROR] at org.aspectj.weaver.ResolvedType.getDirectSupertypes(ResolvedType.java:66) [java] [ERROR] at org.aspectj.weaver.ResolvedType.collectInterTypeMungers(ResolvedType.java:1191) [java] [ERROR] at org.aspectj.weaver.ResolvedType.getInterTypeMungersIncludingSupers(ResolvedType.java:1172) [java] [ERROR] at org.aspectj.weaver.ResolvedType.checkInterTypeMungers(ResolvedType.java:1240) [java] [ERROR] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:691) [java] [ERROR] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.weaveInterTypeDeclarations(AjLookupEnvironment.java:559) [java] [ERROR] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.doPendingWeaves(AjLookupEnvironment.java:404) [java] [ERROR] at org.aspectj.ajdt.internal.compiler.lookup.AjLookupEnvironment.completeTypeBindings(AjLookupEnvironment.java:200) [java] [ERROR] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.internalBeginToCompile(Compiler.java:616) [java] [ERROR] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.beginToCompile(Compiler.java:357) [java] [ERROR] at org.aspectj.org.eclipse.jdt.internal.compiler.Compiler.compile(Compiler.java:371) [java] [ERROR] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performCompilation(AjBuildManager.java:1003) [java] [ERROR] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.performBuild(AjBuildManager.java:267) [java] [ERROR] at org.aspectj.ajdt.internal.core.builder.AjBuildManager.batchBuild(AjBuildManager.java:181) [java] [ERROR] at org.aspectj.ajdt.ajc.AjdtCommand.doCommand(AjdtCommand.java:112) [java] [ERROR] at org.aspectj.ajdt.ajc.AjdtCommand.runCommand(AjdtCommand.java:60) [java] [ERROR] at org.aspectj.tools.ajc.Main.run(Main.java:355) [java] [ERROR] at org.aspectj.tools.ajc.Main.runMain(Main.java:234) [java] [ERROR] at org.codehaus.mojo.aspectj.AbstractAjcCompiler.execute(AbstractAjcCompiler.java:360) [java] [ERROR] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134) [java] [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207) [java] [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) [java] [ERROR] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) [java] [ERROR] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116) [java] [ERROR] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80) [java] at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)[ERROR] at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) [java] [java] [ERROR] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128) [java] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128) [java] [ERROR] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307) [java] [ERROR] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193) [java] [ERROR] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106) [java] [ERROR] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863) [java] [ERROR] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288) [java] [ERROR] at org.apache.maven.cli.MavenCli.main(MavenCli.java:199) [java] [ERROR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] [ERROR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [java] [java] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193) [java] [ERROR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] [ERROR] at java.lang.reflect.Method.invoke(Method.java:498) [java] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106) [java] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)[ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) [java] [java] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)[ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) [java] at org.apache.maven.cli.MavenCli.main(MavenCli.java:199) [java] [java] [ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[ERROR] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [java] [java] [ERROR] at org.codehaus.classworlds.Launcher.main(Launcher.java:47) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[ERROR] -> [Help 1] [java] at java.lang.reflect.Method.invoke(Method.java:498) [java] [java] [ERROR] [java] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [java] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)[ERROR] Re-run Maven using the -X switch to enable full debug logging. [java] [java] [ERROR] [java] [ERROR] For more information about the errors and possible solutions, please read the following articles: [java] [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException [java] [ERROR] [java] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)[ERROR] After correcting the problems, you can resume the build with the command [java] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) [java] [java] [ERROR] mvn <goals> -rf :ji-common [java] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) [java] at org.codehaus.classworlds.Launcher.main(Launcher.java:47) [java] 07:47:19.084 main I Dumping to /opt/JasperReports-Server-6.3.0-src/jasperserver-pro/./ajcore.20170111.074719.084.txt

That is a great info! I will try using JNDI instead of JDBC. I was under the impression that, JDBC connection will be created only when the scheduled report starts running. But here the connections are already created and added to the DBCP pool for all the reports. And it started failing because the already created connections are failed to refresh after the oracle restart. And here, since I am not using JNDI, for each report a new JDBC connection object will be created and added to the pool, and will be closed after the report generation. If I use JNDI, connections will not be closed but will be released to the pool for the new reports, along with the frequent validations and refresh. Please correct me if I said anything wrong. Thank You.

Hi, I am using jasperserver 5.6. Many scheduled reports are pointing to oracle JDBC datasource. (It is JDBC not JNDI datasource) We had an oracle instance restart. But after that alll scheduled reports pointing to that oracle instance started failing with the below exception. We restarted the jasperserver tomcat instance and everything came back to normal. Oracle instance went down only for 5 mins, but reports kept on failing for 5-6 hours till the restart. Caused by: java.sql.SQLException: No more data to read from socket ERROR EngineServiceImpl,quartzScheduler_Worker-4:1716 - Error while closing data source connectioncom.jaspersoft.jasperserver.api.JSExceptionWrapper:java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.closeConnection(BaseJdbcDataSource.java:57) Anyone has any idea why all reports failed? Thanks in advance.

Thanks for the response. Yes.. Thats true to kill all the processes. But i want to kill only selected processes.

Hi, Is there anyway to kill/terminate the running reports in Jasper Server other than the below option? http://community.jaspersoft.com/documentation/jasperreports-server-web-services-guide/v56/stopping-running-reports-and-jobs

Yes. I have already gone through that thread. I think I have to upgrade my ojdbc jar file. But what confuses me is, it was working fine till last restart.

Hi, I am using Jasper Server 5.6 which is pointing to Oracle 11g database. Database is actually a Stand By database which is replicated using Oracle Data Guard. All the reports were running fine, but now I am facing this exception for many scheduled reports intermittently. Please help. Thanks. Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Control_Table32Dataset321_1470059618509_58007 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:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:651) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) Caused by: java.sql.SQLException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 13 more

Thank you @hozawa for the info. I was not aware of monitoring feature. It was already enabled in the server. I found out the table where all monitoring events getting logged. And I used the below query to get the required details. SELECT *FROM jireportmonitoringfactWHERE time_stamp BETWEEN to_timestamp('10-23-2016 07:30:00','MM-DD-YYYY HH.MI.SS') AND to_timestamp('10-23-2016 07:59:00','MM-DD-YYYY HH.MI.SS')[/code] Thanks Again!!

Hi, Is there any way to get all the report names/details which have been running at particular time interval? I know by using the below url, i will get all currently running reports. http://localhost:8080/jasperserver-pro/rest_v2/reportExecutions But I need all reports which have been generated at a given time. Please help. Thanks! An sql query on report database is also fine. Thanks.

Hi, I need the source file for jasper server 6.2.0/6.3.0 commercial version to rebuild the app after pointing to oracle. I can see only installer .run file available for download. Where can i download that? Please help.