Error "The Conversion Of A Char Data Type To A Datetime Data Type Resulted In An Out-Of-Range Datetime Value" In P6 Web Access (Doc ID 909313.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
All Platforms
***Checked for relevance on 14-MAR-2013***


Symptoms

The following error is encountered in the Milestone Status Window in P6 Web Access when connecting to a SQL Server 2005/2005 database:

An error occurred while processing your request. Please try again.

No more details available. DBEngine.executeSelect: {SELECT count(*) thecount FROM {oj task LEFT OUTER JOIN rsrc ON task.rsrc_id=rsrc.rsrc_id} WHERE ( task.task_type = 'TT_Mile' OR task.task_type = 'TT_FinMile') AND task.proj_id = 515 AND ( (task.status_code = 'TK_NotStart' AND task.target_end_date < '2008-05-25 11:11:01') OR (task.status_code = 'TK_Complete' AND task.act_end_date > '2008-05-05 11:11:01' AND task.act_start_date < '2008-05-25 11:11:01') )} The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT count(*) thecount FROM {oj task LEFT OUTER JOIN rsrc ON task.rsrc_id=rsrc.rsrc_id} WHERE ( task.task_type = 'TT_Mile' OR task.task_type = 'TT_FinMile') AND task.proj_id = 515 AND ( (task.status_code = 'TK_NotStart' AND task.target_end_date < '2008-05-25 11:11:01') OR (task.status_code = 'TK_Complete' AND task.act_end_date > '2008-05-05 11:11:01' AND task.act_start_date < '2008-05-25 11:11:01') )}The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)

 

 

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