jamesmay Posted June 24, 2011 Posted June 24, 2011 I've just moved our SIMS server over to a virtualised one, but in addition to this we have moved our admin machines over to thin clients (Ncomputing on Multipoint 2011). SIMS works fine, but FMS reports that Crystal reports are not installed. When in FMS, reports can be run, but I'm expecting a bararge of calls on Monday morning that I've broken FMS. All the DLLs and Windows folder have been replicated to the users profiles and checked the crystal reports registry settings to ensure that they are pointing at relevant places. Any ideas?
localzuk Posted June 24, 2011 Posted June 24, 2011 I had the same issue - http://www.edugeek.net/forums/mis-systems/25094-terminal-server-sims-net-fms.html 1
jamesmay Posted June 24, 2011 Author Posted June 24, 2011 I saw that, just wondered if anyone had come up with a fix in the last 3 years. It works, but its annoying me!
dhicks Posted June 24, 2011 Posted June 24, 2011 (edited) FMS reports that Crystal reports are not installed. When in FMS, reports can be run, but I'm expecting a bararge of calls on Monday morning that I've broken FMS. All the DLLs and Windows folder have been replicated to the users profiles and checked the crystal reports registry settings to ensure that they are pointing at relevant places. I'm just doing the same thing, installing the SIMS and FMS clients to a Windows Server 2008 R2 machine for Remote Desktop Services access. I've done this before on a Windows Server 2003 machine, as noted here: http://www.edugeek.net/forums/mis-systems/36755-sims-under-terminal-services.html One thing I notice from that thread was the line "If you also will be using FMS ensure that Crystal Reports is installed via the simsapplications.exe file, else printing will not work." Currently, our client machines run SIMS locally. SIMS, FMS and SchoolComms are installed via a batch file: @echo off echo Installing SIMS... net use s: \\kssims\SimsShare /PERSISTENT:no \\ks-nas1\Software\SIMS\install.exe copy "\\ks-nas1\Software\Sims\connect.ini" "C:\Program Files\SIMS\SIMS .net" echo ...with FMS... S:\SIMS\Setups\FMSApplicationSetup.exe mkdir "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\WINDOWS\system32" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\Program Files\SIMS\SIMS .net" echo Sims Directory=C:\Program Files\SIMS\FMSSQL>>C:\WINDOWS\sims.ini copy "\\ks-nas1\Software\FMS\PDOXUSRS.NET" "C:\" echo ...and SchoolComms... \\ks-nas1\Software\dotNet\4.0\dotNetFx40_Full_x86_x64.exe /passive /norestart msiexec /i \\ks-nas1\Software\SchoolComms\7.2\Schoolcomms72H.msi /qb- s: cd S:\SIMS\Setups call simsperm.bat CAMELOT\KS-SEC-ADMIN call simsperm.bat CAMELOT\KS-SEC-SIMS call simsperm.bat CAMELOT\KS-SEC-SMT call simsperm.bat CAMELOT\KS-SEC-TEACH SubInAcl /FILE "C:\PDOXUSRS.NET" /GRANT=CAMELOT\KS-SEC-ADMIN=F c: I've ran that same install script on our Server 2008 R2 machine, in "install" mode from the command line, and all install procedures seemed to complete. Time to start testing... Edit: This thread might also come in handy: http://www.edugeek.net/forums/mis-systems/63553-sims-via-ts-remoteapp-server-2008r2-2.html#post590407 Edited June 24, 2011 by dhicks
matt40k Posted June 24, 2011 Posted June 24, 2011 I've just moved our SIMS server over to a virtualised one, but in addition to this we have moved our admin machines over to thin clients (Ncomputing on Multipoint 2011). SIMS works fine, but FMS reports that Crystal reports are not installed. When in FMS, reports can be run, but I'm expecting a bararge of calls on Monday morning that I've broken FMS. All the DLLs and Windows folder have been replicated to the users profiles and checked the crystal reports registry settings to ensure that they are pointing at relevant places. Any ideas? You haven't set Windows to install mode.
jamesmay Posted June 25, 2011 Author Posted June 25, 2011 do you mean maintenance mode in MPS. FMS runs and prints fine from what I can tell, just an annoying box at start up saying its not installed, whichi i know the bursar will pick up on first thing monday morning and think there is a problem..
matt40k Posted June 25, 2011 Posted June 25, 2011 Run CMD as administrator change user /install [enter]s:\ s:\setups\fms\fmsapplicationsetup.exe [enter] Above should sort it. Below is to make sure it runs as the user without any extra permissions (I just need to add to it) Change the FMS shortcut to "run in" c:\programdata\all users\app data\capita Change BDE PDOXUSR.NET to c:\programdata\all users\app data\capita
jamesmay Posted June 25, 2011 Author Posted June 25, 2011 fantastic, that seems to of worked, can you explain the second bit of ur post?
matt40k Posted June 29, 2011 Posted June 29, 2011 Sorry, was rushing that day... not sure about the paths, I'm still suck on XP here, so have to find a W7 to check it's correct. Change the FMS shortcut to "run in" c:\programdata\all users\app data\capita FMS will write files to the "Run In" path, default is the program files\sims\fmssql folder. Change it to somewhere the users does have read\write access then they only need read to the folder - assuming your doing the upgrades\using SOLUS3 Change BDE PDOXUSR.NET to c:\programdata\all users\app data\capita By default BDE config file is located in the root of C:, you need to put it in a folder that all users have read\write too... and is local. Open BDE Administrator from Control Panel Tip: You may need to switch to Control Panel to Classic View Select Configuration tab Expand Configuration > Drivers > Native Select PARADOX Change the NET DIR to [NEW PATH] Click Object > Apply Click OK to confirm saving changes. And OK to confirm message. Close BDE Administrator 1
dhicks Posted July 5, 2011 Posted July 5, 2011 S:\SIMS\Setups\FMSApplicationSetup.exe mkdir "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "C:\Program Files\SIMS\Finance" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\WINDOWS\system32" copy "\\ks-nas1\Software\FMS\FMSConnect.ini" "c:\Program Files\SIMS\SIMS .net" echo Sims Directory=C:\Program Files\SIMS\FMSSQL>>C:\WINDOWS\sims.ini copy "\\ks-nas1\Software\FMS\PDOXUSRS.NET" "C:\" Right: so I'm no getting the "Create User DSN Has Failed" error message whenever I try and start FMS. I've searched Google and these forums, and have of course come accross this post: http://www.edugeek.net/forums/mis-systems/29918-create-user-dsn-has-failed.html However, trying the solutions in that thread has not, so far, given a succesful result. I've tried installing the SQL Native Client driver and manually creating a User DSN called "SIMS_FMS_DATABASE", but I still get the same error message. Is there some other fix I can try, or am I missing some part of FMS' setup? In particular, I don't get how manually creating a User DSN is going to help - surely that's what FMS tries (and, currently, fails) to do when it starts? Isn't FMS trying to create SIMS_FMS_DATABASE for the current user on startup and finding it can't for some reason?
matt40k Posted July 5, 2011 Posted July 5, 2011 David - Scripting #CapitaSIMS FMS installation #Windows7 | Matt40k 1
dhicks Posted July 6, 2011 Posted July 6, 2011 David - Scripting #CapitaSIMS FMS installation #Windows7 | Matt40k Many thanks. Unfortunatly, I've already moved the PDOXUSRS.NET file to C:\Paradox and manually changed the settings via the BDE Administrator in the Control Panel appropriatly - still no luck. I think I'm going to try a complete reinstall of SIMS and FMS from scratch - I seem to have SIMS install folders split over "Program Files" and "Program Files (x86)" which is probably causing some confusion.
matt40k Posted July 6, 2011 Posted July 6, 2011 Is this when you login? Did you set it to install mode? Do you have a default printer? 1
dhicks Posted July 6, 2011 Posted July 6, 2011 (edited) Is this when you login? Login? You mean as a particular user (in my case, of course, with admin rights, which might cause some confusion)? I've logged in to the server as myself, the network administrator account and I've had one of the accountancy staff log in to test FMS. All login accounts get the same result when they start FMS, an eror message reading "Could not create user DSN". > Did you set it to install mode? Oh bother. I did originally, but I've just done a resinstall and forgot that step. Theorectially, Server 2008 R2 is meant to be able to spot install operations and react accordingly, I guess we'll see how well that actually works... Do you have a default printer? No, but it's a good point, I'll set one up. I've now got SIMS, FMS and SchoolComms reinstalled from scratch, this time making sure everything installs in "C:\Program Files (x86)" instead of half in "C:\Program Files". I've kept PDOXUSRS.NET in a separate folder, not the root of C drive, and made sure the BDE Administrator knows where it is. FMS now seems to be working - I'll just nip down and get the accountancy staff to see if they can run it. Edit: Yes, all seems fine. Hooray! Edited July 6, 2011 by dhicks
matt40k Posted July 7, 2011 Posted July 7, 2011 I think they might be fixing the printer issue - 1105-****** Description: If a default printer is not present FMS fails to login [31/05/2011] Progress Update: The case is under investigation. [21/06/2011] Progress Update: The application build has been prepared and is now under review with a senior developer. Roll on the Autumn 11 release? 1
ChrisMiles Posted July 7, 2011 Posted July 7, 2011 I had the same issue - http://www.edugeek.net/forums/mis-systems/25094-terminal-server-sims-net-fms.html To fix this crystal reports error when exporting to XLS form FMS and possibly the other crystal reports errors posted here try copying the following files into the C:\Program Files\SIMS\Finance folder (or wherever you have installed FMS). crpe32.dll u2ddisk.dll u2fwordw.dll u2fxls.dll The files should all be dated 09/30/1997 and should either be found in c:\windows\system32 or c:\windows\crystal on a pc with a working installation. The files do not need to be in the windows folder where they are installed to nor do they need registering. I had to figure out this fix because one of our other pieces software overwrote these files with a new version of crystal reports and broke FMS for us I have attached the needed files if you cannot find them.FMS DLLs.rar 1
matt40k Posted July 7, 2011 Posted July 7, 2011 That's good to know, will give that a go, you can copy the fmsapplicationsetups.exe and then change the extension to .zip then you can just extract them like that.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now