+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, FMS Problem in Technical; Hi guys, I have searched the forum to see if i could find the soloution to this problem without bothering ...
  1. #1

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    FMS Problem

    Hi guys, I have searched the forum to see if i could find the soloution to this problem without bothering you but i failed!

    FMS is bringing up the old:

    UNHANDLED EXCEPTION IN SIMS FMS MODULE
    General SQL Error.
    (Sybase)(OBDC Driver)Unable to Connect to database sever: unable to start database engine

    I've had a look on the server and the SQL_ANYWHERE service isn't running, and it won't start, even after a server restart.

    Any ideas and the finance staff are chewing my ear off!

    Thanks!

    Seb

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,115
    Thank Post
    512
    Thanked 2,313 Times in 1,789 Posts
    Blog Entries
    24
    Rep Power
    803

    Re: FMS Problem

    Have you tried re-installing FMS on the server?

    Rename the sqlany50 folder on the c: drive to something else, and the FINANCE folder wherever it is (either c:\program files\sims or d:\program files\sims usually) to finance.old, then follow the usual method of installing FMS. When you are asked for the database, enter the local path of the db file (here it is d:\simsarea\sims\sql). Ensure you choose the right options though (ie. tick the server option).

    This is what we did to get it working again when we had a similar problem.

  3. #3

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Problem

    Thanks for the quick reply localz,

    I haven't tried reinstalling FMS, to be honest i'm not that experienced with sims or fms and the guy who is, is off work.

    So unless there isn't another way, looks like i may have to reinstall fms on the server?

  4. #4

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    194
    Thank Post
    17
    Thanked 7 Times in 7 Posts
    Rep Power
    15

    Re: FMS Problem

    Make sure that no-one in the school currently has FMS open the:

    On your FMS server run, C:\SQLANY50\WIN32\DBSVMN50.EXE

    Stop the service and then start it. Usually works, if not will FMS run ok on the actual FMS server?

  5. #5

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Problem

    @dan

    The service isn't even running, it won't start. I've just tried to run FMS on the server and it brought up the same error as the client machines.

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,115
    Thank Post
    512
    Thanked 2,313 Times in 1,789 Posts
    Blog Entries
    24
    Rep Power
    803

    Re: FMS Problem

    Ok, just need to confirm that the database file is where it should be - go to start -> run on the server, and type odbcad32. Now on the 'system DSN' tab click on the SIMS32 item and click configure. Under 'database file' there should be a path - check that the file that is listed there actually exists where it should be.

  7. #7

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    194
    Thank Post
    17
    Thanked 7 Times in 7 Posts
    Rep Power
    15

    Re: FMS Problem

    Is there any indication in the system event log to indicate why the service has failed to start?

    If not then maybe rename the folder and try a reinstall but I've never done that either.

    If you don't want to reinstall FMS then you could try renaming the FMS folders and restoring them from last nights backup.

  8. #8

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Problem

    @ localz

    Database file is in order, where it should be

    @ dan

    The error in the event log is very vauge and unhelpful -

    The description for Event ID in Source (SQLANYs_SUMS_SQL_DB_Server) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. Could not start server

    Its a pain in the backside!

  9. #9

    Join Date
    Jul 2007
    Location
    Nottingham
    Posts
    194
    Thank Post
    17
    Thanked 7 Times in 7 Posts
    Rep Power
    15

    Re: FMS Problem

    mmmm, its died more than mine ever has I'm afraid. :x

    Load the service manager for SQL Anywhere again and you should be able to edit the service configuration by clicking edit.

    Check that the path to the exe is correct (C:\SQLANY50\WIN32\DBSRV50.EXE). I have no idea what all the parameters are for but for my server they are as follows:

    -n SIMS_Server -c 8192 -tl 1500 -x NamedPipes,TCPIP

    Hope this helps.

  10. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,115
    Thank Post
    512
    Thanked 2,313 Times in 1,789 Posts
    Blog Entries
    24
    Rep Power
    803

    Re: FMS Problem

    Is your SIMS managed by your county council or do you get your support via capita?

  11. #11

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Problem

    @ dan

    Says the same as yours mate, path for the exe and the parameters. May have to call for external support on this one, i don't want to got breaking the whole sims install!

  12. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,115
    Thank Post
    512
    Thanked 2,313 Times in 1,789 Posts
    Blog Entries
    24
    Rep Power
    803

    Re: FMS Problem

    I would advise calling external support - as the instructions I have here for reinstalling FMS may be different for your setup.

  13. #13

    Join Date
    Oct 2007
    Location
    March UK
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: FMS Problem

    @ localz

    We get support from capita, although i don't know much, theres one guy in the office who knows all about sims, but hes off ill. We're gonna give FMS a reinstall and see how that goes.

    It all appears to be down to this SQLANY service though, if it'd just start, fms would work, but it doesn't!

  14. #14

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    449
    Thank Post
    16
    Thanked 82 Times in 74 Posts
    Rep Power
    28

    Re: FMS Problem

    Have you tried re-starting the server, and removing its network cable, then re-starting the service? May sound strange but I have had a similar issue before which this resolved - I think its something to do with a client starting up a copy of the database server, and it wont start if it finds another one running on the network.

    Steve

  15. #15
    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
    29

    Re: FMS Problem

    Boy, after reading this I can't wait for FMS to goto SQL server

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

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
  •