Skip to main content
A
Amirtharaj_K17-Peridot
17-Peridot
March 5, 2025
Solved

Data Report - Windchill

  • March 5, 2025
  • 1 reply
  • 437 views

Hi Guys,

Can we obtain the total data from Windchill using export to spreadsheet, but the problem is I have more than 5 lakh data.

Amirtharaj_K_0-1741172375594.png

Regards,

Aj

Best answer by PS_10220246

Hi @Amirtharaj_K 

 

I think below can help you:

  • Depending on the memory allocated to Windchill you may decide to lower or raise this value
  • Increase the value of com.ptc.jca.exportRowLimit
  1. Launch Windchill Shell and execute the command xconfmanager -s com.ptc.jca.exportRowLimit=*** -t codebase\wt.properties -p 
     
    where *** is replaced by a number e.g. 80000
  2. Restart Windchill

Notes:

  • Be aware that a high value may cause memory shortage and MethodServer instability
  • The new limit does not work for "XLS" and "XLS Report", because older Excel versions are limited to 65531 rows
    • Use the XLSX export instead

PTC support Article for same: https://www.ptc.com/en/support/article/CS52471

 

Thank you,

Pravin S.

1 reply

P
PS_102202467-BedrockAnswer
7-Bedrock
March 6, 2025

Hi @Amirtharaj_K 

 

I think below can help you:

  • Depending on the memory allocated to Windchill you may decide to lower or raise this value
  • Increase the value of com.ptc.jca.exportRowLimit
  1. Launch Windchill Shell and execute the command xconfmanager -s com.ptc.jca.exportRowLimit=*** -t codebase\wt.properties -p 
     
    where *** is replaced by a number e.g. 80000
  2. Restart Windchill

Notes:

  • Be aware that a high value may cause memory shortage and MethodServer instability
  • The new limit does not work for "XLS" and "XLS Report", because older Excel versions are limited to 65531 rows
    • Use the XLSX export instead

PTC support Article for same: https://www.ptc.com/en/support/article/CS52471

 

Thank you,

Pravin S.

Terms & ConditionsAccessibility statement