DX NetOps

 View Only
Expand all | Collapse all

jasper reports e-mail

  • 1.  jasper reports e-mail

    Posted Oct 23, 2020 08:49 AM
    Hello Community,

    I can't send e-mail by jasper reports anymore,today when I tried to send an e-mail using jasper reports I saw this error in logs on jasper server:

    2020-10-23 10:43:19,393 ERROR ReportExecutionJob,quartzScheduler_Worker-2:366 - The job error notification was not completed. An error occurred while sending it.
    org.springframework.mail.MailSendException: Failed messages: javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_2_1977045253.1603456999368"; message exception details (1) are:
    Failed message 1:
    javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_2_1977045253.1603456999368"
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:625)
    at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:416)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:140)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1123)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:581)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:248)
    at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
    Caused by: javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_2_1977045253.1603456999368"
    at javax.activation.ObjectDataContentHandler.writeTo(Unknown Source)
    at javax.activation.DataHandler.writeTo(Unknown Source)
    at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)
    at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1683)
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:585)
    ... 10 more

    What i need to do to fix this error ?

    thank you



    ------------------------------
    Valéria Revheim
    ------------------------------


  • 2.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Oct 24, 2020 04:24 AM
    Hi Valeria,

    what version of Jaspersoft are you running? And what java version?

    Can you share a screenshoft of the Notification configuration? How are you attaching the report to mail? As a zip?

    Regards


  • 3.  RE: jasper reports e-mail

    Posted Oct 26, 2020 07:59 AM
    Hello Jose Vicente,

    I'm using 6.4.2 Jasper Reports and the last version of java (Java 8 Update 261).Yes,I'm attaching the report to mail as pdf and below you can see the error on logs in Jasper Server :

    2020-10-23 19:56:43,556 ERROR ReportExecutionJob,quartzScheduler_Worker-1:366 - The job error notification was not completed. An error occurred while sending it.
    org.springframework.mail.MailSendException: Failed messages: javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_997195499.1603490203462"; message exception details (1) are:
    Failed message 1:
    javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_997195499.1603490203462"
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:625)
    at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:416)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:140)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1123)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:581)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:248)
    at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
    Caused by: javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_997195499.1603490203462"
    at javax.activation.ObjectDataContentHandler.writeTo(Unknown Source)
    at javax.activation.DataHandler.writeTo(Unknown Source)
    at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)
    at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1683)
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:585)
    ... 10 more

    thank you,





  • 4.  RE: jasper reports e-mail

    Posted Oct 26, 2020 11:22 AM
    Hi Valeria,

    Did you check that Jaspersoft Server have communication to mail server using the port assigned for that task. You change maybe the password for the email account user and this is the cause that the email didn't work anymore?

    Because if this works OK before, some change was made.

    Regards

    Jose


  • 5.  RE: jasper reports e-mail

    Posted Oct 26, 2020 05:30 PM
    Hello Jose,

    I think the problem could be these 2 variables:

    report.scheduler.mail.sender.username=admin
    report.scheduler.mail.sender.password=password

    because neither of both I have put something value,so in this case can I put "" to say that is empty?
    the username and password must be empty 

    thank you,


  • 6.  RE: jasper reports e-mail

    Posted Oct 29, 2020 11:09 AM
    Hi Valeria,

    The mail account that you are using to send the schedule reports from Jaspersoft needs user and password to get access to the SMTP server?
    Because I have problems to send email reports when the email account used have security so I have to asked the email administrator to put the account without any validation and works.

    I hope this help you.

    Regards
    Jose


  • 7.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Oct 27, 2020 04:15 AM
    Hi Valerie,

    my research points to a classpath issue. Can you please search for mail and activation jar libraries under apache-tomcat folder?

    Have in mind that libraries can have the version in the name like mail-1.4.jar or activation-1.1.jar

    Regards


  • 8.  RE: jasper reports e-mail

    Posted Oct 27, 2020 10:21 AM
    Hello Jose,

    How can I make the installation on my cabi server?Only run mail-1.4.jar or activation-1.1.jar after downloading it?



    thank you



  • 9.  RE: jasper reports e-mail

    Posted Oct 27, 2020 05:31 PM
    Hello Jose,

    I have 2 jar libraries that you told me  :mail-1.4.jar and  activation-1.1.jar in E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib





  • 10.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Oct 28, 2020 03:56 PM
    Hi Valerie,

    I think the problem comes from the fault to load the proper class to manage "multipart/mixed" mime-type.

    This is mapped in a file inside mail-1.4.jar

    Can you extract the file META-INF/mailcap from mail-1.4.jar file and check if it contains the following line?

    multipart/*;; x-java-content-handler=com.sun.mail.handlers.multipart_mixed; x-java-fallback-entry=true

    To extract it, make a copy of mail-1.4.jar file to a different location, change the extension of the file to zip and extract as usual.

    In order to debug the problem, can you follow these steps?

    1. Stop CABI
    2. Edit E:\CA\JASPER\apache-tomcat\bin\catalina.bat and place the following line after nolocal line (around line 372)
    set JAVA_OPTS="
    -Djavax.activation.debug=true"
    3. Start CABI
    4. Reproduce the issue and look for lines like the following in catalina.out

    MailcapCommandMap: createDataContentHandler for multipart/mixed
      search DB #1
      search DB #2
      search fallback DB #1
        got content-handler
           class com.sun.mail.handlers.multipart_mixed

    Regards


  • 11.  RE: jasper reports e-mail

    Posted Oct 29, 2020 04:58 PM
    Hello Jose Vicente,

    I did what you asked me,but I didn't find theses errors that you told me in catalina.out,:

    MailcapCommandMap: createDataContentHandler for multipart/mixed
      search DB #1
      search DB #2
      search fallback DB #1
        got content-handler
           class com.sun.mail.handlers.multipart_mixed


    but I realized when i did the process again to send an e-mail the error appeared inside of logs but the hour was wrong because when I did it was 17:32 o'clock  and appeared as 18:32 o',clock:


    2020-10-29 18:32:21,802 ERROR ReportExecutionJob,quartzScheduler_Worker-1:366 - The job error notification was not completed. An error occurred while sending it.
    org.springframework.mail.MailSendException: Failed messages: javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_630052124.1604003541717"; message exception details (1) are:
    Failed message 1:
    javax.mail.MessagingException: IOException while sending message;
    nested exception is:
    javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_630052124.1604003541717"
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:625)
    at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:416)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340)
    at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:140)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1123)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:581)
    at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:248)
    at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
    Caused by: javax.activation.UnsupportedDataTypeException: no object DCH for MIME type multipart/mixed;
    boundary="----=_Part_0_630052124.1604003541717"
    at javax.activation.ObjectDataContentHandler.writeTo(Unknown Source)
    at javax.activation.DataHandler.writeTo(Unknown Source)
    at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)
    at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1683)
    at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:585)
    ... 10 more

    The jasper reports server was the hour correct but in the logs I always see the wrong hour (it's seems like1 hour ahead).


  • 12.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Oct 30, 2020 05:33 AM
    Hi Valerie,

    The only reason for that Exception is because the handler is not found for any strange reason. I confirmed in the source code.

    I have realized the tomcat in Windows starts differently and this is why the debug flag did not apply.

    For doing the test again:

    1) Stop CABI as usual from services panel
    2) Edit the file E:\CA\JASPER\apache-tomcat\conf\logging.properties
    3) Add this line at the end

    javax.activation.level = ALL

    4) Save the file
    5) Start CABI as usual from services panel

    The output will be printed in catalina.out

    Regards




  • 13.  RE: jasper reports e-mail

    Posted Nov 04, 2020 01:44 PM
    Hello Jose,

    I did what you asked me do.Follow the logs below:

    04-Nov-2020 16:37:03.791 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: file C:\Users\Administrator\.mailcap
    04-Nov-2020 16:37:03.791 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load SYS
    04-Nov-2020 16:37:03.792 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: file E:\CA\JASPER\jre\lib\mailcap
    04-Nov-2020 16:37:03.792 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load JAR
    04-Nov-2020 16:37:03.793 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: !anyLoaded
    04-Nov-2020 16:37:03.793 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: not loading mailcap file: /META-INF/mailcap
    04-Nov-2020 16:37:03.794 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load DEF
    04-Nov-2020 16:37:03.794 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: InputStream
    04-Nov-2020 16:37:03.795 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log parse: image/gif;; x-java-view=com.sun.activation.viewers.ImageViewer
    04-Nov-2020 16:37:03.795 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Type: image/gif
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.ImageViewer
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log parse: image/jpeg;; x-java-view=com.sun.activation.viewers.ImageViewer
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Type: image/jpeg
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.ImageViewer
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log parse: text/*;; x-java-view=com.sun.activation.viewers.TextViewer
    04-Nov-2020 16:37:03.796 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Type: text/*
    04-Nov-2020 16:37:03.797 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.TextViewer
    04-Nov-2020 16:37:03.797 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log parse: text/*;; x-java-edit=com.sun.activation.viewers.TextEditor
    04-Nov-2020 16:37:03.797 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Type: text/*
    04-Nov-2020 16:37:03.797 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Command: edit, Class: com.sun.activation.viewers.TextEditor
    04-Nov-2020 16:37:03.797 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Merging commands for type text/*
    04-Nov-2020 16:37:03.798 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: successfully loaded mailcap file: /META-INF/mailcap.default
    04-Nov-2020 16:37:03.798 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load HOME
    04-Nov-2020 16:37:03.798 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: file C:\Users\Administrator\.mailcap
    04-Nov-2020 16:37:03.799 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load SYS
    04-Nov-2020 16:37:03.799 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: file E:\CA\JASPER\jre\lib\mailcap
    04-Nov-2020 16:37:03.799 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load JAR
    04-Nov-2020 16:37:03.800 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: !anyLoaded
    04-Nov-2020 16:37:03.800 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: not loading mailcap file: /META-INF/mailcap
    04-Nov-2020 16:37:03.801 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load DEF
    04-Nov-2020 16:37:03.803 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log MailcapCommandMap: add to PROG
    04-Nov-2020 16:37:03.803 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log new MailcapFile: default
    04-Nov-2020 16:37:03.803 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log appendToMailcap: image/*;;x-java-content-handler=org.apache.cxf.attachment.ImageDataContentHandler
    04-Nov-2020 16:37:03.803 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log parse: image/*;;x-java-content-handler=org.apache.cxf.attachment.ImageDataContentHandler
    04-Nov-2020 16:37:03.804 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Type: image/*
    04-Nov-2020 16:37:03.804 FINE [http-nio-8080-exec-9] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: org.apache.cxf.attachment.ImageDataContentHandler
    04-Nov-2020 16:37:53.113 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log MailcapCommandMap: createDataContentHandler for text/plain
    04-Nov-2020 16:37:53.113 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log search DB #1
    04-Nov-2020 16:37:53.113 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log search fallback DB #1
    04-Nov-2020 16:37:53.124 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log MailcapCommandMap: createDataContentHandler for multipart/mixed
    04-Nov-2020 16:37:53.124 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log search DB #1
    04-Nov-2020 16:37:53.124 FINE [quartzScheduler_Worker-1] com.sun.activation.registries.LogSupport.log search fallback DB #1

    ------------------------------
    Valéria Revheim
    ------------------------------



  • 14.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 04, 2020 03:02 PM
      |   view attached
    Hi Valerie,

    it is clear that you have a problem with your classloader in tomcat because it should load mailcap from mail-1.4.jar

    Two questions:
    1. Does mail-1.4.jar exist in E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib from the beginning? Or did you download and copy it from Internet?
    2. Can you check the file permission of mail-1.4.jar file?
    As a workaround, extract the attached zip file in C:\Users\Administrator\ and restart CABI tomcat

    Note: after zip extraction a file C:\Users\Administrator\.mailcap must exist (including . in the file name)

    Test after that and let me know

    Regards

    Attachment(s)

    zip
    mailcap.zip   447 B 1 version


  • 15.  RE: jasper reports e-mail

    Posted Nov 04, 2020 04:37 PM
    Hello Jose,

    Aswering your questions:

    1. Does mail-1.4.jar exist in E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib from the beginning? Or did you download and copy it from Internet?
    the mail-1.4.zjar already existed.

    1. Can you check the file permission of mail-1.4.jar file?

    Yes.There are groups like "System","Administrators" and Users.
    System and Administrators have full control but the users doesn't have.

    Do you want to download the file .jar and copy it to E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib ?

    Thank you,



    ------------------------------
    Valéria Revheim
    ------------------------------



  • 16.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 04, 2020 04:50 PM

    Hi Valerie,

    I am confusing. Why do you ask me this?

    Do you want to download the file .jar and copy it to E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib ?

    If mail-1.4.jar file is already located in that folder why you would need to download it and copy there. 

    Have you tested the workaround I propose?

    Regards




  • 17.  RE: jasper reports e-mail

    Posted Nov 05, 2020 08:46 AM
    Hello Jose,

    Sorry for the misunderstanding.I didn't see the zip file attached here.

    The workaround worked perfectly,but what happened about classloader mail-1.4.jar that suddenly stopped working. 

    thank you so much


  • 18.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 05, 2020 10:19 AM
    Hi Valerie,

    happy to hear that the workaround worked.

    Regarding why mail-1.4.jar file is not found by the webapp classloader, I think it can be a permission problem in the Security Manager.

    Did you modify this file E:\CA\JASPER\apache-tomcat\conf\catalina.policy?
    What we can do is to debug the Security Manager errors. For doing that:
    1) Stop CABI tomcat
    2) Open a CMD terminal and go to E:\CA\JASPER\apache-tomcat\bin
    3) Execute command
    tomcat8w.exe //ES//cabusinessintelligencetomcat
    4) Go to Java tab and append the highlighted line in the parameters

    5) Apply the changes and close the window
    6) Start CABI tomcat and reproduce the issue (there is no need to remove the .mailcap file)

    After that, open cabusinessintelligencetomcat-stderr.<date> and search mail-1.4.jar. Is there any access error?

    Note: Remember to repeat the steps and remove the new command line option added in step 4.

    Regards





  • 19.  RE: jasper reports e-mail

    Posted Nov 05, 2020 12:48 PM
    Hello Jose,

    I've tried to run the command "tomcat8.exe //ES//cabusinessintelligencetomcat" on directory E:\CA\JASPER\apache-tomcat\bin but this command restart again the tomcat  and couldn't see the java tab as you told me.

    thank you



  • 20.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 05, 2020 01:11 PM
    Hi Valerie,

    there is a typo in your command.

    Correct command is (look at the w after tomcat8)

    tomcat8w.exe //ES//cabusinessintelligencetomcat

    Regards


  • 21.  RE: jasper reports e-mail

    Posted Nov 05, 2020 01:41 PM

    Hello Jose,

    When I put the w. after 8  as you did "tomcat8w.exe" I receive this error that I attached here :


    thank you,



    ------------------------------
    Valéria Revheim
    ------------------------------



  • 22.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 05, 2020 02:11 PM
    Hi Valeria,

    I am doing my tests in CABI 7.1.1. Maybe in 6.4.2 is different.

    Does a similar .exe exist? Maybe tomcat7w.exe?

    What do you have in bin folder?

    Regards


  • 23.  RE: jasper reports e-mail

    Posted Nov 05, 2020 02:41 PM
    Hello Jose,

    Doesn't have the tomcat7w.exe in this directory.Follow the picture below to help you :


    thank you,


  • 24.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 06, 2020 04:02 AM
    Hi Valeria,

    in that case, we can remove it and create the service again using service.bat script

    Here the example:


    Just after removing the service, edit service.bat and modify the line --StartPath to include the new parameter at the end.

    Remember to undo the changes after the test.

    Regards


  • 25.  RE: jasper reports e-mail

    Posted Nov 06, 2020 10:12 AM
    Hello Jose,

    I did what you asked me,but I didn't find errors or mail-1.4.jar in cabusinessintelligencetomcat-stderr.2020-11-06.Follows the logs below:


    06-Nov-2020 12:59:04.412 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load HOME
    06-Nov-2020 12:59:04.414 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: file C:\Users\Administrator\.mailcap
    06-Nov-2020 12:59:04.415 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/plain;; x-java-content-handler=com.sun.mail.handlers.text_plain
    06-Nov-2020 12:59:04.416 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/plain
    06-Nov-2020 12:59:04.416 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_plain
    06-Nov-2020 12:59:04.416 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/html;; x-java-content-handler=com.sun.mail.handlers.text_html
    06-Nov-2020 12:59:04.416 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/html
    06-Nov-2020 12:59:04.416 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_html
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/xml;; x-java-content-handler=com.sun.mail.handlers.text_xml
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/xml
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_xml
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: multipart/*;; x-java-content-handler=com.sun.mail.handlers.multipart_mixed; x-java-fallback-entry=true
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: multipart/*
    06-Nov-2020 12:59:04.417 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.multipart_mixed
    06-Nov-2020 12:59:04.418 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: message/rfc822;; x-java-content-handler=com.sun.mail.handlers.message_rfc822
    06-Nov-2020 12:59:04.418 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: message/rfc822
    06-Nov-2020 12:59:04.418 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.message_rfc822
    06-Nov-2020 12:59:04.418 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load SYS
    06-Nov-2020 12:59:04.418 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: file E:\CA\JASPER\jre\lib\mailcap
    06-Nov-2020 12:59:04.419 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load JAR
    06-Nov-2020 12:59:04.421 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: !anyLoaded
    06-Nov-2020 12:59:04.421 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: not loading mailcap file: /META-INF/mailcap
    06-Nov-2020 12:59:04.427 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load DEF
    06-Nov-2020 12:59:04.427 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: InputStream
    06-Nov-2020 12:59:04.429 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: image/gif;; x-java-view=com.sun.activation.viewers.ImageViewer
    06-Nov-2020 12:59:04.430 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: image/gif
    06-Nov-2020 12:59:04.430 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.ImageViewer
    06-Nov-2020 12:59:04.430 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: image/jpeg;; x-java-view=com.sun.activation.viewers.ImageViewer
    06-Nov-2020 12:59:04.432 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: image/jpeg
    06-Nov-2020 12:59:04.433 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.ImageViewer
    06-Nov-2020 12:59:04.433 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/*;; x-java-view=com.sun.activation.viewers.TextViewer
    06-Nov-2020 12:59:04.433 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/*
    06-Nov-2020 12:59:04.433 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: view, Class: com.sun.activation.viewers.TextViewer
    06-Nov-2020 12:59:04.433 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/*;; x-java-edit=com.sun.activation.viewers.TextEditor
    06-Nov-2020 12:59:04.434 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/*
    06-Nov-2020 12:59:04.434 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: edit, Class: com.sun.activation.viewers.TextEditor
    06-Nov-2020 12:59:04.434 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Merging commands for type text/*
    06-Nov-2020 12:59:04.434 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: successfully loaded mailcap file: /META-INF/mailcap.default
    06-Nov-2020 12:59:04.435 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load HOME
    06-Nov-2020 12:59:04.435 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: file C:\Users\Administrator\.mailcap
    06-Nov-2020 12:59:04.437 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/plain;; x-java-content-handler=com.sun.mail.handlers.text_plain
    06-Nov-2020 12:59:04.437 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/plain
    06-Nov-2020 12:59:04.437 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_plain
    06-Nov-2020 12:59:04.438 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/html;; x-java-content-handler=com.sun.mail.handlers.text_html
    06-Nov-2020 12:59:04.438 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/html
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_html
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: text/xml;; x-java-content-handler=com.sun.mail.handlers.text_xml
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: text/xml
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.text_xml
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: multipart/*;; x-java-content-handler=com.sun.mail.handlers.multipart_mixed; x-java-fallback-entry=true
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: multipart/*
    06-Nov-2020 12:59:04.439 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.multipart_mixed
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: message/rfc822;; x-java-content-handler=com.sun.mail.handlers.message_rfc822
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: message/rfc822
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: com.sun.mail.handlers.message_rfc822
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load SYS
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: file E:\CA\JASPER\jre\lib\mailcap
    06-Nov-2020 12:59:04.440 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load JAR
    06-Nov-2020 12:59:04.441 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: !anyLoaded
    06-Nov-2020 12:59:04.441 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: not loading mailcap file: /META-INF/mailcap
    06-Nov-2020 12:59:04.442 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load DEF
    06-Nov-2020 12:59:04.444 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: add to PROG
    06-Nov-2020 12:59:04.444 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log new MailcapFile: default
    06-Nov-2020 12:59:04.444 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log appendToMailcap: image/*;;x-java-content-handler=org.apache.cxf.attachment.ImageDataContentHandler
    06-Nov-2020 12:59:04.445 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log parse: image/*;;x-java-content-handler=org.apache.cxf.attachment.ImageDataContentHandler
    06-Nov-2020 12:59:04.446 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Type: image/*
    06-Nov-2020 12:59:04.447 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log Command: content-handler, Class: org.apache.cxf.attachment.ImageDataContentHandler

    I have removed the append line as you told in service.bat.

    thank you


  • 26.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 06, 2020 10:26 AM
    Hi Valeria,

    didn't you find any line (error or not error) matching "mail-1.4.jar" in cabusinessintelligencetomcat-stderr log file?

    Regards



  • 27.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 06, 2020 11:34 AM
    That means the classloader does not find the class and this is the reason for the problem.

    Can you confirm mail-1.4.jar is located in the apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib folder?

    Can you check the permissions of the file?

    Can you share the file?

    Regards


  • 28.  RE: jasper reports e-mail

    Posted Nov 06, 2020 11:57 AM
      |   view attached
    Hello Jose,

    Answering your questions:

    1: Can you confirm mail-1.4.jar is located in the apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib folder?
    yes.

    2.Can you check the permissions of the file?

    Administrators and System have full control and users only read and execute.

    3.Can you share the file?

    Yes.I have attached the file here and I changed the type of file because I couldn't upload the file as .jar.

    thank you


    ------------------------------
    Valéria Revheim
    ------------------------------

    Attachment(s)

    rar
    mail-1.4.rar   360 KB 1 version


  • 29.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 09, 2020 03:09 AM
    Hi Valeria,

    it is clear the root cause of the problem is because classloader does not load the file.

    In my case, when I enable -Djava.security.debug=all in tomcat, I am able to see lines like this in cabusinessintelligencetomcat-stderr log file:

    scl: getPermissions ProtectionDomain (file:/C:/Program%20Files/CA/SC/CA%20Business%20Intelligence/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/mail-1.4.jar <no signer certificates>)
    ParallelWebappClassLoader
    context: jasperserver-pro
    delegate: false
    ----------> Parent Classloader:
    java.net.URLClassLoader@31befd9f

    <no principals>
    java.security.Permissions@1b0ba602 (
    ("java.io.FilePermission" "\C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\mail-1.4.jar" "read")
    )

    Can you repeat the steps and double check that -Djava.security.debug=all is present at the beginning of catalina.out file? You should see a line like this

    05-Nov-2020 16:09:01.682 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.debug=all

    Regards


  • 30.  RE: jasper reports e-mail

    Posted Nov 09, 2020 01:52 PM
    Hello Jose,

    Follows the lines on catalina.out as you asked me:


    09-Nov-2020 16:43:22.325 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.23
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 28 2017 10:30:11 UTC
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.23.0
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows Server 2012
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 6.2
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: E:\CA\JASPER\jre
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0-b132
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: E:\CA\JASPER\apache-tomcat
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: E:\CA\JASPER\apache-tomcat
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=E:\CA\JASPER\apache-tomcat
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=E:\CA\JASPER\apache-tomcat
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=E:\CA\JASPER\apache-tomcat\endorsed
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=E:\CA\JASPER\apache-tomcat\temp
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=E:\CA\JASPER\apache-tomcat\conf\logging.properties
    09-Nov-2020 16:43:22.341 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
    09-Nov-2020 16:43:22.357 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+CMSClassUnloadingEnabled
    09-Nov-2020 16:43:22.357 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djs.license.directory=E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro
    09-Nov-2020 16:43:22.357 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.home=C:\Users\Administrator
    09-Nov-2020 16:43:22.357 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
    09-Nov-2020 16:43:22.357 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [E:\CA\JASPER\apache-tomcat\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;E:\CA\JASPER""\bin;;.]
    09-Nov-2020 16:43:22.685 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
    09-Nov-2020 16:43:22.732 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
    09-Nov-2020 16:43:22.747 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
    09-Nov-2020 16:43:22.747 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
    09-Nov-2020 16:43:22.747 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1740 ms
    09-Nov-2020 16:43:22.810 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
    09-Nov-2020 16:43:22.810 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.23
    09-Nov-2020 16:43:22.935 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [E:\CA\JASPER\apache-tomcat\webapps\CABISync.war]
    09-Nov-2020 16:43:22.935 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [E:\CA\JASPER\apache-tomcat\webapps\SpectrumProxy.war]

    thank you,

    ------------------------------
    Valéria Revheim
    ------------------------------



  • 31.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 10, 2020 05:09 AM
    Hi Valeria,

    I don't see the parameter in the tomcat startup. It seems the change did not properly apply.

    Did you follow the steps?

    1) Stop tomcat

    2) Remove the service

    3) Edit service.bat and modify the line --StartPath to include the new parameter at the end.
    4) Add the service

    5) Start the tomcat

    Regards


  • 32.  RE: jasper reports e-mail

    Posted Nov 10, 2020 08:11 AM
    Hello Jose,

    I've made all steps that you told me and follows the lines in the catalina.out log:


    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.23
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 28 2017 10:30:11 UTC
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.23.0
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows Server 2012
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 6.2
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: E:\CA\JASPER\jre
    10-Nov-2020 10:51:42.610 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0-b132
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: E:\CA\JASPER\apache-tomcat
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: E:\CA\JASPER\apache-tomcat
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=E:\CA\JASPER\apache-tomcat
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=E:\CA\JASPER\apache-tomcat
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=E:\CA\JASPER\apache-tomcat\endorsed
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=E:\CA\JASPER\apache-tomcat\temp
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=E:\CA\JASPER\apache-tomcat\conf\logging.properties
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+CMSClassUnloadingEnabled
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djs.license.directory=E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Duser.home=C:\Users\Administrator
    10-Nov-2020 10:51:42.625 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.debug=all


    thank you

    ------------------------------
    Valéria Revheim
    ------------------------------



  • 33.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 10, 2020 08:15 AM
    Perfect Valeria

    Now, look for mail-1.4.jar entries in cabusinessintelligencetomcat-stderr log file.

    Do you find something like this?

    scl: getPermissions ProtectionDomain (file:/C:/Program%20Files/CA/SC/CA%20Business%20Intelligence/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/mail-1.4.jar <no signer certificates>)
    ParallelWebappClassLoader
    context: jasperserver-pro
    delegate: false
    ----------> Parent Classloader:
    java.net.URLClassLoader@31befd9f

    <no principals>
    java.security.Permissions@1b0ba602 (
    ("java.io.FilePermission" "\C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\mail-1.4.jar" "read")
    )

    Regards




  • 34.  RE: jasper reports e-mail

    Posted Nov 10, 2020 09:40 AM
    Hello Jose,


    Yes, I found any lines like this:


    ----------> Parent Classloader:
    java.net.URLClassLoader@31befd9f

    <no principals>
    java.security.Permissions@169a2178 (
    ("java.io.FilePermission" "\E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\json-20090211.jar" "read")
    )


    scl:
    scl: getPermissions ProtectionDomain (file:/E:/CA/JASPER/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/mail-1.4.jar <no signer certificates>)
    ParallelWebappClassLoader
    context: jasperserver-pro
    delegate: false
    ----------> Parent Classloader:


    ----------> Parent Classloader:
    java.net.URLClassLoader@31befd9f

    <no principals>
    java.security.Permissions@47793aa2 (
    ("java.io.FilePermission" "\E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\mail-1.4.jar" "read")
    )


    scl:
    scl: getPermissions ProtectionDomain (file:/E:/CA/JASPER/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/commons-net-3.3.jar <no signer certificates>)
    ParallelWebappClassLoader
    context: jasperserver-pro
    delegate: false
    ----------> Parent Classloader:

    ----------> Parent Classloader:
    java.net.URLClassLoader@31befd9f

    <no principals>
    java.security.Permissions@108a6fa (
    ("java.io.FilePermission" "\E:\CA\JASPER\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib\json-20090211.jar" "read")
    )


    scl:
    scl: getPermissions ProtectionDomain (file:/E:/CA/JASPER/apache-tomcat/webapps/jasperserver-pro/WEB-INF/lib/mail-1.4.jar <no signer certificates>)
    ParallelWebappClassLoader
    context: jasperserver-pro
    delegate: false
    ----------> Parent Classloader:


    thank you,

    ------------------------------
    Valéria Revheim
    ------------------------------



  • 35.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 11, 2020 07:57 AM
    Hi Valeria,

    I realized about something that called my attention

    In the original error message, the execution was triggered by a quartzScheduler_Worker thread (as expected for scheduled reports). quartzScheduler_Worker-2 thread classloader is the same as jasperserver-pro application classloader (where mail-1.4.jar is loaded from)

    2020-10-23 10:43:19,393 ERROR ReportExecutionJob,quartzScheduler_Worker-2:366 - The job error notification was not completed. An error occurred while sending it.

    In the traces where mailcap file is searched and loaded internally by activation framework, the thread is a http server thread

    06-Nov-2020 12:59:04.419 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: load JAR
    06-Nov-2020 12:59:04.421 FINE [http-nio-8080-exec-7] com.sun.activation.registries.LogSupport.log MailcapCommandMap: !anyLoaded

    The reason why quartzScheduler_Worker-2 thread classloader does not find the mailcap file in mail-1.4.jar is because http-nio-8080-exec-7 thread classloader is different

    My question to you is:

    - how do you reproduce the issue to send the email? Do you create a scheduled report from UI?

    Regards


  • 36.  RE: jasper reports e-mail

    Posted Nov 11, 2020 08:59 AM
    Hello Jose,

    First of all,I scheduled report on Jasper Reports and it worked perfectly,then it suddenly stopped working and the only thing that I remember it has been updated the  java to the lastest version.
    I could use this workaround that you told me without problems?


    thank you,


    ------------------------------
    Valéria Revheim
    ------------------------------



  • 37.  RE: jasper reports e-mail

    Broadcom Employee
    Posted Nov 11, 2020 09:06 AM
    Maybe the update of Java introduced anychange.

    You can use the workaround with no problem. Have it in mind if you upgrade.

    Regards


  • 38.  RE: jasper reports e-mail

    Posted Nov 11, 2020 11:40 AM
    Hello Jose,

    I appreciate your support and attention with this case.

    thank you

    ------------------------------
    Valéria Revheim
    ------------------------------