Skip to Content
Former Member
Jan 22, 2009 at 10:49 PM

Please Wait Prompts


We are currently unable to schedule Webi reports on our XIr2 environment. It only occurs when using a universe pointing to large Oracle transactional tables. The reports are set to Refresh on Open to force the use of prompts.

We are using the standard scheduling procedure detailed below:

1.log on to infoview your report schedule

4.expand the prompt section modify (the prompt window opens) all the new prompt values

7.Press apply


Normally there is no delay between step 7 and 8. However for all reports using this universe webi hangs with the following message "Please Wait Prompts". Many articles online mention this is a known bug with XIr2 SP2 where BO sends some SQL to the database - it should only pass the values to the prompt and send the SQL once the schedule job starts (after step 8).

A known workaround is to disable "Refresh on Open" and the above error does not occur.

I assume data volume has a direct impact on the "delay/hanging" duration however I cannot explain why disabling the above option changes the schedule procedure.

Would anyone know what could cause this strange & inconsistent behaviour and how I can fix this without disabling Refresh On Open?

Thanks in advance,