Skip navigation
1579 Views 2 Replies Latest reply: Jul 10, 2011 11:47 PM by aparker RSS Branched to a new discussion.
Rookie 7 posts since
Apr 7, 2011

Has received 1 of 9 achievements.
Currently Being Moderated

Jul 6, 2011 2:25 AM

Raise User to Analyst

Hi, wonder if any one can help me out.

 

When I add an Analyst to a Support Group, if I log a new incident for this user, then click save I get the error:

 

There has been an unexpected error. Click Continue to return to the previous page.

The  INSERT statement conflicted with the FOREIGN KEY constraint  "fkey$pm_process$cust". The conflict occurred in database "ldsd", table  "dbo.tps_customer", column 'tps_guid'.
The statement has been terminated.

 

If I remove the Analyst from the Support group and add to a Customer group then it works fine (or no group at all), but then I will not get a list of Incidents open for a group (i.e 3rd Line Support Group), from a query, for example using the system querie My Group Incidents Workload.

 

Has any one had the same issue ?

 

Thanks

 

Mehmet Kocak

  • Expert 233 posts since
    Jan 27, 2009

    Has received 7 of 9 achievements.
    Currently Being Moderated
    1. Jul 10, 2011 11:40 PM (in response to MKocak)
    Re: Raise User to Analyst

    Hi Mehmet,

     

    I would probably recommend logging that with support for a thorough look, but at a glance it sounds like when you are saving it is attempting to populate a Customer field with a Support Group value (probably as this is the Analysts Primary Group) which is obviously causing a conflict because, although both are Groups they are different Group Types (Customer and Support Group).

     

    Try adding a Customer and Support Group to this Analyst, then ensure the Primary Group is set to the Customer group not the Support Group and see if you get the same error. If you do, then definitely log this with support. If you don't, still log it with support but at least you'll have more of an idea where the problem lies.

     

    Cheers,

    Hadyn Dawson

  • aparker Employee 593 posts since
    Feb 18, 2009

    Has received 6 of 9 achievements.
    Currently Being Moderated
    2. Jul 10, 2011 11:47 PM (in response to MKocak)
    Re: Raise User to Analyst

    Hi Mehmet,

     

    You are experiencing a common problem that occurs when you have not set uup the users and groups correctly in the system. Before I answer anymore on this, please have a read of the following community article and especially my response outlining the rules of users and groups. If you have any more questions, let us know.

     

    http://community.landesk.com/support/message/60910#60910

     

    Andy

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software