Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error with tFileOutputPDF Component

Hi,
I would like to generate a file PDF when an user has no obligatory ownership.
However, it is possible that this file sometimes is empty. When I try a trial game for this case I have this error :

Exception in component tFileOutputPDF_1
java.lang.ArithmeticException: / by zero
at importcrm.importusers_0_1.ImportUsers.tJDBCInput_4Process(ImportUsers.java:2413)
at importcrm.importusers_0_1.ImportUsers.tJava_1Process(ImportUsers.java:492)
at importcrm.importusers_0_1.ImportUsers.tSageCRMConnection_1Process(ImportUsers.java:430)
at importcrm.importusers_0_1.ImportUsers.runJobInTOS(ImportUsers.java:10536)
at importcrm.importusers_0_1.ImportUsers.main(ImportUsers.java:10439)

The job is a simple tMap which tried users with an address mail or not. Some users without adress mail are send from PDF file.
I how do not see resolving this problem??
Labels (4)
19 Replies
Anonymous
Not applicable
Author

Merci..
taux credit consommation
- Taux credit consommation, Un organisme de credit, ou banque de nouvelle generation, offre du credit
consommation
Anonymous
Not applicable
Author

Yes,
he said he will take a look at this issue. But you are free to contact him directly. May be you could give him some additional information. Looks like you took a closer look at the code...
Bye
Volker
Anonymous
Not applicable
Author

I downloaded tFileOutputPDF component today.
I want to create a pdf even if there's no data. I'm getting the same error mentioned on this post.
Any resolution is available?
Anonymous
Not applicable
Author

Hi viralfti,
Which custom component tFileOutputPDF are you using? The one written by ceppo1996?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina
Yes. I downloaded the component from Exchange
tFileOutputPDF 1.0 ceppo1996
Any resolutions or alternate solutions or components?
Thanks
Veer
Anonymous
Not applicable
Author

Yes there is an alternate solution. To create PDF files I suggest using JasperSoft Report Studio.
You create a very professional looking report and with the component tJasperReportExec you run your report within a Talend job.
http://www.jaspersoft.com (the community edition is right enough!)
and
the component:
http://www.talendforge.org/exchange/index.php?eid=549&product=tos&action=view&nav=1,1,1
Anonymous
Not applicable
Author

jlolling,
I used Jasper reports as an alternate solution. I'm using XML file as DataSource.
I see the output when i preview in report studio.
When I load the report using Jasper ReportExec in Talend the report output of records is Null.
Any ideas? I can share the screenshot.
Thanks
Anonymous
Not applicable
Author

Yes a screenshot would be fine. You have to configure the select expression like in your datasource of iReport.
Alternatively you could use the newest release 1.9 of this component which can use the select expression from the report it self. This should be your preferred solution.
Anonymous
Not applicable
Author

jlolling,
The new version did the trick. Thanks for the suggestion and support.
Thanks
Anonymous
Not applicable
Author

You should also give Jasper Studio a try. This is the future of report design for JasperSoft. iReport will be supported but will not developed in the same way as Jasper Studio.