Hi Stoyka,
You were able to resolve the problem? Can you tell me the solution as I just experienced the issue. For me we are on 11.1.5 and this is a data module, but hope the solution could be similar.
Thanks
------------------------------
Jeremy Aude
Channell Commercial Corporation
Rockwall TX
------------------------------
Original Message:
Sent: Tue May 26, 2020 01:54 AM
From: Stoyka Bojkova
Subject: Join Filet Type: TABLE limitation in 11.1.6
Hi Nigel,
thanks for your replay. Yes i have a ticket and IMB solve the issue
Regards
Toni
------------------------------
Stoyka Bojkova
Original Message:
Sent: Mon May 25, 2020 08:16 PM
From: NIGEL CAMPBELL
Subject: Join Filet Type: TABLE limitation in 11.1.6
I'd encourage you to look at why a filter-join is trying to create a list of 10K terms. Unto itself that suggests a potential issue separate from the governor tripping.
Assuming you have a support ticket with customer support.
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Fri May 22, 2020 03:06 AM
From: Stoyka Bojkova
Subject: Join Filet Type: TABLE limitation in 11.1.6
Hi Henk, i am on prem and its DQM framework. In the governer i couldnt find where to change it as it works in 11.1.3 and not in 11.1.6
i am admin
------------------------------
Stoyka Bojkova
Original Message:
Sent: Wed May 20, 2020 02:48 PM
From: HENK CAZEMIER
Subject: Join Filet Type: TABLE limitation in 11.1.6
Hi Stoyka,
This value is controlled by a governor. The idea was to avoid run-away queries, because the in-list were too long, the reported one was many times larger.
There is a between option as well, that might work.
The other option is to define another value, there are a couple of places.
Is this model using Framework Manager or Data Modules ?
Are you on-prem and have access to <install>/configuratioin or on cloud?
// Henk
------------------------------
HENK CAZEMIER
Original Message:
Sent: Wed May 13, 2020 08:56 AM
From: Stoyka Bojkova
Subject: Join Filet Type: TABLE limitation in 11.1.6
Hi in 11.1.6 we have 2 queries which are joined with filter type TABLE (package is DQM).
Untill now it was working fine but in 11.1.6 i get error bellow:
"XQE-PLN-0355 Filter join optimization between 'Query1' and 'Query2' is not applied because more than 10,000 values are needed."
Any idea where this limit is set up?
thanks a lot
Toni
------------------------------
Stoyka Bojkova
------------------------------
#CognosAnalyticswithWatson