Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
screen freezes upon calling export pivot data.

I'm a newbie to ADF and im having issues while extracting pivot table data.
1. Create a VO with a bind variable.
2. Drag and drop execute with params to the page.
3. Drag and drop data control as pivot table to the page.
4. Add below code in the jsf source above the pivot table
<af:commandButton text="Export To Excel" immediate="true" id="cb1">
<dvt:exportPivotTableData type="excelHTML" exportedId="pt2"
filename="updated_export.xls" title="PivotTable export"/>
</af:commandButton>
5. Run the jsf page.
6. Click on export to excel button, excel gets generated but the screen hangs. user has to forcefully refresh the screen.
Any workarond present for this issue?
Jdev version:12.1.3
Best Answer
-
Hello,
There is a related bug listed in Oracle Support (Bug 19524936 : AFTER EXPORTING PIVOT TABLE TO EXCEL, SCREEN FREEZES)
Apply the related patch (Patch 19524936: AFTER EXPORTING PIVOT TABLE TO EXCEL, SCREEN FREEZES) and try again.
Answers
-
Which browser you are using ?? Try to run in other browser and see if issue occurs.
Nitesh
-
try setting partial submit of button to true
Ashish
-
Same problem across all browsers.
Tried partial submit and it didn't work.
-
This sounds like a scalability issue. How many records do you have in the underlying table?
Export functionality works only for a limited number of records (we use it for under 1000 records), but if you need to export large amounts of data, you will need a dedicated publishing engine (Oracle BI Publisher or Jasper Reports).
You can count the number of records part of the export by overriding ViewObjectImpl.createInstanceFromResultSet() method.
-
i've 10 records in the database. Even the exported excel contains all the 10 records.
-
Is there something in Log ??
Try setting pivot table's iterator changeEventPolicy to none
Ashish
-
I've tried setting the iterator to none from ppr, still the issue persist. wondering whether this is a bug in 12.1.3.
Also there is nothing in the admin console when screen freezes.
-
Hi user,
Its not bug, I've tested in same version.It works fine. Replace your button code with this and try or just add exportedData="all" .
<dvt:exportPivotTableData exportedId="pivotTable1" type="excelHTML"
exportedData="all" filename="all.xls"
title="All pivotTable data"/>
Nitesh
-
User
I haven't told you but i have posted a blog about it
Once download and check sample application and let us know how it works on your machine ??
Sample is developed in 12.1.3
Ashish
-
Ashish, i started working on pivot only after referring your blog
Only change is i'm using execute with params to populate the pivot table.
I've a combo box and execute with params button. on clicking on execute with params button data gets populated in pivot table without any problem.
only problem is after clicking on the export button, excel gets generated but after that i've to refresh the page to continue working.