Educational Software Thread, FMS SQL Error in Technical; When in FMS and going to FOCUS | PERSONEL LINKS | SALARY PROJECTION, this message apears. Any ideas?
13th August 2009, 04:24 PM #1
FMS SQL Error
When in FMS and going to FOCUS | PERSONEL LINKS | SALARY PROJECTION, this message apears. Any ideas?
[Microsoft][SQL native Client][SQL Server]The UPDATE statement conflicted with the CHECK constraint "CK_person_gender". The conflict occured in database"CCSFMS", table "dbo.person", column "gender". General SQL error.
[Microsoft][SQL native Client][SQL Server]The statement has been terminated.
13th August 2009, 04:29 PM #2
This is quite a common problem, especially if your server is now running windows 2k8.
Do you have SQL Native Client installed on the server?
if not install it (download here: Download details: Feature Pack for SQL Server 2005 Feb 2007)
- Pick the download:
sqlncli.msi for 32 bit systems
sqlncli_x64.msi for 64 bit systems
Hope that helps,
Last edited by EduTech; 13th August 2009 at 04:33 PM.
13th August 2009, 04:35 PM #3
Yes it's already installed on the server.
13th August 2009, 05:12 PM #4
hmm, this error was very similar to the one i got a while back now when playing with SIMS and Server 2008. Erm.. Try Detaching and Re-attaching the FMS database?
13th August 2009, 05:22 PM #5
13th August 2009, 05:37 PM #6
Try running SIMS on the workstation, make sure it works, then try FMS again. Failing that log a call with Capita. Looks like you have a problem with your P7 data.
3rd June 2014, 04:18 PM #7
- Rep Power
I appreciate this thread is very old however I had this exact issue today and there was a quick and easy solution.
There were a few members of staff who had no gender assigned to them within Sims. Once all staff within Sims had a gender assigned all worked correctly....
By penfold_99 in forum Coding
Last Post: 15th May 2009, 02:30 PM
By button_ripple in forum MIS Systems
Last Post: 3rd April 2009, 10:10 PM
By tonijh in forum MIS Systems
Last Post: 26th February 2009, 02:21 PM
By wesleyw in forum MIS Systems
Last Post: 3rd April 2008, 09:58 AM
By thom in forum MIS Systems
Last Post: 30th August 2007, 05:50 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)