How exactly value is generated for Ida2a2 column in EPMDocumentMaster table

[ptc-1011665]

Hi Friends,

Need to understand how value is generated fir Ida2a2 column in EPMDocumentMaster.  Observed that it is not an identity column.  Is it normal max+1 serial number filling or any other logic exists?

Windchill database is hosted on SQL Server.

We are trying to repair windchill database which got corrupted due to disk failure.

Please share info if anyone is aware of the logic.

Regards,

Hema

[joe_morton]

Oh man... for any Database issues, I'd recommend you open a call with PTC for their support. Direct database edits (without their involvement) are typically not supported. 

[ptc-1011665]

Hi Joe,

Agree with you.  PTC has suggested for backup restoration.  But ours is an extremely unfortunate case of backup failure.   We do not have decent backup for restoring.

Corrupt database has been recovered using recovery tool.  But application is throwing ava runtime errors while accessing.  We understood that the errors are because of some missing records, which we are trying to build.

Our vault is intact, and we were able to get list of orphaned files for which we are trying to create EPMDocumentMaster records.

Any suggestion?

Regards,

Hema

[HelesicPetr]

Hi @ptc-1011665 

The ida2A2 value for EPMDocument is generated by id_sequence in database. In this table are the numbers that are used for ida2A2. 

The numbers are cached so in my case I can find only each next one hundred value. 

I'm not sure if this can help you to restore the EPM rows.

last EPMDocument row

The information I found in follwoing article : CS367634

PetrH

[ptc-1011665]

The article talks about wtpart.  Does the same holds good for epmdocument as well??

[HelesicPetr · Accepted solution]

It is used for everythink

Odesláno z iPhonu

[avillanueva]

@ptc-1011665 , send us an update when things are back and running. I think it would be useful for others to learn about what failed with your backup strategy.