ORA Exception with Hybris 5.6

[Former Member]

ORA-01795 maximum number of expressions in a list is 1000 exception thrown when including B2B customer as a member of a B2B Unit.

Environment Hybris Commerce Suite 5.6.0 Oracle 11G

Reproducing the Issue 1. Create a B2B Unit in hMC / B2B Commerce / B2B Unit 2. Assign more than 1000 B2B Units as members (children) of the B2B Unit created on step 1 3. Include a B2B Customer as member (group) of the B2B Unit created on step 1 4. Log in store front with this B2B Customer. 5. As a result you are going to get Oracle exception ORA-01795: maximum number of expressions in a list is 1000

[alex_alvarez1]

This is actually an Oracle limitation, the initial issue should normally be resolved on currently supported Commerce versions.

[VinayKumarS]

This is the limitation in hybris. you cannot update more than 1000 literals at a time. So you need to select or update them in batches.

[former_member671076]

I am getting the same error.

Can you please provide more input on this to handle this error using FlexibleSearch .

Thanks,

Nilesh