Community
Showing results for 
Search instead for 
Do you mean 
Reply

Unknown error

Copper Contributor
Posts: 29
Country: USA

Unknown error

We suddenly started getting this unknown error. Can anyone help me out?

 

Thanks

 

The UPDATE statement conflicted with the FOREIGN KEY constraint "PHONE_PHONEMASKID_FK". The conflict occurred in the database "XXX", table "dbo.TBL_PHONEMASK", column 'PHONEMASKID'. The statement has been terminated.

 

(I omitted the name of the database which is our company name.)

Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Unknown error

What are you trying to do when you get the error? That's a SQL error. Are you getting the error working from ACT! itself?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 29
Country: USA

Re: Unknown error

Yes, we had an incorrect history that needed to be deleted and when 1 of our users deleted the history, we now get this error whenever we do anything with this contact. Quite weird.

Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Unknown error

How did you delete the history?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 29
Country: USA

Re: Unknown error

I fixed the ptorblem. The formatting for a phone number was the culprit. Once I changed it to the USA format, the error went away. Very weird