+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 35
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 ...
  1. #16

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    @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 09:56 AM. Reason: sense

  2. Thanks to vikpaw from:

    Rawns (14th October 2011)

  3. #17

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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.

    http://www.microsoft.com/download/en/details.aspx?id=3508


    Last edited by vikpaw; 8th October 2011 at 10:56 AM. Reason: add link

  4. Thanks to vikpaw from:

    Rawns (14th October 2011)

  5. #18

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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 ]

  6. Thanks to vikpaw from:

    Rawns (14th October 2011)

  7. #19

    Join Date
    Dec 2009
    Posts
    4
    Thank Post
    3
    Thanked 2 Times in 1 Post
    Rep Power
    0
    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
    "HKCU\Software\Microsoft\Office\14.0\Common\Genera l\UserTemplates"
    exists and has the value of the changed UserTemplates location. e.g "F:\Word_Templates"

    To Remedy:
    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

  8. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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.

  9. #21
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    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.

  10. Thanks to Rawns from:

    duncane (21st February 2012)

  11. #22

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    Quote Originally Posted by Rawns View Post
    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.
    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.
    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

  12. #23

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    UPDATE -
    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 07:34 AM.

  13. #24
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    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.

  14. #25

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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.

  15. #26
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    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 04:19 PM.

  16. #27

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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..?

  17. #28
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    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..?
    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.

    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.

  18. #29

    Join Date
    Nov 2010
    Location
    Great Grimsby
    Posts
    72
    Thank Post
    7
    Thanked 2 Times in 2 Posts
    Rep Power
    8
    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.

  19. #30

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,335
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    Not a popular message but I'd recommend re-creating the templates in 2012. We have found problems sometimes when old templates are used.

  20. Thanks to PhilNeal from:

    DeeGee (28th March 2012)

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. IMS Support Specialist (SIMS.net) – Office Based (South Croydon)
    By HollyKeen in forum Educational IT Jobs
    Replies: 2
    Last Post: 7th July 2011, 08:49 AM
  2. [SIMS] SIMS Spring 2011 and Office 2010
    By eddyc in forum MIS Systems
    Replies: 3
    Last Post: 11th May 2011, 09:13 AM
  3. Replies: 0
    Last Post: 4th February 2011, 12:21 PM
  4. [SIMS] SIMS .net and FMSSQL Autumn 2010 released!
    By matt40k in forum MIS Systems
    Replies: 5
    Last Post: 24th November 2010, 10:14 PM
  5. SIMS .net does not fully support Open Office
    By mark in forum MIS Systems
    Replies: 24
    Last Post: 28th March 2008, 09:57 AM

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
  •