Symptom
When you are running an Analysis for Office report with a query or a view and you get an error similar as below:
- millis -<number> < minimum value -<number>@bali.util.Calendar.setTimeInMillis(long millis)
Environment
Analysis for Office
Reproducing the Issue
- Execute a query on Analysis for Office with a time based characteristic or measure
- Issue below pops up:
On the LOG file appears:
|millis -30607616129000 < minimum value -12219292800000@bali.util.Calendar.setTimeInMillis(long millis)
Could not serialize the application model[msg.SerializingAppErr]
bei com.sap.ip.bi.pioneer.core.serializing.CrApplicationSerializingService.SerializeApplication()
bei com.sap.ip.bi.pioneer.excel.main.EaSession.SerializeApplicationAndWriteToWorkbook(EaModelWbApplication iWorkbook, Boolean iForceCompressBicsStateXml, Boolean iDo1X, Boolean iForwardToCof)
bei com.sap.ip.bi.pioneer.excel.main.EaSession.StoreApplicationStateForRecoveryOnError(EaModelWbApplication iWorkbook)
bei com.sap.ip.bi.pioneer.excel.views.EaViewManagerSession.OnProcessingFinished(Object iSender, CoProcessingFinishedEventArgs iEventArgs)
>> General .NET Exception:
millis -30607616129000 < minimum value -12219292800000@bali.util.Calendar.setTimeInMillis(long millis)
bei bali.util.Calendar.setTimeInMillis(Int64 millis)
bei bali.util.Calendar.setTime(Date date)
bei com.sap.ip.bi.base.service.xml.base.BaseDomWriter.calendarDayToString(Date )
bei com.sap.ip.bi.base.service.xml.base.BaseDomWriter.addNodeAttributeCalendarDay(String name, Date calendarDay)
bei com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomSerializer.serializeCharacteristic(ICharacteristic characteristic, IDomWriter domWriter, Int64 mode)
Cause
Analysis for Office was designed to supports dates since the introduction of the Gregorian calendar in the range from 15-OCT-1582 to 31-DEC-9999 so any other range outside of those values will generate a dump (and even Excel cannot properly handle it as a date value).
Resolution
On backend you need to clean dates outside of the range from 15-OCT-1582 to 31-DEC-9999 of the time based characteristic or measure.
Keywords
millis, minimum, value, bali.util.Calendar, setTimeInMillis, date, gregorian, calendar, invalid, dump, range, excel. , KBA , BI-RA-AO-XLA , Excel Addin , Known Error