Skip to main content

Error: 'The added or subtracted value results in an unrepresentable DateTime'

Written by Charnjit Singh Dharival

Cannot open the plan or run align to status date or align with actuals because of the following error message:-
​
​ An unexpected error occurred. Please report this problem to your system administrator with the following information:
​
System.ArgumentOutOfRangeException: the added or subtracted value results in an un-representable DateTime.
Parameter name: x


Solution

Please check the Start Date for the works order operations within FactoryMaster (or the ERP system being used) is not set to far ahead e.g. the year 9999. If the StartDate is longer than 5 years ahead (default planning range from tools, options) of the present Plan Start Date and Time (from file, plan properties), the imported tasks(s) with these dates will cause the plan to error, when opened or when running align to status date from the plan.

Run the below SQL query to check there aren't any tasks with start and end dates outside of the default planning range (e.g. the year 2000).

Select A.TaskID, A.StartDate, A.FinishDate, a.Status, A.DeadlineDate, *from orc_Tasks as AWhere Status <> 99 Order by A.StartDate ASC


​
If you see this error when running align to actuals, the functionality has been enhanced in Orchestrate version 7.77. Please upgrade to this version or above.

Did this answer your question?