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

cameron_1

Members
  • Posts

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

Posts posted by cameron_1

  1. Not sure if this will still work on 6.2... It was written for 5.2, and updated again with 5.5, but that's the latest version I have, so I've not been able to test/port to 6.2 unfortunately. I have had a quick look at 6.2 and there did appear to be some changes in the way the input controls were rendered, so I suspect it may break this code in the process...
  2. Hi All,

    I've just upgraded our test server to 6.0, and no the MS SQL Server 2005 Driver (com.microsoft.sqlserver.jdbc.SQLServerDriver) no longer works.

    Whenever you try to connect to the server it just returns this error - 

    The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key".[/code]

    Anyone else experiencing this problem?

    This is running on SQL Server 2014. I think the JVM installed with jaspersoft may be contributing here (I loathe to play with it though, for fear of breaking things further), thats on version 1.6.0_18.

     

    Full stack trace is here - 

    com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key".ClientConnectionId:2153df67-6305-42e4-ba3b-39c2dfee6b3batcom.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)atcom.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1668)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1323)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)at java.sql.DriverManager.getConnection(DriverManager.java:582)at java.sql.DriverManager.getConnection(DriverManager.java:185)atorg.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36)atorg.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.testConnection(JdbcDataSourceService.java:84)atcom.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy.java:73)atcom.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy.java:44)atcom.jaspersoft.jasperserver.remote.connection.ConnectionsManager.createConnection(ConnectionsManager.java:71)atcom.jaspersoft.jasperserver.jaxrs.connection.ConnectionsJaxrsService.createConnection(ConnectionsJaxrsService.java:84)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)atcom.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)atcom.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)atcom.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)atcom.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)atcom.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)atcom.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)atcom.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)atcom.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483)atcom.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414)atcom.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363)atcom.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353)atcom.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)atcom.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)atcom.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708)at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)atorg.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)atorg.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)atorg.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:163)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)atorg.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)atorg.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:103)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.NullFilter.doFilterHttp(NullFilter.java:44)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:85)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)atorg.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)at java.lang.Thread.run(Thread.java:619)Caused by: javax.net.ssl.SSLException: Server keyatcom.sun.net.ssl.internal.ssl.Handshaker.throwSSLException(Handshaker.java:850)atcom.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:187)atcom.sun.net.ssl.internal.ssl.Handshaker.processLoop(Handshaker.java:516)atcom.sun.net.ssl.internal.ssl.Handshaker.process_record(Handshaker.java:454)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:884)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1112)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1139)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1123)atcom.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1618)... 123 moreCaused by: java.security.spec.InvalidKeySpecException: key spec notrecognisedatorg.bouncycastle.jcajce.provider.asymmetric.util.BaseKeyFactorySpi.engineGeneratePublic(UnknownSource)atorg.bouncycastle.jcajce.provider.asymmetric.ec.KeyFactorySpi.engineGeneratePublic(UnknownSource)at java.security.KeyFactory.generatePublic(KeyFactory.java:304)atcom.sun.net.ssl.internal.ssl.HandshakeMessage$ECDH_ServerKeyExchange.(HandshakeMessage.java:904)at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:183)... 130 more [/code]

     

  3. When will this "future release" arrive? It's been 2 years now!

     

    It's a very critical missing feature, as you've provided mechanisms to copy input controls, yet no way to rename them, when the input control recourse ID *HAS* to match the report parameter, it's critical that you provide the functionality to rename it, and not just half implement a feature.

  4. I don't think there should be any difference between platforms, it's all about the configuration of Jaspersoft that impacts this...

     

    Can you provide some more info, like the version you're running, the platforms you're using, what exactly happens when you try to export (are you getting a stack track, or something in the log file?).

     

    It might be worth posting an entirely new question, instead of a reply to an answer to a question.

  5. Parameters are attached to the dataset, if you expand the dataset itself, you'll find a section there for parameters, just like in your main report.

    JaspersoftStudioProfessional_2014-01-21_09-03-18.png.9b9a438018d629ec7e6be90b83f56912.png

    You'll need to link the parameters together though, using the connection properties where you're actually using the dataset, eg, in a chart or a table. For example, in the table, you go to the dataset tab of the properties pane, and click on the parameters button to map the parameters between your main report and your sub dataset.

    JaspersoftStudioProfessional_2014-01-21_09-07-05.png.42a65abd9da488bdecd7ff35a18938db.png

     

    JaspersoftStudioProfessional_2014-01-21_09-07-38.png.34556d74b30c632847344bda3913282f.png

  6. You could do that using different reports and hyperlinks to each report. The hyperlink would pass through the parameters from the parent report (where applicable, such as the subject and dates), and pick up the student from the record in the report itself.
  7. Just be aware if you're looking for Dashboards, what's available in the "Professional" edition may be a fair way away from what you'd expect from a paid Dashbaord product. Give it a trial first, before investing money, don't make the same mistake we did...

  8. Hello,

    Working with iReport, we need to use a subreport in a main report that is greater than the width of the main report.

    Idea is - Main report is A4 landscape, most subreports are A4 landscape as well, however some are A3 landscape.

    How do we set up the report to expand the pages to A3 landscape, while keeping the rest of the report at A4 landscape?

     
  9. I've found that Jaspersoft doesn't work well at all with anything less than IE9. Given that IE7 is now almost 7 years old, and is less than 1% of the worldwide market share, it's probably for the best (you can't expect them to support everything forever).

     

    Maybe time to upgrade to IE11?

  10. 1. Yup.

    2. Ha! When have you seen Jaspersoft document anything useful???

    3. Verion 2.3.2, as of Jaspersoft Profession version 5.5 (Annoying Jaspersoft DIDN'T upgrade to the latest version of Highcharts when they moved to Version 5.5, or 5.2, or 5.1....)

    I use this for documentaion on Highcharts (and HTML5 charts in Jaspersoft) - http://api.highcharts.com/highcharts

    Generally most of the options here can be translated into "advanced parameters" in the HTML5 cahrt options in dotted formats, eg, to disable xAxis labels you'd create the advanced property xAxis.label.enabled and set the expression to be Boolean.FALSE.

    When setting parameter expressions, it accesses fields from the main report, not the sub dataset you're using to fill your chart.

  11. I've asked the same question before and got a pretty blunt "No" response... Pretty hopeless, to be honest.

    The workaround I ended up doing was to create some new groups in AD and map the to JS roles, then login with say, 1 user who has every role assigned, get those AD linked roles set up in JS, then assign the permissions to those roles. Then when AD users login they'll get their roles assigned based upon their group memberships in AD.

    Downside of this is you need to maintain your Jaspersoft role membership in AD, instead of Jaspersoft. Depends on the kind of access you have to AD (or more specifically the kind of access your JS administrators have to AD), to decide if this is an acceptable solution.

  12. You can't use collections with the $P{} parameter reference.

    I'm more curious as to how your stored procedure is expecting the values to be given to it? Is it expecting some kind of formatted string of values to parse, or somethign else?

    I suspect your solution will require you to have 2 parameters, 1 being a collection, used as an input control to collect your parameters, then another parameter to pass to your stored procedue (in the same way as you've done here with the $P{} use), this would be a string type, and it would have a default value set with some code to take your collection and turn it into whatever your stored procedure is expecting for the input.

  13. In Windows, you can use tomcat6w.exe to make this change. But you need to stuff around a little first (assuming you're using the bundled Tomcat)...

    Navigate to your JS install DIR, the apach-tomcat folder. Go into the 'bin' folder. In there there's a file called tomcat6w.exe, make a copy of that and rename it to jasperreportsTomcatw.exe.

    Right click this file, and choose "run as administrator". In here, go to the Java tab, and you'll see the Java Options listed there. Make your recommended changes here and click OK! (and restart Tomcat of course).

     

    If you're not using the bundled J2EE server, you should read the documentation of your server in use, it'll usually have the methods listed on how to change that.

    Not sure at all about the Linux version, sorry, don't have a copy of it running to check with...

     

  14. As Jaspersoft doesn't seem interested in answering this, even though it is clearly a bug within their software, I'll do my best to let people know what I've found with this and what i've managed to do to get it working (in my environment at least).

    The crux of the problem appears to be that Jaspersoft Server 5.5 doesn't read the parameters for the font extensions if the values are enclosed in CDATA elements in their XML files. 5.2 did.

    iReport (version 5.2 and 5.5) produces JAR archives that contain XML files with the parameter values enclodes in CDATA blocks.

    Jaspersoft Studio 5.5 does not enclose values in CDATA blocks, however it has a different bug where it uses the absolute path to the font file on the local machine where the JAR font extension was created, instead of the relative path to the font file contained within the JAR archive.

    Jaspersoft Studio 5.2 doesn't appear to be capable of creating a working JAR font extension at all.

    In order to fix this you can edit the XML file within the JAR archive of the font extension (Hopefully you don't have too many font extensions...)

    You can open the JAR archive using 7-Zip or soething similar, in there under the fonts directory, there'll be an XML file that needs to be modified (either using the in-built editor of your compression program or by extracting, editing, saving and replacing the file within the archive).

    The contents of this file should look something like this (this is the file generated by iReport, which you should be working with, as Jaspersoft Studio doesn't, well, work properly at all) -

    <?xml version="1.0" encoding="UTF-8"?><fontFamilies>   <fontFamily name="Herr Von Muellerhoff">       <normal><![CDATA[fonts/HerrVonMuellerhoff-Regular.ttf]]></normal>       <pdfEmbedded><![CDATA[true]]></pdfEmbedded>   </fontFamily></fontFamilies>[/code]

    What you need to do, for each of the properties listed, is remove the surrounding CDATA blocks (so, "<![CDATA[" at the beginning and "]]>" at the end. The resulting file should look similar to this -

    <?xml version="1.0" encoding="UTF-8"?><fontFamilies>   <fontFamily name="Herr Von Muellerhoff">       <normal>fonts/HerrVonMuellerhoff-Regular.ttf</normal>       <pdfEmbedded>true</pdfEmbedded>   </fontFamily></fontFamilies>[/code]

    Save that file in place within the JAR archive and upload to you lib directory on the server (replacing the current font extension), and that should get you up and running again. At least it did for me.

  15. Hello,

    We're in the process of setting up some connections for our end users to our SQL Server Analysis Services Database, using an XML/A connection. The intended usage scenario for this is for them to access it via the ad-Hoc report tool within Jaspersoft Server.

    After creating the connection and making it available, we're finding the performance to be completely unusable. At first we had to configure Tomcat to have 6gb of memory, and 4gb of MaxPermSize memory, and it' uses it (we kept getting out of memory exceptions with anything less). Then to make matters worse, it take about 10 minutes to actually open the Ad-Hoc view/screen/editor after selecting the connection.

    Why on earth does it use so much RAM and take so long to open a connection? These aren't remote servers over a WAN, they're on a high-speed LAN in the same data centre. This cube opens instantly in other tools such as Excel and ProClarity, it's only Jaspersoft which takes excessive time. The server is, for the most part, consistently under load while it's opening this connection. It uses on average about 40% CPU, pretty much the entire time it's opening the connection.

    What can we do to make this actually usable? Right now end users can't wait 10 minutes for a web page to open. It's unusable for us.

    Thanks,

  16. Hello,

    How do we go about enabling the right click in Jaspersoft Server? I get requests from users wanting to, for example, print out a dashboard, but they can't because there's no right click menu!

    Rather simplistic example, but there are many cases where the menu is actualy useful (you know, being part of the native platform and all), I don't see why you would disable it??

×
×
  • Create New...