Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL DateTime overflow error during sync.

New Member
Posts: 1
Country: United States

SQL DateTime overflow error during sync.

I'm getting an SQL DateTime overflow error Date must be between 1/1/1753 12:00:00 AM and 12/31/9999 12:00:00 PM. Contact Administrator

when attempting to sync Act 9.0.

 

How do I correct this error?  I have been through all the date fields on both the main and remote database.

 

Thanks

Moderator
Posts: 4,395
Country: USA

Re: SQL DateTime overflow error during sync.

Hello,

 

Usually this error is caused by invalid dates or times.  When you looked at the date fields, did you also look at the activities?  If you haven't, go to the Task List and add these columns: Date, End Date, Time, Duration.  Make sure show cleared activities is enabled and look after the columns to see if there are any negative values, invalid dates and durations.  Delete any that you find from the parent and remote database and try to sync again.

 

If the issue is remote specific, you can try creating a new remote database.