#1 2016-03-01 18:04:05

vipul
Member
Registered: 2016-03-01

Scheduled report not accesible

Hi.

I have scheduled a report and can see its been completed successfully {in scheduled tab}

but when i am trying to access that report i am getting below error. can you please let me know why i am not able to access this?

29-Feb-2016 13:39:55.755 SEVERE [http-nio-8080-exec-11] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [default] in context with path [/reportserver] threw exception
java.lang.NullPointerException
        at net.datenwerke.rs.scheduleasfile.server.scheduleasfile.ExportScheduledAsFileReportServlet.doGet(ExportScheduledAsFileReportServlet.java:88)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
        at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
        at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
        at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
        at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
        at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
        at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
        at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
        at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

Thanks
Vipul Ostwal

Offline

#2 2016-03-01 18:23:44

tomharney
Member
Registered: 2014-03-11

Re: Scheduled report not accesible

Vipul,

I'm not certain but this line in your error log leads me to believe it's some kind of permissions problem:

at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)

If you login as root, are you able to access it then?   That is a superuser and should have permissions to virtually everything.

Offline

#3 2016-03-01 18:27:32

vipul
Member
Registered: 2016-03-01

Re: Scheduled report not accesible

Thanks Tom for replying.
I tried that one also but still same error.

logged in as root and try to access the file but same error.

Thanks
Vipul

Offline

#4 2016-03-02 20:56:55

Thorsten J. Krause
Guest

Re: Scheduled report not accesible

Hi Vipul,

my guess is that something went wrong with executing the report despite the success message. The error message indicates that the report was empty when we tried to determine the correct content type.

Can you give me some more details on what you were doing, so I can try to reproduce this here?

Thanks,
Thorsten

#5 2016-03-04 15:59:35

vipul
Member
Registered: 2016-03-01

Re: Scheduled report not accesible

Thanks Thorsten  for reply.

I have a report whose output is around 132K rows . When it ran from scheduled reports i see below error {but it seems as my mail is not setup that why its coming} but when same view i ran manually i can see all rows coming correctly then i exported it {20MB csv} file.  but problem with scheduled report is still there.

04-Mar-2016 15:39:01.279 WARNING [pool-DwAsyncService-1-thread-2] net.datenwerke.rs.core.service.mail.SimpleMail.setFrom Illegal address
javax.mail.internet.AddressException: Illegal address in string ``''
    at javax.mail.internet.InternetAddress.<init>(InternetAddress.java:114)
    at net.datenwerke.rs.core.service.mail.SimpleMail.setFrom(SimpleMail.java:47)
    at net.datenwerke.rs.core.service.mail.SimpleMail.<init>(SimpleMail.java:42)
    at net.datenwerke.rs.core.service.mail.SimpleCryptoMail.<init>(SimpleCryptoMail.java:66)
    at net.datenwerke.rs.core.service.mail.SimpleCryptoMail$$FastClassByGuice$$1b264aa7.newInstance(<generated>)
    at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
    at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60)
    at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
    at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
    at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
    at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
    at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.newSimpleMail(MailServiceImpl.java:94)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.newTemplateMail(MailServiceImpl.java:99)
    at net.datenwerke.rs.scheduleasfile.service.scheduleasfile.hooker.ScheduleAsFileEmailNotificationHooker.sendmail(ScheduleAsFileEmailNotificationHooker.java:144)
    at net.datenwerke.rs.scheduleasfile.service.scheduleasfile.hooker.ScheduleAsFileEmailNotificationHooker.actionExecutionEndedSuccessfully(ScheduleAsFileEmailNotificationHooker.java:100)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:461)
    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)

04-Mar-2016 15:39:01.283 WARNING [pool-5-thread-1] net.datenwerke.rs.core.service.mail.SimpleMail.setFrom Illegal address
javax.mail.internet.AddressException: Illegal address in string ``''
    at javax.mail.internet.InternetAddress.<init>(InternetAddress.java:114)
    at net.datenwerke.rs.core.service.mail.SimpleMail.setFrom(SimpleMail.java:47)
    at net.datenwerke.rs.core.service.mail.SimpleMail.<init>(SimpleMail.java:42)
    at net.datenwerke.rs.core.service.mail.SimpleMail$$FastClassByGuice$$98f8586.newInstance(<generated>)
    at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
    at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60)
    at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
    at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
    at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
    at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
    at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:168)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl$1.run(MailServiceImpl.java:267)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

04-Mar-2016 15:39:01.286 WARNING [pool-5-thread-1] net.datenwerke.rs.core.service.mail.MailServiceImpl$1.run Mail could not be send
net.datenwerke.rs.core.service.mail.exceptions.MailerRuntimeException: Mail could not be send
    at net.datenwerke.rs.core.service.mail.MailServiceImpl$MailSupervisorImpl.handleException(MailServiceImpl.java:59)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:244)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl$1.run(MailServiceImpl.java:267)
    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: java.lang.NullPointerException
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:176)
    ... 4 more

Thanks

Offline

#6 2016-03-06 13:45:44

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Scheduled report not accesible

Hi Vipul,

it looks like the sender address is not properly configured. Could you post yourmail.cf configuration?

Cheers,
Arno

Offline

Board footer

Powered by FluxBB