+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 21
MIS Systems Thread, SIMS Scheduled reports in Technical; I was wondering if any one had an success running SIMS scheduled reports ? I have a school asking for ...
  1. #1
    GazN's Avatar
    Join Date
    Oct 2011
    Location
    St Aspah
    Posts
    23
    Thank Post
    2
    Thanked 7 Times in 6 Posts
    Rep Power
    7

    SIMS Scheduled reports

    I was wondering if any one had an success running SIMS scheduled reports ? I have a school asking for them to be set up and have followed the set up instructions I received from Capita support but the reports don't seem to be running on the server. Not sure where I'm going wrong. Thanks

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Works fine here.
    make sure the user running the task has the right permissions and the SIMS user has permission to the data for each report.
    i went step by step through the Capita reference sheet on how to set it up and it worked.
    check the task runs, or tr it manually. Make sure the report runs manually too. Then check your scheduled reports panel and it should be there.

  3. Thanks to vikpaw from:

    GazN (27th June 2013)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    The document i had is no longer available, but i think it's all pretty much covered in the standard reports manual. Is this what you used? : Section 8 - http://simspublications.com/204564/Report.pdf

  5. Thanks to vikpaw from:

    CarpeDiem (14th February 2014)

  6. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    If all else fails, you could always create a simple BAT script to run them via CommandReporter and add a scheduled task for the script in Windows (though the username and password will be stored as plain text inside the script, unless you use AD authentication of course)

  7. Thanks to LosOjos from:

    GazN (27th June 2013)

  8. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    The process is nigh on the same anyway, just running autoreports.exe instead of command reporter, plus it then when it works pops up for the users on their panel.

  9. #6
    GazN's Avatar
    Join Date
    Oct 2011
    Location
    St Aspah
    Posts
    23
    Thank Post
    2
    Thanked 7 Times in 6 Posts
    Rep Power
    7
    I'm still having problems, the account to run the tasks is a local administrator and the SIMS account is our LA account which is System Manger/School Administrator level

  10. #7
    GazN's Avatar
    Join Date
    Oct 2011
    Location
    St Aspah
    Posts
    23
    Thank Post
    2
    Thanked 7 Times in 6 Posts
    Rep Power
    7
    Thanks to everyone how has helped me, I've finally got the reports to run.

  11. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by GazN View Post
    Thanks to everyone how has helped me, I've finally got the reports to run.
    Great news. What was the missing setting / problem?

  12. #9
    GazN's Avatar
    Join Date
    Oct 2011
    Location
    St Aspah
    Posts
    23
    Thank Post
    2
    Thanked 7 Times in 6 Posts
    Rep Power
    7
    I think I hadn't setup the permissions right in system manager 6. Thanks

  13. #10

    Join Date
    Mar 2012
    Posts
    46
    Thank Post
    17
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Also have issues, what permissions did you alter? Although I did find out that staff for whom it did work didn't even know it was there....!!!

  14. #11
    GazN's Avatar
    Join Date
    Oct 2011
    Location
    St Aspah
    Posts
    23
    Thank Post
    2
    Thanked 7 Times in 6 Posts
    Rep Power
    7
    My problem was not having added the Report Execution manager group and permissions in system manager 6. When this was done it all worked.

  15. 2 Thanks to GazN:

    CarpeDiem (4th July 2013), vikpaw (5th October 2013)

  16. #12

    Join Date
    Jan 2012
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Can you elaborate on these permissions please. I don't see a group called Report Execution Manager in System Manager 6.

    Thanks

    Bob

  17. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by RobertJM View Post
    Can you elaborate on these permissions please. I don't see a group called Report Execution Manager in System Manager 6.

    Thanks

    Bob
    I never used anything like that. If you follow the instructions I linked earlier then the sims user it runs as just needs the permissions to show whatever data is bring requested.

  18. #14

    Join Date
    Jan 2012
    Posts
    5
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Vikpaw

    Thanks for that I've done all that (but for Windows 2008 task scheduler library). It looks like permissions on the server are blocking it (autoreports is set to run with domain admin credentials and highest privileges) as event viewer reports insufficient permissions.

    Bob

  19. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    The scheduled task is set to run as domain admin level...? But the autoreports requires a sims login, does this login have sufficient rights? It could be that entity that doesn't have the permissions. Is the error message more detailed?
    Last edited by vikpaw; 13th January 2014 at 05:07 AM.

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

Similar Threads

  1. [SIMS] Re: SIMS MIS reporting error
    By philserre in forum MIS Systems
    Replies: 3
    Last Post: 28th January 2013, 11:00 AM
  2. [SIMS] SIMS .net Report Supplier
    By Shuriken1 in forum MIS Systems
    Replies: 7
    Last Post: 25th August 2012, 12:25 PM
  3. [SIMS] SIMS Annual Reporting
    By laserblazer in forum MIS Systems
    Replies: 12
    Last Post: 6th December 2010, 11:03 AM
  4. [SIMS] SIMS.net Reporting
    By MikeW in forum MIS Systems
    Replies: 2
    Last Post: 24th November 2010, 11:11 AM
  5. SIMS.net Schedule Reports
    By manxdan in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2007, 10:53 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
  •