Last post May 29, 2009 08:29 AM by trondhindenes
Feb 26, 2008 09:29 AM|chrsm|LINK
When I run the schedule task ExchangeData.exe to collect exchange data to MPSSQL I got the following error in the application log and the schedule task failed
Event Source: Collect Exchange Data Collect Services
Event Category: None
Event ID: 50103
Time: 3:14:37 PM
Exception Creating SQL Connection Objects.
The '-ge' operator failed: Could not compare "26-02-2008 15:14:10" to "14-02-1998 01:15:02". Error: "Cannot convert value "14-02-1998 01:15:02" to type "System.DateTime". Error: "String was not recognized
as a valid DateTime."".
Both the Exchange backend server ”EXBE01” and the MPSSQL server ”SQL01” are using US regional settings.
Exchange 2007 SP1 HMC4
Mar 03, 2008 10:24 AM|pcsupport|LINK
We have the same problem. I found out that there is a register key, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HSExchangeData , The exchangedata.exe only extract data the last 24 hours. If the registerkey date is further away then 24 hours, the scheduled tast failes.
We have a case running with Microsoft support, but no solution has been given yet. Have you found anything out how to fix this?
Mar 11, 2008 07:08 AM|chrsm|LINK
Did you find a solution ??
Mar 31, 2009 09:40 AM|ChristianAT|LINK
I am having the same issue
Did you ever get this problem solved? (and possibly how)
May 28, 2009 09:06 PM|trondhindenes|LINK
Does anyone have an update on this one?
May 29, 2009 02:24 AM|pcsupport|LINK
We use the version 4.0.460.88 . This one seems to be working somewhat. Sometimes it fails. We then only have to change the registry entry to a date closer to todays date and time, and then it starts running again. I also changed the the scheduled task run.
The exchange data collector runs every hour.
Let me know if you need this version. I can send it to you.
May 29, 2009 03:52 AM|ChristianAT|LINK
That would be great to have. Tried to find the file from google but didn't end up with anything. I have version 4.0.460.00 and i am still unable to run that command no matter how close i set the date. In what format do you have your servers US?
May 29, 2009 04:20 AM|pcsupport|LINK
We hade problems with that version too.
you can download it from here:
We have US language set.
May 29, 2009 05:22 AM|ChristianAT|LINK
Thanks a lot for that file!
Well now i just get this error in the event log...guessing i will never get that data gatherer working.. Or would you happen to have any more ideas?
Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Time: 12:18:52 PM
EventType clr20r3, P1 exchangedata.exe, P2 4.0.460.88, P3 4822bb45, P4 mscorlib, P5 188.8.131.52, P6 471eb8e7, P7 246e, P8 2a, P9 system.formatexception, P10 NIL.
May 29, 2009 05:29 AM|pcsupport|LINK
I would try to uninstall .net 3.5 if you have that installed.
I have had some problems with that update before. Not with the exchangedata, but.. I would try.
Have you installed .net 2.0 SP2?
May 29, 2009 05:37 AM|ChristianAT|LINK
Thanks for the reply.
I haven't installed .net 3.5 and i don't have the .net 2.0 sp2 only sp1 installed.
May 29, 2009 08:29 AM|trondhindenes|LINK
will try that one. Thanks!