*** 04/01/05 01:50 pm *** 
For Customer Bugs 
----------------- 
TAR number :4308767.994 
Country where the TAR is logged : US 
. 
. 
For Plus, Viewer and Portlet Provider bugs - 
Version & machine info 
------------------------------------------------- 
Discoverer Viewer Release : 
. 
OracleBI Discoverer 10g (10.1.2.00.00) 
Oracle Business Intelligence Discoverer Plus 10g (10.1.2.45.46c) 
Discoverer Model - 10.1.2.45.46c 
Discoverer Server - 10.1.2.45.46c 
End User Layer - 5.1.1.0.0.0 
End User Layer Library - 10.1.2.45.46c 
Oracle Database 10g Enterprise Edition Release 10.1.0.3.1 - Prod 
Copyright © 1999, 2004, Oracle.  All rights reserved. 
. 
middle tier server machine -- 
OS : Windows orf Linux 
. 
. 
. 
Problem Description 
------------------- 
. 
1. Set Options in Discoverer Plus: 
. 
    Tools >> Options >> General >> "Don't Run Query (leave sheet empty) 
. 
2. Open a scheduled workbook result set 
. 
3. Pres the refresh icon or Tools >> Refresh Sheet 
. 
4. DIALOG BOX: Do you want to query the database for the most recent data?   
If you choose No, then you will continue to see the results run for this  
scheduled workbook. 
. 
5. Click 'No'  (which according to the dialog should give result set 
. 
6. Worksheet shows 'No Data is shown because the query was cancelled.' 
. 
7. Click 'Yes' and it runs the query from the datbase. 
. 
. 
. 
If you have the options set to run the query  automatically, then it works  
fine and brings in the scheduled result set. 
. 
. 
. 
. 
. 
Generic/Port-specific findings: 
------------------------------- 
Did you test with the latest version? 
Yes 
. 
Server OS Client OS Discoverer RDBMS 
Reproduce? and Ver and Ver version Version 
---------- --------- --------- ---------- ------- 
Y       Solaris Middle-tier (Customer) 
Y       Linux Middle-tier (Support) 
Y       Windows Middle-tier (Support) 
. 
Cannot test 10.1 Desktop as you encounter BUG 4279280 
. 
Available workarounds: 
--------------------- 
. 
Set the Query options in Plus to:  'Run Query Automatically' 
. 
. 
. 
Reproducible Case (For All bugs) 
-------------------------------- 
. 
. 
PLUS: 
. 
. 
. 
EFMSDBO/EFMSDBO@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orldss 
. 
CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED))) 
. 
EUL= ATT_EUL 
. 
2.  Set Options in Discoverer Plus: 
. 
    Tools >> Options >> General >> "Don't Run Query (leave sheet empty) 
. 
3. Open a scheduled workbook result set 
. 
      Open scheduled workbook Gary.dis 
   
 Note: Disable Fan Trap or you will receive the error: 
          'Join configuration cannot be resolved. Reason: more than 1 of the  
detail folders uses non-aggregated items' 
. 
Customer is aware that they disable Fan Traps 
. 
4. Pres the refresh icon or Tools >> Refresh Sheet 
. 
5. DIALOG BOX: Do you want to query the database for the most recent data?   
If you choose No, then you will continue to see the results run for this  
scheduled workbook. 
. 
6. Click 'No'  (which according to the dialog should give result set 
. 
7. Worksheet shows 'No Data is shown because the query was cancelled.' 
. 
. 
. 
*** 04/01/05 03:15 pm *** (CHG: Asg->NEW OWNER) 
*** 04/01/05 03:15 pm *** 
*** 04/01/05 03:47 pm *** (CHG: Sta->11 Pri->2 Asg->NEW OWNER) 
*** 04/01/05 03:47 pm *** 
*** 04/04/05 12:00 am *** (CHG: Asg->NEW OWNER) 
*** 04/07/05 03:54 am *** (CHG: Sta->32) 
*** 04/07/05 03:54 am *** 
This is not a bug. 
. 
When you refresh workbook and cancel(no) the query then you will see previous  
run results. 
. 
Since previous run result was empty and hence you see empty sheet. 
. 
You can crosscheck behavior after applying debug patch of bug 4279280. 
*** 04/07/05 06:36 am *** (CHG: Sta->11) 
*** 04/07/05 06:36 am *** 
*** 04/07/05 09:27 am *** 
*** 04/08/05 08:38 am *** 
*** 04/08/05 09:09 am *** 
*** 04/08/05 12:59 pm *** ESCALATED 
*** 04/08/05 12:59 pm *** 
*** 04/10/05 02:02 am *** (CHG: Asg->NEW OWNER) 
*** 04/11/05 12:22 am *** (CHG: Asg->NEW OWNER) 
*** 04/12/05 06:22 am *** 
*** 04/12/05 06:23 am *** (CHG: Asg->NEW OWNER) 
*** 04/14/05 06:49 am *** 
*** 04/14/05 07:04 am *** (CHG: FixBy->10 DevPri->1) 
*** 05/11/05 07:57 am *** 
*** 05/16/05 08:32 am *** 
*** 05/31/05 12:34 pm *** 
*** 05/31/05 12:34 pm *** ESCALATION -> CLOSED 
*** 07/28/05 10:52 pm *** (CHG: Asg->NEW OWNER) 
*** 07/28/05 10:52 pm *** 
*** 08/01/05 03:14 am *** (CHG: Asg->NEW OWNER) 
*** 08/09/05 02:57 am *** (CHG: Fixed->10.1.2.48.17) 
*** 08/09/05 02:57 am *** (CHG: Sta->35) 
*** 08/09/05 02:57 am *** 
*** 08/09/05 04:49 am *** (CHG: Sta->11) 
*** 08/10/05 04:00 am *** (CHG: Sta->40) 
*** 10/11/05 12:41 pm *** 
*** 11/14/05 06:45 am *** 
*** 06/14/06 03:37 am *** (CHG: DevPri->4) 
*** 06/21/06 11:57 pm *** (CHG: FixBy->11.1.1.0.0) 
*** 02/14/07 01:54 am *** (CHG: Sta->36) 
*** 02/14/07 01:54 am ***