Community Advisor

Question

Personalization block query too complex

Forum|Forum|3 years ago
January 12, 2023
2 replies
2363 views

Hello,

we have personalization block that has 5k lines with conditional content and we run to error below. Is there a option or server config option to increase processing limits?

The max number of conditions can add up to 2000

Marcel

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Craig_Thonis

Adobe Employee

Hi Marcel,

Depending on your version of Campaign, this issue should already be addressed if your version is 7.3.1 or 8.4.3 and above based on bug reference NEO-48807.

Regards,

Craig

Marcel_Szimonisz

Author

Community Advisor

Hello Graig,
thanks a lot for information.

i cannot find NEO-48807 where do i see more information
We have version 9349 installed

Marcel_Szimonisz

Author

Community Advisor

Okey i can see the version :

Release 7.3.2 - Build 9356

Fixes this issue. Can you give me more info about the bug? and possible workarounds in the meantime? We think to split the huge perso block in to more blocks

Marcel

_Manoj_Kumar_

Community Advisor

Hello @marcel_szimonisz

Currently, you have one personalization block for all 2000 conditions. Split these conditions into multiple personalization blocks, and it should work.

Manoj Find me on LinkedIn

Marcel_Szimonisz

Author

Community Advisor

Hello @_manoj_kumar_ i have split that in to multiple perso blocks and it did not help. We tried also redo all logic with pre-processing instructions which makes the whole perso block with 2000 conditions 100 lines but still on delivery it fails with the query to complex. We will try to upgrade and will let you know as mentioned above.

Marcel

Release 7.3.2 - Build 9356

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded