+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, FMS: Read Failures/General SQL Error/[Microsoft][SQL Native Client]Communication Link in Technical; On our 2 finance machines we are consistantly getting the following error when FMS is left open and not used ...
  1. #1

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    497
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    20

    FMS: Read Failures/General SQL Error/[Microsoft][SQL Native Client]Communication Link

    On our 2 finance machines we are consistantly getting the following error when FMS is left open and not used for somewhere between 10-20 minutes:

    Read Failure.
    General SQL Error.
    [Microsoft][SQL Native Client]Communication Link failure.

    It causes a particular problem if in the middle of working on something like a bank rec for example.

    There is an article on SupportNet but it simply directs you to a Microsoft KB. In this case it talks about disabling the TCP Chimney Offload, which I have done and it's made no difference.

    I would raise a call with Captia but I suspect they will say goto Microsoft has the KB instructs. Has anybody else seen this problem and if so how did you resolved it?

    We are using FMS Summer 2011 on Windows 7.

    Cheers

    Adam.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Can't remember if this is either a problem with the network card on the server going to sleep and it's dropping network connections.

    Or if it's the fact you shouldn't leave it open and not doing anything. I think it's the above, is it a HP server?

  3. #3

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    497
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    20
    Nope. A Dell server. In addition to SIMS/FMS the server also has our cashless catering software/db installed on it, would it really be going to sleep?

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158

  5. #5

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    497
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    20
    Yes, thats where the link in the SupportNet KB goes. It is a broadcom nic...

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Big discussion on SupportNet forum about this a while ago, I found swapping the NIC to be the best - assuming you've got a nice Intel server NIC lying around.

    Found this topic on here = Help needed with FMS since Capita can't resolve an issue with there own software. - penfold posted about turning the power settings off.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158

  8. #8

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    497
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    20
    Quote Originally Posted by matt40k View Post
    Big discussion on SupportNet forum about this a while ago, I found swapping the NIC to be the best - assuming you've got a nice Intel server NIC lying around.

    Found this topic on here = Help needed with FMS since Capita can't resolve an issue with there own software. - penfold posted about turning the power settings off.
    Also seen that the issue was tracked down to a group policy refresh setting. I have that enabled and have now disabled it to see if it fixes the issue.

SHARE:
+ Post New Thread

Similar Threads

  1. FMS SQL Error
    By Rawns in forum Educational Software
    Replies: 6
    Last Post: 3rd June 2014, 03:18 PM
  2. [SIMS] General SQL Error aftering upgrading to FMS 6.136
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 22nd December 2010, 11:24 AM
  3. Microsoft TMG 2010 Client
    By neilault in forum Internet Related/Filtering/Firewall
    Replies: 6
    Last Post: 16th October 2010, 12:50 PM
  4. Replies: 1
    Last Post: 10th November 2009, 10:37 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
  •