LOV0001 limitation in BO...and oracle.....

building reports desktopintelligence
1

Hi all,

We have two different physical data bases and the corresponding universes. In the report , we have used two data providers pointing to these universes.They are linked by a unique number(object).

In one of the queries(DP1) we have an inner query (in List ) which gets data from the other DP(DP2).Now if the result of the inner query is more than 1000 it is giving “LOV0001” error(might be because of MAX_INLIST is configured to 999).

I tried increasing the MAX_INLIST Parameter in the Universe …to more than 1000…then the query execution started giving Connection SQL error [oracle does not allow more than 1000 values in a list ]…

Is there any work around for this problem ???..as we cannot write a custom query as two data providers are pointing to different Universes…

Thanks in Advance,

Chaitanya K.

kurtcobain :india: (BOB member since 2006-04-12)

2

2 things…

This feature has a limit of 1000. It is not changeable. I believe this is due to Oracle not being able to handle more than 1000 items in an InList. I’m pretty sure that Oracle 9 and earlier had this limitation.

Be very careful of this feature. We had nothing but problems with it. It is very buggy and will corrupt your reports. It did not work in 6.5.1 or 6.5.2. It works fine when you build a report, but will start to fail after a few runs.

Steve Krandel :us: (BOB member since 2002-06-25)

3

Does anyone know if Netezza has these limitations as well?

Jkamradt :us: (BOB member since 2008-10-20)