Windchill

I'm not a WindChill Admin nor am I a user however I was asked to create a SSRS reports in SQL.  The issue I'm having is figuring out what tables have the fields I'm looking for.  Even with help from our seasoned WindChill Admin we are unable to trace the data viewed on the front end to the back.  For example I am looking for a field the front end refers to as "Process Status"  and contains text called "Running" and "Executed".  I'm concerned it could be some front end calculation where it may "Interpolates" those values rather then actually storing them...which makes it even harder for me. Going forward how can we find this data ourselfves...is there a HELP menu you can activate that shows the SQL location when you hoover above the data on the front end?

Dear Windchill Community!   Given the following structure: >main part      >sub part 1           >sub part 1 1      >sub part 2   I would like to publish multiple BOM depending on View version. I set the preference View To Distribution Target Mappings like so: Design:001,Manufacturing:002,Manufacturing X:003,Manufacturing Y:004   When every part is in Design view and I send it to Distribution Target, All the parts are successfully sent to target 001. When I create a Manufacturing View Version from main part (others remain in Design view) and I send it to Distribution Target, I expect that main part to be sent to target 002 and the other parts which are in design view to be sent to target 001.   On the preview screen looks like they are separated, but if I actually send it, I get the following error: ESI pre release : ESI ( 801 ) : One or more of the distribution targets associated to "6AAB0

First time using this. Short summary, looking to block "Design" view BOMs from being sent to ERP Connector (SAP). I am using preference "Business Rule set to inhibit production BOM publishing" and I have loaded a custom Attribute business rule. I have also set my DT value for "Always publish Production BOM..." to no. Sry I cannot post text of Business Rule but here it is: Simple rule that should be true if view=Design. Except that I am still getting Design View BOM Headers in my export when the Change Notice is released. Do I have the right attribute for "view"? I often wonder where the source of the exact names is so I can look them up? I've seen it in the ESIResponseMetaInfo.xml as "view.identity" so I could be wrong there. Is the value right? I know that Design in DB is actually 1445. How can you test a business rule to know if its working? I did not see that in the documentation. Any logs that can be turned on to show it being evaluated? Thanks in advance for any replies.   A

Could  share the sql query to get list of project name and numbers.

I have creo parts/assemblies that are in my workspace and they are flagged as "Modified Locally" and "Modifications need to be uploaded" I must of modified these by accident, and i dont want to check them out, save them, then check back in. How do i go about reverting these files in my workspace so they are as they were before I "modified" them. I tried updating the files individually, doing check out then undo checkout, synchronize workspace, update workspace.   Thanks in advance

Hi,   Looking to create an infoengine task that outputs related information about resulting items in a change activity. A snippet of what I have now is below.. I don't think my DIRECTION value is correct but I'm not sure what value to place in here. Any ideas?   ie:param name="TYPE" data="wt.change2.ChangeRecord2"/> param Name="DIRECTION" data="theChangeActivity2"/> param Name="OBJECT_REF" data= (a VR of a ChangeActivity) /> param Name="ATTRIBUTE" data="*" />   This isn't returning anything in the collection. Below is the output. -<wc:COLLECTION>  wt.change2.ChangeRecord2 .... </wc:COLLECTION>  

Has anyone migrated Windchill data to Teamcenter? I'm doing some contigency planning in case we need to support Teamcenter clients in the future.Is there a way to bulk dump metadata from Windchill to a neutral format that can be imported into Teamcenter? Can file vaults be uploaded to Teamcenter? Is anyone aware of a Windchill to Teamcenter migration application?Thanks in advance.

Reposting here ..  Hello, We have following platform configured in the Production Environment. Platform 1 - We have Thingworx Navigate apps configured using Windchill Auth ( ptc-identity-provider-authenticator).  Platform 2 We have another 25000 users platform configured using Active Directory Configuration. We are able to automate user provisioning here.   We have an issue with Platform #1 where we need to assign users manually to various twx apps group on this platform.    Is there a way we can leverage platform #2 configuration for platform #1?   thanks, Preeti

What recommendations for Windchill development code repositories are there?

I'm working on some code in a workflow and I want to be able to query baselines that meet certain conditions. When I use syntax like the below, the workflow goes to an "aborted" state with no indication as to why.  How would I query baselines?   wt.query.SearchCondition sc = new wt.query.SearchCondition(wt.vc.baseline.ManagedBaseline.class, "lifeCycleState", wt.query.SearchCondition.EQUAL, "Approved", false);

ThingWorx Navigate 9.2 is Here!  Launched yesterday, 9.2 features new functionality, including: New Contribute App to create Problem Reports in Windchill  Intuitive UI with support for attachments  Role-based tailoring capabilities for the administrator ThingWorx Flow for system connectivity  More details in the release preview posted last week. Or....      Jump right into the release notes and download 9.2 from the Software Downloads Page today!   Let me know what you think! Emily 

Applicable Release: Windchill release 10.0+   Description: In this video, we will be enabling server side DEBUG Logs by adding additional properties to log4jMethodServer.properties file.              log4j.logger.com.ptc.windchill.uwgm=DEBUG log4j.logger.wt.method.server.timing=INFO log4j.logger.wt.adapter.verbose=INFO

Hi, Would anyone know what windchill setting to change to allow users to create windchill packages (CAD/Technical) and export them?  Our environment currently only allows org admin or higher privileges to create packages.Was hoping that non cad users (purchasing and MFG) that could see the files in windchill would be able to create a package and export it for use outside the Creo Parametric environment.I can fetch a Creo Parametric file to a Creo Parametric workspace but I'm not able to create a package with my user permissions. Any ideas if there's a setting we can change to allow me and others to create packages that contain Creo files without the need of Admins help? Thanks for any help you can provide! Don A  

We typically use this something like this to get the latest rev either in reports or sql. "p.versionsortida2versioninfo = (select max (p1.versionsortida2versioninfo) from wcadmin.wtpart p1 where p1.ida3masterreference = p.ida3masterreference)and p.latestiterationinfo = 1" Does anyone know how to make this work for each view?  The issue comes up when the view revisions are not the same.  For example "part1 Rev A Design view" and "part1 Rev B Service view" excludes the design view.  Anyone know a trick to getting this to work?

Hi All,    My requirement is to send out an Windchill Notification Via Mail before (5day or any set number of days) Prior to the Actual ECN Need date.    Need support on the Same. 

This symbol, seen in your workspace columns, means that changes to a file have been uploaded to the server. How do you reverse this besides removing the modified items from the workspace?  

Hi, can i add some Attributes in Part List under State?

Hi all,       i've tried to call this servlet   POST /Windchill/servlet/odata/IE/InvokeIETask   with this body     { "Task": "com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml", "Params": [ { "Name": "object_ref", "Value": "wt.query.template.ReportTemplate:6852467828" }} ] }   now I need to change the report criteria directly from the API. I tried to add a parameter but it doesn't seem to work.   For example (but it doesn't works)   { "Task": "com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml", "Params": [ { "Name": "object_ref", "Value": "wt.query.template.ReportTemplate:6852467828" }, { "Name":"where", "Value":"((Associated Part.Latest Iteration equals 1) AND (Part Master.Number in 1234))" } ] }     Where can I find documentation? what is the correct parameter?

I have a question about fiability in structure tab. I use "show document" with standard action  On a part, I have 3 described documents attach on it.  See below :(same documents on associated objects)     But in a nomenclature with this part attached, I do the same action (show document) on all structure, Only 2 documents are displayed !!   It's very critical to not have the good information here. someone already had the trouble ?   And last test, if in the structure, I show/hide documents of the specific part it works and after I show document of the entire structure in the case it works....   Very Strange ?   Many Thanks   Windchill version : 10.2 M022 CPS25

Hi,    When I trying to add alias attributes subtypes not working but the same work on when created in OOTB types. How to resolve this? Any Ideas Please?

Hi, has anyone out there come up with a good scheme for managing memory in the WVS CAD Worker machines? I run 5 virtual CAD workers on a single VM, which spawns 5 Creo sessions for converting CAD models to Creo View format. Everything is great when it starts, but over time (about a week), each session of Creo will grab up all memory it can until the machine has little to no memory left. We have implemented a new monitoring system here and I get reports about my CAD workers being critically low on available RAM and virtual memory all the time. I'd like to find a way to make them run more efficiently. Considering a weekly restart of the GS Worker Daemon service over the weekend to see if that will help, but I don't think once/week will be enough. Also concerned about stopping and starting the service on the CAD Worker w/o first shutting down the CAD worker from the Worker Admin UI in Windchill.

Hello again!   I am pleased to announce that our PLM Virtual Conference is now available On Demand in English, French, Italian, and German via the following link: www.plmvirtualconference.com. You can login to the conference with the email you used to registered. If you haven't registered, you can do so here: https://www.ptc.com/en/special-event/plm-virtual-conference.     We hope you enjoy the sessions!   Katie   

Applicable Release: Windchill release 10.0+   Description: In this video, we will learn setting server side DEBUG Log levels using Windchill shell

  Applicable Release: Windchill release 10.0+   Description: In this video, we will be enabling server side DEBUG Logs using Windchill Monitoring Tools.

Applicable Release: WWGM 11.0 and above   Description: In this video, we will learn how to setup and collect DEBUG logs for Windchill Workgroup Manager interactions using WWGM Logger Utility.