cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Windchill Bulk Migrator: No FilterOption xml is found.

Julian_L.
5-Regular Member

Windchill Bulk Migrator: No FilterOption xml is found.

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.

Julian_L_0-1700062141861.png

 


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.

ACCEPTED SOLUTION

Accepted Solutions
rleir
17-Peridot
(To:Julian_L.)

2 REPLIES 2
rleir
17-Peridot
(To:Julian_L.)

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.
5-Regular Member
(To:rleir)

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

Announcements


Top Tags