cancel
Showing results for 
Search instead for 
Did you mean: 
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

adev-2
4-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
BenPerry
12-Amethyst
(To:adev-2)

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.

adev-2
4-Participant
(To:BenPerry)

Thank you Ben,

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

Announcements