laggybuggy

Have you been able to address this issue?

I found the solution to my problem. It was caused by my update in the security-config.properties file in $TOMCAT/webapps/jasperserver/WEB-INF/classes/esapi/. I updated security.validation.sql.on to true. It was defaulted to false. security.validation.sql.on=false[/code]After setting it back, my query successfully run in JasperReports Server.

@hozawa, there's really no succeeding logs. That's the end of the logs. Before it is the sql command but it is prefixed by the following text: 2018-09-22 10:06:52,622 ERROR Validator,pool-4-thread-12:499 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632),[/code]This is what confused me because it is running as expected in JasperReports Studio 6.6.0. I'm able to successfully generate reports there.

Error in the stacktrace: Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) 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:440) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:945) 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:896) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1812) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1143) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1072) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:967) 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)[/code]

bump!

I've been trying to restrict uploading of certain file extensions in Jasper Server but it is easily overriden when you select the Secure File option from the dropdown menu. How do I remove / disable this option? I was able to remove the option from here, but not from the above. I needed to modify the following file: /usr/apache-tomcat-9.0.7/webapps/jasperserver/WEB-INF/actionModel-search.xml

Thanks @hozawa for getting back with me. The one you sent is used to encrypt passwords in configuration files. I used your reference, though, to check for v6.4.X series and it lead me to this article: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v640/encrypting-user-passwords. There's a part there for cipher transformation. It is the one used to encrypt user passwords in the DB. Thanks a lot!

Thanks for your responses @elizam and @hozawa. But what I mean is something like the below. In version 3.7, the password of a user can easily be retrieved in the Users module using Developer Tools in Chrome as seen below. In version 6.4.3, this is no longer available. Also, if you check the DB entries for the users, the password stored there is encrypted as well. I'd like to know the encryption mechanism.

I've tried following the instructions here: https://community.jaspersoft.com/wiki/keystoremanagerinit-error-after-starting-newly-installed-jasperreports-server-55 but I can't make it work. Here are the technology stack I am using: Linux (via AWS)Apache Tomcat 9.0.7Jasper Server Community Edition 6.4.3Java JDK 8I noticed that I can't find the *.jrks and *.jrksp files as well. Are they required?

We installed a new version of Jasper Server Community Edition (v64.3) coming from an obsolete version (v3.7). We noticed that the password of users have already been obscured. I want to know what mechanism were used from password protection? What type of encryption?

These are the following tables involved for deletion: JICONTENTRESOURCEJIRESOURCEYou can also check the following to filter down your search results: JIRESOURCEFOLDERSample Query: SELECT *FROM JIRESOURCE rsrcLEFT JOIN JIRESOURCEFOLDER folderON rsrc.parent_folder = folder.IDLEFT JOIN JICONTENTRESOURCE conrsrcON rsrc.ID = conrsrc.IDWHERE folder.URI = '/FolderName'[/code]

Soap APIs must be converted to REST V2 for Jasper Server CE v7.1.0 onwards. Source: TIBCO Jaspersoft 7.1.0 Release Briefing

Hi All, I'm trying to use the SOAP Web Services of Jasper Server but the wsdl link does not work for the latest version (Jasper Server Community Edition v7.1.0). It was working for previous versions as documented here: https://community.jaspersoft.com/documentation/jasperreports-server-web-services-guide/v56/soap-web-services-overview Can anyone help please? Thanks!

Our Jasper Server has been up for quite a long time. Due to this, some of the folders that contain the generated output reports contain a lot if files already and I'm unable to open it from the UI. I want to clean them up. I want to know how to navigate these files/directories from the database. Is there anyone who has done this? Thanks!

Is there a way to disable a user (Ex. jasperadmin), to have multiple logins / sessions? I am using Jasper Server Community Edition 7.1.0. Thanks!

Hi @reportdev, I'm using the Jasper Community Edition only. Is there another way other than the link above? Thanks!

I am trying to download TIB_js-jrs-cp_7.1.0_bin.zip but it seems that sourceforge is blocked in my organization. Is there an alternative download site where I can get it?

Upon following reportdev's instruction, I was able to see my newly added Time Zones. I used Java TimeZone IDs here: https://garygregory.wordpress.com/2013/06/18/what-are-the-java-timezone-ids/.

We are trying to migrate to the new Jasper Server. Our current version is 3.7. In this version, we're able to see the Australia/NSW - Eastert Standard Time (New South Wales). However, the new version 6.4.3, does not have this. How can I add/enable it for my new version? Thanks!