FMS SQL Error

[Rawns]

When in FMS and going to FOCUS | PERSONEL LINKS | SALARY PROJECTION, this message apears. Any ideas?

Key Voiolation.
[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.

[EduTech]

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,

James.

[Rawns]

Yes it's already installed on the server.

[EduTech]

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?

James.

[Rawns]

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?

James.

Good idea.


Shame it did not work.

Same issue still. :'(

[matt40k]

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.