SAP Knowledge Base Article - Public

2870655 - millis -<number> < minimum value -<number>@bali.util.Calendar.setTimeInMillis when using dates in AO

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:

2019-12-05_15-53-42.png

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

Product

SAP Analysis for Microsoft Office all versions