[sims] SIMS Scheduled reports

[GazN]

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

[vikpaw]

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.

[vikpaw]

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

[LosOjos]

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)

[vikpaw]

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.

[GazN]

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

[GazN]

Thanks to everyone how has helped me, I've finally got the reports to run.

[vikpaw]

Thanks to everyone how has helped me, I've finally got the reports to run.

Great news. What was the missing setting / problem?

[GazN]

I think I hadn't setup the permissions right in system manager 6. Thanks

[CarpeDiem]

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....!!!

[GazN]

My problem was not having added the Report Execution manager group and permissions in system manager 6. When this was done it all worked.

[RobertJM]

Can you elaborate on these permissions please. I don't see a group called Report Execution Manager in System Manager 6.

 

Thanks

 

Bob

[vikpaw]

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.

[RobertJM]

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

[vikpaw]

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? Edited January 13, 2014 by vikpaw

[RobertJM]

The SIMS login has sufficient rights (it's mine - in order to test the setup). I've posted a question back to Capita and their helpful reply was "The task should be set to a user (windows) who has sufficient permissions on the server."

 

The error message in the event log just says "user has insufficient rights to execute scheduled reports" (Event ID is 0)

 

I think it's to do with the local security policy and UAC. Although I have the task set to run with domain admin credentials and also set to run with highest privileges it still says user has insufficient permissions. I've started the autoreports.exe in a cmd window with run as administrator but still get the same error message.

 

Bob

[RobertJM]

Hi

 

Just picking this up again.

 

I have set the scheduled task to run with domain admin credentials, as the actual domain admin, as the SYSTEM account and as the server local admin account. I have the scheduled task configured for Windows Vista or Windows Server 2008 and have ticked the option to run with highest privileges.

 

The autoreports is configured to run as follows:

 

autoreports.exe /S:misbox /D:sims /U:myname /P:mypassword /R:k:\sims

 

All of these combinations tell me in the Application Event Log on the server that the user has insufficient permission to Execute Scheduled Report(s). I don't know who else has higher permissions over the server than any of these accounts. It's a Windows 2008 R2 server, running SQL2008 the installation of which is on a data partition and not the system partition. Capita's documentation is not up to date (there's a shock) for this environment.

 

It's really puzzling me.

 

Thanks

 

Bob

[vikpaw]

I vaguely remember that there is a weird permission to allow report scheduling. Or something you have to enable on a server to allow it to happen, but i forget what it was.

A quick google mentions log on locally rights, log in as a batch job, log in as a service, all permissions which might be needed. Also is the box a DC?

Can you setup a scheduled task to run a regular batch file to dir /b -> test.txt on local drive, but not root, somewhere with permissions. redirecting to a shared drive can be added later. If that works then it's something related to the autoreports.

[LosOjos]

Daft as it sounds, it could be fallout from the conficker virus (more specifically, an over zealous AV trying to prevent it). I had an issue setting up scheduled reports because the Windows folder permissions were all messed up. You can try googling it or if you hang on a while I'll find the link explaining it (and the solution)

[RobertJM]

No I've sorted it

 

I have noticed on page 79 of the Designing and Running Reports Manual there is the following

 

Execute Scheduled Report - users must have sufficient access rights to execute the scheduled report.

 

I have combed through the permissions tree and found the relevant permissions in Core then Home Page then Report Execution Manager and set all. Retried the operation and it's now running the report. Feel daft but ultimately it's sorted so I'm happy.

 

Thanks for all contributions

 

Bob

Edited October 4, 2013 by RobertJM

[vikpaw]

Good catch, of course the perms lie there, because you have to update the scheduled reports panel on the homepage where it tells you it ran!

Having looked, i have a group with that permission.