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

Friendly User

Members
 View Profile  See their activity

  • Posts

    435

  • Joined

  • Last visited

  • Days Won

    2

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Everything posted by Friendly User

  1. Friendly User
    Scenario:You are trying to do a select from a Hive array in a derived table and get the following error: [toc]Select field1,analysis_d1.TYPE,analysis_d1.SEQfromhiveTable LATERAL VIEW explode(array1) adTable AS analysis_d1;It got Error message after clicking RUN QUERY button in the derived table tab.Cannot execute JDBC Query.[Tibcosoftware][Hive JDBC Driver][Hive]Error while processing statement: FAILED:Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask.Vertex failed, vertexName=Map 1, vertexId=vertex_1496095817591_0903_1_00, diagnostics=[Vertex vertex_1496095817591_0903_1_00 [Map 1]killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: hiveTable initializer failed, vertex=vertex_1496095817591_0903_1_00 [Map 1],java.lang.RuntimeException: serious problem [/code]Solution:The following statement needs to be added before the select: set hive.vectorized.execution.enabled=false;[/code]However, this will make the query not pass the SQL validator. If you want to disable the validatior, you'll need to go to your JasperReports Server WAR file WEB-INF/classes/esapi/security-config.properties file and set security.validation.sql.on=true to falseand then restart the server.Another alternative is to modify the validSQL regex in /classes/esapi/validation.properties file so that using the SET statement would be allowed.
  2. Friendly User
    Scenario:You are building a report that has cascading input control. How to make TIBCO JasperReports® Server pre-select all values in the cascade. Solution:Non-mandatory input controls act like everything is selected when nothing is selected. When the $X{} collection is empty it transforms into AND 1=1 in the query.
  3. Friendly User
    Scenario:You're importing an archive to TIBCO JasperReports® Server in a Unix system and you get an access denied error related to ehache: [toc]Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ehCacheBasedJasperServerAclCache' defined in file [/tmp/jasperreports-server-pro-6.3.2-bin/buildomatic/conf_source/iePro/applicationContext-security.xml]: Cannot resolve reference to bean 'aclCache' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'aclCache' defined in file [/tmp/jasperreports-server-pro-6.3.2-bin/buildomatic/conf_source/iePro/applicationContext.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied // {factory} = org.springframework.beans.factory.support // at {factory}.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at {factory}.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at {factory}.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:651) at {factory}.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145) at {factory}.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077) at {factory}.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981) at {factory}.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487) at {factory}.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) at {factory}.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at {factory}.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at {factory}.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at {factory}.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at {factory}.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 212 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'aclCache' defined in file [/tmp/jasperreports-server-pro-6.3.2-bin/buildomatic/conf_source/iePro/applicationContext.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException: java.io.IOException: Permission denied at {factory}.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514) at {factory}.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) at {factory}.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) at {factory}.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at {factory}.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at {factory}.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at {factory}.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at {factory}.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 224 more Caused by: net.sf.ehcache.CacheException: java.io.IOException: Permission denied at net.sf.ehcache.DiskStorePathManager$DiskStorePath.<init>(DiskStorePathManager.java:331) at net.sf.ehcache.DiskStorePathManager.resolveAndLockIfNeeded(DiskStorePathManager.java:145) at net.sf.ehcache.DiskStorePathManager.getFile(DiskStorePathManager.java:262) at net.sf.ehcache.DiskStorePathManager.getFile(DiskStorePathManager.java:251) at net.sf.ehcache.store.disk.DiskStorageFactory.<init>(DiskStorageFactory.java:125) at net.sf.ehcache.store.disk.DiskStore.create(DiskStore.java:156) at net.sf.ehcache.store.DiskBackedMemoryStore.createDiskStore(DiskBackedMemoryStore.java:61) at net.sf.ehcache.store.DiskBackedMemoryStore.create(DiskBackedMemoryStore.java:49) at net.sf.ehcache.Cache.initialise(Cache.java:1097) at net.sf.ehcache.CacheManager.initializeEhcache(CacheManager.java:1298) at net.sf.ehcache.CacheManager.addCacheNoCheck(CacheManager.java:1329) at net.sf.ehcache.CacheManager.addCache(CacheManager.java:1227) at org.springframework.cache.ehcache.EhCacheFactoryBean.afterPropertiesSet(EhCacheFactoryBean.java:356) at {factory}.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573) at {factory}.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) ... 231 more Caused by: java.io.IOException: Permission denied at java.io.UnixFileSystem.createFileExclusively(Native Method) at java.io.File.createNewFile(File.java:1006) at net.sf.ehcache.DiskStorePathManager$DiskStorePath.<init>(DiskStorePathManager.java:322) ... 245 moreSolution:This happens when you don't have sufficient permissions for the temp folder. The solution is either one of these: If you insatlled JasperServer as root user, use sudo to execute the import script If you cannot use the root user, make sure the system temp folder has all the permissions for the user executing the script If you cannot assign permissions to the folder, you can select a different folder to be used for temp. Try to pass a different java.io.tmpdir variable to the import-export script JVM. To do that edit the js-import.sh and find the line with JAVA_OPTS and edit it like this: export JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx512m -XX:PermSize=32m -XX:MaxPermSize=128m -Djava.io.tmpdir=/new/tmp/dir/with/permissions/for/user/maybe/home/directory” Here, you pass a new -Djava.io.tmpdir location. In general though you need to make sure your user has complete permissions over the system temp folder (read/write/delete). Make sure the folder is empty too.
  4. Friendly User
    Scenario:You want to use a stored procedure to create an ad hoc view. How can stored procedure results be used to design ad hoc views. Solution:Stored procedures can be used in regular topics. To use a stored procedure create a regular ad hoc topic: create a report in TIBCO JasperSoft® Studio with a query that uses a stored procedure. The report should use the stored procedure in main dataset. It can have parameters, calculations, etc.upload the report to TIBCO JasperReports® Server to /organization_folder/adhoc components/topics location or /public/adhoc components/topics. The location is important because only reports in that folder are consiedered topicswe need to allow JasperReports Server to execute stored procedure queries. The validator for validSQL in JasperServer needs to be set to accept CALL or EXEC or other stored procedure statement. To configure that go to /WEB-INF/classes/esapi/validation.properties, find Validator.ValidSQL and adjust the regex value accordingly. Restart the server afterwards
  5. Friendly User
    Scenario:When opening any report (or domain to create an adhoc) the option or filter boxes do not appear as expected like 'Zoom Out', Zoom In' etc In the report view the Back, Save or Download buttons do not work. Some of the menu items are not functioning correctly like View -> Schedules. The standard theme is selected but the problem appears on other themes also. Solution:This usually happens when you upgrade to the new version and import the repository archive from the previous one with --update flag. This overwrites the default theme. This can be rectified by doing a minimum catalog import with the --update flag. The minimum catalog can be found in {TIBCO JasperReports® Server distro}/buildomatic/install_resources/export. do js-import on the minimal-pro catalog for your database with --update flag.
  6. Friendly User
    Scenario:You have an existing repository database and want to just install a new instance of TIBCO JasperReports® Server against that database without deleting or overwriting anything in it. Solution:Configure default_master.properties with the correct connection details for that database and for the correct application server location/version.. Execute js-ant deploy-webapp-pro This should just deploy the JasperReports Server WAR file to the application server with correct database configuration.
  7. Friendly User
    Scenario:You have a large repository with a lot of organizations and folders. When you go to Create -> Ad hoc View it takes a very long time to display the list of available domains and topics for your ad hoc views. The repository database sees a lot of activity during that time. Eventually after a long wait the list is displayed. Solution:This happens due to repository datbase search inefficiency. The best way to remedy this problem is to upgrade to version 6.4.0 or higher. If you are on version 6.3.x or 6.2.x you can request the cumulative hotfix and apply it to resolve the issue.
  8. Friendly User
    Scenario:You have exported your community (CE) repository and try to upgrade to pro version. The importing process fails to import the public folder and throws this error: [toc][java] ************** HibernateDaoImpl.executeWriteCallback EXCEPTION **********[java] com.jaspersoft.jasperserver.api.metadata.common.service.JSResourceNotFoundException: jsexception.folder.not.found.at[java] Arguments: "/organizations/organization_1/public",[/code]Solution:Export just the public folder from the community server. Open the archive with the public folder and find this property: <property name="jsVersion" value="6.4.0 CE"/>[/code]change it to: <property name="jsVersion" value="6.4.0 PRO"/>[/code]Try to re-import to Professional version.
  9. Friendly User
    Scenario:When we perform export to excel in an ad-hoc view which as some date time columns, it is not considering the logged in user’s time zone while displaying the dates in the export output file. It is directly getting the dates from the database without time zone conversion as part of export. Whereas export to PDF, CSV and others are converting the dates into logged in users time zone. Solution:try to append this property to {JRS WAR}/WEB-INF/classes/jasperreports.properties file: net.sf.jasperreports.export.xls.use.timezone=true[/code]and re-start the server.
  10. Friendly User
    That would involve having a custom data source that would stitch together your JDBC result set and XLS spreadsheet resultset together and then feed it to report for filling. Out of the box there is no datasource like that.
  11. Friendly User
    I have tested two different versions on my side and it works same for me - I drag the field to the filter pane and a new EQUALS filter is created with first value selected but not applied. If you want to select other values you click on the value and start searching. List type of filter only appears for IS ONE OF type of filters. Do you consider drop down for equals not appearing immediately after you drag the field to the filter a bug?
  12. Friendly User
    This will require you to create a completely new role and then define where users with the role can navigate to in the actionModel-navigation.xml. The actions that user with the role can take in the repository is defined in actionModel-search.xml. Both XML files can be found in {JRS-WAR}/WEB-INF/. For more information on this refer to chapter "Customizing Menus" of the JasperReports Server Ultimate Guide.
  13. Friendly User
    You will need to use two separate report objects in the band (summary band I guess) - table and crosstab. Both can use same data set or you can use different data sets. When exporting to Excel though I'd recommend to put them both on different sheets as crosstab columns and table columns can have different size and that can cause the exporter to merge a lot of cells and generally give you a messy output. To force a page break add a break element between Table and Crosstab elements. To force Excel exporter to print each page on it's own sheet use this property in the report: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.one.page.per.sheet
  14. Friendly User
    You can create a domain based on tables from data source connection and not stored procedure. You can use stored procedure in an ad hoc topic to return fields you want and then build ad hoc view based on the topic. To create a topic simply create a JRXML with a stored procedure call and then upload that JRXML to the server /ad hoc components/topics location. If you're a licensed user and your implementation is stalled you probably should contact support instead.
  15. Friendly User
    The multiselect input control is passing the value into the report as a collection. That collection is then used in an $X{IN} statement in the query as I would imagine. The IN statement in SQL translates in exactly what you see in your situation. It shows all the records that contain any of the items from the array. What you would need is probably a different $X{} operation or different query all together but that would depend on how your data is stored in the database.
  16. Friendly User
    1. Not domain. If you want to use stored procedure for ad hoc you'll need to use a regular topic. Upload a JRXML that calls your stored procedure as a query to the /adhoc components/topics folder and then you can select it when creating a view. You can add parameters to the report and then use these parameters in the query and build input controls on these parameters on the server. When in ad hoc editor you can press a button to bring up the parameter window and pass parameters to the topic. 2. See 1. 3. You can use Visualize.js to embed the dashboard. Visualize.js is a javascript library that allows you to embed content from JasperServer into your own applications. See visualize.js guide for more info on that.
  17. Friendly User
    Unfortunately it's not possible to make one input control to be dependent on another input control like that unless they are query based. Cascading input controls operate in a sense that selection from one input control automatically is passed to the query of a dependent input control. So if your date ranges are returned by a query then it's possible but I doubt they are. You may want to allow users just to enter both and have an auxilliary parameter in the report that has a default value expression based on the other parameter values and do the calculations in that expression.
  18. Friendly User
    When you create a domain you specify the domain repository object details first and then click on Edit with Designer hyperlink-like button on the lower part and then go to domain designer. In domain designer select the tables, define joins, derived tables, etc., then go to Display tab and put some objects to be visible. Once you have a domain designed in the designer and have the save location - your domain will be saveable.
  19. Friendly User
    Detail band prints as many times as you have rows in the result set. Putting chart to a detail band is not a good solution, The report should add more pages if the summary band stretches beyond the report page size. One thing you can try is Subreports and put the charts in a subreport and subreports in the summary band.
  20. Friendly User
    The input types on the server need also to be correct. Should be date/time for the date input controls. I guess you already have that. The displayed date for the fields is based on the pattern masks you choose for the text fields. Do you only see this problem for the display or you get actual incorrect time value passed to the calculations?
  21. Friendly User
    You can only have one summary band in the report. The reason why your first page is blank is probably because the data is to large to be fit on the page and the Split Type for the Detail band is set to Prevent. You may want to try Stretch instead.
  22. Friendly User
    JasperServer starting from version 6 has an option to use profile attributes in the data source definitions. Take a look at the chapter 4.1 "Profile attributes in data source definitions" in the JasperServer Admin Guide for more information on the feature. Another thing you can do to restrict the data based on the user logged in is to use domain data security. For that feature take a look at Chapter 5 in JasperServer Security Guide.
  23. Friendly User
    One more thing to add to the poster above is that NULL string is different from "" string which is an empty string. Make sure you actually do have nulls when testing that.
  24. Friendly User
    It looks as if the web client cannot establish connection to the server and does not get back the response with server information from the connection attempt. What exactly is the remote server in this case? Is your server behind a proxy? Are you able to do Test Connection successfully in the server properties? Can you try to do Advanced Settings -> Use SOAP Only to see if you get a more meaningful error than this one?
  25. Friendly User
    Depending on how you installed the server, your server might be looking for license in an incorrect folder/location. If you used installer, it'll look in the root folder of the installed package. Find the jasperserver.license file there and replace it. Otherwise the server will look for license in the user home folder. Check out the installation guide for information about how to apply the license and how to troubleshoot issues like this.
×
×
  • Create New...

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

Products

Explore