How to fix this error - Engineering Part Revision already exists

@Link Thank you for your reply.

currently the Eng Rev=2, Inventory Rev = 2, I am trying to create a new Eng Rev =3, and I get above error message.

below is the screenshot for inventory part → tab Revisions. Thank you.

Hi @ronhu,

We are talking about the Eng Part Rev first and not the Inv Part Rev. Therefore, please check whether there is already a Rev 3 for this Eng Part 1069908. If so, this cannot be created a second time, but a Rev 4 must be created from the Rev 2. The Inv Part Rev only comes into play when the Eng Part Rev is transferred to a location via the Transfer job. Therefore, these Rev numbers can also differ and do not necessarily have to be identical. The reference can be seen in the Inv Part Rev in the column "Eng Rev".

Best regards,
Mike

@Shaun Next Engineering Part Revision can be anything, as long as it is valid and not duplicate in Eng Rev No, I think.

@mike.brukner There is no Eng Rev 3 for this part. I did some tests, i realized the problem is due to the column Revision Number Maximum, this number controls the Eng Rev counts it is currently for the part. It could be a bug, this value currently for this part is 1. I can simply obsolete one of the engineering part revision and delete it, then this problem can be resolved. but deletion is not easy, since this revision is used in product structure, unless you remove it all from all the structure where it resides. 

I think I have to talk to IFS to DB repair this column value to 2. 

Thank you.

Hi @Shaun,

You mean this column here, right:
 

As can be seen from the field help...

Revision Number Maximum
The highest number used when generating a new revision, i.e., the total number of revisions created for this part. This value is an internal counter used to keep track of all revisions for a part. When a new revision is created, the counter is incremented by 1. Removal of a revision does not affect this counter. This value is used to correctly order part revisions in forms and reports. If the last created revision is deleted, the value in the Last Revision No field is updated to show the number of the latest existing revision, while the value in this field remains unchanged.

...this column shows which internal revision number is the highest. Here as an example to the above marked line with the value "5" this comes from the (internal) revision No 5 to the Eng Rev "R03":

Check if the value in the "Engineering Part" mask matches the maximum value of the "Revision No" in the "Engineering Part Revision" mask.

Mike

@mike.brukner Thank you for your input.

@Shaun I figured out why this is happening, but our case might be different as what you are. We are using migration job to uploading Windchill new revisions. the migration might not be configured properly, so the column Revision Number Maximum is not update accordingly. What is your case then, have you figure out why this is happening? 

Thank you.

I believe that our issue may be triggered by a similar process used to load parts in bulk.

@mike.brukner I understand the reasoning for this but how would it explain the max revision number seemingly reverting to a lower value than when an attempt was made to add another engineering part revision ? I would expect the update to fail without updating a value ? As stated previously we have traces in place to see whether that is actually happening though :-)