laggybuggy
-
Posts
19 -
Joined
-
Last visited
Community Answers
-
laggybuggy's post in Report works in JasperReports Studio but not in JasperReports Server was marked as the answer
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.
-
laggybuggy's post in How are users' password protected in Jasper Server? was marked as the answer
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!
-
laggybuggy's post in Delete generated reports from Database was marked as the answer
These are the following tables involved for deletion:
JICONTENTRESOURCE JIRESOURCE You can also check the following to filter down your search results:
JIRESOURCEFOLDER Sample Query:
SELECT *FROM JIRESOURCE rsrcLEFT JOIN JIRESOURCEFOLDER folderON rsrc.parent_folder = folder.IDLEFT JOIN JICONTENTRESOURCE conrsrcON rsrc.ID = conrsrc.IDWHERE folder.URI = '/FolderName'[/code]
-
laggybuggy's post in SOAP Web Services URL is not working for v7.1.0 (../jasperserver/services/repository?wsdl) was marked as the answer
Soap APIs must be converted to REST V2 for Jasper Server CE v7.1.0 onwards. Source: TIBCO Jaspersoft 7.1.0 Release Briefing