[THIN] Re: Edgesight 4.5 error loading payload issue

Thanks Berny, answers to each question are..

 

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

 

Ive just browsed to the table and there's actually nothing in it.

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.

 

Checked for this on one of the Citrix servers, this file doesnt exist

 

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

No, just installed it manually via the .msi file

 

Is there anything in:

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

which refers to an incorrect local hostname?

No

 

 

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)

 

No, as its just using the IP address

 

Dont suppose any of this helps ??

 

 

 

----- Original Message ----
From: Berny Stapleton <berny@technology.net.au>
To: thin@freelists.org
Sent: Monday, September 29, 2008 3:45:58 PM
Subject: [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?         Ive just browsed to the table and there's actually nothing in it.

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
************************************************