LOVs only showing partial results

[Former Member]

I have just moved to XI 3.0 from XI R2 and now all LOVs are showing partial results.

I have checked the 'limit result set' option in the universe parameters and that is NOT set.

Does anyone have any ideas ?

[Former Member]

Sue,

Limit Size of Result set has nothing to do with LOV,if your object LOV are not populating with all the data then in that case you have to increase the size of "MAX_INLIST_VALUES" parapeter,by default it is set to -1 ,you can increase it to 256.

Follow this.

1.Go to Universe parameter.

2.Go to Paramter tab.

3.Change MAX_INLIST_VALUES parameter to 256.

Hope this works for you.

Thanks,

Suraj

[Former Member]

You can increase the " Limit size of result set to " option or uncheck it if you are not sure of the value.

[Former Member]

Hi Sue,

Follow these steps in Designer:

1. Open the Universe.

2. Go to File > Parameters.

3. Go to the "Controls" tab.

4. Increase the " Limit size of result set to " option.

Hope this helps.

Regards,

Deepti Bajpai