• E
    etantonio

    Thanks,
    I've learned something more but maybe it is not enough,
    my problem is that in Mango 2.8.4 is not available the start rollup,
    and that I need to write in the daily excel report some datapoints where it is used "Log when change".
    There'a a way to achieve this using Mango 2.8.4?
    Maybe rollup accumulator could be the right solution but with the following configuration I've no data:

    0_1542809351702_7862449b-d15f-4bf9-bd37-c98f9103d426-Screenshot - 21_11_2018 , 15.02.04.png

    Thanks,
    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    Hy,
    I know how to populate an excel report with a set of values relating to a variable,
    but it is not clear to me how to add just a single value coming from a static mango datapoint used as parameter, for example I need to insert in cell AZ15 the value of datapoint "DegreesForPixel" having value 0.037 .
    Thanks,
    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    @phildunlap said in NullPointer exception but info not available:

    AnnotatedPointValueTime

    Thanks,
    it seems now it is ok,
    it is necessary to add also the new interface IAnnotated.class.
    Thanks,
    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    Thanks for your answer,
    I would want if possible to test it before to buy a license also for latest Mango.
    Actually we are using h2 and testing mysql, I'm interested to test no-sql and I think could be better to start from mango v3.x.x

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    Hy,
    I would want to try migration of a project from Mango 2.8.4 to latest Mango version,
    which way is the best for such migration:

    1. using Mango upgrade functionality
    2. starting directly from latest Mango and import all data sources
    3. I don't if it works to insert old mah2.h2.db into latest Mango

    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    You are right, "e" gives the full stack trace, it is in sterr and is the following, but it seems there's no info about the point having problem, maybe just in debug I could find it.
    Any suggestion is appreciated

    ERROR 2018-11-14 09:02:10,758 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException
            at com.serotonin.m2m2.rt.dataImage.AnnotatedPointValueTime.getAnnotation(AnnotatedPointValueTime.java:39)
            at com.serotonin.m2m2.web.mvc.rest.v1.model.pointValue.PointValueTimeModel.<init>(PointValueTimeModel.java:67)
            at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated(PointValueWebSocketPublisher.java:172)
            at com.serotonin.m2m2.rt.dataImage.DataPointRT$EventNotifyWorkItem.execute(DataPointRT.java:632)
            at com.serotonin.m2m2.rt.maint.BackgroundProcessing$1.run(BackgroundProcessing.java:73)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
            at java.lang.Thread.run(Thread.java:745)
    

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    Hy,
    thanks for your reply,
    I think that e.getMessage() in

    catch (Exception e) {
    			LOG.error(e.getMessage(),e);
    		}
    

    gives only the short description of the exception, not the full stack trace
    in fact in the log I've only a long sequence of :

    ERROR 2018-11-13 14:37:17,874 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException
    ERROR 2018-11-13 14:37:27,887 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException
    ERROR 2018-11-13 14:37:37,871 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException
    ERROR 2018-11-13 14:37:47,886 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException
    

    it seems I've no way to understand which point is envolved.

    In which case the class PointValueWebSocketPublisher.java
    is invoked?

    It is not clear to me if all source code of Mango automation are available on git or just something and if there's a chance for me to debug the code directly on my machine using an eclipse JEE Ide?

    Thanks,
    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    Hy,
    i migrated an H2 database to mysql,
    there's this error about every 10 seconds:

    ERROR 2018-11-12 14:49:38,838 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:179) -
    java.lang.NullPointerException

    How I can understand where's the problem?
    Thanks,

    Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    At the end tuning datapoints purge I'm arrived to a reasonable size for H2 database, about 1.5GB, now I'm testing the mysql porting of this database. I've 2 troubles:

    1. backupMysqlWithOutDatabase:442) - java.io.IOException: Cannot run program "mysqldump"

    the mysql setting on env.properties is the following:

    # MySQL database settings. Your MySQL instance must already be running and configured before this can be used.
    db.type=mysql
    db.url=jdbc:mysql://127.0.0.1:3306/mango
    db.username=solergy
    db.password=secret
    db.mysqldump=
    db.mysql=
    

    what is required in "db.mysqldump" and "db.mysql" fileds?

    1. When using excel reports purge I've the following exception

    0_1541496296046_46cd4e6c-ef45-4f41-8fe0-21b09d0e54b8-immagine.png

    what's the problem and how to solve it?

    WARN  2018-11-06 10:23:35,344 (com.infiniteautomation.mango.web.mvc.rest.v1.exce
    lreports.ExcelReportRestController.purge:547) -
    java.lang.NullPointerException
            at java.io.File.<init>(Unknown Source)
            at com.infiniteautomation.mango.excelreports.ExcelReportsCommon.getRepor
    t(ExcelReportsCommon.java:172)
            at com.infiniteautomation.mango.excelreports.dao.ExcelReportDao.purgeRep
    ortsBefore(ExcelReportDao.java:190)
            at com.infiniteautomation.mango.web.mvc.rest.v1.excelreports.ExcelReport
    RestController.purge(ExcelReportRestController.java:543)
            at com.infiniteautomation.mango.web.mvc.rest.v1.excelreports.ExcelReport
    RestController.purgeUsingSettings(ExcelReportRestController.java:509)
            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.springframework.web.method.support.InvocableHandlerMethod.doInvok
    e(InvocableHandlerMethod.java:221)
            at org.springframework.web.method.support.InvocableHandlerMethod.invokeF
    orRequest(InvocableHandlerMethod.java:137)
            at org.springframework.web.servlet.mvc.method.annotation.ServletInvocabl
    eHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
            at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
    andlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
            at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
    andlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
            at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapt
    er.handle(AbstractHandlerMethodAdapter.java:85)
            at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
    erServlet.java:959)
            at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
    rServlet.java:893)
            at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
    workServlet.java:970)
            at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkSe
    rvlet.java:894)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:713)
            at org.springframework.web.servlet.FrameworkServlet.service(FrameworkSer
    vlet.java:846)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808
    )
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
    Handler.java:1669)
            at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.j
    ava:83)
            at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:300)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
    Handler.java:1652)
            at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
    al(CharacterEncodingFilter.java:85)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
    Handler.java:1652)
            at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterIntern
    al(ShallowEtagHeaderFilter.java:87)
            at com.serotonin.m2m2.web.filter.MangoShallowEtagHeaderFilter.doFilterIn
    ternal(MangoShallowEtagHeaderFilter.java:47)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
    Handler.java:1652)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:317)
            at org.springframework.security.web.access.intercept.FilterSecurityInter
    ceptor.invoke(FilterSecurityInterceptor.java:127)
            at org.springframework.security.web.access.intercept.FilterSecurityInter
    ceptor.doFilter(FilterSecurityInterceptor.java:91)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.access.ExceptionTranslationFilter.do
    Filter(ExceptionTranslationFilter.java:115)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.session.SessionManagementFilter.doFi
    lter(SessionManagementFilter.java:137)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.authentication.AnonymousAuthenticati
    onFilter.doFilter(AnonymousAuthenticationFilter.java:111)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.servletapi.SecurityContextHolderAwar
    eRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.savedrequest.RequestCacheAwareFilter
    .doFilter(RequestCacheAwareFilter.java:63)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.authentication.logout.LogoutFilter.d
    oFilter(LogoutFilter.java:121)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at com.serotonin.m2m2.web.mvc.spring.security.CsrfHeaderFilter.doFilterI
    nternal(CsrfHeaderFilter.java:41)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(Csr
    fFilter.java:124)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.header.HeaderWriterFilter.doFilterIn
    ternal(HeaderWriterFilter.java:66)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.context.SecurityContextPersistenceFi
    lter.doFilter(SecurityContextPersistenceFilter.java:105)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.context.request.async.WebAsyncManage
    rIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
            at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
    equestFilter.java:107)
            at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
    doFilter(FilterChainProxy.java:331)
            at org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
    lterChainProxy.java:214)
            at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
    nProxy.java:177)
            at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
    elegatingFilterProxy.java:346)
            at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
    ingFilterProxy.java:262)
            at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
    Handler.java:1652)
            at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
    :585)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
    ava:143)
            at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
    a:577)
            at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
    er.java:223)
            at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
    er.java:1127)
            at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
    515)
            at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
    r.java:185)
            at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
    r.java:1061)
            at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
    ava:141)
            at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Cont
    extHandlerCollection.java:215)
            at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
    .java:97)
            at org.eclipse.jetty.server.Server.handle(Server.java:499)
            at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
            at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.jav
    a:257)
            at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java
    :540)
            at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
    l.java:635)
            at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
    .java:555)
            at java.lang.Thread.run(Unknown Source)
    
    

    Thanks, Antonio

    posted in Mango Automation general Discussion read more
  • E
    etantonio

    @phildunlap sorry, I'm working on several pc and this question was related to another post

    https://forum.infiniteautomation.com/topic/3795/sum-each-minute-of-parameter-each-second-value

    I don't know maybe my distraction or a cross-session problem. Thanks, Antonio

    posted in Mango Automation general Discussion read more