Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
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
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.
Thank you Ben,
This is really very helpful I am able to change the type of object