Failed to send report via email

SridharManala · August 11, 2016, 5:49am

Hi,

I started using ReportServer. I did auto installation of report server community model.

Now iam facing issue in sending report via email.
Can any one help on this ? Below error messages for youe ref,.

Could not export report via mail: Guice provision errors:

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but parameter 2 of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.() is not @Nullable
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for parameter 2 at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:66)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail

1 error

Arno_Mittelbach · August 11, 2016, 7:06am

Hello Sridhar,

welcome to the forum.

My best guess is that you do not have the mail configuration file properly set up. The configuration is done in the internal file system in file /fileserver/etc/mail/mail.cf. Have a look at https://reportserver.net/en/guides/config/chapters/Setting-up-the-Scheduler/#Mail-Server-Configuration for further information. A basic set up of the config should look as follows:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <smtp>
      <host>mail.datenwerke.net</host>
      <port>25</port>
      <username>SOME_USER</username>
      <password>SOME_PASSWORD</password>
      <ssl>false</ssl>
      <tls>
         <enable>false</enable>
         <require>false</require>
      </tls>
   </smtp>
   <mail>
      <sender>SOME_SENDER@EXAMPLE.COM</sender>
      <forceSender>false</forceSender>
      <encryptionPolicy>allow_mixed</encryptionPolicy>
   </mail>
</configuration>

Apparently ReportServer cannot find the configuration.

Best Regards,
Arno

SridharManala · August 11, 2016, 7:38am

Hi Arno,

Thanyou for quick response, As you mentioned I have already configured the Mail settings through ReportServer/Administration/FlieSystem/etc/mail/mail.cf.

After this configuration done, I am facing this issue.

Below is the detailed log

11-Aug-2016 10:39:06.716 WARNING [pool-DwAsyncService-1-thread-1] net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions action execution failed
com.google.inject.ProvisionException: Guice provision errors:

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but parameter 2 of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.() is not @Nullable
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for parameter 2 at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:66)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail

1 error
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newSimpleMail(MailServiceImpl.java:93)
at net.datenwerke.rs.scheduler.service.scheduler.mail.SchedulerMailHelper.prepareSimpleMail(SchedulerMailHelper.java:59)
at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction.doExecute(MailReportAction.java:98)
at net.datenwerke.scheduler.service.scheduler.entities.AbstractAction.execute(AbstractAction.java:59)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeAction(SchedulerTask.java:495)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:385)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:209)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

11-Aug-2016 10:39:07.599 WARNING [pool-DwAsyncService-1-thread-1] net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.executionEndedAbnormally scheduler notification error
com.google.inject.ProvisionException: Guice provision errors:

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but parameter 2 of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.() is not @Nullable
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for parameter 2 at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:66)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail

1 error
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newSimpleMail(MailServiceImpl.java:93)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newTemplateMail(MailServiceImpl.java:98)
at net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.sendMessage(SchedulerNotificationHooker.java:294)
at net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.executionEndedAbnormally(SchedulerNotificationHooker.java:149)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:293)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Many Thanks !!!
Sridhar Manala

Arno_Mittelbach · August 11, 2016, 7:40am

Hi Sridhar,

did you run

config reload

on the terminal (you can open the terminal with CTRL+ALT+T).

Regards,
Arno

SridharManala · August 11, 2016, 7:52am

Hi Arno,

Yes just now i did that but no luck still tha same error.

Even I restarted the servers Still same error.

com.google.inject.ProvisionException: Guice provision errors:

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but parameter 2 of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.() is not @Nullable
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for parameter 2 at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:66)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail

1 error
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newSimpleMail(MailServiceImpl.java:93)
at net.datenwerke.rs.scheduler.service.scheduler.mail.SchedulerMailHelper.prepareSimpleMail(SchedulerMailHelper.java:59)
at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction.doExecute(MailReportAction.java:98)
at net.datenwerke.scheduler.service.scheduler.entities.AbstractAction.execute(AbstractAction.java:59)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeAction(SchedulerTask.java:495)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:385)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:209)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Regards
Sridhar Manala

Arno_Mittelbach · August 11, 2016, 8:05am

Could you post your configuration?

SridharManala · August 11, 2016, 8:10am

Hi Arno,

Please find the below configuration for SMTP

<?xml version="1.0" encoding="UTF-8"?> 10.241.8.15 25 paxplusadmin@omanair.com ********* false false false paxplusadmin@omanair.com false allow_mixed

Please find the below responses from terminal server

reportserver$ ls
datasources tsreport
reportmanager usermanager
dadgetlib
fileserver

reportserver$ config reload
Configuration reloaded
reportserver$

Arno_Mittelbach · August 11, 2016, 8:18am

Could you run

ls -l /fileserver/etc/mail/

on the terminal and post the result?

The configuration looks fine, but for some reason RS is not picking it up..

Arno

SridharManala · August 11, 2016, 8:27am

Hi Arno,

Please find below response from terminal server for the above command.

reportserver$ ls -l /fileserver/etc/mail/
2567 mail.cf FileServerFile
reportserver$

Then again i tried still the same.

Regards
Sridhar Manala

Arno_Mittelbach · August 11, 2016, 8:38am

One more idea .. does your password by any chance have any special characters such as < or >. Could you try wrapping the password in a CDATA section such as

<password><![CDATA[PASSWORD_WITH_SPECIAL_CHARACTERS<>]]></password>

SridharManala · August 11, 2016, 8:46am

password is alphanumaric no special caherecters.

and evan i tried with above option still the same

Many thanks!!!
Sridhar Manala

Arno_Mittelbach · August 11, 2016, 8:59am

I am at a loss .. could you post the entire log file?

SridharManala · August 11, 2016, 9:46am

Hi Arno,

11-Aug-2016 12:57:12.221 WARNING [pool-DwAsyncService-1-thread-1] net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.executionEndedAbnormally scheduler notification error
com.google.inject.ProvisionException: Guice provision errors:

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but parameter 2 of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.() is not @Nullable
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for parameter 2 at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:66)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail

1 error
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:987)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newSimpleMail(MailServiceImpl.java:93)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.newTemplateMail(MailServiceImpl.java:98)
at net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.sendMessage(SchedulerNotificationHooker.java:294)
at net.datenwerke.rs.incubator.service.schedulernotification.SchedulerNotificationHooker.executionEndedAbnormally(SchedulerNotificationHooker.java:149)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:293)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Arno_Mittelbach · August 11, 2016, 10:30am

Hi Sridhar,

I would need the complete log file to see whether there is anything pointing to the problem. If you don’t want to paste it here, you could also send it to info@datenwerke.net.

Arno

SridharManala · August 14, 2016, 5:05am

Hi Arno,

Thanks for your support, Now its working fine to me.
I did reinstall the RS, then everything is working fine to me.

Further, I have one more query
I have imported all my existing birt reports to RS. But the issue is we are maintain separate Style sheet and reportlibrary file for those reports.

How we can add those styles and rptlib file to RS and where exactly we cann add ?

Many thanks!
Sridhar Manala

Arno_Mittelbach · August 16, 2016, 10:24am

This is good to hear. As for birt libraries and resources, they go into a folder in the internal filesystem. You then need to ensure that ReportServer knows about this folder by specifying it in the /etc/reportengines/reportengines.cf config file. (Instead of the ID you can also provide a path.

Cheers,
Arno

mirza · June 30, 2021, 9:52am

Hi,

I have installed ReportServer 3.7.0 and after installation, I’m trying to configure email configuration using email datasink, but can’t test email configuration below is same log above

I have reinstall so many time RS but issue can’t resolve

null returned by binding at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom()
but the 3rd parameter of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:70) is not @Nullable
at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom(MailModule.java:186)
at net.datenwerke.rs.core.service.mail.MailModule.provideDefaultFrom(MailModule.java:186)
while locating java.lang.String annotated with @net.datenwerke.rs.core.service.mail.annotations.MailModuleDefaultFrom()
for the 3rd parameter of net.datenwerke.rs.core.service.mail.SimpleCryptoMail.(SimpleCryptoMail.java:70)
while locating net.datenwerke.rs.core.service.mail.SimpleCryptoMail annotated with @com.google.inject.internal.UniqueAnnotations$Internal(value=1)

1 error
at net.datenwerke.rs.emaildatasink.server.emaildatasink.EmailDatasinkRpcServiceImpl.testEmailDatasink(EmailDatasinkRpcServiceImpl.java:151)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.google.inject.ProvisionException: Unable to provision, see the following errors:

mirza · July 7, 2021, 11:00am

Hi team,

I would like to inform you that my subject issue has been resolved by few lines of changing in default mail.cf file on RS Version: 3.7.0, I have just removed comments lines from this file as well as and tags moved downward after tag. then after this changing my SMTP configuration work fine and received a mail on the mail server successfully.

<?xml version="1.0" encoding="UTF-8"?> 192.168.0.177 25 false false false noreply@mydomain.com noreply123 noreply@mydomain.com ReportServer false allow_mixed

jalbrecht · July 8, 2021, 12:13pm

Dear mirza,

thank you for sharing your solution.

wbr jan