[THIN] Re: Edgesight 4.5 error loading payload issue

My real question is, what's in:

database "EdgeSight", table "dbo.machine", column 'machid'. What's the
FK_SInstance_machine?

I understand what a foreign key etc is, but my question is, why is
there a conflict? What else is in that table?

Anything after this is wild and pure speculation by myself not knowing
enough about the product. They could be questions worth asking
though.......

I would be looking at %ALLUSERSPROFILE%\Application Data\Citrix\System
Monitoring\Data\SYS_DATA.TXT to see if there is any reference to the
local hostname for the agent. See if there is a conflict in that.

Did you build a custom package for the agent which has a hostname
built into it which is getting rolled across multiple clients?

Is there anything in:

HKEY_LOCAL_MACHINE\Software\Citrix\System Monitoring\Agent\EdgeSight\4.00\

which refers to an incorrect local hostname?

Are you using a CNAME / Alias for:

HKEY_LOCAL_MACHINE\Software\Citrix\System
Monitoring\Agent\EdgeSight\4.00\Netaccess\ServerName (Is it using
this as part of what's in the machid column that's tripping up the
foreign key)

2008/9/30 Berny Stapleton <berny@technology.net.au>:
> Hang on a second, did you re-install an agent on a server? If so, did
> you delete the server from the database first?
>
>
> 2008/9/29 andy mac <a_r_mc789@yahoo.com>:
>> This is just when rolling out the agent to the Citrix servers, I havent even
>> rolled out the agent to any client machines yet
>>
>> ----- Original Message ----
>> From: Berny Stapleton <berny@technology.net.au>
>> To: thin@freelists.org
>> Sent: Monday, September 29, 2008 11:09:50 AM
>> Subject: [THIN] Re: Edgesight 4.5 error loading payload issue
>>
>> What are the clients? They aren't deployed out of the same image and
>> have the same hostname or something do they? Mis-configured thin
>> clients perhaps?
>>
>>
>>
>> 2008/9/29 andy mac <a_r_mc789@yahoo.com>:
>>> Ive installed an eval of edgesight on a w2k3 sp2 server connecting to a
>>> sql
>>> 2005 server.
>>>
>>> ive configured it and rolled out the presentation server agent to a couple
>>> of citrix servers. However, when it tries to upload the payload file back
>>> to
>>> the edgesight server, we get the following error emailed out and appearing
>>> in the messages area
>>>
>>>
>>>
>>> "The UPDATE statement conflicted with the FOREIGN KEY constraint
>>> "FK_SInstance_machine". The conflict occurred in database "EdgeSight",
>>> table
>>> "dbo.machine", column 'machid'.
>>>
>>> The statement has been terminated"
>>>
>>>
>>>
>>>
>>>
>>> We did have an initial issue uploading the payload as it was putting a
>>> double backslash in part of the path which was giving us an access is
>>> denied
>>> error, but I solved that by editing the edgesight.cfg file.
>>>
>>> Anyone any ideas, done a citrites/google search and found nothing !
>>>
>>> Thanks
>>>
>>> Andy
>>>
>> ************************************************
>> For Archives, RSS, to Unsubscribe, Subscribe or
>> set Digest or Vacation mode use the below link:
>> http://www.freelists.org/list/thin
>> NEW! Follow Thin List on Twitter!
>> http://twitter.com/thinlist
>> Thin List discussion is now available in blog format at:
>> http://thinmaillist.blogspot.com
>> HOT! Thinlist MOBILE Feed!
>> http://thinlist.net/mobile
>> Thinlist quick pick
>> http://thinlist.net
>> ************************************************
>>
>>
>
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://www.freelists.org/list/thin
NEW! Follow Thin List on Twitter!
http://twitter.com/thinlist
Thin List discussion is now available in blog format at:
http://thinmaillist.blogspot.com
HOT! Thinlist MOBILE Feed!
http://thinlist.net/mobile
Thinlist quick pick
http://thinlist.net
************************************************