Limitation of Export functionality

[arajagopal]

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

[AL_ANDERSON]

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

[ddemay]

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]

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

[arajagopal]

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.

[arajagopal]

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.

[arajagopal]

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

[ddemay]

Make sure you increase heap to temporarily store data being exported.


Sent from my Verizon Wireless 4G LTE Smartphone

[cc-2]

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

[STEVEG]

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.