[sims] SIMS Scheduled Reports - Arrrrghhhh!!!

[LucieP]

I have spent countless hours reading through various guides, handouts, snippets and forum threads, but I am still getting nowhere with this!

 

I cannot get any scheduled reports to run.

I believe that all accounts being used have the correct permissions and that the commands in the scheduler are correct. I am not getting any error messages when it runs but no reports either.

 

HELP!!

[Esteban_Child_of_the_Sun]

Have you created the custom permissions group in SIMS and assigned it to the user you are running the scheduler as? (That is usually the step missed)

[LucieP]

I believe so.......

[Esteban_Child_of_the_Sun]

it should look like this

[LucieP]

In that case, yes I have. It also has 'Execute Scheduled Report' enabled as well......

[Esteban_Child_of_the_Sun]

yes, that should have been in my screenshot too.

[Esteban_Child_of_the_Sun]

if you open a command prompt as the user you are running the scheduled task as, and run C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\AutoReports.exe

(taking in to account your setup for file location), does it say it is the version matching your version of SIMS?

If so then run the same with the arguments

 /S:Servername\SQLinstance /D:Databse /U:SIMSUser /P:Password 

(altered for your setup) Do you get any errors?

Edited June 23, 2017 by Esteban_Child_of_the_Sun

[CJLane]

I had this issue not so long ago. The issue was access in the Binn (Microsoft SQL Server) folder. Emmanuel from Capita recommended having access to all of the C:\. Once enabled, I used the scheduled task with the argument. And this worked.

[Esteban_Child_of_the_Sun]

Emmanuel from Capita recommended having access to all of the C:\.

This is why I don't let Capita on our servers without very close supervision. The security holes they open up, you may as well put up a neon sign to all ransom ware saying "Free Money Here!"

[LucieP]

OK, Esteban - I have checked the command prompt in the scheduled task and is the same as you have - no error report, but still no reports either

 

CJLane - have tried this as well and still nothing. My user account has full control permissions to the drive containing the binn folder

 

???????

[jthompson]

We have ours set to run the Windows Scheduled Task as SYSTEM (on the SIMS server).

[LucieP]

 

Thank you sooooooooo much!!! You have all helped to make me very popular!!

xxx

[Esteban_Child_of_the_Sun]

the first thing to look for, is in the Binn folder, is there a connect.ini file with a modification of the time you ran the command? If so does it have the correct information in it? (Mine looks like this)

[sIMSConnection]
ServerName=MIS-Server\SIMS2012
DatabaseName=SIMS
ServerType=SIMSSQL
[Reports]
Timeout=300
MaxNumberOfTableJoins=1

[Esteban_Child_of_the_Sun]

Also worth noting, the homepage refresh time for the Scheduled report widget is very long so to check it worked you'll need to close and re-open the SIMS homepage.