+ Post New Thread
Results 1 to 6 of 6
Educational Software Thread, FMS SQL Error in Technical; When in FMS and going to FOCUS | PERSONEL LINKS | SALARY PROJECTION, this message apears. Any ideas? Key Voiolation. ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0

    FMS SQL Error

    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.

  2. #2

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    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.
    Last edited by EduTech; 13th August 2009 at 03:33 PM.

  3. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    Yes it's already installed on the server.

  4. #4

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    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.

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 487 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by EduTech View Post
    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. :'(

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Help With SQL Query Error
    By penfold_99 in forum Coding
    Replies: 6
    Last Post: 15th May 2009, 01:30 PM
  2. March Release FMS error
    By button_ripple in forum MIS Systems
    Replies: 22
    Last Post: 3rd April 2009, 09:10 PM
  3. Replies: 2
    Last Post: 26th February 2009, 01:21 PM
  4. FMS Upgrade to SQL and CFR reports
    By wesleyw in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 08:58 AM
  5. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •