Windchill

Can anyone help me with my SQL query?   I have a query built that integrates several tables in order to report on workflow items and document lifecycle: WTUser, WorkItem, PDMLinkProduct,EPMDocument, etc I have a bunch of reportable information gathered, but I am missing one key piece - the date a workflow task was accepted. I have workflow created date, I have task completion date, I have the who and the what and the where, but I do not have workflow task accepted date.   We discovered that this information is stored in WfAssignmentEventAudit under .timestamp when .actionPerformed=Accepted, but I am unable to get this data table into my query successfully with a JOIN to WfAssignedActivity or or creating a subset, etc.   Any SQL experts out there willing to take a look at how to join up these related tables?

Hi,   We got a 2-node Windchill cluster environment and I need to give few developers access to logs. Windchill Logs Viewer only shows logs of currently connected application server. So, the questions are; Is there any way to move the location of logs from <wt_folder>\Logs to a shared network path so both application servers will write logs to this location instead of default location? If answer is yes, is it a good practice to do this?   Thank you,

Hello all,   here is my use case: I create a configurable product with options and variants. I am able to define a specification of the product.   then, I have an issue when I try to create a variant part. (Action / Request Deliverables). Here is the requested deliverables message:   18 Jan 19 17:24* Deliverable "Bill of Materials (BOM)" failed; com.ptc.windchill.option.model.Choice cannot be cast to wt.part.WTPart Nested exception is: com.ptc.wpcfg.pdmabstr.CommunicationException: com.ptc.windchill.option.model.Choice cannot be cast to wt.part.WTPart     does someone already had this issue? could you help me to understand what this message means?   thanks in advance, Ronan

I installed CPS06 on Windchill PDMLink 11.0 m030 the other night and now Creo View will not launch on either my workstation or when remoted into the Windchill server. I get a new IE window with a 'Starting Creo View Client' across the top of the window, but that is all. I have verified that Creo View will start manually from its installation on both computers. It all worked fine before the CPS06 patch install.

Hello,    A group of users will have to use Google Suite solution instead of Microsoft Office products, do we have any information about the compatibility or possible issues that can be faced while working with Cognos such as Export to csv or Excel etc    Thanks in advance Yassine

Hello,   Please I need help, even with full permissions on Windchill folder the system is not able to read the license file. Below the full stack   2018-05-23 11:25:53,337 DEBUG [main] wt.licenseusage.licensing.PaidLicenseManager - Unable to read license file from license path location.2018-05-23 11:25:53,368 FATAL [main] wt.method.server - MethodServerMain abortjava.lang.NoClassDefFoundError: com/flexnet/lm/FlxException at wt.licenseusage.licensing.PaidLicenseManager.initialize(PaidLicenseManager.java:110) at wt.licenseusage.licensing.LicenseController.getLicenseController(LicenseController.java:108) at wt.licenseusage.licensing.StandardLicenseManagerService.performStartupProcess(StandardLicenseManagerService.java:122) at wt.services.StandardManager.startup(StandardManager.java:459) at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363) at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112) at wt.services.StandardManagerService.per

Hi,   We are using one revisioning sytem for all parts.The custom made parts and the catalogue parts in Windchill. This is done to keep it simple in  Windchill. In our organization, out of Windchill, the costum made part receives an revision number according to our revision scheme. The catalogue part does not receive a revision number but only an itteration numberaccording to our itterartion scheme.   The organization has decided now to add a BOM table to the drawing displaying also the revision number.That is no problem for the custom parts but is a problem for the catalogue parts.Now a revision number is displayed in the BOM table for the catalogue parts too.I am looking for advice how to solve this.   Thanks in advance.   regards, Bert

I want to install windchill for testing, can I use SQL Server 2017 Developer?

Is there an easy way to save solidworks files out of windchill? When we have assemblies with parts and drawings we open each part and drawing etc individually and "save as" and into a folder on computer so we can send files to customers. Is there an easy way to save assm/parts/drawings out without have to do each file? thanks

Hello, I've recently taken up the position of Administrator for Windchill PDM Link.  One of the things I've ran into since taking on this position is related to licensing.  We currently use Creo, Inventor, and Solidworks cad tools and have the required PDM Licenses for Solidworks and Inventor users.  Is it true that we also need to have a light or heavy user licenese for each of the Solidworks/Inventor users?   Thanks for your help RJ  

We are creating 3D models using AutoCAD and WC is configured to assign a number automatically the first time it is saved.  We then update metadata within WC, by checking out and editing the attributes.   My question is:  Is there not a way to create a list in Excel with all the filenames as per WC, where the metadata is created/updated and this list then imported into WC which then populates the spaces for the data?   Regards   Kobus

Hi All,I have created change request workflow. my requirement is like, Admin group user has ability to "Reject" Change Request at any time, but at same time normal users This "Reject" routing must be hidden.Is any way to do this.Regards,Vivek

Is there a way the methodserver to see changes in wt.properties without restarting services, i.e. if i changed a property, the server is aware of it?

Hi everyone,   I was recently assigned to be in charge of reliability for my teams projects and have no previous experience.  After using the WQS I find it somewhat user friendly.  I do have a particular question if someone is able to answer.     Currently using the Prediction module and trying to calculate MTBF for a synchro.  Under the Parts Table, the following are what I have:  Part Classification: EPRD Category: Synchro Subcategory: Receiver/transmitter   Is there anywhere I can get detailed information on the parameters under the Prediction Data tab?  For example, I have no idea what I'm suppose to put down for "Subtype".  Attached is the Prediction Data pane for a synchro. 

Hi everyone, I created some custom views for Doc Control, the downside is that now all users get those Views as the default view in My Tasks Anyone know how to set the default back to Open for all users?   11 M020. Cheers.

In the Document of the knowledge base cs175282 there is a statement: Only one lifecycle state can be used at a time and not multiple lifecycle states.   Does anyone publishes PDF from Word Documents using Cover Sheet from the Adobe DOC Worker at more than one lifecycle state ? For example, is there are more than one type of Document having different lifecycle templates without any common state for adding a cover sheet, how can I do that ?

We're using Windchill 11.0 M030. Strange thing noticed after testing CPS12 is; Windchill 11.0 M030 CPS12 OOTB installation and Windchill updated from 11.0 M030 CPS10 to CPS12 are showing different versions of components   Screenshots are attached here. Any idea why? Will this have any issue in future if production is upgraded to CPS12? A PTC case is also opened to see if it is something we missed during CPS12 update.

I am running 10.2 M020.  When I try to run the command java wt.access.UpdateSecurityLabels -inputFilePath="F:\doc_security_set.xlsx" -allVersions It ask me to login in.  I have tried my wcadmin account, my admin account and my personal account who is also a site admin.  I receive the Error: Unable to connect to the Windchill server. Contact your administrator tostart Windchill before you retry.  Windchill is up and running fine.  I have verified that all these accounts belong to the site admin group.  The install guide says to set this propertywt.access.UpdateSecurityLabels.authorizedParticipant or it defaults to the Site Admin group.  Has anyone else ran into this problem.

We have a huge backlog of jobs listed in the queue from an issue that was causing publishing to fail. I'm unsure of exactly how many there are because each page is limited to 2000, but I have a feeling it's close to 50,000 if not more (this is including the successful jobs as well). What would be the easiest way to clean this up? I can manually do it but that'll take a lot of time because loading and deleting takes a while for 2000 jobs at a time. I tried setting up a scheduled clean up job to start immediately but it just sits there saying Ready and doesn't do anything. Do I have to set up a new worker that specifically does this task? If so, can someone show me an example of setting this kind of worker up?Thanks

Hi!   how are you handling data protection with Windchill? ok Permissions for general access.   But is there a way to prevent Creo users from downloading cad files and passing to other companies? Encryption was skipped with Creo 3.0  I think.   Our reseller suggested remote workstation in a data center. Prevents physical access. But they can still upload files to wetransfer or dropbox. Mail, chat, ...   Anybody using some type of logging? Scann trail file for download actions?! Firewall or mail logging?   I found security labels, but they are more or less another layer within Windchill. (and quite tricky for setup)   br Bernhard

I have a life cycle that contains out of the various state two that can be set with a Set State action. Both have a right mouse button in the Action menu. When I click either one, I get a pop up window (the same window for both) with a pull down from which I can select which Action/State I want.    Is there a way to have the pull down show the state that I select in the pull down based on which Action menu I click?  For example: State 1 = Library. --> Action menu = "Library" --> pop up window pull down "Library" State 2 = Publish. --> Action menu = "Publish" --> pop up window pull down "Publish"   The current behavior is that regardless of which action menu I select, I still have to make the secondary selection to pick the state I want in the pull down menu from the pop up window.     

We have a scenario where we need to view a WT structure offline, the user will be at a test facility with no internet connection and needs to see both visualisations and structure with expressions. We can export the PVZ for visualisation and export a Excel of PDF of the structure tab but where we have more than 1 occurance of a part we might have different expressions against them and its impossible to know which is which from the visualisation.   Anyone have any ideas?

Hello, I need to make the query-object search case insensitive. According to the documentation, it is by default. But it my test it does not work. So I put the explicit parameter   <ie:param name="WHERE_CASE_SENSITIVITY" data="FALSE"/> but the case still sensitive. Is there further parameters or changes needed?   Thank you.

Hey all looking for a good reference manual for windchill/pdm link.  A lot of the things I want to do in our system are not turned on or ready out of the box.  For instance, email the users when an item is added to their task list or customizing the windchill branding to our own.   It just seems like the information is spread out everywhere.  See link thru PTC support and link thru Ptc.    http://support.ptc.com/help/windchill/whc/whc_en/index.html#page/Windchill_Help_Center%2FWCCG_Oview_LoginPageCust.html%23  https://www.ptc.com/cs/help/windchill_hc/wc100_hc/index.jspx?id=WCCG_UICust_CustHTMLClients_CustUIBrand&action=show     I would love just one location I can flip thru for all the information I need.  Any recommendations? 

Hello,   A customer reported that his security team did a scan of his Pro/Intralink server and found the Oracle Database needs patches for vulnerabilities.  I am trying to get more data from the scan, such as CVE or anything helpful to further identify.  The scan snippet had little helpful info.   I opened a case to ask where to find these patches.  I presumed PTC would have them since they bundled the database.  The rep told me I had to get them from Oracle.  You cannot get anything from Oracle without a "Support Identifier", so I pushed back.  While I wait for a response, I wanted to get any insight from the Community on this.   Thank you!