SQL Tables

Hi, I using Asset navigator 5.1 helpdesk portal and I'm getting error when updating a ticket.
I'm using sql express 2008.

This is the error:  Activity has not been submitted - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_HD_Ticket_Activity_HD_Ticket_Activity_CategoryHD_Ticket_Activity". The conflict occurred in database "NAV5", table "dbo.HD_Ticket_Activity_Category", column 'Activity_Category'

thanks for you support.
tiinettechAsked:
Who is Participating?
 
PortletPaulfreelancerCommented:
if you are using a product (i.e. "Asset navigator 5.1") why are you issuing inserts at all?

they should be performed by the product (or via some supported API) and you may be violating your support arrangements by direct DML
0
 
coreconceptsCommented:
What was the insert statement you issued?

It looks like you entered a value that is NOT in the unique column that the foreign key references.
0
 
rshqCommented:
Hi
 Maybe you want insert data in "dbo.HD_Ticket_Activity" but you dont have any information
 about that in table "dbo.HD_Ticket_Activity_Category".
0
 
tiinettechAuthor Commented:
how do I add the information in "dbo.HD_Ticket_Activity_Category" ?

thanks;
0
 
tiinettechAuthor Commented:
the insert is being done by the app itself, how do I add the information in "dbo.HD_Ticket_Activity_Category" ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.