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

mc.bechara

Members
 View Profile  See their activity

  • Posts

    26

  • 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 mc.bechara

  1. mc.bechara
    But if i comment those 2 I'm getting the following error: java.lang.RuntimeException: groovy evaluation failed on string args[0].value and expression Integer(2015) and if I comment only the timestamp I get the following error: java.lang.RuntimeException: error getting schema
  2. mc.bechara
    anyone help with this!
  3. mc.bechara
    any ideas of the solution ?
  4. mc.bechara
    I have an adhoc view with date filter in jasper 6.0. I imported that to another instance of jasper 6.1 and the date filter stopped affecting the adhoc view. Looking at the adhoc cache, I found out that in v.6.0 my query in jasper used to be and ("PO_DATE" > TIMESTAMP '2015-08-12 00:00:00') while in v.6.1 it's and ("PO_DATE" > '2015-08-12 00:00:00') that's why the error. My database is Oracle and I checked the semantics file in 6.1, mapping of date is correctly set to java.util.date What could be the problem?
  5. mc.bechara
    anyone has a solution for this please? i'm not finding any in the forums.
  6. mc.bechara
    oh by the way my database is oracle
  7. mc.bechara
    @marianol I found out that in v.6.0 my query in jasper used to be and ("PO_DATE" > TIMESTAMP '2015-08-12 00:00:00') while in v.6.1 it's and ("PO_DATE" > '2015-08-12 00:00:00') that's why the error. But how to fix it? knowing that mapping of semantics is correct.
  8. mc.bechara
    of course I clicked Apply and nothing happened. The domain was imported from v.6.0 and I have this in the log: xception calling JRDataSource.next() for query select * from ( select "PO_DATE", Sum("QUANTITY") as "Sum_QUANTITY", Sum("TOTAL_NET_PRICE_USD") as "Sum_TOTAL_NET_PRICE_USD"from "KARLOS"."VIEW_REPORT_PURCHASES"where "SCOPE_ID" = 'CB' and 1 = 1 and 1 = 1 and 1 = 1 and EXTRACT(YEAR FROM "PO_DATE") = 2015 and ("PO_DATE" > '2015-08-25 12:29:12')group by "PO_DATE"order by "PO_DATE" ) where ROWNUM <= 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432)at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219)... 127 moreCaused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null.at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156)... 1 moreCaused by: java.sql.SQLDataException: ORA-01861: literal does not match format string
  9. mc.bechara
    did the solution work? I have the same problem and I checked the semantic file, it is correct: <entry key="DATE" value="java.util.Date"/> <entry key="TIMESTAMP" value="java.sql.Timestamp"/> What else could be the problem?
  10. mc.bechara
    I have an adhoc view with field myDate, when I add it to the filters and say myDate is After DAY-30 or any other time value, nothing is affected. There results don't get refreshed with this filter. However same report used to work with jaspersoft 6.0 Why isn't it working in version 6.1?
  11. mc.bechara
    /default template is used. There's nothing out of normal in the adhoc view. Just normal columns, I have numbers, text and date columns.
  12. mc.bechara
    I have Jaspersoft AWS version 6.0. I created an ad hoc view table with many columns grouped by one field. I saved the adhoc and created a report based on it. In the report not all columns visible in the adhoc view are visible in the report. Any ideas why? Is there a limit for the columns in the report?
  13. mc.bechara
    this is what I got from the Log: ERROR errorPage_jsp,http-bio-80-exec-4776:580 - stack trace of exception that redirected to errorPage.jsporg.springframework.webflow.conversation.impl.LockTimeoutException: Unable to acquire conversation lock after 90 seconds
  14. mc.bechara
    no errors just as if it goes timeout and loader keeps turning
  15. mc.bechara
    I have the Jaspersoft AWS version installed and I have created many adhoc views and reports since long and everything was working perfect. Except few days again, when I click on any of my existing adhocs or reports, it keeps loading and never opens. My internet connection is good. My datasource is well connected to oracle. What is the problem?
  16. mc.bechara
    Using Visualize.js with Jaspersoft AWS version 6.0, the authentication method is plain text username and password in the script file. How can I secure the login and password and remove the plain text credentials?
  17. mc.bechara
    We still haven't figured how to configure CAS and jasper. Any help please?
  18. mc.bechara
    I have a folder REPORTS containing all reports created from adhoc views. Another folder datasources containing the datasource. Another folder containing the adhoc reports. But I was to give access to user "R" to see only the REPORTS folder. so I created role_reports and on REports folder put permission of this role to "administer", and on the "Datasources" and "Ad hoc reports" permission no access. I then went inside datasources folder and selected the datasource and gave permission "Read-only" Same for the ad hoc reports folder, I selected the adhocs related to the reports and gave permission "Read-only" But still after logging to user "R", I see the "Reports" folder and when I try to click on a report it opens and gives me access denied. What am i missing?
  19. mc.bechara
    Yes we followed the setup for Java to trust CAS Certificate but Jasper and CAS are on different server. They should run on the same server?
  20. mc.bechara
    when configuring tomcat with the https on CAS server: <Connector protocol="org.apache.coyote.http11.Http11NioProtocol" port="8443" SSLEnabled="true" maxThreads="200" scheme="https" secure="true" keystoreFile="/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.75.x86_64/jre/lib/security/cacerts" keyAlias="casserver" keystorePass="changeit" clientAuth="false" sslProtocol="TLS" /> cas server doesn't open on https error message: I have no error messages in /var/lib/tomcat7/logs/catalina.out
  21. mc.bechara
    Getting error configuring CAS with Jaspersoft AWS version 6.0 with selfsigned certificate
  22. mc.bechara
    I have Jaspersoft server AWS version, I see in the samples a world map chart report. However when I create a new adhoc view, I can't see any map in the chart types. How can I create a world map report based on an adhoc view? Thanks
  23. mc.bechara
    Using visualize.js, how to specify the url of a dashbaord to embed? I only see I can embed report urls. I have the AWS version.
  24. mc.bechara
    I need to have a secure connection to jasper using visualize.js. I found an article that describes installing CAS on jaspersoft server but community edition. Didn't find anything for AWS version. Any ideas? Perhaps there's another way for AWS edition?
  25. mc.bechara
    I have jaspersoft version 5.6 and I need to make my dashboard as the homepage when I log in. I've modified the home1.jsp as I've found in the wiki but it just doesn't work. As if nothing is affected. I've created a role ROLE_DASHBOARD and in my home1.jsp here's what I've written: <authz:authorize ifAllGranted="ROLE_DEMO"> <%-- We have special home page for demo user only on PostgreSQL db. For other DB's it have same home page as other users. --%> <c:if test="${demoHomeResourceExists}"> <c:set var="homePageRequested">homeForDemo.jsp</c:set> </c:if> <c:if test="${not demoHomeResourceExists}"> <c:set var="homePageRequested">homeForNonDemo.jsp</c:set> </c:if></authz:authorize><authz:authorize ifAllGranted="ROLE_DASHBOARD"> <c:set var="homePageRequested">homeForDashboard.jsp</c:set></authz:authorize><authz:authorize ifNotGranted="ROLE_DEMO"> <c:set var="homePageRequested">homeForNonDemo.jsp</c:set></authz:authorize> <jsp:include page="${homePageRequested}"/> Now in homeforDashboard.jsp here's the iframe: <iframe id="outerFrame" class="outerDashboardFrame" name="Dashboard" allowtransparency="true" align="center" marginwidth="0" marginheight="0" hspace="0" vspace="0" frameborder="0" height="100%" width="100%" scrolling="no" src="${pageContext.request.contextPath}/flow.html?_flowId=dashboardRuntimeFlow&dashboardResource=${demoHomeResource}&viewAsDashboardFrame=true&decorate=no&hidden_isJasperAnalysis=<%=licenseManager.isAnalysisFeatureSupported()?"true":"false"%>"> </iframe> What else needs to be changed?
×
×
  • Create New...

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

Products

Explore