Hi, I have created a document

[nimmy99]

Hi,

I have created a document sucessfully in WEBI. But when I try to refesh that one I am getting Page is empty error.

Cal anyone tell me the reason?

 

[PAULSGS]

Can you run the sql that is generated by your report on another tool? For example can you run it through TOAD or SQLPLUS?

What happens if you build up the report 1 object at a time, does it only fail at a certain object or condition?

Does the same happen if you build the report in full client?

 

[nimmy99]

The refresh is working fine for documents without parameters(ie prompts). If the report contains any prompts. then this error is comming (page is empty w0100)

 

[PAULSGS]

If you hard code the prompt/response do you still get an empty page?

Do you know that the value entered against the prompt esists in the DB and will return results?

Can you try the SQL with any other tool?

 

[nimmy99]

No hard coded value for prompt. Just I am trying to get some list of values defined in LOV. Refresh is working fine for the documents without prompts

 

[promero]

Please, use a meaningful subject in your messages.