--no value-- in all LOV in WEBI view mode

[Former Member]

Hi all,

we have encountered a serious problem about generating and viewing LOVs in our Web Intelligence.

After moving from one server to another using Import Wizard: Environment - BIAR - Environment, we lost our LOVs in WEBI only in view mode (all 3 modes - Interactive, web, PDF). All LOVs in promtps are empty, just "no value" there.

In creation mode - Advanced (Java) it is all good, LOVs are generating, updating, everything is fine.

Desktop Intelligence works fine also.

here is our setup:

BO Enterprise, product version 12.3.6.0.601

Oracle 10g 10.2.4.0 64bit

MS Windows Server 2003 R2 64bit

We have tried:

regenerating LOVs in universes and reexporting

checking LOVs as Export with universe, and Automatic refresh before use

dropping and regenerating them again

clearing, turning off and turning on Cache for reports and universes

restarting all servers

increasing Cache memory for LOVs and universes

deleting LOV files

checking JAVA (1.6.0.0.16) and clearing its cache

and some more,

but nothing worked.

We found this issue in many other forums around the web, even in about two forums here, but no advices worked.

It is a little disappointing problem, because all standard users are unable to use LOVs in prompts.

Thank you, Martin

Edited by: MartinHajekBC on Oct 6, 2010 3:18 PM

[Former Member]

Hi,

Just a thought. Please check out the parameter List Of Values Batch Size (entries) in the properties of WebIntelligenceProcessingServer. Whats the value there? Is it 1000 or 0 by default?

[Former Member]

I am seeing something similar. If I log in with the Administrator ID, or create a new ID and make it a member of the Admin group, my reports run OK. If I try to log in with another ID I always see No Value when trying to refresh values. If I run a report which doesn't have any prompts, it comes up with "NoData". The same report produces data correctly when run using the Admin ID.

Sounds like a permissions issue obviously - but I have double and triple checked all the rights and everything looks perfect. Any ideas???

[Adam_Stone]

Are you using the SDK to view the reports and are having this issue? Is it reproducible when viewing through Infoview?

[Former Member]

We don´t use SDK

and sorry, we open our webi documents only through infoview...

[Former Member]

Any Idea anyone?

[Former Member]

We are facing the same problem and cannot find a solution. Please post if you got any solution.