[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 
SpagoBI scheduler mails are not triggering for reports  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
pavan91.spw



Joined: 23/11/2017 07:30:06
Messages: 1
Offline

Hi,

I am new to SpagoBI.

I am trying to schedule the reports using spagobi 5.2 server.

I have gone through the document and made configuration for scheduler Smtp Host, scheduler Smtp port, scheduler from, scheduler user, scheduler Password under "Configuartion Management -> mails ".

I am facing 2 issues under this.
1. Unable to get the newly created reports while configuring schedule.
2. Chosen existing report and configured the scheduler, mails are not triggering.

Error ::

scheduler error log:

it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.getTriggerInfo: Error while getting detail of the schedule(trigger)
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Trigger with name [TestScheduler_11731] not found in group [DEFAULT]
at it.eng.spagobi.services.scheduler.service.XSchedulerServiceSupplier.getJobSchedulationDefinition(XSchedulerServiceSupplier.java:129)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.getTriggerInfo(SchedulerService.java:566)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.executeTrigger(SchedulerService.java:347)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:72
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:11
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.executeTrigger: Error while create immediate trigger
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while getting detail of the schedule(trigger)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.getTriggerInfo(SchedulerService.java:583)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.executeTrigger(SchedulerService.java:347)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:72
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:11
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Trigger with name [TestScheduler_11731] not found in group [DEFAULT]
at it.eng.spagobi.services.scheduler.service.XSchedulerServiceSupplier.getJobSchedulationDefinition(XSchedulerServiceSupplier.java:129)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.getTriggerInfo(SchedulerService.java:566)
... 34 more

mail error log :

Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Trigger with name [TestScheduler_11731] not found in group [DEFAULT]
at it.eng.spagobi.services.scheduler.service.XSchedulerServiceSupplier.getJobSchedulationDefinition(XSchedulerServiceSupplier.java:129)
at it.eng.spagobi.tools.scheduler.services.rest.SchedulerService.getTriggerInfo(SchedulerService.java:566)
... 34 more
it.eng.spagobi.engines.drivers.generic.GenericDriver.getMap: Error while recovering execution parameter map:
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while getting user's information
it.eng.spagobi.tools.scheduler.dispatcher.MailDocumentDispatchChannel.dispatch: Error while sending schedule result mail
com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. a81sm16662690pfj.143 - gsmtp

at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:210
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1609)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:1117)
at javax.mail.Transport.send0(Transport.java:254)
at javax.mail.Transport.send(Transport.java:124)
at it.eng.spagobi.tools.scheduler.dispatcher.MailDocumentDispatchChannel.dispatch(MailDocumentDispatchChannel.java:26
at it.eng.spagobi.tools.scheduler.dispatcher.DocumentDispatcher.dispatch(DocumentDispatcher.java:79)
at it.eng.spagobi.tools.scheduler.jobs.XExecuteBIDocumentJob.executeInternal(XExecuteBIDocumentJob.java:45
at it.eng.spagobi.tools.scheduler.jobs.XExecuteBIDocumentJob.execute(XExecuteBIDocumentJob.java:73)
at it.eng.spagobi.tools.scheduler.jobs.ExecuteBIDocumentJob.execute(ExecuteBIDocumentJob.java:29)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

Please help me out to find the solution. Thanks
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team