Error when removing users from SMS

Discussions about other Church websites
Post Reply
austinjs8185
New Member
Posts: 2
Joined: Sun Oct 10, 2021 12:09 pm

Error when removing users from SMS

#1

Post by austinjs8185 »

Hello all!

I am getting this error when trying to remove some old users from our Stake SMS:

Database Error : The DELETE statement conflicted with the REFERENCE constraint "FK__ActionIte__To_Us__3D73F9C2". The conflict occurred in database "jordanriverysa_StakeSMS", table "dbo.ActionItems", column 'To_UserID'. The statement has been terminated.

Has anyone encountered this error before and know how to fix it?
russellhltn
Community Administrator
Posts: 35337
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Error when removing users from SMS

#2

Post by russellhltn »

I assume you mean MLS, not SMS.

You can't delete any user that's done any financial transaction in the last three years plus current. So any involvement 2019 or later. You'll have to settle for deactivating the account.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
austinjs8185
New Member
Posts: 2
Joined: Sun Oct 10, 2021 12:09 pm

Re: Error when removing users from SMS

#3

Post by austinjs8185 »

lol I apologize! I thought the system we were using to track calling called SMS was church wide. It is not. Thank you for your quick response. Sorry for the confusion
scgallafent
Church Employee
Church Employee
Posts: 3025
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Error when removing users from SMS

#4

Post by scgallafent »

The application actually is called SMS. SMS is not developed by the Church. You will need to contact the developers of that application.
Post Reply

Return to “Other Websites”