laggybuggy
Members-
Posts
19 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by laggybuggy
-
How to set default date-timestamps format in jasperserver
laggybuggy replied to mlopez_1's topic in Products
Have you been able to address this issue? -
Report works in JasperReports Studio but not in JasperReports Server
laggybuggy replied to laggybuggy's topic in Products
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. -
Report works in JasperReports Studio but not in JasperReports Server
laggybuggy replied to laggybuggy's topic in Products
@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]
-
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
-
How are users' password protected in Jasper Server?
laggybuggy replied to laggybuggy's topic in Products
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! -
How are users' password protected in Jasper Server?
laggybuggy replied to laggybuggy's topic in Products
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
- 1 reply
-
- web services
- jrs7
-
(and 3 more)
Tagged with:
-
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!
- 1 reply
-
- web services
- jrs7
-
(and 3 more)
Tagged with:
-
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!
-
Is there an alternate host where I can download Jasper Server?
laggybuggy replied to laggybuggy's topic in Products
Hi @reportdev, I'm using the Jasper Community Edition only. Is there another way other than the link above? Thanks! -
Is there an alternate host where I can download Jasper Server?
laggybuggy posted a topic in Products
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? -
How to add/enable a Time Zone in Jasper Reports Schedule
laggybuggy replied to laggybuggy's topic in Products
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!