Skip to main content
A
arajagopal11-Garnet
11-Garnet
June 23, 2014
Question

Limitation of Export functionality

  • June 23, 2014
  • 9 replies
  • 2508 views

I am interested to know how you are handling when data set is too large to export out of PDMLink.



System slow or crash when one try to export too much data.


CS54605to over come export issue.


Ayyappan Rajagopal

9 replies

A
AL_ANDERSON12-Amethyst
12-Amethyst
June 23, 2014
I'm pretty sure you limitation is in Excel. Are you using an old version
of Excel (.xls)? Excel 2010 (.xlsx) will display over a million records,
but older versions stop at about 65K.

Al









[solutions] - Limitation of Export functionality

Ayyappan Rajagopal
D
ddemay1-Visitor
1-Visitor
June 23, 2014
Think there is also a property for 65535 row export limit I came across once. Not sure if helpful.


Sent from my Verizon Wireless 4G LTE Smartphone
BenPerry
BenPerry15-Moonstone
15-Moonstone
June 24, 2014
Ayyappan,
When the data set is too large, I get the SQL and run against the DB using a query program such as SQLDeveloper or something similar. There are no queryLimits when querying the DB directly.

But if you don’t want to go through that trouble, then you’ll just need to increase your queryLimits as per CS54605. These are the ones that always give me the best luck. If your data set is higher than 100,000 then you’ll need to try 150,000, 200,000, or more.

· from WC shell in the <wc home="> directory:

· xconfmanager -t db/db.properties -s wt.pom.queryLimit=<~100000?>

· xconfmanager -t db/db.properties -s wt.pom.paging.snapshotQueryLimit=<~100000?>

· xconfmanager -t db/db.properties -s wt.pom.snapshotQueryLimit=<~100000?> -p

· restart

Just keep an eye on WC performance the first few times you run the query. That is the disclaimer.

Ben

A
arajagopal11-GarnetAuthor
11-Garnet
June 27, 2014

I could see some responses here and thanks for all your help.


I have to see how Excel Vs Csv option goes.


But here is the link preventing me play with property limits


https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS58170&posno=1&q=snapshotQueryLimit&nav=ptcproductgroups||windchill||Product+Group||windchill&source=Search


Will update how things goes.


A
arajagopal11-GarnetAuthor
11-Garnet
June 27, 2014

Albert,


I see this must be limitation to export funtioanlity tied up with propertycom.ptc.jca.exportRowLimit=65535. Since we have query limit set to250000.


Thanks for your note.



A
arajagopal11-GarnetAuthor
11-Garnet
July 3, 2014

I could understand how both properties work.


We had values as shown here and changed second one to fix the export issue.


wt.pom.queryLimit 250000


D
ddemay1-Visitor
1-Visitor
July 3, 2014
Make sure you increase heap to temporarily store data being exported.


Sent from my Verizon Wireless 4G LTE Smartphone

C
cc-21-Visitor
1-Visitor
July 10, 2014

Hello



when I have such issue I export as CSV rather than excel and then open in excel 2010.


I did not know about this property limit. I shall try it 🙂


Thank you


Best regards

S
STEVEG21-Topaz I
21-Topaz I
August 19, 2015

I get this message whether I use .xlsx or .csv from 10.1 M050 to Excel 2010.  Not sure if I want to change the property though.

Terms & ConditionsAccessibility statement