Skip to main content
D
DK_103042223-Newcomer
3-Newcomer
August 13, 2024
Solved

We are trying to extract Windchill As-stored BOM Information from Windchill DB

  • August 13, 2024
  • 2 replies
  • 2222 views

Version: Windchill 11.1

 

Use Case: We are trying to Extract Windchill As-stored BOM Information from Windchill DB and Staging DB, We are not finding the BOM Child As-stored Revision in the both database.


Description:

We are trying to Extract Windchill As-stored BOM Information from Windchill DB and Staging DB, We are not finding the BOM Child As-stored Revision in the both database.
From the Windchill Database we are not able to find Child Relation between EPMASSTOREDMEMBER and EPMMEMBERLINK.

Best answer by HelesicPetr

So you did something wrong.

Check your condition.

PetrH

2 replies

H
Hari_Vara16-Pearl
16-Pearl
August 13, 2024

Hi,

As far as I know, only EPMDocument structure is by default always have a "As Stored" configuration. For BOM, there must a Baseline defined, or a Promotion Request snap shot or "As Matured" configuration (In case of Release by ECN), only if any of the 3 are there in the system , you can extract the BOM configuration as per your intent.

We can wait for other experts reply on this.

There may be some workaround through the CAD-Part link somehow.

 

Cheers

Hari

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
August 20, 2024

Hi @Hari_Vara 

@DK_10304222 talking about the CAD BOM Structure not about the WTPart structure. 

So the CAD Structure have the as stored definition. 

@DK_10304222 

It is really not good practice to collect information directly from DB. 

If the information is not in the database then the as stored configuration does not exists.

PetrH

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
August 20, 2024

Hi @DK_10304222 

It is litle but complicated 😄 there is a table where is a configuration and it is linked by child CADName

 

here is the sql that returns the child IDA2A2 and parent IDA2A2 

With this select you find the specific as stored child. 

 

select asstored.idA3B5 as CHILDEPMIDA2A,link.idA3A5 as PARRENTIDA2a2,epmMaster.documentNumber as CHILDNUMBER,* from wcuser.EPMMemberLink link 
inner join wcuser.EPMDocumentMaster epmMaster on epmMaster.idA2A2=link.idA3B5
inner join wcuser.EPMAsStoredMember asstored on link.asStoredChildName=epmMaster.CADName
inner join wcuser.EPMAsStoredConfig config on asstored.idA3A5=config.idA2A2

 

Select with revision/iteration info from child EPMDocument

select asstored.idA3B5 as CHILDEPMIDA2A,epmDoc.versionIdA2versionInfo as REVISION,epmDoc.iterationIdA2iterationInfo as ITERATION,link.idA3A5 as PARRENTIDA2a2,epmMaster.documentNumber as CHILDNUMBER,* from wcuser.EPMMemberLink link 
inner join wcuser.EPMDocumentMaster epmMaster on epmMaster.idA2A2=link.idA3B5
inner join wcuser.EPMAsStoredMember asstored on link.asStoredChildName=epmMaster.CADName
inner join wcuser.EPMAsStoredConfig config on asstored.idA3A5=config.idA2A2
inner join wcuser.EPMDocument epmDoc on epmDoc.idA2A2=asstored.idA3B5

Hope this help you to solve your issue.

PetrH

V
vnamboodheriCommunity Manager
Community Moderator
August 20, 2024

Hello @DK_10304222, 

 

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.

Terms & ConditionsCookie settingsAccessibility statement