Groove Management Server doesn't search for users

M

Michael Hirczy

Hi!

I have setup an onsite Management Server and Relayserver. Everything
configured ok, ManagementServer and Relayserver do communicate and the
activation email for the users has been sent w/o problems.

Now, when I start my client and try to search for other users in our
onsite-DB, GrooveClient tells me that no search results could be
fetched, and I should check my Internet connection (???).
Nevertheless, it seems like the client _DOES_ communicate with the
management server, since I get 2 errors (ID 212 and 223) in the server's
eventlog (sorry, the server is german):
--------------------------
<IID>{7641F71D-1FF6-4E63-BD7A-37617C157E45}</IID><Details
Process="w3wp.exe" HRESULT="0x80040208" EventMessage="An exception was
thrown while executing the stored procedure
&apos;Grv_Contact_Search&apos;. Exception follows:" PID="2544"
TID="2580" OSMajor="5" OSMinor="2" OSBuild="3790" OS="Win2k3"
Date="Dienstag, 17. Juni 2008 10:52:08" OSServicePack="Service Pack 2"
PreviousMessages="

As a result of the error:
Arithmetischer Überlauffehler beim Konvertieren von expression in den
datetime-Datentyp. in IID {0C733A63-2A1C-11CE-ADE5-00AA0044773D}"
/><CallStack>
--------------------------
..... and a lot of CDATA following.

the error is an "arithmetic overflow when converting datatype expression
to datetime".

did anybody else have this problem?

thx and greetings
michi
 
M

Michael Hirczy

Greetings!

I found it out myself :)
So, here's my quick-hack solution...

It looks like in the called stored procedure, the part with

SELECT @CutOfDate = DateAdd(dd, (TTLForContactSearch_Days * -1),
GetDate())
FROM GmsDomainData
WHERE DomainGuid = @DomainGuid

is faulty...

I changed it to a hardcoded date
SET @CutOfDate = '1.1.2000'

directly on the SQL server, now everything works fine...

greetings
michi
 
Top