Symptom
- SQL statement contains <N> JOINs. Maximum JOINs per query is 40. The value can be configured through DP Agent configuration framework.maxJoinsPerQuery, however maxJoinsPerQuery > 40 (default) could adversely affect query parse time and increased memory allocation for complex queries.
- Table name involved in the query contains the word JOIN, ex:
- SELECT "VTABLE_JOIN$VT"."WWREC", "VTABLE_JOIN$VT"."WWREG" FROM """DISTRIBUTE"".""TABLE_JOIN""" "VTABLE_JOIN$VT" ]
- The number <N> shown in the error text roughly corresponds to the number of columns selected from the table
Read more...
Environment
SAP HANA Smart Data Integration
Product
SAP HANA smart data integration all versions
Keywords
KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.