Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Oct 06, 2010 at 07:07 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 24, 2011 at 06:41 PM

    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???

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 06:11 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.