Load Expressions (or Choices) on Item, Usage, Occurence using XML LoadFromFile in Windchill PDMLink

[Lukasz1]

I am using Windchill PDMLink Release 11.2 and Datecode with CPS 11.2.1.17

Hello,
When loading Usage Expressions to the Windchill product container am getting error message:
java.lang.Exception: Cache key "BASICEXPRESSIONMEMBERS_CACHE_KEY" not found

this command is used:
Windchill wt.load.LoadFromFile -d add.xml -CONT_PATH \"/wt.inf.container.OrgContainer=cpc/wt.pdmlink.PDMLinkProduct=test_trivial_004\" -u username -p pass

Here are the errors that I faced
2023-08-29 11:21:16,434 WARN [ajp-nio-127.0.0.1-8010-exec-5] wt.method.server lli - Interrupting thread DataSource Task Executor-25
2023-08-29 11:22:34,854 INFO [RMI TCP Connection(81)-172.16.1.11] wt.system.out - Processing data file: F:\ptc\Windchill_11.2\Windchill\src\loadFiles\remove.xml
2023-08-29 11:22:34,854 INFO [RMI TCP Connection(81)-172.16.1.11] wt.system.out - Getting container path= '/wt.inf.container.OrgContainer=cpc/wt.pdmlink.PDMLinkProduct=test_trivial_004'
2023-08-29 11:22:34,854 INFO [RMI TCP Connection(81)-172.16.1.11] wt.system.out lli - Using container with path= '/wt.inf.container.OrgContainer=cpc/wt.pdmlink.PDMLinkProduct=test_trivial_004'
2023-08-29 11:22:35,026 INFO [RMI TCP Connection(81)-172.16.1.11] wt.system.out lli - All objects were imported successfully.
2023-08-29 11:23:08,559 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.out - Processing data file: F:\ptc\Windchill_11.2\Windchill\src\loadFiles\add.xml
2023-08-29 11:23:08,559 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.out - Getting container path= '/wt.inf.container.OrgContainer=cpc/wt.pdmlink.PDMLinkProduct=test_trivial_004'
2023-08-29 11:23:08,559 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.out lli - Using container with path= '/wt.inf.container.OrgContainer=cpc/wt.pdmlink.PDMLinkProduct=test_trivial_004'
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - java.lang.Exception: Cache key "BASICEXPRESSIONMEMBERS_CACHE_KEY" not found.
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at com.ptc.windchill.option.load.Loader.addBasicExpressionMember(Loader.java:5070)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at java.lang.reflect.Method.invoke(Method.java:498)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.handlers.netmarkets.CsvIxHandler.invokeLoad(CsvIxHandler.java:545)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.handlers.netmarkets.CsvIxHandler.createObject(CsvIxHandler.java:241)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.actor.PickingExistingObjectActorForPersistable.createObject(PickingExistingObjectActorForPersistable.java:34)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.actor.ActorTemplateForPersistable._createObject(ActorTemplateForPersistable.java:340)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.createObjects(ClassExporterImporterTemplate.java:765)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.importElementsBatchDefault(ClassExporterImporterTemplate.java:652)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.importElement(ClassExporterImporterTemplate.java:452)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforhandlers.ClassExporterImporterTemplate.importElements(ClassExporterImporterTemplate.java:494)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforapps.Importer.importElements(Importer.java:1604)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforapps.Importer.importElement(Importer.java:1550)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforapps.Importer.doRealImport(Importer.java:1349)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.ixb.publicforapps.Importer.finalizeImport(Importer.java:568)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at wt.load.StandardLoadService.importData(StandardLoadService.java:817)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.system.err lli - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-08-29 11:23:08,575 INFO [RMI TCP Connection(82)-172.16.1.11] wt.sy

[Fadel]

just a dummy question , are the conf  parts having an Option Set assigned ? 

[Lukasz1]

The problem pops up for those lines:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE NmLoader PUBLIC "SYSTEM" "standardX24.dtd">
<NmLoader>
	<csvAssemblyAdd handler="wt.part.LoadPart.addPartToAssembly">
		<csvassemblyPartNumber>0000442329</csvassemblyPartNumber>
		<csvconstituentPartNumber>0000442332</csvconstituentPartNumber>
		<csvconstituentPartQty>1</csvconstituentPartQty>
		<csvconstituentPartUnit>ea</csvconstituentPartUnit>
		<csvassemblyPartVersion/>
		<csvassemblyPartIteration/>
		<csvassemblyPartView>Design</csvassemblyPartView>
	</csvAssemblyAdd>
	<csvBeginAssignBasicExpression handler="com.ptc.windchill.option.load.Loader.beginAssignBasicExpression">
		<csvoptionSet>test_trivial_004</csvoptionSet>
	</csvBeginAssignBasicExpression>
	<csvAddBasicExpressionMember handler="com.ptc.windchill.option.load.Loader.addBasicExpressionMember">
		<csvchoiceName>4 K</csvchoiceName>
		<csvInstanceValue/>
		<csvExclude/>
	</csvAddBasicExpressionMember>
	<csvEndAssignBasicExpression handler="com.ptc.windchill.option.load.Loader.endAssignBasicExpression"/>
	<csvAddBasicExpressionMember handler="com.ptc.windchill.option.load.Loader.addBasicExpressionMember">
		<csvchoiceName>No condensing line</csvchoiceName>
		<csvInstanceValue/>
		<csvExclude/>
	</csvAddBasicExpressionMember>
	<csvEndAssignBasicExpression handler="com.ptc.windchill.option.load.Loader.endAssignBasicExpression"/>
</NmLoader>

Is it because they are belonging from different options?

Lukasz

[Fadel]

The given option set should include the choices to be assigned and its option  , it could also be thrown by some mis configured preferences for expressions .

I will run the test and get back to you .

[Lukasz1 · Accepted solution]

I can see, It is because of 

<csvEndAssignBasicExpression handler="com.ptc.windchill.option.load.Loader.endAssignBasicExpression"/>

that should be removed, between the options.

Lukasz