Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation⤷
CA-EPT-BCV (Application Component) Business Context Viewer⤷
/BCV/QRM (Package) BCV Query Management Layer 
Attribute
| Message class |  |
/BCV/QRM | |
| Short Description |  |
Query Management Messages | |
| Message Number |  |
414 | |
| Documentation status | Space: object requires documentation |
||
| Authorization check Error Message | |||
| Changed On |  |
20110908 |
Message Text
Help Document
Diagnosis
In query , you have created the join criterion that uses input field of the secondary search connector . For this field, only selection mode Single Value or Interval is available. This means that the system cannot pass a set of field values to search connector in one search request.
System Response
When processing a join, the system collects all different values returned by the output field of the primary search connector corresponding to field . Since it can only pass one field value to search connector at a time it might have to call the search connector multiple times. Depending on the data provision technology and the amount of data inside the data provider this may result in long runtimes or even in aborting query processing due to lack of memory.
Procedure
To avoid the problem, pay attention to the following:
- Use query fields with selection modes Single Value or Interval as input field in join criteria only in exceptional cases.
- Use a fast data provision technology.
- Use a small set of field values to be passed to the secondary search connector (not more than 10).
- If possible, look for an equivalent search connector that can handle the problematic field in selection mode Multiple Values or Select Option.
If you have to use search connector , ensure the following:
- You have set the MaxExec (Maximum Number of Executions of Secondary Search Connector) feld of the query join definition to the maximum number of calls of the search connector that you consider acceptable.
- You have checked whether setting the Dld. Sel. (Delayed Selection by Optional Input Fields Allowed) indicator of the query join definition could reduce the number of necessary calls.
Procedure for System Administration
History
| Last changed on/by | |
20110908 | SAP |
| SAP Release Created in | 701 |
