jasperreportsuser

Did you ever find a solution? I'm seeing the same error. Using JasperReports Server 6.1

Thank you for the reply. You are exactly right about the reasoning. I am trying to dig deeper into what is going on in my report and want to see what SQL results from my $X expressions. I believe your link is again referring to the Jasper Server. As I do not administrate the Jasper server I would like to view the SQL generated in Jaspersoft Studio. I searched the install folder for jasperreports.properties and it doesn't appear to be present. Any further suggestions?

I've seen some discussion on how to log generated SQL on jasper server and iReport. Is it possible to do so in Jaspersoft Studio?

Thank you for the comment. I am attempting exactly what you describe. I am running the installer as a non-root user and do use the default install location. However, that defaults to users home directory. The error I posted is coming during an attempt at installation by a non-root user.

OK. I misunderstood initially. Off hand I can only concur with your finding. Its the first time I've tried to use a procedure in a report but its working the same way for me as it is for you. I'll keep an eye out and see if anyone else has a way to populate the fields.

I setup a test which was simply a table with data, a stored procedure which simply did a "select * from table", and then I created a report to use the procedure. My data query is simply "call TestProcedure()". I received the same error in the data query display that you did stating that select was expected. However, if I add the fields myself and run the report it does display the appropriate data on the report. Does your reports have fields populated in Jaspersoft Studio? If not try adding them. If so try double checking that the values match the column names returned by the procedure.

I'm using Jaspersoft Studio so I'm not sure this exists in iReports Designer but the Break element has a "Print When Expression" field. In that you can enter an expression of $P{MyParameter}.equals( Object )

No matter what I do the stack trace looks bad. I'll take a suggestion on how to present that better too if someone has one.

I am trying to install jasper reports server on a RHEL 5 machine as a non-root user. I am getting a lot of errors that look like the following, Caused by: org.springframework.beans.factory.BeanCreationException:Error creating bean with name 'dataSnapshotCachingService' defined infile[/home/josesm/jasperreports-server-cp-5.5.0/buildomatic/conf_source/ieCe/applicationContext-data-snapshots.xml]:Cannot create inner bean'org.springframework.cache.ehcache.EhCacheFactoryBean#43b12dbb' of type[org.springframework.cache.ehcache.EhCacheFactoryBean] while settingbean property 'contentsCache'; nested exception isorg.springframework.beans.factory.BeanCreationException: Error creatingbean with name'org.springframework.cache.ehcache.EhCacheFactoryBean#43b12dbb' definedin file[/home/josesm/jasperreports-server-cp-5.5.0/buildomatic/conf_source/ieCe/applicationContext-data-snapshots.xml]:Invocation of init method failed; nested exception isnet.sf.ehcache.CacheException: java.io.IOException: Permission denied[java] atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:281)[java] atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:120)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)[java] atorg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)[java] atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)[java] atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)[java] atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)[java] atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)[java] ... 160 more [java] Caused by:org.springframework.beans.factory.BeanCreationException: Error creatingbean with name'org.springframework.cache.ehcache.EhCacheFactoryBean#43b12dbb' definedin file[/home/josesm/jasperreports-server-cp-5.5.0/buildomatic/conf_source/ieCe/applicationContext-data-snapshots.xml]:Invocation of init method failed; nested exception isnet.sf.ehcache.CacheException: java.io.IOException: Permission denied[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)[java] atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:270)[java] ... 170 more [java] Caused by: net.sf.ehcache.CacheException:java.io.IOException: Permission denied [java] atnet.sf.ehcache.DiskStorePathManager$DiskStorePath.<init>(DiskStorePathManager.java:331)[java] atnet.sf.ehcache.DiskStorePathManager.resolveAndLockIfNeeded(DiskStorePathManager.java:145)[java] atnet.sf.ehcache.DiskStorePathManager.getFile(DiskStorePathManager.java:262)[java] atnet.sf.ehcache.DiskStorePathManager.getFile(DiskStorePathManager.java:251)[java] atnet.sf.ehcache.store.disk.DiskStorageFactory.<init>(DiskStorageFactory.java:125)[java] atnet.sf.ehcache.store.disk.DiskStore.create(DiskStore.java:156) [java] atnet.sf.ehcache.store.DiskBackedMemoryStore.createDiskStore(DiskBackedMemoryStore.java:61)[java] atnet.sf.ehcache.store.DiskBackedMemoryStore.create(DiskBackedMemoryStore.java:49)[java] at net.sf.ehcache.Cache.initialise(Cache.java:1097) [java] atnet.sf.ehcache.CacheManager.initializeEhcache(CacheManager.java:1298)[java] atnet.sf.ehcache.CacheManager.addCacheNoCheck(CacheManager.java:1329)[java] at net.sf.ehcache.CacheManager.addCache(CacheManager.java:1227)[java] atorg.springframework.cache.ehcache.EhCacheFactoryBean.afterPropertiesSet(EhCacheFactoryBean.java:332)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)[java] atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)[java] ... 173 more [java] Caused by: java.io.IOException: Permissiondenied [java] at java.io.UnixFileSystem.createFileExclusively(NativeMethod) [java] at java.io.File.createNewFile(File.java:947) [java] atnet.sf.ehcache.DiskStorePathManager$DiskStorePath.<init>(DiskStorePathManager.java:322)[java] ... 187 more[/code] I have seen several posts pointing to this link as as solution, http://community.jaspersoft.com/wiki/javaioioexception-permission-denied-when-running-js-export-non-root-user This information does not seem to help me. I tried creating a directory /temp and gave it permissions 777 but the errors continue. The file specified is buildomatic/conf_source/iePro/applicationContext-web-services.xml but I am not using the Pro version. The file buildomatic/conf_source/ieCe/applicationContext-web-services.xml does not exist. I found a file by same name in WEB-INF which does have a tempFolder property. I tried changing it from temp to tmp and ran <js-install>/js-install-ce.sh but the errors still exist. Does anyone know what else could be wrong or have an advice on something I may be overlooking? Thanks!

On the Dataset and Query Dialog page there are tabs at the bottom (Fields, Parameters, Sorting, Filter Expressions, and Data Preview). You can add a field on the Sorting section. Alternatively you could add an Order By to your Query if you are using SQL.

After the above steps, try this. Shutdown Jaspersoft Studio (and all Eclipse instances), go to C:Users (in windows 7) and delete the directory .eclipse. Then restart Jaspersoft Studio. A new .eclipse file will be generated.

I had a similar problem when I first downloaded Jaspersoft Studio. I resolved the issue by doing the following, Setup master key encryption in Eclipse Go to Window >Preferences > General > Security > Secure Storage Click Change Password. If it complains about a problem and asks if you want to cancel press no. Provide recovery Q/A Hope this helps.

Greeting. I am hoping you will be able to assist me with a terrible inconvenience while developing chart customizers in Jaspersoft Studio. I have downloaded the example code and successfully built it into a jar. I can put that jar on the classpath in the Jaspersoft Studio project and the results work just as expected. The trouble comes when I make a change and rebuild the jar. After changing the customizer and building a new jar the report renders the same. The new jar is not loaded and an old cached version seemst to be used. My current work arounds for this are either making a new jar, adding that second jar to the classpath, and then setting the chart customizer to use the class from the new jar or to restart Jaspersoft Studio. Both of these are slowing down debuggin efforts tremendously. I have spent some time looking for a solution and I have seen that previously in iReports when you add a jar to the classpath you have a checkbox to make it "reloadable". I cannot find such an option in Jaspersoft Studio. Does anyone know of a way that I can easily reload jars in my project?