1-Visitor

Question

How to update the Type of the EPMDocument

Forum|Forum|8 years ago
May 26, 2017
1 reply
2499 views

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

EPM

15-Moonstone

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.

Author

1-Visitor

Thank you Ben,

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