You can translate the question and the replies:

"The join requires generating too many search methods" Error

Hi Denodo team, We have facing below issue while creating a Join between two views: Finished with error: The join requires generating too many search methods. Reduce the number of obligatory fields/parameters in the join conditions. The same join is performed on another environment, using same tables and same database... any ideas? Thanks in advance!
user
19-11-2019 12:40:27 -0500

1 Answer

Hi, This error seems to point out that the problem is related to the [Query Capabilities](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/advanced_configuration_of_views/query_capabilities) of the view you are trying to create. I have been unable to reproduce this issue but if I were in your situation I would first compare the configuration of the environment where this error is prompted vs the environment where the same query works. The difference might point out the source. Another thing that I would do is to configure the log to try to look at a deeper level what might be triggering this error. You can take a look at the article about [Configuring the Logging Engine](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/configuring_the_logging_engine/configuring_the_logging_engine) and [LOGCONTROLLER](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/logcontroller#logcontroller). Hope this helps!
Denodo Team
20-11-2019 13:32:16 -0500
You must sign in to add an answer. If you do not have an account, you can register here