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

How to update the Type of the EPMDocument

Participant

How to update the Type of the EPMDocument

Hi,

I am working in data migration  but mistakenly I have loaded data in wt.epm.EPMDocument but I want to load data in wt.epm.EPMDocument|com.xxxxxx.DefaultEPMDocument data type can any one please tell me which table values I need to updated

select epmdocument.ida2a2, controlbranch.ida2a2, epmdocumentmaster.documentnumber, wttypedefinitionmaster.inthid, wttypedefinitionmaster.ida2a2 from wttypedefinitionmaster, epmdocumentmaster, epmdocument, controlbranch

where epmdocumentmaster.ida2a2 = epmdocument.ida3masterreference and controlbranch.ida3b5 = wttypedefinitionmaster.ida2a2

and epmdocument.branchida2typedefinitionrefe = controlbranch.ida2a2 and  epmdocumentmaster.documentnumber = 'xxxxxx.PRT';

I have updated epmdocument.branchida2typedefinitionrefe but it did not work

2 REPLIES 2

Re: How to update the Type of the EPMDocument

Ankit Dev‌,

Have you reviewed these 2 articles yet?

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS7287

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS52368

The article states you need to update both branchIdA2typeDefinitionRefe and idA2typeDefinitionReference values.

Re: How to update the Type of the EPMDocument

Thank you Ben,

This is really very helpful I am able to change the type of object

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________ Check out the Windchill Tips Board! We're talking about Whirlpool's use of digital twin, augmented reality, and data-driven design!

The NAVIGATE WORKING GROUP is here! Come innovate with PTC!

Sign up for a Working Group