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


    • Related Articles

    • Sharing Report Shortcuts using Intelligence Reporting

      Problem When you create a report shortcut, it creates and points to a file within the AppData directory of the user that created the shortcut, which in turn points to the BICore.exe on the machine. When another user tries to run the report shortcut, ...

    • Scheduling Alchemex Reports

      You would like your reports automatically emailed to particular users across your organisation It’s time to stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute themselves.  In this tip, ...

    • Downloading and Installing Intelligence Reporting

      1. Download Intelligence Reporting To download your version of Sage Intelligence, visit our website and choose the appropriate version. a) Visit our website here: https://www.alchemex.com.au/intelligence-reporting/#alchemextrial b) Choose the ...

    • Does Intelligence Reporting and CData support TLS 1.2?

      Question A recent upgrade from Microsoft has marked End of Life for TLS 1.0 and 1.1. I am using Intelligence Reporting and/or Cdata drivers selled by Alchemex and need to upgrade my servers. How will it affect my Reporting? Support for Intelligence ...

    • Installation of MYOB Live Intelligence Reporting (ODBCLink)

      How the product works We install a few products below that all work together to make a replication of your MYOBLive database on a local installation. The product that is doing the work is called ODBCLink which connects directly to MYOB live and ...