When the wrong table is chosen as the main table for a database view with a left join, and that database view is used as an indicator source, data collection jobs end with errors.
Steps to Reproduce
- Create a database view with a left join. Configure the database view so that the main table is incorrect for the specified join.
- Create an indicator source based on the database view.
- Create an automated indicator using the new indicator source.
- Create and run a data collection job for the new indicator.
Note that the job ends with errors.
There is no known workaround for this issue. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In field to determine whether any versions have a permanent fix.
Related Problem: PRB905555