Excel Report created but not visible

[etantonio]

Hy,
this night an excel report was automatically created,
this is the reference:

but when I require to see the report I've a bad result, an empty page

I've no error during excel report template validation.

The report is not created in the excel report destination folder.

Yesterday the same report was created.

How I can solve this problems? These report are really important for our customer.

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
Caused by: java.lang.NullPointerException
	at java.io.File.<init>(Unknown Source)
	at com.infiniteautomation.mango.excelreports.ExcelReportsCommon.getReport(ExcelReportsCommon.java:172)
	at com.infiniteautomation.mango.web.mvc.rest.v1.excelreports.ExcelReportRestController.viewReportFile(ExcelReportRestController.java:332)

REQUEST HEADERS
   Cookie=splitContainer_0=365; splitContainer_1=965; MANGO8888=1kflmho4mbaosf2qa7156jvp4; XSRF-TOKEN=2cda084f-956f-4624-b573-e11ba022585b
   Accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
   Upgrade-Insecure-Requests=1
   User-Agent=Mozilla/5.0 (Windows NT 6.1; rv:52.0) Gecko/20100101 Firefox/52.0
   Referer=http://localhost:8888/excel-reports.shtm?template=1
   Connection=keep-alive
   Host=localhost:8888
   Accept-Language=it-IT,it;q=0.8,en-US;q=0.5,en;q=0.3
   Accept-Encoding=gzip, deflate


REQUEST ATTRIBUTES
   javax.servlet.forward.context_path=
   org.springframework.web.servlet.View.pathVariables={xid=XLR_724056}
   org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER=org.springframework.web.context.request.async.WebAsyncManager@d8798e
   javax.servlet.error.status_code=500
   javax.servlet.forward.servlet_path=/rest
   org.springframework.web.servlet.DispatcherServlet.CONTEXT=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Thu Jul 26 09:29:35 CEST 2018]; parent: Root WebApplicationContext
   javax.servlet.jsp.jstl.fmt.localizationContext.request=org.springframework.web.servlet.support.JstlUtils$SpringLocalizationContext@572343
   org.springframework.web.servlet.resource.ResourceUrlProvider=org.springframework.web.servlet.resource.ResourceUrlProvider@17ede17
   org.eclipse.jetty.server.error_page=/exception/error.jsp
   __spring_security_session_mgmt_filter_applied=true
   org.springframework.web.servlet.DispatcherServlet.LOCALE_RESOLVER=org.springframework.web.servlet.i18n.SessionLocaleResolver@12ffe9c
   org.springframework.web.servlet.HandlerMapping.bestMatchingPattern=/v1/excel-reports/view/{xid}
   org.springframework.web.servlet.DispatcherServlet.OUTPUT_FLASH_MAP=FlashMap [attributes={}, targetRequestPath=null, targetRequestParams={}]
   javax.servlet.error.exception_type=class org.springframework.web.util.NestedServletException
   org.springframework.web.servlet.DispatcherServlet.FLASH_MAP_MANAGER=org.springframework.web.servlet.support.SessionFlashMapManager@1a3aa23
   org.springframework.core.convert.ConversionService=ConversionService converters =
	@org.springframework.format.annotation.DateTimeFormat java.lang.Long -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,@org.springframework.format.annotation.NumberFormat java.lang.Long -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.DateTimeFormat java.time.LocalDate -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.LocalDate -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@1446d7c
	@org.springframework.format.annotation.DateTimeFormat java.time.LocalDateTime -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.LocalDateTime -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@4983c
	@org.springframework.format.annotation.DateTimeFormat java.time.LocalTime -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.LocalTime -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@41c3d4
	@org.springframework.format.annotation.DateTimeFormat java.time.OffsetDateTime -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.OffsetDateTime -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@db4f32
	@org.springframework.format.annotation.DateTimeFormat java.time.OffsetTime -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.OffsetTime -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@1090f58
	@org.springframework.format.annotation.DateTimeFormat java.time.ZonedDateTime -> java.lang.String: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.time.ZonedDateTime -> java.lang.String : org.springframework.format.datetime.standard.TemporalAccessorPrinter@1604857
	@org.springframework.format.annotation.DateTimeFormat java.util.Calendar -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8
	@org.springframework.format.annotation.DateTimeFormat java.util.Date -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8
	@org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalDate -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,org.joda.time.LocalDate -> java.lang.String : org.springframework.format.datetime.joda.ReadablePartialPrinter@1e102e3
	@org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalDateTime -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,org.joda.time.LocalDateTime -> java.lang.String : org.springframework.format.datetime.joda.ReadablePartialPrinter@ac17df
	@org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalTime -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,org.joda.time.LocalTime -> java.lang.String : org.springframework.format.datetime.joda.ReadablePartialPrinter@2d719
	@org.springframework.format.annotation.DateTimeFormat org.joda.time.ReadableInstant -> java.lang.String: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,org.joda.time.ReadableInstant -> java.lang.String : org.springframework.format.datetime.joda.ReadableInstantPrinter@994df0
	@org.springframework.format.annotation.NumberFormat java.lang.Byte -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.lang.Double -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.lang.Float -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.lang.Integer -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.lang.Short -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.math.BigDecimal -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	@org.springframework.format.annotation.NumberFormat java.math.BigInteger -> java.lang.String: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.Boolean -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@1fc70fe
	java.lang.Character -> java.lang.Number : org.springframework.core.convert.support.CharacterToNumberFactory@c37b37
	java.lang.Character -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@a33e67
	java.lang.Enum -> java.lang.String : org.springframework.core.convert.support.EnumToStringConverter@761d91
	java.lang.Long -> java.time.Instant : org.springframework.format.datetime.standard.DateTimeConverters$LongToInstantConverter@17f65d3
	java.lang.Long -> java.util.Calendar : org.springframework.format.datetime.DateFormatterRegistrar$LongToCalendarConverter@11945ed,java.lang.Long -> java.util.Calendar : org.springframework.format.datetime.DateFormatterRegistrar$LongToCalendarConverter@1072b58
	java.lang.Long -> java.util.Date : org.springframework.format.datetime.DateFormatterRegistrar$LongToDateConverter@197d2d2,java.lang.Long -> java.util.Date : org.springframework.format.datetime.DateFormatterRegistrar$LongToDateConverter@1d6ecda
	java.lang.Long -> org.joda.time.ReadableInstant : org.springframework.format.datetime.joda.JodaTimeConverters$LongToReadableInstantConverter@270c1f
	java.lang.Number -> java.lang.Character : org.springframework.core.convert.support.NumberToCharacterConverter@d648ae
	java.lang.Number -> java.lang.Number : org.springframework.core.convert.support.NumberToNumberConverterFactory@13f4196
	java.lang.Number -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@115b546
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.lang.Long: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Long: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.LocalDate: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.LocalDate: org.springframework.format.datetime.standard.TemporalAccessorParser@167d27a
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.LocalDateTime: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.LocalDateTime: org.springframework.format.datetime.standard.TemporalAccessorParser@1257cc4
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.LocalTime: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.LocalTime: org.springframework.format.datetime.standard.TemporalAccessorParser@913f1f
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.OffsetDateTime: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.OffsetDateTime: org.springframework.format.datetime.standard.TemporalAccessorParser@72d931
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.OffsetTime: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.OffsetTime: org.springframework.format.datetime.standard.TemporalAccessorParser@4334af
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.time.ZonedDateTime: org.springframework.format.datetime.standard.Jsr310DateTimeFormatAnnotationFormatterFactory@188ac57,java.lang.String -> java.time.ZonedDateTime: org.springframework.format.datetime.standard.TemporalAccessorParser@aeede3
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.util.Calendar: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat java.util.Date: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalDate: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,java.lang.String -> org.joda.time.LocalDate: org.springframework.format.datetime.joda.LocalDateParser@16ab2f4
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalDateTime: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,java.lang.String -> org.joda.time.LocalDateTime: org.springframework.format.datetime.joda.LocalDateTimeParser@d7fd6c
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat org.joda.time.LocalTime: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,java.lang.String -> org.joda.time.LocalTime: org.springframework.format.datetime.joda.LocalTimeParser@14dfc8f
	java.lang.String -> @org.springframework.format.annotation.DateTimeFormat org.joda.time.ReadableInstant: org.springframework.format.datetime.joda.JodaDateTimeFormatAnnotationFormatterFactory@8b0bc8,java.lang.String -> org.joda.time.ReadableInstant: org.springframework.format.datetime.joda.DateTimeParser@626be8
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Byte: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Double: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Float: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Integer: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.lang.Short: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.math.BigDecimal: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> @org.springframework.format.annotation.NumberFormat java.math.BigInteger: org.springframework.format.number.NumberFormatAnnotationFormatterFactory@1c34825
	java.lang.String -> java.lang.Boolean : org.springframework.core.convert.support.StringToBooleanConverter@c53a47
	java.lang.String -> java.lang.Character : org.springframework.core.convert.support.StringToCharacterConverter@1a9f535
	java.lang.String -> java.lang.Enum : org.springframework.core.convert.support.StringToEnumConverterFactory@197ca97
	java.lang.String -> java.lang.Number : org.springframework.core.convert.support.StringToNumberConverterFactory@17067ea
	java.lang.String -> java.nio.charset.Charset : org.springframework.core.convert.support.StringToCharsetConverter@b35e43
	java.lang.String -> java.time.Instant: org.springframework.format.datetime.standard.InstantFormatter@7757ca
	java.lang.String -> java.util.Currency : org.springframework.core.convert.support.StringToCurrencyConverter@142fb40
	java.lang.String -> java.util.Locale : org.springframework.core.convert.support.StringToLocaleConverter@1ae195a
	java.lang.String -> java.util.Properties : org.springframework.core.convert.support.StringToPropertiesConverter@1746977
	java.lang.String -> java.util.TimeZone : org.springframework.core.convert.support.StringToTimeZoneConverter@e62415
	java.lang.String -> java.util.UUID : org.springframework.core.convert.support.StringToUUIDConverter@11bb899
	java.nio.charset.Charset -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@154d91
	java.time.Instant -> java.lang.Long : org.springframework.format.datetime.standard.DateTimeConverters$InstantToLongConverter@b16d17
	java.time.Instant -> java.lang.String : org.springframework.format.datetime.standard.InstantFormatter@7757ca
	java.time.LocalDateTime -> java.time.LocalDate : org.springframework.format.datetime.standard.DateTimeConverters$LocalDateTimeToLocalDateConverter@3969e8
	java.time.LocalDateTime -> java.time.LocalTime : org.springframework.format.datetime.standard.DateTimeConverters$LocalDateTimeToLocalTimeConverter@efe3c9
	java.time.OffsetDateTime -> java.time.Instant : org.springframework.format.datetime.standard.DateTimeConverters$OffsetDateTimeToInstantConverter@f69c99
	java.time.OffsetDateTime -> java.time.LocalDate : org.springframework.format.datetime.standard.DateTimeConverters$OffsetDateTimeToLocalDateConverter@34349c
	java.time.OffsetDateTime -> java.time.LocalDateTime : org.springframework.format.datetime.standard.DateTimeConverters$OffsetDateTimeToLocalDateTimeConverter@182d16d
	java.time.OffsetDateTime -> java.time.LocalTime : org.springframework.format.datetime.standard.DateTimeConverters$OffsetDateTimeToLocalTimeConverter@5d5c34
	java.time.OffsetDateTime -> java.time.ZonedDateTime : org.springframework.format.datetime.standard.DateTimeConverters$OffsetDateTimeToZonedDateTimeConverter@1d3cbeb
	java.time.ZoneId -> java.util.TimeZone : org.springframework.core.convert.support.ZoneIdToTimeZoneConverter@2695f6
	java.time.ZonedDateTime -> java.time.Instant : org.springframework.format.datetime.standard.DateTimeConverters$ZonedDateTimeToInstantConverter@114a2b4
	java.time.ZonedDateTime -> java.time.LocalDate : org.springframework.format.datetime.standard.DateTimeConverters$ZonedDateTimeToLocalDateConverter@122f214
	java.time.ZonedDateTime -> java.time.LocalDateTime : org.springframework.format.datetime.standard.DateTimeConverters$ZonedDateTimeToLocalDateTimeConverter@c41d6b
	java.time.ZonedDateTime -> java.time.LocalTime : org.springframework.format.datetime.standard.DateTimeConverters$ZonedDateTimeToLocalTimeConverter@14f51c3
	java.time.ZonedDateTime -> java.time.OffsetDateTime : org.springframework.format.datetime.standard.DateTimeConverters$ZonedDateTimeToOffsetDateTimeConverter@11a4bd1
	java.time.ZonedDateTime -> java.util.Calendar : org.springframework.core.convert.support.ZonedDateTimeToCalendarConverter@10659a0
	java.util.Calendar -> java.lang.Long : org.springframework.format.datetime.DateFormatterRegistrar$CalendarToLongConverter@8b1491,java.util.Calendar -> java.lang.Long : org.springframework.format.datetime.DateFormatterRegistrar$CalendarToLongConverter@508ed8
	java.util.Calendar -> java.time.Instant : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToInstantConverter@8b143e
	java.util.Calendar -> java.time.LocalDate : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToLocalDateConverter@af6d99
	java.util.Calendar -> java.time.LocalDateTime : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToLocalDateTimeConverter@1ba52b
	java.util.Calendar -> java.time.LocalTime : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToLocalTimeConverter@2522c1
	java.util.Calendar -> java.time.OffsetDateTime : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToOffsetDateTimeConverter@1247b85
	java.util.Calendar -> java.time.ZonedDateTime : org.springframework.format.datetime.standard.DateTimeConverters$CalendarToZonedDateTimeConverter@f2d9cf
	java.util.Calendar -> java.util.Date : org.springframework.format.datetime.DateFormatterRegistrar$CalendarToDateConverter@333931,java.util.Calendar -> java.util.Date : org.springframework.format.datetime.DateFormatterRegistrar$CalendarToDateConverter@a91705
	java.util.Calendar -> org.joda.time.ReadableInstant : org.springframework.format.datetime.joda.JodaTimeConverters$CalendarToReadableInstantConverter@a4a6e1
	java.util.Currency -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@1496f5b
	java.util.Date -> java.lang.Long : org.springframework.format.datetime.DateFormatterRegistrar$DateToLongConverter@2180b2,java.util.Date -> java.lang.Long : org.springframework.format.datetime.DateFormatterRegistrar$DateToLongConverter@1436cae
	java.util.Date -> java.util.Calendar : org.springframework.format.datetime.DateFormatterRegistrar$DateToCalendarConverter@529a03,java.util.Date -> java.util.Calendar : org.springframework.format.datetime.DateFormatterRegistrar$DateToCalendarConverter@cf020a
	java.util.Date -> org.joda.time.ReadableInstant : org.springframework.format.datetime.joda.JodaTimeConverters$DateToReadableInstantConverter@88ab09
	java.util.Locale -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@1b9ea51
	java.util.Properties -> java.lang.String : org.springframework.core.convert.support.PropertiesToStringConverter@17ddb8d
	java.util.UUID -> java.lang.String : org.springframework.core.convert.support.ObjectToStringConverter@16a2316
	org.joda.time.DateTime -> java.lang.Long : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToLongConverter@1fcd257
	org.joda.time.DateTime -> java.util.Calendar : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToCalendarConverter@7b961c
	org.joda.time.DateTime -> java.util.Date : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToDateConverter@1ef3da4
	org.joda.time.DateTime -> org.joda.time.DateMidnight : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToDateMidnightConverter@226eb3
	org.joda.time.DateTime -> org.joda.time.Instant : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToInstantConverter@427cf5
	org.joda.time.DateTime -> org.joda.time.LocalDate : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToLocalDateConverter@7cb1e4
	org.joda.time.DateTime -> org.joda.time.LocalDateTime : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToLocalDateTimeConverter@33a178
	org.joda.time.DateTime -> org.joda.time.LocalTime : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToLocalTimeConverter@138173c
	org.joda.time.DateTime -> org.joda.time.MutableDateTime : org.springframework.format.datetime.joda.JodaTimeConverters$DateTimeToMutableDateTimeConverter@1e616c2
	org.joda.time.LocalDateTime -> org.joda.time.LocalDate : org.springframework.format.datetime.joda.JodaTimeConverters$LocalDateTimeToLocalDateConverter@1ec16a6
	org.joda.time.LocalDateTime -> org.joda.time.LocalTime : org.springframework.format.datetime.joda.JodaTimeConverters$LocalDateTimeToLocalTimeConverter@eb2f71
	org.springframework.core.convert.support.ArrayToArrayConverter@307a23
	org.springframework.core.convert.support.ArrayToCollectionConverter@183da9d
	org.springframework.core.convert.support.ArrayToObjectConverter@ae8773
	org.springframework.core.convert.support.ArrayToStringConverter@1a55a65
	org.springframework.core.convert.support.ByteBufferConverter@901344
	org.springframework.core.convert.support.ByteBufferConverter@901344
	org.springframework.core.convert.support.ByteBufferConverter@901344
	org.springframework.core.convert.support.ByteBufferConverter@901344
	org.springframework.core.convert.support.CollectionToArrayConverter@c9c553
	org.springframework.core.convert.support.CollectionToCollectionConverter@aa8fe0
	org.springframework.core.convert.support.CollectionToObjectConverter@147a03b
	org.springframework.core.convert.support.CollectionToStringConverter@1cb2fd4
	org.springframework.core.convert.support.FallbackObjectToStringConverter@52878c
	org.springframework.core.convert.support.IdToEntityConverter@1c468f7,org.springframework.core.convert.support.ObjectToObjectConverter@4b3356
	org.springframework.core.convert.support.MapToMapConverter@18ce31a
	org.springframework.core.convert.support.ObjectToArrayConverter@66398f
	org.springframework.core.convert.support.ObjectToCollectionConverter@4e4a5d
	org.springframework.core.convert.support.ObjectToOptionalConverter@1ea1f7f
	org.springframework.core.convert.support.StreamConverter@eb65cf
	org.springframework.core.convert.support.StreamConverter@eb65cf
	org.springframework.core.convert.support.StreamConverter@eb65cf
	org.springframework.core.convert.support.StreamConverter@eb65cf
	org.springframework.core.convert.support.StringToArrayConverter@65c710
	org.springframework.core.convert.support.StringToCollectionConverter@1683cba

   javax.servlet.forward.request_uri=/rest/v1/excel-reports/view/XLR_724056
   javax.servlet.forward.path_info=/v1/excel-reports/view/XLR_724056
   javax.servlet.http.HttpServletResponse=org.springframework.security.web.header.HeaderWriterFilter$HeaderWriterResponse@15eb1ad
   _csrf=org.springframework.security.web.csrf.DefaultCsrfToken@1153e62
   __spring_security_filterSecurityInterceptor_filterApplied=true
   javax.servlet.error.servlet_name=springDispatcher
   javax.servlet.error.message=org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
   org.springframework.web.servlet.DispatcherServlet.THEME_SOURCE=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Thu Jul 26 09:29:35 CEST 2018]; parent: Root WebApplicationContext
   org.springframework.web.servlet.HandlerMapping.producibleMediaTypes=[text/html]
   org.springframework.web.servlet.HandlerMapping.pathWithinHandlerMapping=/v1/excel-reports/view/XLR_724056
   org.springframework.security.web.csrf.CsrfToken=org.springframework.security.web.csrf.DefaultCsrfToken@1153e62
   org.springframework.web.servlet.HandlerMapping.uriTemplateVariables={xid=XLR_724056}
   javax.servlet.error.request_uri=/rest/v1/excel-reports/view/XLR_724056
   org.springframework.web.servlet.DispatcherServlet.THEME_RESOLVER=org.springframework.web.servlet.theme.FixedThemeResolver@1710f3d
   javax.servlet.jsp.jstl.fmt.locale.request=it_IT
   javax.servlet.error.exception=org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException


SESSION ATTRIBUTES
   org.springframework.security.web.csrf.HttpSessionCsrfTokenRepository.CSRF_TOKEN=org.springframework.security.web.csrf.DefaultCsrfToken@1153e62
   sessionUser=User [id=1, username=admin, password={BCRYPT}$2a$10$wOlI2RVOKJxpieZ77tgkzeSBrddU3LK.01IjOjnxZWKuxTDKQ9C/2, email=stefano.cerino@enel.com, phone=, disabled=false, homeUrl=, lastLogin=1532459931647, receiveAlarmEmails=-3, receiveOwnAuditEvents=false, timezone=, permissions=superadmin]
   LONG_POLL_DATA_TIMEOUT=1532592137552
   SPRING_SECURITY_CONTEXT=org.springframework.security.core.context.SecurityContextImpl@1c167ca8: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@1c167ca8: Principal: User [id=1, username=admin, password={BCRYPT}$2a$10$wOlI2RVOKJxpieZ77tgkzeSBrddU3LK.01IjOjnxZWKuxTDKQ9C/2, email=stefano.cerino@enel.com, phone=, disabled=false, homeUrl=, lastLogin=1532459931647, receiveAlarmEmails=-3, receiveOwnAuditEvents=false, timezone=, permissions=superadmin]; Credentials: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: ROLE_superadmin, ROLE_ADMIN
   LONG_POLL_DATA=[com.serotonin.m2m2.web.dwr.longPoll.LongPollData@115ae26]

[etantonio]

By the way,
Mango completely crashed during report generation,
this morning it was necessary to restart the service otherwise no data from the plant, any idea about how to solve this problem?

[phildunlap]

Hi etantonio,

That null pointer exception wouldn't crash Mango. So, something else must be in your logs, or there may be an hs_err file in your Mango/ directory.. I am not sure what caused it, but the report's filename must be null. You can check to see if the report was actually generated by checking the Mango/web/modules/excelReports/web/report-data/ directory. If you find the right report, you can try to update the row in the database for the report instance that is causing the null pointer exception, or you can delete those report instances since you found the generated files.

/sqlConsole.shtm
Find and update the reports' records (run whichever line individually):

SELECT * FROM excelReports WHERE filename IS NULL; --submit query
UPDATE excelReports SET filename='Filename_here.xlsx' WHERE filename IS NULL; --submit update
-- use "WHERE id IN (1, 2, 3)" gotten from the select statement if you have more than one type of report)

Or just delete those excel report instances with

DELETE FROM excelReports WHERE filename IS NULL; -- submit update