Sourcing entry already exists

[avillanueva]

I have a number of updates to do for about 100 parts so want to make use of the import from spreadsheet. The OEM parts, Mfg and vendor parts all exist. What I am looking to do is have each part of 2 MFG parts and those two MFG parts have a vendor part which is basically the same part. Also, in some cases, the AML exists partially meaning that the MFG parts are already linked. We are just adding the additional vendor part relationship.  The sheet validated ok but import failed with "Sourcing entry already exists". 

Resorting the sheets ...

Sheet 1 "axl-1":
Type: Type: Error
Row: 
Description: Description: Sourcing entry already exists
(com.ptc.windchill.suma.ixb.SuMaIxbHndRB/SUMA_AXLENTRY_EXIST_CONFLICT) wt.ixb.publicforhandlers.LogHelper$IxbException: Sourcing entry already exists
	at wt.ixb.publicforhandlers.LogHelper.userError(LogHelper.java:252)
	at com.ptc.windchill.suma.ixb.SuMaIxbHndHelper.userError(SuMaIxbHndHelper.java:412)
	at com.ptc.windchill.suma.ixb.handlers.ExpImpForAXLEntry.createObject(ExpImpForAXLEntry.java:482)
	at wt.ixb.actor.PickingExistingObjectActorForPersistable.createObject(PickingExistingObjectActorForPersistable.java:34)
	at wt.ixb.actor.ActorTemplateForPersistable._createObject(ActorTemplateForPersistable.java:340)
	at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.createObjects(ClassExporterImporterTemplate.java:785)
	at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.importElementsBatchDefault(ClassExporterImporterTemplate.java:673)
	at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.importElements(ClassExporterImporterTemplate.java:521)
	at wt.ixb.publicforapps.Importer.importElements(Importer.java:1609)
	at wt.ixb.publicforapps.Importer.importElement(Importer.java:1554)
	at wt.ixb.publicforapps.Importer.doRealImport(Importer.java:1353)
	at wt.ixb.publicforapps.Importer.finalizeImport(Importer.java:572)
	at wt.ixb.publicforapps.Importer.finishImport(Importer.java:1064)
	at com.ptc.windchill.suma.ixb.importer.AXLSheetImporter.importSheetElements(AXLSheetImporter.java:170)
	at com.ptc.windchill.ixb.importer.StandardImportService.importInChunk(StandardImportService.java:1280)
	at com.ptc.windchill.ixb.importer.StandardImportService.doSameTypeSheetImport(StandardImportService.java:1234)
	at com.ptc.windchill.ixb.importer.StandardImportService.doPreviewOrImport(StandardImportService.java:907)
	at com.ptc.windchill.ixb.importer.StandardImportService.importSpreadsheet(StandardImportService.java:215)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at wt.queue.QueueEntry.execute(QueueEntry.java:267)
	at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:317)
	at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:925)
	at wt.queue.PollingQueueThread.run(PollingQueueThread.java:103)
Type: : Error
Row: : 226
Description: : Import failed...
wt.util.WTException: Import failed...
IMPORT RESULT : FAILED

[avillanueva]

ok very strange things going on here. Perhaps it has to do with the vendor part being the same but here is the import sheet for a single OEM part.

I tried loading this line by line as a test. I think it remove one of the MFG lines and replace it with another!

[avillanueva · Accepted solution]

Yep, this is what I had before I submitted an update:

Notice MFG was 07955. I then uploaded a sheet that ADDED a new MFG as 8FQB9 with the same vendor part. I think what the import is doing is thinking that this is the same line and the intent was to replace it with the import. Not my intent at all. Ok, let's try adding the other MFG but leaving vendor off. Ok, better:

Let's try adding the vendor to the 07955 line...

So, same error, via import, its not possible to add the vendor in for another MFG. Not possible to do manually as well. Ok, chalk this up to the rule that you cannot have two MFGs listed tying to the same vendor part. Got it!