[jaspersoft 6.1 adhoc filter of type date not affecting the results]

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

[Datetime filter in ad hoc view doesn't work]

anyone help with this!

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

any ideas of the solution ?

[aws jasper server 6.1 Date filters not working]

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?

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

anyone has a solution for this please? i'm not finding any in the forums.

 

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

oh by the way my database is oracle

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

@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.

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

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 more

Caused 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 more

Caused by: java.sql.SQLDataException: ORA-01861: literal does not match format string

 

[Datetime filter in ad hoc view doesn't work]

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?

 

[jaspersoft 6.1 adhoc filter of type date not affecting the results]

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?

[Jaspersoft server 6.0 report missing columns]

/default template is used. There's nothing out of normal in the adhoc view. Just normal columns, I have numbers, text and date columns.

[Jaspersoft server 6.0 report missing columns]

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?

[Visualize.js how to securely connect?]

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.jsp

org.springframework.webflow.conversation.impl.LockTimeoutException: Unable to acquire conversation lock after 90 seconds

[AWS jaspersoft server created AD hocs and reports not opening]

no errors just as if it goes timeout and loader keeps turning

[AWS jaspersoft server created AD hocs and reports not opening]

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?

[Visualize.js how to securely connect?]

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?

 

[Configuring CAS with Jaspersoft AWS version giving error]

We still haven't figured how to configure CAS and jasper. Any help please?

[setting role permission to a folder of reports but still access denied]

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?

[Configuring CAS with Jaspersoft AWS version giving error]

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?

[Configuring CAS with Jaspersoft AWS version giving error]

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

[Does the integration of CAS with Jasper works with selfsigned certificate?]

Getting error configuring CAS with Jaspersoft AWS version 6.0 with selfsigned certificate

[Jaspersoft server 6.0 world map report]

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

[How to embed a dashbaord with visualize.js?]

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.

 

 

 

[AWS Visualize.js and Secure connection]

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?

[Setting my dashboard as homepage]

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?