Question
Error too many stages in execute_like while opening analysis
Hello,
I have loeaded my data model successfully but when i open my analysis there is no data (even the poucentage of cases). This error appears in all components :
too many stages in execute_like
Do you have any idea what causes this issue please an how can i fix it?
PS: there is no filter applicable on the whole analysis and i kept the data model very simple.
Thank you in advance
+2Hello Mounia,
which Celonis version (which cluster on the IBC, CPM4.5, ) are you using?
Can you check if you have any queries in your analysis that use the LIKE operator?
Best
David
Hello,
Indeed i have a filtrer using LIKE %XXX%.
The problem have been solved by removing %
I suppose that there is no need to add wildcards before and after the expression, the interpreter adds them automatically.
Thank you
+2Hello,
ok, happy to hear that removing the wildcard works for you. Yes, if you dont use any other wildcards in the pattern, the % is always assumed at the beginning and the end.
However it still should work with the '%'s. This has been fixed some while ago, so Im assuming that you are working on an older on-prem version like CPM4.5. When upgrading to a new version, the error will most likely not appear anymore.
Cheers
David
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.