screen freezes upon calling export pivot data.

810582 · Jun 23, 2015 7:21AM

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 · Jun 24, 2015 4:21AM

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 · Jun 23, 2015 7:42AM

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

Nitesh

Ashish Awasthi · Jun 23, 2015 8:14AM

try setting partial submit of button to true

Ashish

810582 · Jun 23, 2015 8:35AM

Same problem across all browsers.

Tried partial submit and it didn't work.

Florin Marcus · Jun 23, 2015 8:36AM

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 · Jun 23, 2015 9:14AM

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

Ashish Awasthi · Jun 23, 2015 9:32AM

Is there something in Log ??

Try setting pivot table's iterator changeEventPolicy to none

Ashish

810582 · Jun 23, 2015 9:50AM

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 · Jun 23, 2015 12:00PM

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 · Jun 23, 2015 2:33PM

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 · Jun 24, 2015 2:08AM

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.

Forum Stats

Quick Links

Categories

screen freezes upon calling export pivot data.

Best Answer

Answers

Data

Databases

Development

Development Tools

Open Source

Programs

Forum Stats

Categories

screen freezes upon calling export pivot data.

Best Answer

Answers