Hello,
We have installed EDRSMS 6.5sp2. Environment details are as follows:
MOSS 2007 sp2 on Windows Server 2003 R2 Standard sp2 (64 bit)
SQL Server 2008 Standard (64 bit) sp1 on Windows Server Standard 2008 (64 bit) sp2
Content Server 6.5sp3 on Solaris (Oracle database)
Installation went fine and it was working well but now we get following error in log every minute. This error started once date changed to "13.6.2010". It seems it is trying to parse date part as month. But I am not sure which settings and where I should make changes to make this working and get rid of this error.
EDRSMS has encountered error on: 13.6.2010 0:01:12
Error Message: ***************************************
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Emc.Documentum.SPJournaling.Jme.Dao.JmeDao.UpdateLastActiveTime(String connectionString, String lastActiveTimeName, Guid jmeId)
Any clue on this would be quite appreciable.
BR,
Rajesh