MIS Systems Thread, SIMS FMS - 6.83 to 6.85 upgrade issues in Technical; Okies, I know I am very far behind on this one, but having taken over SIMS FMS support last year, ...
27th July 2009, 02:47 PM #1
SIMS FMS - 6.83 to 6.85 upgrade issues
Okies, I know I am very far behind on this one, but having taken over SIMS FMS support last year, it took me long enough to migrate it to a new server before looking into the upgrade path. We do not use SIMS.net for our MIS so it is not installed on the server.
I've logged things with Capita to whom we do pay annual support for FMS but they are not exactly helpful given support on 6.83 is no longer available.
I obviously have a working 6.83 installation on a Windows 2003 SP2 Server with SQL Server 2005. I have replicated this installation on a test server to sort out the upgrade process before upgrading the live system.
I have the 6.85 upgrade CD and the 6.91 CD. If I run Solus.exe from the 6.85 CD I am told:
The SIMS.INI file does not contain a setting indicating the location of the SIMS.net Progam Files. Please indicate where SOLUS can find the SIMS.net Program files by setting the SIMS.INI file correctly.
If I download the latest Solus is tells me:
This machine could not be validated as a SIMS/FMS workstation or SQL Server. This installer requires valid entries for SIMS or FMS to be present in the SIMS.ini located in the system folder e.g. C:\Windows
My SIMS.INI contents are:
[CONFIG32] Params=c:\vol1\SIMS\FMS\SQL\ c:\SQLANY50\ c NamedPipes,TCPIP
I am so far lost in what I should be doing to get this upgrade to work. If anyone can point me in the right direction I would be eternally grateful!
IDG Tech News
27th July 2009, 02:53 PM #2
Just donwe the same upgrade as it happens... here's my SIMS.ini (a little bigger than yours!)
The X: in mine replaces the usual S: because I'm awkward.
SIMSDotNetDirectory=C:\Program Files\SIMS\SIMS .net
OfflineSQLAppsDirectory=d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
SIMSSQLAppsDirectory=d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
SIMS Attendance Key 8pt (VGA res)=SIMSATT.FON
SIMS Monospaced 6,8pt (VGA res)=SIMSMONO.FON
SIMS Field Navigator 8pt (VGA res)=SIMSFNAV.FON
SIMS Clear 'a' font 8,10,12,14,18,24pt (VGA res)=SIMSCLRA.FON
27th July 2009, 03:04 PM #3
Cheers - it can't be a setting in there then, as adding any of those in makes no difference?
27th July 2009, 03:08 PM #4
Latest solus still gives the same error - the 6.85 solus runs now, but doesn't accept my FMS login and if I choose 'Trusted' it complains of an unhandled exception.
27th July 2009, 03:33 PM #5
Trusted isn't support for FMS. Can you log on to FMS? Are you using the new version? If so have attached a blank database? Have you tried the default user\pass?
27th July 2009, 03:44 PM #6
I can login to FMS with the sysman password which we have changed, if I login to solus with this it tells me 'Login failed for user _sysman' and complains of an unhandled exception.
27th July 2009, 05:58 PM #7
FMS is still it's own installation package and therefore has it's own ini file:
Here is a copy of my FMSConnect.ini
Also a copy of FMSLoad.ini
There is also another ini file called finrep.ini and here is it's content:
; Last change: VR 10 Nov 99 12:58 pm
Word for Windows Format=
[Formats For Full Report]
Comma Separated Values Format(CSV)=
Tab Separated Values Format=
Rich Text Format =
[Word for Windows Format]
Filter=Word for Windows (*.doc)|*.doc
Filter=Excel Worksheet (*.xls)|*.xls
[Comma Separated Values Format(CSV)]
Filter=Comma Separated (*.csv)|*.csv
[Tab Separated Values Format]
Filter=Tab Separated (*.tsv)|*.tsv
[Rich Text Format]
Filter=Rich Text Format (*.rtf)|*.rtf
Hope this helps you.
28th July 2009, 10:18 AM #8
i was having problems with setting up a test fms install, at some point you need to run fms applications set up and also surprisingly sims applications. maybe they are linked in some way. do you have access to run sims applications setup, even though you don't run it and have no sims server it might put some files in place you need.
28th July 2009, 11:34 AM #9
I just bit the bullet when we had to do it - and paid them to come in - and I was very glad too - as the guy couldn't get it to play nicely and had to move all the data off onto a clean laptop to do the upgrade and then move it back - yeuch!
28th July 2009, 11:54 AM #10
incidentally, for once, had no problems with the June upgrade neither SIMS nor FMS had any issues and both upgraded ok.
I'll probably find problems when the users come back and they can't access FMS but will wait until early September for that rather than pre-empt it now.
30th July 2009, 04:08 PM #11
Capita have sent me the upgrade CD's for 6.83-6.85 and subsequent versions onwards, however Solus is still required to go from 6.83 to 6.85.
For whatever reason there is nobody on the ICT Support Desk at Capita this afternoon, nice afternoon off for them maybe!
I do not have access to the SIMS applications and have asked Capita for further advice on how I am supposed to upgrade FMS - we don't even have a licence for Solus/Solus support apparently either.
I can see myself dragging out the 2yr old original SIMS/FMS Server that we decommissioned just to see if I can upgrade that version to 6.85 and that might be a very painful workaround.
For those that paid Capita to do this, how much did it cost?
11th August 2009, 12:06 PM #12
No idea why no-one at Capita told me this before, but the 6.85 upgrade CD has a '6.85' folder on. Within it are a number of exe's but most of these give an error when run - if you go through all of them the last 5 or so all run correctly and you can then run the DBUpgrade exe, then FMS Module which upgrades the FMS files to 6.85.
By adamf in forum MIS Systems
Last Post: 2nd July 2008, 09:02 PM
By Jake in forum MIS Systems
Last Post: 3rd April 2008, 03:47 PM
By wesleyw in forum MIS Systems
Last Post: 3rd April 2008, 09:58 AM
By cjohnsonuk in forum MIS Systems
Last Post: 5th March 2008, 09:51 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)