Skip to Content
0
Former Member
Mar 14, 2018 at 03:32 PM

SQL search error in Assortment View (with Hana DB)

156 Views

In the Assortment View of the Backoffice Product Cockpit, an error occurs when a category with many subcategories is clicked.

The error message is: SQL search error - SAP DBTech JDBC: [464]: SQL internal parse tree depth exceeds its maximum: join depth exceeds its maximum:255details

It uses a Hana DB. If MySQL is used, the error does not occur. But the Hana DB must be used.

What is to be done? Any suggestions and ideas?

Thank you and best regards

Hybris Commerce: Version: 6.6

Hana DB: Version: 2.00.024.00.1520347815 (fa/hana2sp02) OS: SLES 12 SP2 (4.4.21-69-default) CPU: 8 RAM: 72 GB (HANA Limit 64 GB)