lost object attribute for all part/assys/dwg in Commonspace

[ptc-2245035]

Pro Experts,

I had modified an Intralink attribute called Cage_Code by modifying its
Default value. PTC told me it would affect existing components but all
of our parts and assemblies have lost their Cage_Code information
because it is overwritten by the Default value of - .

What is the best way to get back the attribute information. I know I
can restore the *.dmp file to the last known date when I had the
attributes. Is there a less risky way to do this? Would I be able to
somehow extract the Cage_Code information from the *.dmp file and
manually put them back in? The reason I ask this is I would have to
restore back from 2 weeks ago, so we could potentially lose 2 weeks of
information. Any help would be greatly appreciated!







Madhav Rao

DRS C3 Systems, Inc.

1200 E. Mermaid Lane

Wyndmoor, PA 19038

215-242-7237




This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[pwilliams-3]

Ouch,

That's a rough one. Off the top of my head you could stand-up a
separate Pro/INTRALINK system with the 2 week old .dmp file. You would
then have to execute a sql script or Pro/INTRALINK toolkit program to
extract the attribute information (to a text file for example). Then
have another sql script or Pro/INTRALINK toolkit program to read the
text file and update the current database with the values. It's not the
best solution but you may not have a choice.



I would lean more towards the toolkit program because PTC will support
that method rather than directly modifying the Oracle tables through sql
scripts.



Patrick Williams | Sr. Application Engineer | Engineering Systems |
Steelcase Inc. | 616.698.4078 | My Site
<">http://my.steelcase.com/Person.aspx?accountname=NA\PWILLIA3>

[rstewart-2]

I agree with Patrick, but the Pro/INTRALINK toolkit approach has too many
drawbacks that depends on the attribute type. Modifying the Oracle data is
by far the easiest, there is some risk, but it's minimal with attribute
data. I have done this numerous times to recover/update data.



Basic approach with single server.



Backup current Oracle database.

Load old Oracle dump file.

Extract the attribute values with a SQL script.

Load the current Oracle dump file.

Update the attribute data.

Test to make sure the values are correct.



The scripts to extract and update attribute data have been posted numerous
times. I am sure someone has it.



Good Luck,





Raymond Stewart



Principal Consultant, Data Management Services

Stewart & Associates Consulting Services

Flower Mound, TX 75028