we recently moved over to BOXI Rel 3.2 from BOXI Rel 2.
I am currently experiencing problems with a universe,where
the webi reports have subqueries. The webi reports are just
not returning any data or the query keeps on running.
The only way around I have found so far is to take out the
subquery and then re-introduce the subquery as a
query-on-query, even though the data is
from the same universe.
Please post the code of your subquery.
Does the code run, returning the full result set, in a SQL tool using the BO user account?
Are there any errors in the event logs on your BOXI server?
I suspect that the LOV in list is too big for your DB, what RDBMS are you using?
Check the max values in list parameter in your universe, is this setting a different value in your XIr2 installation.
As I said before, try running the query, in a SQL query editor, with the BO user account / connection, do you get the error then?
“As I said before, try running the query, in a SQL query editor, with the BO user account / connection, do you get the
error then?”
I have tried running the code in SQL management studio using my nt a/c
as that is the only access we have and the query has been running for over 25 mins…
Also where can I find…“Check the max values in list parameter in your universe”
I am getting a WIS 00019 error but don’t quite know what to do with it!
I can’t find the “max in list values” option in the universe parameters. Anyone know how to help fix the issue?
Using: Business Objects XI 3.1 WebIntelligence.
Error Message text = “A query filter object contains too many values for the object to be used in a query filter. (Error: WIS 00019) (Error: INF)”
Ikriger,
if you change the value of MAX_INLIST_VALUES to -1 (instead of 999) your query is no longer restricted on number InList values. Once done, if your database would allow it, you would have got rid of the problem…
(BOB member since 2005-01-06)
(BOB member since 2005-01-06)
(BOB member since 2011-02-15)
(BOB member since 2003-02-11)