Skip to main content
avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
September 10, 2025
Solved

Sourcing entry already exists

  • September 10, 2025
  • 2 replies
  • 417 views

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
Best answer by avillanueva

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

avillanueva_1-1757505058674.png

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:

avillanueva_2-1757505273525.png

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!

 

2 replies

avillanueva
23-Emerald I
avillanueva23-Emerald IAuthor
23-Emerald I
September 10, 2025

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.

avillanueva_0-1757504710062.png

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
23-Emerald I
avillanueva23-Emerald IAuthorAnswer
23-Emerald I
September 10, 2025

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

avillanueva_1-1757505058674.png

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:

avillanueva_2-1757505273525.png

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!

 

Terms & ConditionsCookie settingsAccessibility statement