17-Peridot

Solved

Data Report - Windchill

1 reply
481 views
Translate All

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.

Regards,

Aj

Other

PS_10220246Answer

7-Bedrock

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

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
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.

Answer

7-Bedrock

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

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
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.

Translate