"system.Argumentoutofrangeexception: Year, Month, and Day Parameters Describe an Un-representable Datetime" in Visualizer (Doc ID 2197750.1)

Last updated on NOVEMBER 15, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load Visualizer, it takes a long time and the project list that loads is not correct.

The following error is visible in the visualizer log:

16/12/2015 1:41:33 AM Information Exception Exception trying to load globaldata for WBS: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->
System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at System.DateTime..ctor(Int32 year, Int32 month, Int32 day, Int32 hour,
Int32 minute, Int32 second, Int32 millisecond)
at Oracle.ManagedDataAccess.Types.DateTimeConv.ToDateTime(Byte[] byteRep,
Boolean isNotTimeStampTZ, Int32 offset, Int32 length)
at Oracle.ManagedDataAccess.Client.OracleDataReader.GetDateTime(Int32 i)
at Oracle.ManagedDataAccess.Client.OracleDataReader.GetValue(Int32 i)
at Primavera.Venus.Data.DbStore.BaseSqlHydrator.ConstructEntityTEntity(DbDataReader reader, IDictionary'2 valueConversionDict, Func'1 ConstructorFunc)
at Primavera.Venus.Data.DbStore.BaseSqlHydrator.<Query>d__9'1.MoveNext()
at Primavera.Venus.Infrastructure.Types.Entity.EntitySet'1.Load(IEnumerable'1source)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments,Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj,Object] parameters, Object[ arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Primavera.Venus.DataRepository.BaseDataserviceContext.<LoadGlobalTables>b__29(Type TEntity)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms