I would be going back to the database level.
Presuming you are using MS SQL server, use the SQL profiler and take a
look at access to the database server. See if profiler is throwing any
other errors.
What I am questioning here is access to the database by the
application, whether it has access to update the table or something.
Maybe it's getting denied access somewhere along the lines and that's
why it's giving errors about the foreign key contraint.
If there is nothing in the table, I have a hard time believing that
it's actually getting a conflict in the machine ID.
The only other thing I can think of is what the foreign key is referencing....
Do a google search for sys.foreign_key_columns
Take a look at what that gives you, take a look at the database and
see whether there is data in another table that's causing the problem.
If there isn't a lot of tables / data etc in the database, you might
even want to take a look through manually. The first three links or
four links should help you dig up what you are trying to find though.
There is a post by someone from MS at the following link:
Let me know what you come up with.
Berny
2008/9/30 andy mac <a_r_mc789@yahoo.com>:
> 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
> ************************************************
>
>
************************************************
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
************************************************
No comments:
Post a Comment