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@xxxxxxxxxxxxxxxxx> To: thin@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxx>: > 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@xxxxxxxxx>: >> 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@xxxxxxxxxxxxxxxxx> >> To: thin@xxxxxxxxxxxxx >> 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@xxxxxxxxx>: >>> 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: >> //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: //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 ************************************************