+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, SIMS FMS Error in Technical; Hi, We are running SIMS FMS version 6.91 here and for some reason we have recently encountered an error with ...
  1. #1
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS FMS Error

    Hi,

    We are running SIMS FMS version 6.91 here and for some reason we have recently encountered an error with our SIMS. When we are processing our purchase orders and press the print option the machine crashes out and we get the following error message:

    "General SQL error.
    [Microsoft][SQL Native Client][SQL Server]Error converting data type varchar to int."

    Has anyone any idea of what could be causing this problem? It sounds like it is some sort of problem with a field that is trying to convert from one type to another but the SIMS FMS works fine if we remote desktop to the server?

    Has anyone any ideas on what could be causing this?

    Ben

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Have you tried hooking up to another printer?

  3. #3

    Join Date
    Jan 2007
    Location
    Bacton
    Posts
    17
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    16
    Hi,

    This is a long shot, but have to tried to save it first then print

  4. #4
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    876
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    i guess the SQL native client was installed when you did the FMS setup? tried reinstalling FMS?

    Might be to do with Crystal reports .... you a member of supportnet?

  5. #5
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    It prints the Purchase Orders out fine but then i get the error message. Here is a screen print of the exact message. So printing is fine whichever printer I use and printing is fine, its just after printing happens and it tries to save the file this is when the error message pops up.
    Attached Images Attached Images

  6. #6
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Were trying to setup another PC so we can test it out but when we install this from scratch it still says the error. Very strange... I know it could be something very easy to fix so thanks for the pointers so far.

    Cheers, Ben

  7. #7
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    FMS 6.91, surely thats pretty old??

    Is the SQL Native Client package installed on the PC concerned, might be worth a shot - Search google for sqlncli.msi and download the appropriate version from MS

  8. #8
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    876
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    That's what I suggested

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Oh yes - sorry, missed that.

    Another one would be to try as administrator, FMS printing can be a bit funny with peoples profiles (usually around cheque printing though).

  10. #10
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Try upgrading to the latest version.

  11. #11
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I did get a work around. I copied the sims FMS folder from the server onto the effected machine and the problem has gone away for now anyway

  12. #12
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38

    SQL error

    This error message tends to suggest that there is a data type conversion of varchar to int that is starting with data that is not in an integer format, eg. 2.5 cannot be converted to an integer. Either the original input data is invalid or the SIMS programming, I can't tell which.

  13. #13
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thats what i thought. Its strange because everything was fine until some MS updates kicked in on the machine and messed with something. I copied the latest FMS files from the server and the error went away. We will test a bit more before finally closing the door on this one.

    Cheers, Ben

  14. #14
    garrysaddington's Avatar
    Join Date
    May 2007
    Location
    Hogsthorpe
    Posts
    89
    Thank Post
    3
    Thanked 25 Times in 16 Posts
    Rep Power
    38

    Data type conversion

    Perhaps a slack attitude to type conversion was tightened up in the upgrade.

  15. Thanks to garrysaddington from:

    ben_snclc (11th December 2009)

  16. #15
    ben_snclc's Avatar
    Join Date
    Nov 2009
    Location
    South Yorkshire
    Posts
    34
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by garrysaddington View Post
    Perhaps a slack attitude to type conversion was tightened up in the upgrade.

    Yes i think so. I'm glad we found a quick work around though or all payment runs would stop

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. FMS SQL Error
    By Rawns in forum Educational Software
    Replies: 6
    Last Post: 3rd June 2014, 03:18 PM
  2. SIMS, FMS and New Term
    By CadlaM in forum MIS Systems
    Replies: 6
    Last Post: 5th July 2009, 10:57 PM
  3. Reporting in SIMS FMS
    By cjohnsonuk in forum MIS Systems
    Replies: 1
    Last Post: 21st April 2009, 02:49 PM
  4. March Release FMS error
    By button_ripple in forum MIS Systems
    Replies: 22
    Last Post: 3rd April 2009, 09:10 PM
  5. Sims FMS problems
    By dave20046 in forum Windows
    Replies: 15
    Last Post: 25th February 2009, 11:13 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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