[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: freekb.spw
Forum Index » Profile for freekb.spw » Messages posted by freekb.spw
Author Message
Hi,

I've tried to set a password on reports sent by Jasperreports but it does not seem to work.

What I've done is:

1) Changed /usr/local/tomcat/webapps/SpagoBIJasperReportEngine/WEB-INF/classes/jasperreports.properties and added line 'net.sf.jasperreports.export.xls.password=password'
2) I've created a very simple Jasperreport and did add it to the SpagoBI system. I've added the output parameter outputType.
3) I've created a scheduler, added this document to it, set the parameter to XLS, created an e-mail output and ran the scheduler.

The output was an e-mail with an XLS attachment but without the password.

Do I need to set any other thing? The other options in the jasperreports.properties file do work properly. It looks now as follows:

net.sf.jasperreports.awt.ignore.missing.font=true
# XLS exporter settings
net.sf.jasperreports.export.xls.create.custom.palette=false
net.sf.jasperreports.export.xls.one.page.per.sheet=false
net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true
net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true
net.sf.jasperreports.export.xls.white.page.background=true
net.sf.jasperreports.export.xls.detect.cell.type=true
net.sf.jasperreports.export.xls.size.fix.enabled=false
net.sf.jasperreports.export.xls.ignore.graphics=false
net.sf.jasperreports.export.xls.collapse.row.span=false
net.sf.jasperreports.export.xls.ignore.cell.border=false
net.sf.jasperreports.export.xls.ignore.cell.background=false
net.sf.jasperreports.export.xls.max.rows.per.sheet=0
net.sf.jasperreports.export.xls.password=pa22w0rd
net.sf.jasperreports.export.xls.wrap.text=true

By the way, I've also added the lines:
net.sf.jasperreports.export.pdf.owner.password=pa22w0rd
net.sf.jasperreports.export.pdf.user.password=pa22w0rd

But the same result. So a PDF file without password.

I've checked all logfiles and there is nothing reported in there.

Anyone any clue?

Best regards and thanks in advance,
Freek
Hi,

We did some tests with browsers on SpagoBI 3.6. The server is running Ubuntu 64 bit and we're using MySQL as a database. The georeport accesses geoserver in order to get the mapping data.

The programs were up-to-date on 7-3-2013.
Firefox: Works fine.
Chrome: Does not draw up the map.
Opera: Works fine.
Safari: Works fine.
Internet explorer: Works, but cancels out on large quantities.

I use also 3 browsers on Ubuntu 64 client to connect to the same server.
Firefox: Does not draw up the map.
Chrome: Works fine.
Chromium: Works fine.

I did a post a few months ago where I made the same type of list. Funny enough, that list was the reason for people to move to Chrome, since it seemed very stable in combination with the GeoReport. Anyone experiencing the same problems?

Best regards and thanks in advance,
Freek
Hi,

If I add the parameter outputType to a report and I wish to e-mail the report with an excel attachment, you cannot do this from the application, since if you execute the report without filling the outputType=XLS, you will get an html format and will only be able to send that, if you do fill outputType=XLS, it looks like you can send the e-mail, but the form is disabled.

Best regards,
Freek

PS: SpagoBI 3.6, Ubuntu 11.10, MySQL.
Hi,

I've created a report with a date selection. If the date selection is empty, it automatically fills the date with a default date (in this case from date 01-01-2013, until date 31-12-2013).

Now I run the report and do not fill any date. The header of the report shows the parameters and they are ok. I press the sendmail button and all works fine.. E-mail arrives with the right date.

Now I run the report again and fill the from and until date with a value of 01-12-2012 and 31-12-2012. I run the report and all is ok on the screen. The report shows the correct dates. Now I press the sendmail button and send the email. The e-mail that was received now contains the dates 01-01-2013 until 31-12-2013, while it should have taken over the date from the selection made.

Best regards,
Freek
Hi,

Check the documentation... https://wiki.spagobi.org/xwiki/bin/view/spagobi_sdk/SDK_3_5_1_User_guide

What I did is start a wget from the unix command line to execute the interface.

Best regards,
Freek
Yes... I use it myself.
I do the same since SpagoBI 3.6 using the SDK. You can import an export file from the server command line.

Best regards,
Freek
Hi,

I never finished this topic, but on SpagoBI 3.6 I synchronize multiple servers without any problem. I also use the SpagoBI SDK in order to update the reports in batch automatically.... So all problems in this are solved.

Best regards,
Freek
To add to this topic... In expert mode you will get this to work, but still it feels wrong..

AND ....

in my case when you want to show invoices longer than an amount of days, you would like to add your 'Calculated field' to the select area. This does not work. So the only thing you can do is take the internal fieldnames, create manually a 'Where clause' and paste something like:

t_0.dateinfoByDatepaid.julian - t_0.dateinfoByDateinvoice.dateid

into the field name field..

Why not simply allow filter???

Best regards and thanks in advance,
Freek
Hi,

I've tested this under Ubuntu 64 bit, SpagoBI 3.3 and 3.6, mysql, tomcat.

I have a table that has two date fields and a few amount fields. The date fields are linked to a table that does contain all kind of information about a date, like a Julian number, day, week, etc, etc.

If I substract with an 'Add Calculated' two fields from the main table, it works perfectly.

If I substract the julian number from the two date fields, it fails..
14 Dec 2012 08:45:00,216 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:101 - The error root cause stack trace is:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 161 [SELECT t_0.invoicenumber, t_0.account.name, t_0.dateinfoByDateinvoice.dateid, t_0.dateinfoByDateinvoice.julian, t_0.dateinfo
ByDatepaid.julian, it.dealer.Invoice::dateinfoByDatepaid[datepaid]:julian- it.dealer.Invoice::dateinfoByDateinvoice[dateinvoice]:julian FROM it.dealer.Invoice t_0]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
at it.eng.qbe.statement.hibernate.HQL2SQLStatementRewriter.rewrite(HQL2SQLStatementRewriter.java:6
at it.eng.qbe.statement.hibernate.HQLStatement.getSqlQueryString(HQLStatement.java:1309)
at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.executeQuery(ExecuteQueryAction.java:205)
at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.service(ExecuteQueryAction.java:106)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:48
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:200)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:86)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:679)
14 Dec 2012 08:45:00,217 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:102 - The error full stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineServiceException: An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT t_0.invoicenumber, t_0.account.name, t_0.dateinfoByDateinvoice.dateid,
t_0.dateinfoByDateinvoice.julian, t_0.dateinfoByDatepaid.julian, it.dealer.Invoice::dateinfoByDatepaid[datepaid]:julian- it.dealer.Invoice::dateinfoByDateinvoice[dateinvoice]:julian FROM it.dealer.Invoice t_0]
at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.executeQuery(ExecuteQueryAction.java:217)
at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.service(ExecuteQueryAction.java:106)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:48
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:200)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:86)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:679)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 161 [SELECT t_0.invoicenumber, t_0.account.name, t_0.dateinfoByDateinvoice.dateid, t_0.dateinfoByDateinvoice.julian, t
_0.dateinfoByDatepaid.julian, it.dealer.Invoice::dateinfoByDatepaid[datepaid]:julian- it.dealer.Invoice::dateinfoByDateinvoice[dateinvoice]:julian FROM it.dealer.Invoice t_0]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
at it.eng.qbe.statement.hibernate.HQL2SQLStatementRewriter.rewrite(HQL2SQLStatementRewriter.java:6
at it.eng.qbe.statement.hibernate.HQLStatement.getSqlQueryString(HQLStatement.java:1309)
at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.executeQuery(ExecuteQueryAction.java:205)
... 23 more

The select it should build in this case would be:
SELECT invoice.invoicenumber, account.name, Dateinvoice.dateid, Dateinvoice.julian, Datepaid.julian, (Datepaid.julian- Dateinvoice.julian
FROM invoice JOIN (dateinfo Dateinvoice) ON (invoice.dateinvoice=dateinfo.dateid)
JOIN (dateinfo Datepaid) ON (invoice.datepaid=dateinfo.dateid)
WHERE Datepaid is not null;

A describe from the dateinfo table shows the Julian field as follows (so it's an integer):
| JULIAN | int(11) | NO | | NULL | |

If I change the field to a decimal field, it makes no difference in the error message.

By the way... I also notice that the WHERE part of the clause is gone in the error log.

Could anyone have a look at this?

Thanks in advance,

Freek
Hi,
I'm using excel 2007 but even on open-office, which I'm using most of the time, it's not a problem. So I expect the problem to be somewhere in your setup of the file.
Best regards,
Freek
Hi,

I've updated to iOS6.01 and SpagoBI 3.6 and the Mobile engine does not show the 'root directory' in the Document browser anymore. So I can login, but after the login I only have the possibility to logout.

If I use Chrome in order to login, it works fine. I can move to the reports without a problem.

In SpagoBI 3.51 in combination with the previous version of iOS, it worked fine.

Is there a solution?

Best regards and thanks in advance,
Freek
Is there any news on this yet????
Hi,

I've changed the file:
/usr/local/tomcat/webapps/SpagoBIJasperReportEngine/WEB-INF/classes/jasperreports.properties with the content described before. I've restarted my server and it works fine. If I export I can do sums, etc, etc.

Best regards,
Freek
Hi I've tested this on SpagoBI 3.6 and it works perfectly. Perhaps you have not restarted the tomcat server?

Best regards,

Freek
 
Forum Index » Profile for freekb.spw » Messages posted by freekb.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team