ntjp

Hi, I'm using JasperReport 5.6.0 (upgraded from JasperReport 5.0) and I'm having the following issue: A user can run a report without problem in the front-end but he gets an AccessDeniedExcepton when running that same report in the background. The user has full (admin) access to the output directory (which is the same as the folder where the report is located) Any idea why ? Please find below Exception message: 2015-04-06 15:45:30,929 ERROR ReportExecutionJob,quartzScheduler_Worker-1:311 - error.generating.reportorg.springframework.security.AccessDeniedException: Access is deniedat org.springframework.security.vote.AffirmativeBased.decide(AffirmativeBased.java:68)at org.springframework.security.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:265)at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)at com.sun.proxy.$Proxy161.getResource(Unknown Source)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getRepositoryResource(EngineServiceImpl.java:1857)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getFinalResource(EngineServiceImpl.java:1881)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:1652)at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getMainJasperReport(EngineServiceImpl.java:2023)at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:445)at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:222)at org.quartz.core.JobRunShell.run(JobRunShell.java:213)at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Regards Kb

Hi! I'm having troubles in Jasper to force the excel cell format to "Text" (instead of "General") when the cell content is a STRING even though it can be easily done in JExcel: sheet.addCell(new Label(1,1,"test",new WritableCellFormat(NumberFormats.TEXT))) I believe that the problem is in JExcelApiMetadataExporter, the CellTextValueHandler doesn't try to use the cellComplexFormat if the cell contains a string type. Is that correct (in which case it would be nice if that problem could be fixed ! :-)), or did I miss anything obvious ? Regards kb

Hi, I'm using Jasper Server 5.0 Community edition and I've been trying to use a virtual datasource based on 2 separate underlying sybase servers. When I try to run the report linked that virtual datasource, I receive the following error message: Error Message org.teiid.metadata.DuplicateRecordException: TEIID60012 Duplicate Schema mydb_myuser Error Trace org.teiid.metadata.DuplicateRecordException: TEIID60012 Duplicate Schema mydb_myuser at org.teiid.metadata.MetadataStore.addSchema(MetadataStore.java:54) at org.teiid.metadata.MetadataFactory.mergeInto(MetadataFactory.java:362) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:156) at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:557) at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:134) at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:524) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidVirtualDataSourceQueryServiceImpl.deployVirtualDataSource(TeiidVirtualDataSourceQueryServiceImpl.java:211) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.impl.TeiidConnectionFactoryImpl.createConnection(TeiidConnectionFactoryImpl.java:76) at com.jaspersoft.jasperserver.api.engine.common.virtualdatasourcequery.VirtualSQLDataSource.getConnection(VirtualSQLDataSource.java:62) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1611) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Looks to me very much like being the same as following known bug in underlying TEIID 8.1 library: https://issues.jboss.org/browse/TEIID-2066 Would it be possible to provide a patch or at least make sure that next jasperserver edtion makes use of TEIID 8.2 or better ? (hopefully the TEIID library reference just needs to be bumped up to a newer version) Best Regards kb

Hi, I know that this problem has already been debated several times in this forum and that solutions have been proposed but none of them seem to fit my personal needs. Here is the problem: I need to deliver every morning reports linked to the business activity of the previous business day (note that between 2 business days there can be weekends, national holidays and that each country follows a different calendar) All the calendar info is database-driven and the reports are based on stored-procedures taking a "report_date" input parameter. To meet those needs, I built a hidden SQL input control which automatically calculates the previous business day. When the report is manually run, the hidden input control value is calculated and the report behaves as expected...so-far-so-good. Problems start when using the scheduler, as it seems like the scheduler doesn't try to reevaluate the hidden SQL input control value before each run. I know that I can build a java class and call it from the report template, but that also means that my java class needs a clean way to connect to the database, probably by borrowing connectivity from the jasper application itself...can be done, but I end up doing much more work on this than I intended to. Hence my question: is there a way to force the scheduler to reevaluate the input control values before each run ? Regards kb

Your fix worked perfectly ! Thanks a lot to everyone involved. kb

As per your request, I've added a resource descriptor sample to my initial post for a report unit where the main report and the subreport are both file references. (I've created this descriptor directly through the web GUI; I also managed to create it without problem through SOAP). For REST, I've tried 2 approaches: 1) creating the whole resource-descriptor in one go 2) first creating the resource-descriptor without the subreport resource-descriptor (that steps works fine), then separately add the subreport resource-descriptor (couldn't manage to get that part to work) However both above-mentionned approaches failed Regards kb

Hi I'm having a problem trying to add a SUBresource file-reference to a report unit through the REST API (this pattern happens when the main report and its sub-report are both file-references) Whichever way I try, the ReportUnitHandler for the rest API ends up calling AbstractResourceHandler->CreateChildResource which itself calls FileResourceHandler->CreateResource. However contrary to the SOAP fileResourceHandler which works fine, the REST FileResourceHandler doesn't make any any effort to check if the resourcedescriptor is for a file, or a reference. As a result com.jaspersoft.jasperserver.remote.handlers.FileResourceHandler.updateResource throws a "could not find the binary content" exception because my REST API request doesn't have any file attached to it (of course it doesnt ! ... thesubresource is just assumed to be a reference to an already existing file in the repository !) Is this a bug or am I doing anything wrong ? Regards kb PS: 1) if it is indeed a bug, it would be nice to provide a source-code fix, even if it means having to recompile the server. 2) if it is not a bug, would it be possible to demonstrate how to add, through the REST API, a subresource file-reference to a report-unit ?

for whatever reason looks like wrapping the DB connection inside a JNDI pool solves the issue. kb

I have the following issue: my jrxml report calls a Sybase stored procedure which itself creates (and drops) some temporary table before returning the result dataset. eg: CREATE PROCEDURE mystoredproc BEGIN CREATE TABLE #MYRESULTS(COL1 INT) INSERT INTO #MYRESULTS VALUES(1) SELECT COL1 FROM #MYRESULTS DROP TABLE #MYRESULTS END the stored procs works fine in ireport but when run from JasperServer, I'm getting the following error: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database. It seems like the problem is that the datasource wraps the stored proc call into a transaction. The same problem can be reproduced from a DB front-end tool by explicitely wrapping the stored-proc call within a transaction: begin transaction exec mystoredproc commit transaction Hence my question is: how to prevent in JasperServer the stored proc call of my sybase data-source from being wrapped into a transaction ? Note: I'm using jtds 1.2.7 as database driver and my connection string is plain vanilla (jdbc:jtds:sybase://myserver:myport/mydatabase) Regards kb

Hi, Could someone tell me where I can find community jasperserver 4.7.1 binary distribution ? (I already have version 4.7.0) Regards kb

Hi, Is there any built-in/predefined "report resource name" parameter (in other words, the report name as defined within jasperserver, NOT within the report template itlsef) ? Regards Karl PS: What I'm trying to achieve is to use the same JRXML file for different reports, and pass different input parameter values to the template based on the report name (as defined within jasperserver, NOT within the report template itself).

Hi, I've succesfully built jasperserver 4.7 from the source but : 1) during testing phase of API Implementations - Metadata 4.7.0, I get java exceptions. 2) during testing phase of Jar for Webapp 4.7.0 I receive a lot of warnings (several hundreds of them) IMPORTANT NOTE: Please find attached to this email buildomatic output. Can above-mentionned exptions/warnings be safely ignored ? Regards kb

Hi. I've installed the BINARY distribution of jasper-server 4.7 on one PC and I'm trying to build the java-webapp sample from the "samples" directory (more specifically the "Jasper server WS Sample JAR subproject) on a 2nd/different PC. On that 2nd PC, I've installed the Zipped maven repository available as one of the jasperserver SOURCE packages from sourceforge (note that I haven't downloaded nor built Jasper's source code itself). When I try to build the webservice sample, I get following messages from maven: ------------------------------------------------------------------------ Building Jasper Server WS Sample JAR 4.7.0 ------------------------------------------------------------------------ The POM for jaspersoft.ji-pro.ji-jpivot-ui:ji-jpivot:jar:4.0.2 is missing, no dependency information available The POM for org.hibernate:hibernate-core:jar:3.3.2.GA-HHH-2763 is missing, no dependency information available The POM for org.olap4j:olap4j:jar:0.9.7.309-JS-2 is missing, no dependency information available The POM for mondrian:mondrian:jar:3.2.0-13661-JS-3 is missing, no dependency information available The POM for json:json-org:jar:1.0 is missing, no dependency information available The POM for com.jaspersoft.jasperserver:jasperserver-ireport-plugin:jar:4.7.0 is missing, no dependency information available Downloading: http://repo.maven.apache.org/maven2/org/hibernate/hibernate-core/3.3.2.GA-HHH-2763/hibernate-core-3.3.2.GA-HHH-2763.jar Downloading: http://repo.maven.apache.org/maven2/org/slf4j/slf4j-api/1.6.1/slf4j-api-1.6.1.jar Downloaded: http://repo.maven.apache.org/maven2/org/slf4j/slf4j-api/1.6.1/slf4j-api-1.6.1.jar (0 B at 0.0 KB/sec) ------------------------------------------------------------------------ BUILD FAILURE ------------------------------------------------------------------------ Total time: 2.047s Finished at: Mon Dec 10 16:19:35 JST 2012 Final Memory: 5M/15M ------------------------------------------------------------------------ Failed to execute goal on project jasperserver-ws-sample-jar: Could not resolve dependencies for project com.jaspersoft.jasperserver:jasperserver-ws-sample-jar:jar:4.7.0: The following artifacts could not be resolved: jaspersoft.ji-pro.ji-jpivot-ui:ji-jpivot:jar:4.0.2, org.hibernate:hibernate-core:jar:3.3.2.GA-HHH-2763, org.olap4j:olap4j:jar:0.9.7.309-JS-2, mondrian:mondrian:jar:3.2.0-13661-JS-3, json:json-org:jar:1.0, com.jaspersoft.jasperserver:jasperserver-ireport-plugin:jar:4.7.0: Failure to find jaspersoft.ji-pro.ji-jpivot-ui:ji-jpivot:jar:4.0.2 in http://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1] 1) Is it possible to build the sample without building the whole server ? 2) if affirmative, would you have any suggestion on how to fix above build issue ? Regards kb

Hi, I'm currently using Jasperserver community edition and I have the following issue: I have 1 JRXML file (let's call it "template1") with one parameter (let's call it "parameter1"). I have 3 different reports (let's call them "Report1", "Report2", "Report3") all based on that same "template1" JRXML file. For "Report1", I would like to automatically pass to parameter1 the value "Report1", for "Report2" automatically pass to that same parameter1 the value "Report2" etc... Any way to achieve that goal ? Regards Karl Note1: The reason why the parameter should be automatically populated is because that parameter doesn't make much sense to the end-user Note2: The reason why I don't want to create 3 slightly different JRXML files, is because I'm already managing a large number of different JRXML files.