Bug 92928

Summary: Same network connection error for each call to GETPIVOTDATA
Product: LibreOffice Reporter: Andreas Säger <villeroy>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: cno, ilmari.lauhakangas, miguelangelrv, xiscofauli
Priority: medium Keywords: regression
Version: 4.4.4.3 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: Zip File, with 3 files to do a test.

Description Andreas Säger 2015-07-25 12:17:10 UTC 
I have a spreadsheet with:
-- one "normal" pivot table linked to a range on another sheet.
-- one pivot table pulling data from a JDBC connection to the local network.
-- dozends of function calls to GETPIVOTDATA merge information from both pivot tables. Currently 38 of these formulas refer to the JDBC pivot.

When my laptop is connected to the local net, I refresh the "normal" pivot which automatically refreshes the other pivot as well. If this is intended, it is a bad idea.
When I try to activate the pivot sheet while being unconnected or when I try to refresh either one of the pivots, I get 38 times "java.net.NoRouteToHostException" in intervals of 3 seconds, so it takes several minutes holding the Escape key until I can close the document gracefully. 38 is the count of GETPIVOTDATA formulas referring to the JDBC pivot.

After deleting the 38 formulas, everything seems to behave normally.
The JDBC pilot does not update automatically when updating the normal one.
The error message pops up when I try to refresh the JDBC pilot.

-----------------------------------------
This is how OpenOffice 4.1 handles this:
It shows the error one time after loading the document, regardless of the currently active sheet and whenever I try to refresh the JDBC pivot.
Comment 1 m_a_riosv 2015-07-26 21:30:51 UTC 
Created attachment 117456 [details]
Zip File, with 3 files to do a test.

Hi Andreas, thanks for reporting.

Reproducible also with at least other type of link.

Attached a sample using a linked spreadsheet, three files:

- DataPilotSampleLinked_GETPIVOTDATA.fods file with the Pivot table.
- SourceLinkedDAta.odb database file with the link to the spreadsheet.
- SourceLinkedData.ods is the source spreadsheet.

After register the database file, opening the first show the correct values for GETPIVOTDATA(), changing the name of the third file, and reopening again the first file show the issue, a message error for every GETPIVOTDATA() function.

BTW, thanks for you macro to recalculate several pivot tables at once, it's really useful for me.
Comment 2 m_a_riosv 2015-07-26 21:33:36 UTC 
Reproducible with:
Win7x64Ultimate
Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
Version: 5.0.0.4 (x64) Build ID: cf112dc905650fb985306a7a03d2fe3fcc6c978f
Comment 3 Cor Nouws 2015-07-30 21:38:03 UTC 
as this is possibly a regression, would it make sense to set a bibisectrequest ?
Comment 4 m_a_riosv 2015-07-31 08:31:42 UTC 
Win7x64

Version: 4.1.6.2 Build Id: 40ff705089295be5be0aae9b15123f687c05b0a
Shows the error only once and crash.

Versión: 4.2.0.0.beta1 Build ID: f4ca7b35f580827ad2c69ea6d29f7c9b48ebbac7
Shows the error once for every GETPIVOTDATA()

Seems it could beginn with the deep rework in 4.2.
Comment 5 QA Administrators 2016-09-20 10:21:40 UTC Comment hidden (obsolete)
Comment 6 Andreas Säger 2016-09-20 10:31:51 UTC 
Still the same bug in 5.1.4
Comment 7 Xisco Faulí 2016-09-20 11:56:03 UTC 
Adding keyword 'bibisectRequest'
Comment 8 m_a_riosv 2016-09-20 15:06:41 UTC 
Only one message:
<<'The file:///xxxx' could not be loaded>>
refreshing the pivot table not at opening.
but
one message for every GETPIVOTDATA() doing hard recalc.

Same issue with 5.1.5.2 and 5.2.2.1, but with a new message for 5.2

With 
Win10x64
Version: 5.3.0.0.alpha0+
Build ID: 3287bc2f91438085b7604773d5e0346fc3c3f452
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-09-18_05:11:16
Locale: es-ES (es_ES); Calc: CL

Only one message updating PT or doing a hard recalc, and don't loose the values on the GETPIVOTDATA cells.

So seems solved in master.
Comment 9 QA Administrators 2017-10-23 13:48:02 UTC Comment hidden (obsolete)
Comment 10 Buovjaga 2018-05-25 17:34:39 UTC 
(In reply to m.a.riosv from comment #8)
> Only one message updating PT or doing a hard recalc, and don't loose the
> values on the GETPIVOTDATA cells.
> 
> So seems solved in master.

Then let's close.