Error Scheduling Reports for Intelligence Reporting

Error Scheduling Reports for Intelligence Reporting

Problem
There is an error scheduling reports to execute using the Windows Task Scheduler
Symptoms:
  1. The Report is scheduled but the BICore.exe process doesn't launch
  2. The report is scheduled but the BICore.exe launches but doesn't consume any memory and is therefore not processing
  3. The report is scheduled, BICore.exe launches but there is no processing done
  4. The report is scheduled, BICore.exe launches, there is processing but there is no Excel Output file created although the task executes effectively.
  5. The report runs perfectly when the radio button is set to "Run when user is logged on" but as soon as it is changed to "Run whether user is logged on or off", the task fails.
Applies to:
  1. Windows Server 2012, 2016, 2019
  2. Windows 8, 10
Solution
To resolve the issue, please following this process:
  1. Generate a new Scheduler command from the Report Manager for the report you would like to run
  2. Paste this command into a Notepad. and save it as a .bat file
  3. Make sure the .bat file is saved somewhere where you can locate it using a UNC path (\\ALCH-SRV\...)
  4. Create a new scheduled task, and point the action to start the .bat file. Make sure to navigate to this using the UNC Path.
  5. Set the user that runs the task as a FULL DOMAIN ADMIN
  6. Make sure the two following blank folders exist on the workstation
C:\Windows\System32\config\systemprofile\Desktop
C:\Windows\SysWOW64\config\systemprofile\Desktop