This can be the compendium of bugs or the pinnacle of features. It resides on the eye of the beholder. Nevertheless it can be from annoying to dangerously close to halt your production DW DB. You can say that business objects are trying to refresh every single LOV in a universe by looking at the queries that are being send at the target DB. All of them should include the magic Clause: Distinct.
The source of all that hassle is an application that scans the system and maintains an index for search porposes from within BI Launch pad (formerly known as InfoView). The Platform Search application's options can be found at CMC. Log in to CMC. Go to Applications.
Then open platform Search application options. The solution to the issue is simply to change the default options for the crawler.
The Platform Search application is configured by default to "Continuously crawl".
Further more the Scope of Indexing is set to Full Content and all resources are being checked.
Change continues crawl to schedule mode and select a time appropriete (e.g during the night cycle). Further more you can deselect universes and change full content to Platform metadata only. The final result should be something like that:
The source of all that hassle is an application that scans the system and maintains an index for search porposes from within BI Launch pad (formerly known as InfoView). The Platform Search application's options can be found at CMC. Log in to CMC. Go to Applications.
Then open platform Search application options. The solution to the issue is simply to change the default options for the crawler.
The Platform Search application is configured by default to "Continuously crawl".
Further more the Scope of Indexing is set to Full Content and all resources are being checked.
Change continues crawl to schedule mode and select a time appropriete (e.g during the night cycle). Further more you can deselect universes and change full content to Platform metadata only. The final result should be something like that:
