screen freezes upon calling export pivot data.

810582

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

Gabriel Sideras

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.

nitesh K

Which browser you are using ?? Try to run in other browser and see if issue occurs.

Nitesh

Ashish Awasthi

try setting partial submit of button to true

Ashish

810582

Same problem across all browsers.

Tried partial submit and it didn't work.

Florin Marcus

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.

810582

i've 10 records in the database. Even the exported excel contains all the 10 records.

Ashish Awasthi

Is there something in Log ??

Try setting pivot table's iterator changeEventPolicy to none

Ashish

810582

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.

nitesh K

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

Ashish Awasthi

User

I haven't told you but i have posted a blog about it

Check - Ashish Awasthi's Blog (Jdev/ADF): Creating and Exporting hierarchical data to excel using dvt:pivotTable & dvt:exportPiv…

Once download and check sample application and let us know how it works on your machine ??

Sample is developed in 12.1.3

Ashish

810582

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.