When a task runs a Knowledge Portal report in InTrust Server (as seen in InTrust Manager), the reporting job fails with the following error:
Report "Alerts Details" failed to process: An error has occurred during report processing. Query execution failed for data set 'MainDataSet'.
But when the same report is manual executed in Knowledge Portal, the report runs successfully.
The task account has all permissions to the config, audit, and alert databases and SRS (SQL Reporting Services).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.