Windchill Bulk Migrator: No FilterOption xml is found.

[Julian_L.]

Hello everyone,

I am currently trying to filter the extraction to only extract objects of an specific Organization. For that i tried to do a filtered extraction. The Filter most likely doesn't work as it is right now,but i didnt even get to test it.

I tried executing following command: windchill com.ptc.windchill.migration.wbm.wc2wc.extractor.filter.WindchillFilteredExtractor -u wcadmin -p wcadmin -d

my Windchill version is 12.0.2.8

Here are the logfiles:

[2023-Nov.-15 15:32:58,255] [main] INFO  client.ExtractProperties                          - Developement environment. Using unencrypted password
[2023-Nov.-15 15:32:59,566] [main] INFO  wbmutil.CommonConnectionPool                      - MinStagingPoolSize: 1  MaxStagingPoolSize:  5 MinWindchillPoolSize: 1  MaxWindchillPoolSize:  5
[2023-Nov.-15 15:32:59,570] [main] INFO  wbmutil.CommonConnectionPool                      - 1 Connections to be Initialized. Starting.......
[2023-Nov.-15 15:33:01,794] [main] INFO  wbmutil.CommonConnectionPool                      - Populating the connections pool of windchill
[2023-Nov.-15 15:33:01,795] [main] INFO  wbmutil.CommonConnectionPool                      - MinStagingPoolSize: 1  MaxStagingPoolSize:  5 MinWindchillPoolSize: 1  MaxWindchillPoolSize:  5
[2023-Nov.-15 15:33:01,806] [main] INFO  wbmutil.CommonConnectionPool                      - 1 Connections to be Initialized. Starting.......
[2023-Nov.-15 15:33:02,797] [main] INFO  wbmutil.CommonConnectionPool                      - Populating the connections pool of staging
[2023-Nov.-15 15:33:02,799] [main] INFO  wbmutil.CommonConnectionPool                      - Total Connections with Staging database are: 1
[2023-Nov.-15 15:33:03,373] [main] INFO  filter.WindchillFilteredExtractor                 - Input Arguments: [-u, wcadmin, -p, wcadmin, -d]
[2023-Nov.-15 15:33:11,706] [main] INFO  wbmutil.CommonConnectionPool                      - Total Connections with Windchill database are: 1
[2023-Nov.-15 15:33:12,032] [main] INFO  wbmutil.CommonConnectionPool                      - Total Connections with Staging database are: 1
[2023-Nov.-15 15:33:15,666] [main] INFO  wbmutil.CommonConnectionPool                      - Total Connections with Staging database are: 1
[2023-Nov.-15 15:33:15,956] [main] ERROR filter.WindchillFilteredExtractor                 - Error: 
com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.lang.NullPointerException: No FilterOption xml is found.
at com.ptc.windchill.migration.wbm.wc2wc.util.WBMExceptionHandler.throwException(WBMExceptionHandler.java:34) [codebase/:?]
at com.ptc.windchill.migration.wbm.wc2wc.extractor.filterjava.lang.NullPointerException: No FilterOption xml is found..WindchillFilteredExtractor.FilterOptionsXML(WindchillFilteredExtractor.java:1586) [codebase/:?]
at com.ptc.windchill.migration.wbm.wc2wc.extractor.filter.GenDD.doGeneration(GenDD.java:196) [codebase/:?]
at com.ptc.windchill.migration.wbm.wc2wc.extractor.filter.WindchillFilteredExtractor.Run(WindchillFilteredExtractor.java:970) [codebase/:?]
at com.ptc.windchill.migration.wbm.wc2wc.extractor.filter.WindchillFilteredExtractor.main(WindchillFilteredExtractor.java:933) [codebase/:?]
Caused by: java.lang.NullPointerException: No FilterOption xml is found.
at com.ptc.windchill.migration.wbm.wc2wc.extractor.filter.WindchillFilteredExtractor.FilterOptionsXML(WindchillFilteredExtractor.java:1583) ~[codebase/:?]
... 3 more
[2023-Nov.-15 15:33:20,928] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - Stopping TimerThread 
[2023-Nov.-15 15:33:20,942] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - Closing all connections in Staging queue
[2023-Nov.-15 15:33:20,952] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - Total connections in Staging are: 2
[2023-Nov.-15 15:33:21,158] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - All connections in Staging queue are closed
[2023-Nov.-15 15:33:21,158] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - Closing all connections in Windchill queue
[2023-Nov.-15 15:33:21,160] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - Total connections in Windchill are: 1
[2023-Nov.-15 15:33:21,279] [Thread-0] INFO  wbmutil.CommonConnectionPool                      - All connections in Windchill queue are closed

This is what i see before as soon as the exception is thrown.

my FilterOption.xml File is at the following location: "D:\ptc\Windchill\Windchill\codebase\com\ptc\windchill\migration\wbm\wc2wc\extractor\filter\FilterOption.xml"
I had to create that file, since there wasn't one when i looked for it. I also copied the FilterOption.xml and renamed it to FilteringOption.xml, since i read both names in different documentations.

Is this even the right directory for the File. If the FilterOption.xml file should be there by default, does a command create it or is it there as soon as the extraction tool is installed?

Thank you in advance.

[rleir · Accepted solution]

Page 88 in:

https://www.ptc.com/support/-/media/support/refdocs/Windchill_Bulk_Migrator/11,-d-,2/WCBulkMigratorUtilInstallUsage_11_2.pdf?sc_lang=en

Which version of WBM are you using?

What do you have in FilterOption.xml?  

[Julian_L.]

Thank you very much. I was using an outdated Documentation. The Link you provided helps a lot.