Jump to content
We've recently updated our Privacy Statement, available here ×

stasp

Members
 View Profile  See their activity

  • Posts

    229

  • 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 stasp

  1. stasp
    Use caseUser needs the select statements to be generated as below to make sure none of them create lock on the DB table: Select * from company with (NOLOCK) where ...[/code]SolutionSuch effect can be achieved by using JNDI connection, and applying the READ_UNCOMMITTED transaction isolation on the connection level. The JNDI connection definition should look something like this: <Resource name="jdbc/databaseName" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="xxxx" password="xxxx" defaultTransactionIsolation="READ_UNCOMMITTED" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://localhost:1433/databaseName" />[/code]You can also find more info about the READ_UNCOMMITED isolation level here: https://msdn.microsoft.com/en-us/library/ms173763.aspx
  2. stasp
    Use caseWhen moving TIBCO Jaspersoft® Studio from one machine to another, or when simply attempting to replicate a setup on a different machine, it might be helpful to have a quick way to copy/move your existing configuration of TIBCO JasperReports® Server connections and/or the Data Adapters SolutionThe TIBCO JasperReports Server connection definitions are stored in the workspace, particularily in \.metadata\.plugins\com.jaspersoft.studio\serverprofiles Just copy the contents of this folder to the new instanace of TIBCO Jaspersoft Studio and restart it. Similarly, the data adapter definitions are stored in .metadata.pluginscom.jaspersoft.studiodataAdapters folder and can be migrated too
  3. stasp
    IssueOne of the users experienced issue where Manage->Users page was always blank in IE11 browser CauseThe issue may not be specific to the Users page only, it may happen for different pages of the application. In general such issue in IE browsers is happening because the browser is running in compatibility mode. You can check this by opening the developer tools on the page (by pressing F12), go to Emulation tab and set the Document mode to "Edge". You can force the Edge mode for IE by modifying the following section in /WEB-INF/decorators/decorator.jsp file on JasperReports Server: <!--<meta http-equiv="X-UA-Compatible" content="IE=8"/>-->[/code]First uncomment this section, and then set content to "IE=Edge" instead of "IE=8". Then restart the server to apply the changes.
  4. stasp
    IssueDepending on the setup you have between the system where JasperReports Server and the system where reporting database is running, in some cases you may see that Oracle dates returned by queries are incorrect and/or adjusted. This happens becase the time component of the dates gets adjusted based on timezone or Daylight Savings time SolutionTo prevent this from happening on JasperReports Server, add one of the following properties to /WEB-INF/classes/jasperreports.properties file: net.sf.jasperreports.pattern.timezone=System[/code]or net.sf.jasperreports.jdbc.time.zone = REPORT_TIME_ZONE[/code]Then save the file and restart the server. Please note that these properties are not available in TIBCO JasperReports® Server versions prior to 6.1.0 Ref. case #00067618
  5. stasp
    IssueSome web pages (for example https://www.google.co.jp/) when embedded into Dashboard on Jasperreports Server are simply not displayed Possible cause and solutionThe page you are trying to embed does not display because of this error: Refused to display 'https://www.google.co.jp/' in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'. [/code]You should be able to see this error in your browser console. This is configured on the website of the 'https://www.google.co.jp/' to prevent the page from being embedded into third party pages. It's not something you can control from within Jasperreports Server. There is some useful information on 'X-Frame-Options' and this issue in particular in the following thread: http://security.stackexchange.com/questions/67889/why-do-browsers-enforce-the-same-origin-security-policy-on-iframes Ref. case #00068366
  6. stasp
    Issue descriptionWhen trying to run any report on a server, the following error is thrown: [toc]java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser Error Trace com.jaspersoft.jasperserver.api.JSException: java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:628) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:1953) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:505) at sun.reflect.GeneratedMethodAccessor822.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80) at com.jaspersoft.ji.license.LicenseCheckAspect.runReport(LicenseCheckAspect.java:139) at sun.reflect.GeneratedMethodAccessor821.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)[/code]TroubleshootingThis error is normally associated with a JVM not being started on a Linux machine in AWT headless mode. JasperReports Server doesn’t provide a virtual X frame buffer on Linux. To prevent Java from trying to connect to an X-Server for image processing in JRS, please modify your application server's startup script to include the following JAVA_OPTS -Djava.awt.headless=true [/code]make sure to restart the server after this modification before testing the report again. The other possible causes of this error re: one or more jar files are missing from Jasperreports Server installation for some reason one or more default system fonts are not accessible in this environment I'd start by checking if all jars are present in the <js-webapp>/WEB-INF/libs folder by comparing the contents of it with the same folder in a working environment. If that doesn't help, here is a stackoverflow.com thread where people were having the same error and provide a couple of solutions that worked: http://stackoverflow.com/questions/4998762/could-not-initialize-class-net-sf-jasperreports-engine-util-jrstyledtextparserRef. case #00068653
  7. stasp
    IssueWhen trying to upload a report with Stored procedure from Jaspersoft Studio to JasperReports Server , one of the following exceptions is trown: org.apache.http.client.HttpResponseException: Bad Request at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:60) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:55) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:520) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:312) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:190) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:68) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:305) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)or org.apache.http.client.HttpResponseException: Invalid JRXMLat com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:87)at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:104)at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:56)at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:52)at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:445)at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:290)at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:184)at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:61)at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:302)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Possible causes and solutions The first thing to make sure is that PLSQL language is configured on JasperReports Server. This language is not configured by default. You'll have to follow steps from this article:http://community.jaspersoft.com/wiki/config-stored-procedures-jasperreports-server-55 The jar file mentioned there can be downloaded from here: http://www.java2s.com/Code/Jar/j/Downloadjasperreportsextensions353jar.htm If that does resolve the issue still, try changing the query language in your report from 'plsql' to 'sql'. This will give a syntax report in the Studio (as it should), but the report should still run:
  8. stasp
    Issue descriptionThis issue was discovered when trying to deploy TIBCO JasperReports Server 6.3.0 under WildFly 8.1.0.Final and Java 8. When trying to start WildFly the application wont deploy, and the following error trace can be found in the logs: [toc]2016-08-08 14:02:19,800 ERROR [org.jboss.msc.service.fail] (MSCservice thread 1-2) () MSC000001: Failed to start servicejboss.deployment.unit."jasperserver-pro.war".PARSE:org.jboss.msc.service.StartException in servicejboss.deployment.unit."jasperserver-pro.war".PARSE: JBAS018733: Failedto process phase PARSE of deployment "jasperserver-pro.war" atorg.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166)[wildfly-server-8.1.0.Final.jar:8.1.0.Final] atorg.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)[jboss-msc-1.2.2.Final.jar:1.2.2.Final] atorg.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)[jboss-msc-1.2.2.Final.jar:1.2.2.Final] atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[rt.jar:1.8.0_101] atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[rt.jar:1.8.0_101] at java.lang.Thread.run(Thread.java:745)[rt.jar:1.8.0_101] Caused by:org.jboss.as.server.deployment.DeploymentUnitProcessingException:JBAS011666: Could not parse file/usr/local/wildfly-8.1.0.Final/standalone/deployments/jasperserver-pro.war/WEB-INF/applicationContext-jms.xml atorg.jboss.as.messaging.deployment.MessagingXmlParsingDeploymentUnitProcessor.deploy(MessagingXmlParsingDeploymentUnitProcessor.java:99) atorg.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:159)[wildfly-server-8.1.0.Final.jar:8.1.0.Final] ... 5 more Caused by:org.jboss.as.server.deployment.DeploymentUnitProcessingException:JBAS011666: Could not parse file/usr/local/wildfly-8.1.0.Final/standalone/deployments/jasperserver-pro.war/WEB-INF/applicationContext-jms.xml atorg.jboss.as.messaging.deployment.MessagingXmlParsingDeploymentUnitProcessor.deploy(MessagingXmlParsingDeploymentUnitProcessor.java:96)... 6 more Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[2,1] Message: Unexpected element'{http://www.springframework.org/schema/beans}beans' atorg.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:108) atorg.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69) atorg.jboss.as.messaging.deployment.MessagingXmlParsingDeploymentUnitProcessor.deploy(MessagingXmlParsingDeploymentUnitProcessor.java:90)... 6 more[/code]CauseThis error message is somewhat rare, and it is related specifically to JMS listener on specific versions of JBoss and Spring. Here are some related threads on this issue if you want look into more details on this: http://stackoverflow.com/questions/15367623/jboss-7-could-not-parse-file-meta-inf-hornetq-jms-xml https://developer.jboss.org/thread/198358?tstart=0 https://developer.jboss.org/thread/222475ResolutionOne of the simplest solutions is to rename the /WEB-INF/applicationContext-jms.xml file so that it doesn't end with "-jms.xml", because that is what JBoss attempts to parse. Use the following steps: stop JBoss WIldFly rename the applicationContext-jms.xml file so that it doesn't end with "-jms.xml" clear WildFly cache restart the application server Ref. case #00070541
  9. stasp
    Issue descriptionWhen trying to start Jaspersoft (Talend) ETL Studio the following exception is thrown: [toc]java.lang.IllegalArgumentException: ex param cannot be nullat org.talend.commons.exception.CommonExceptionHandler.getPriority(CommonExceptionHandler.java:63)at org.talend.commons.exception.ExceptionHandler.process(ExceptionHandler.java:33)at org.talend.designer.runprocess.DeleteAllJobWhenStartUp.earlyStartup(DeleteAllJobWhenStartUp.java:129)at org.talend.designer.runprocess.DeleteAllJobWhenStartUp.startup(DeleteAllJobWhenStartUp.java:53)at org.talend.designer.runprocess.RunProcessService.deleteAllJobs(RunProcessService.java:217)at org.talend.core.CoreService.deleteAllJobs(CoreService.java:318)at org.talend.core.repository.model.ProxyRepositoryFactory.logOnProject(ProxyRepositoryFactory.java:1835)at org.talend.repository.ui.login.LoginHelper$1.run(LoginHelper.java:410)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)[/code]CauseThis is a defect in the application. Here is a link to the defect record on Talend Community tracker: https://jira.talendforge.org/browse/TDI-33903 ResolutionShut down the ETL tool End the java task/process on your system. It should be called javaw.exe, but if you see any other java processes end them too Delete all the files under '.Java/src' folder, This folder should be located in the workspace folder of the ETL tool installation, e.g.: C:Program Files (x86)TalendJETL-20150908_1633-V6.0.1workspace[/code]Start the ETL tool and create a new project Ref. case #00070573
  10. stasp
    More information about "How to import a separate organization via REST v2 API"
    RequirementOne of our users has a task of importing a separate organization via REST v2 API on a regular basis. The correct syntax for this task is not outlined clearly in our current documentation and took some effort and consulting with our engineering to make it work. SolutionThe steps below were performed using Postman plugin for Chrome browser. The general workflow is as follows: 1. Export organization to zip outputfile. Make sure to export specifically organization (meaning use --organization flag in command line, or alternatives for it in web interface or REST API) 2. Import using the RESTv2 API call in Postman The URL used is: POST http://<host>:<port>/jasperserver-pro/rest_v2/import?j_username=superuser&j_password=superuser&organization=myOrg&mergeOrganization=true&brokenDependencies=skip[/code]The headers are : Content-Disposition:form-data; name="file"; filename="222_export.zip"Content-Type:application/zipX-Remote-Domain:true[/code]Note the X-Remote-Domain header. It is required to bypass the CSRF protection on the server. An alternative would be to disable the CSRF protection on TIBCO JasperReports® Server altogether. Also make sure to add to add the zip file as binary to the request body. Also attached is a screenshot of the request from Postman:
  11. stasp
    RequirementIf you for some reason experience issues with the default TIBCO driver when performing export/import using buildomatic command line scripts, it is useful to be able to switch to a different driver (usually it will be the native driver for whichever database you are using) SolutionThe steps below are written for TIBCO JasperReports® Server 6.1.1 running on Oracle database: Copy the latest ojdbc6.jar to TWO locations and make sure it is named ojdbc6-11.2.0.4.jar: buildomatic/conf_source/db/oracle/jdbcbuildomatic/conf_source/iePro/lib[/code]In the /buildomatic/conf-source/db/oracle/db.template.properties file, uncomment the following lines admin.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}js.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}sugarcrm.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}foodmart.jdbcUrl=jdbc:oracle:thin:@${dbHost}:${dbPort}${dbSidOrServiceName}[/code]and at the same time comment out: # admin.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}${AdditionalAdminProperties}# js.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}# sugarcrm.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}# foodmart.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}[/code]In the buildomatic/default-master.properties file make sure the following properties are present: jdbcDriverMarker=nativejdbcDriverClass=oracle.jdbc.OracleDrivermaven.jdbc.groupId=oraclemaven.jdbc.artifactId=ojdbc6maven.jdbc.version=11.2.0.4[/code]Run the following scripts from the buildomatic folder: ./js-ant clean-config./js-ant gen-config[/code]Run the export and/or import command Ref. case #00070727
  12. stasp
    RequirementSometimes you need to create a simple one level Donut (or Doughnut? either works i suppose) chart. The HTML5 Charts library in Jaspersoft Studio provides an option of more complex DualLevelPie chart, but is there a simpler way? SolutionA Donut chart can be created by simply adding the following property: <hc:chartProperty name="plotOptions.pie.innerSize" value="50%"/>[/code]The value can be percentage as above, or it can be a number in pixels if you have specific size requirements. So before adding this property your chart will look something like this: After: Also attaching a sample report that runs on Foodmart data source. Ref. case #00072043
  13. stasp
    Issue descriptionWhen running a report as a non-admin user and trying to save it using the 'Save As' option, the following error is thrown: "JasperReports Server didn't save the report because you don't have sufficient permissions." And this is even when the target folder has Read+Write+Execute permissions on it for current user. Cause and SolutionThe likely reason of the issue is that there are input controls or data souce associated with the report, on which current user has 'Execute Only' permission. A Read Only permission on Input Control is required to 'Save As' report to a different location as a non-admin user.
  14. stasp
    Issue descriptionWhen trying to publish a report from TIBCO Jaspersoft Studio to TIBCO JasperReports Server you encounter one of the following errors (depends on whether you are using REST or SOAP web services to connect to the server): org.apache.http.client.HttpResponseException: Found at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:75) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:51) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:344) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:275) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:171) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:59) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:273) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) OR AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (302)Found faultActor: faultNode: faultDetail: {}:return code: 302 {http://xml.apache.org/axis/}HttpErrorCode:302 (302)Found at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:221) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:336) at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:155) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:101) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:122) at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:83) at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:82) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:99) at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:95) at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:76) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Reason and SolutionThis issue is most likely caused by using http:// connection URL instead of https://. Check you TIBCO JasperReports Server connection configuration and make the corresponding changes.
  15. stasp
    Issue DescriptionWhen adding/modifying a Google Map component in a report in Jaspersoft Studio, after selecting to Save the report the Map gets removed Reason[toc]It is likely that you have the following property in your report <property name="net.sf.jasperreports.components.map.version" value=""/>[/code]For some reason Jaspersoft Studio does not accept this property. This is most likely a defect. SolutionRemove the property from the report completely and do not specify map version
  16. stasp
    Issue [toc on_off::hide=1]A CSV data source is not query language, so parameters cannot be used for filtering the same way they are used in an SQL query. SolutionYou can make use of <filterExpression> for data filtering. The expression should be based on fields and variables corresponding to data columns in CSV file. For example if you have two columns in a simple CSV datasource file, Name and Value, the following would create a filter based on the Value: $F{Value} > 100[/code]In TIBCO Jaspersoft® Studio the expression can be added in the Filter Expression tab of Dataset and Query Dialog. More details on this can be found in section DATA FILTERS on page 104 of TIBCO JasperReports® Ultimate Guide. The Guide is avaiable in the documentation section.
  17. stasp
    RequestThere is a need to restrict access to 'Save/Save As' button based on user role in TIBCO JasperReports® Server. ImplementationThis would require some customization of JSP files. In short, you'll have to open this file: WEB-INFjspmodulesviewReport and add to the top: <%@ taglib prefix="authz" uri="http://www.springframework.org/security/tags" %> Then, search in that file for this line: <li class="leaf"> <button id="fileOptions" class="button capsule mutton up first" title="<spring:message code="button.save"/>" disabled="true"> <span class="wrap"> <span class="icon"> </span> <span class="indicator"> </span> </span> </button> </li> and wrap this tag around it: <authz:authorize ifAllGranted="ROLE_MYROLE"> ... </authz:authorize> Note that in the above example, ROLE_MYROLE is at the root level, not under an organization. If you want to use a role that is under an organization for your condition, you need to add this the organization name as part of the role, e.g.: <authz:authorize ifAllGranted="ROLE_MYROLE|organization_1"> ... </authz:authorize> Other NotesThis is only one specific use case of customizing access to menu items based on role. For basic guedelines, and more general information, you may want to check the 'Restricting Access by Role' section of Jasperserver Ultimate Guide.
  18. stasp
    Issue description [toc on_off::hide=1]After a clean installation of TIBCO JasperReports® Server the superuser is missing from the repository. ReasonThe superuser is only required in a multi-tenant environment. The fact that it is not present in your repository probably means that you are using the Community Edition. In that context, it is an expected result. The system-level admin in this case is jasperadmin.
  19. stasp
    Issue Description [toc on_off::hide=1]When logging into TIBCO JasperReports® Server v6.3.0 under Spanish locale and trying to run reports, the report does not render and the following exception is thrown in the logs: java.lang.IllegalArgumentException: Cannot format given Object as a Date at java.text.DateFormat.format(Unknown Source) at java.text.Format.format(Unknown Source) at java.text.MessageFormat.subformat(Unknown Source) at java.text.MessageFormat.format(Unknown Source) at java.text.Format.format(Unknown Source) at org.springframework.context.support.AbstractMessageSource.getMessageInternal(AbstractMessageSource.java:228) at org.springframework.context.support.AbstractMessageSource.getMessage(AbstractMessageSource.java:147)</pre> The CauseThere is a defect in TIBCO JasperReports® Server 6.3.0 which is specific to Spanish locale only. There is an incorrect configuration in one of the locale bundle files which results in this error. The SolutionThe issue can be fixed inin /WEB-INF/bundles/jasperserver_messages_es.properties file by deleting the following line: jasper.report.view.data.snapshot.message=Donnu00e9es actualisu00e9es le {0,date} u00e0 {0,time} and replacing it with this jasper.report.view.data.snapshot.message=Donnu00e9es actualisu00e9es le {0} u00e0 {1} Then save the file and restart the server. Ref. Case #00069988
  20. stasp
    Use Case Description[toc on_off::hide=1] Here is a requirement decription: there are Profile attributes defined on a server level. As a result these attributes are inherited by all server usersfor regular users that have some values assigned to the attribute, Ad Hoc data should be filteres based on the Attribute valuesfor regular users that don't have any values assigned to the profile attribute the data should not be displayedfor users with admin level roles (e.g. ROLE_SUPERUSER and ROLE_ADMINISTRATOR) the filter should not apply at allResolutionUsing the default Domain security file syntax from the documentation, if you try to filter out the row values based on the attribute values, the data will get filtered equally for all the users. We need to make an exception for users with admin roles. To achieve this use the following syntax in your Domain security file: <resourceAccessGrant id="JoinTree_1_Table_row_access_grant_1"><principalExpression>authentication.getPrincipal().getRoles().any {it.getRoleName() in ['ROLE_ADMINISTRATOR','ROLE_SUPERUSER'] } == false</principalExpression><filterExpression>testProfileAttribute(myTable.myField, 'myProfileAttribute')</filterExpression></resourceAccessGrant> If you have more than one attribute, use this syntax for each of them Ref. Case 00070012
  21. stasp
    Issue Description [toc on_off::hide=1]When creating an adhoc view, pulling a measure onto a chart causes the following exception in the log: java.lang.ClassCastException: com.jaspersoft.commons.semantic.impl.ItemGroupImpl cannot be cast to com.jaspersoft.commons.semantic.Item at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.presentationIdToResourceId(DomainDataStrategy.java:199) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getBaseQueryDataSet(DomainDataStrategy.java:175) at com.jaspersoft.ji.adhoc.strategy.DomainQueryDataStrategy.getBaseQueryDataSet(DomainQueryDataStrategy.java:38) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:736) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getQuery(CommonDomainDataStrategy.java:681) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1232) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1220) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:315) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.initDimensionDataSet(InteractiveCrosstabBaseEngine.java:95) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.init(InteractiveCrosstabBaseEngine.java:72)Any subsequent action gets the same error. ResolutionThis is a rare exception which is usually thrown when you create a domain set and name it 'Measures'. The alias 'Measures' is a reserved name in the application. You will have to rename the Domain Set to a different alias. Ref. Case 00070139
  22. stasp
    Hello Rishi, The short answer is no. JasperReports library is focused on creating pixel-perfect reports and for the most part it requires going in and configuring positioning of elements manually. Jaspersoft Studio does perform auto-alignment for some operations (like when you add multiple new fields to a Detail band in one operation). However not when page layout is changed from Portrait to Landscape or vice verse there is no auto-alignment. This is most likely because report design can be quite complex and in a lot of cases engine would not know how to auto align elements properly.
  23. stasp
    When you are using report groups and the headers 'ABC for Fixed Income' and 'ABC for Equity' are printed in group header band, you can control the printing by isReprintHeaderOnEachPage property. E.g.: <group name="myGroup" isStartNewPage="true" isReprintHeaderOnEachPage="false">...</group>[/code]
  24. stasp
    This is not possible out of the box. As mentioned in the previous comment, you should be able to implement the desired logic by creating a custom scriptlet
  25. stasp
    If the cascading input controls are configured correctly, they should work fine in the scheduler without any additional configuration. If you have the samples installed on Jasperserver, try scheduing the /public/Samples/Reports/Cascading_Report_2_Updated report (the label of the report on the UI is '16. Interactive Sales Report'). All the cascading parameters should be populated correctly here. Maybe the Input controls you have in place are not 'cascading' by Jasperserver definitions, or maybe you have parameters configured for the report but input controls are not defined?
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore