cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL search error in Assortment View (with Hana DB)

Former Member
0 Kudos
279

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)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The problem has been fixed with patch 6.6.0.5 and 6.7.0.1.