Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
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.
Solved! Go to Solution.
Page 88 in:
Which version of WBM are you using?
What do you have in FilterOption.xml?
Page 88 in:
Which version of WBM are you using?
What do you have in FilterOption.xml?
Thank you very much. I was using an outdated Documentation. The Link you provided helps a lot.