MIS Systems Thread, SIMS .net / Office 2010 in Technical; @Rawns - i've merged your thread in here.
@all - I need to combine the other related threads into here ...
8th October 2011, 10:53 AM #16
@Rawns - i've merged your thread in here.
@all - I need to combine the other related threads into here really, the most notably workaround we've had was in the other thread, but i can't think which one. This error is an odd one, and i find it happens a lot of photo reports. But can happen with others, i think it's more the template itself.
There are two big issues i have found, printing individual reports fails with "SIMS has encountered an error". If you look it is going to the C: drive users folder under appdata\local\temp . The others probs seem to go to "My SIMS Documents" or tempsimsrpts folder which usually goes to whereever the 'My Documents' / 'Documents' is redirected to.
For this latter problem, where it has an object error it seems to be to do with having access to a template file from Word. Opening a different type of Word file in another section seems to release this lock. At one point i managed to track down the fact that on first open, the user was the owner but later this changed to a system account. I haven't repeated those findings this academic year though as there have been many system changes. We've tried changing the redirected folders to go to a mapped drive, rather than full UNC path, to no avail as yet.
It also affects late letters, which i guess is doing similar with it's mailmerge routine to the reports using wordlist templates which also pull in variables.
One user on SupportNet said that opening a student's linked documents prior to printing an ind. report run, stopped the first issue (sims encountered an error). So it all seems related to opening templates, locks on the files, permissions, and roaming-ness. Each set up is different and so hard to troubleshoot, one of the main reasons i haven't logged a case yet, as i can't prove it's SIMS though i'm certain it's to do with the way SIMS uses Office in a windows environment.
At the moment, i just keep retrying the report, or a different report, then try quickletters, or a late letter, one of them then releases the lock. Usually, i only need to try another type of report at most twice then can return to the one i want to use. Luckily it's not been a major issue for users as yet.
No joy with printing. I spent ages last year, and have got 3-4 scripts, that will rename .xml to .doc, or do bulk printing of .xml files, in a way that prints them in order, so the workaround is to export to a folder, and then print later. Otherwise, i'm thinking of creating a local user account for the guy who does the ind. report printing, but it would be easier to just give him a virtual win7 box to do it on, so he can still do other work, and email etc.
Last edited by vikpaw; 8th October 2011 at 10:56 AM.
Thanks to vikpaw from:
Rawns (14th October 2011)
8th October 2011, 11:17 AM #17
Shoot, i totally forget.
Worth trying to run the Office 2010 Interop Primary Assemblies, it's called something like that, from 2010, it's an MSI you can run. It worked for someone on SupportNet, so worth a go. Didn't make any difference on my test machine.
Last edited by vikpaw; 8th October 2011 at 11:56 AM.
Reason: add link
Thanks to vikpaw from:
Rawns (14th October 2011)
10th October 2011, 02:39 PM #18
Here is a great little fix that so far has sorted out the Inability to print multiple reports out of SIMS. Just came across it a few days ago on SupportNet and finally tested it out. Seems to work a treat.
It may sort other issues, so might be worth a try @Rawns
Description of the Word 2010 hotfix package (Word-x-none.msp): June 28, 2011
[Thanks to Catherine on SupportNet for pointing it out ]
Thanks to vikpaw from:
Rawns (14th October 2011)
14th October 2011, 04:22 PM #19
- Rep Power
Recent problems with Office 2010 and printing SIMS reports as 'Word List Report' issue.
Problem occurs when running Word List Reports-Report will preview without an error. Running Word List Report will produce an output first time the report is run then gives an Error: Object reference not set to an instance of an object. until the User logs out of SIMS and deletes "tempSimsRpt" folder in My Documents.
Repairing Office, reinstalling on SIMS affected workstation and installing Microsoft Office 2010: Primary Interop Assemblies had no effect.
The root cause of the problem in our case seems to be when the the location of Microsoft Word User Templates has been changed from the default
The following Reg Key
exists and has the value of the changed UserTemplates location. e.g "F:\Word_Templates"
Deleted the above "HKCU\Software\Microsoft\Office\14.0\Common\Genera l\UserTemplates" Reg Key
Browsed to folder "F:\Word_Templates" (\\Server\Server_Share\Word_Templates), renamed "Normal.dotm" to "OldNormal.dotm"
Word will then set the template location to the default location and recreate the "Normal.dotm".
Windows XP: %userprofile%\Application Data\Microsoft\Templates\Normal.dotm
Windows 7: userprofile%\AppData\Roaming\Microsoft\Templates\N ormal.dotm
15th October 2011, 07:05 AM #20
That's really interesting rob_l - that would be another reason, local profiles work, as the redirection will only be for roaming users (...?)
I don't think the temp files are able to cope with the location of redirected folders.
The other issue it could be is if the mapping to the F drive is not visible. I found that some programs are fussy about how they 'see' locations, some will use the F: others will translate that to the full path, one works the other doesn't.
I'd be interested to see if that hotfix had any effect on your system, before the reg key change.
31st October 2011, 05:33 PM #21
Had a response from Capita who have suggested all the options posted above. There were two other things to try which I will give a go tomorrow:
1. With the suer logged in, delete ALL files in the TempSIMSRpt folder and log back into SIMS to test.
2. Run SIMSPerm.bat and then try again.
Thanks to Rawns from:
duncane (21st February 2012)
1st November 2011, 07:03 AM #22
The first is the normal thing to try and i've done it many times, even changing where the temp folder is in the profile (roaming / local) to see if it made a difference. It didn't.
Originally Posted by Rawns
I doubt very much if it's permissions, besides, most affected users are using windows 7, and i'm not sure simsperm deals with it how it needs.
Are you still having problems @Rawns ? The hotfix seems to have fixed the bulk of the problems for us. Yesterday i moved to a shiny new Win7 box with Office 2010, so i'll be doing some testing today, pre and post hotfix. I'm pretty confident it should be fine, but i'll be leaving the XP box available for a while yet, just in case. I think i might make it virtual
1st November 2011, 08:25 AM #23
Before Hotfix : SIMS has encountered an error
After Hotfix : Bulk printing from ind.reps with no problem.
That fix is HOT
Last edited by vikpaw; 1st November 2011 at 08:34 AM.
8th November 2011, 12:54 PM #24
No joy here unfortunately. We have a handful of users in 4/5 different schools now all suffering the same issue. Every solution from Capita has done nothing and they have drawn a blank. They have advised that they know about the issue and think it's an issue with their templates. One ICT manager in a school did some research into this and thinks it could be down to the macro containing the € symbol in it, however I can't seem to find the macro code in any of the SIMS office documents.
So we now await Capita. No idea how long they will able though to fix this.
15th November 2011, 09:29 AM #25
Some of the files in tempSimsRpt have macros, e.g. the rtf template. Some are just generated files though. The way to find them is at the design stage of which ever report, on the template itself, if you enable the developer tab in word / excel, you should be able to find the macros.
The hotfix was a fix to the macros, namely the printout method is the one i think that sorted our bulk printing issue, but it also seemed to sort out the tags not pulling through. Not sure if it was supposed, to but it just does.
A few people on SupportNet saying they have tried both the hotfix and the list of suggestions as above to no joy.
17th January 2012, 05:16 PM #26
Found what appears to be a fix process that works:
1. Install this hotifx: Description of the Word 2010 hotfix package (Word-x-none.msp): June 28, 2011
2. Install the Interop Primary Assemblies: Download: Microsoft Office 2010: Primary Interop Assemblies Redistributable - Microsoft Download Center - Download Details
3. Add C:\USERS to the Trusted Locations area in Word (Enable 'All subfolders' too)
4. Add users H: drive to the Trusted Locations area in Word (Enable 'All subfolders' too)
Worked a treat. Glad we have a way to combat these pesky problems now!
Last edited by Rawns; 17th January 2012 at 05:19 PM.
18th January 2012, 06:48 AM #27
Cool, that's basically what we've found, though i didn't find the Interop Assemblies did much, it was mentioned by someone on SupportNet who found it useful.
That trusted locations one is a new one though, worth a try.
Can you specify what you define as the H drive? is this just their My Documents folder / homedrive..?
18th January 2012, 09:41 AM #28
To be honest, I'm not 100% sure it is doing much either. As it was suggested here as a possible solution, I put it in the process, and the fact it's only 6Mb or so and takes no time at all to install, it was better to be safe than sorry.
Originally Posted by vikpaw
In a standard Somerset setup, their H drive is exactly that, their own "My Documents" area on the network that gets mapped every time a user logs in. I've found that in most instances, SIMS uses it to put the 'My SIMS Documents' and 'tempSimsRpts' folders.
28th March 2012, 10:15 AM #29
- Rep Power
Could someone quickly let me know how best to convert my existing templates to Office 2010? I'm currently running all reports and profiles on a VMWare machine with 2003 installed because results fields aren't populated correctly in 2010. I'd really rather use the more up-to-date package, if I may.
28th March 2012, 10:25 AM #30
Not a popular message but I'd recommend re-creating the templates in 2012. We have found problems sometimes when old templates are used.
By HollyKeen in forum Educational IT Jobs
Last Post: 7th July 2011, 09:49 AM
By eddyc in forum MIS Systems
Last Post: 11th May 2011, 10:13 AM
By mattx in forum Windows
Last Post: 4th February 2011, 01:21 PM
By matt40k in forum MIS Systems
Last Post: 24th November 2010, 11:14 PM
By mark in forum MIS Systems
Last Post: 28th March 2008, 10:57 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)