Error when loading global enumerations using load from file

[RK_10805837]

Hello,

I am trying to load global enumerations from windchill 11.1 to windchill 12.0 using Load from file command. However, I am facing an an uniqueness exception in doing so. The windchill version for the target system is 12.0.2.15 with CPS15 installed. I have attached the log file containing the error. Kindly provide any suggestions on how to resolve this,

Command used:-

windchill --javaargs="-Dwt.auth.trustedAuth.username=wcadmin" wt.load.LoadFromFile -d /appl/ptc/builds/SCF_Lufkin_Build/loadFiles/sic/GlobalEnumerations/Global_Enum_All_0.xml

Thanks,

Ramsha 

[HelesicPetr]

Hi @RK_10805837 

Your source file contains some global enum values that are not unique as it is needed in the database.

You need to find what value is not unique.

PetrH

[RK_10805837]

Hi @HelesicPetr ,

A colleague of mine has used the same source file to load into his local windchill and it seems to be working fine for him. I guess this is a database issue not related to the loader file. Could you please provide any hints on how to resolve that?

Thanks again,

Ramsha

[HelesicPetr]

Hi @RK_10805837 

It is possible. 

The point is that the system can already contains some values that has to be unique and yours are just duplicated. 

One record is not unique and you need to find what it is.

Go to database and check the table LWCLocalizablePropertyValue

select * from wcuser.LWCLocalizablePropertyValue

compare the values to your file

add a where condition

select * from wcuser.LWCLocalizablePropertyValue
where idA2A2='5422'

also you can divide your file and try to load one enumeration by one , and thanks that you can find what is wrong. 

PetrH

PS> if you can share a source file, it can be useful.

[Fadel]

Windchill complains about below entry in DB

LWCLocalizablePropertyValue:5422

you can import the attached qml on the target system and run it with the given id 5422, it should then give better sight in the problematic entry in DB 

[RK_10805837]

Hi @Fadel ,

Thankyou for your response. I tried importing your attached qml on the target system but I am facing the below error:

Is there something wrong that I am doing?

[Fadel]

import as QMl not as template 

[HelesicPetr]

@Fadel 

the ootb record with that number is 'Update Stamp' 😄 

PetrH

[Fadel]

The IDA2A2 are different from a system to the other on my VM they are 69xx  

[HelesicPetr]

Hi @Fadel 

Yes but it is very low ida2a2 number so I guess that the record is from installation so it is the OOTB enumeration record. 

if the source file contains the OOTB enumeration then it could case this problem. 

PetrH

[Fadel]

after 12 years windchill, the ida2a2 is still a mystery to me , wcadmin is actually one one of the first objects that are  created and it has ida2a2=2008 , on other VMs it has ida2a2=11 .

[RK_10805837]

Hi @Fadel ,

Whenever I execute the load command, the value at which the error is pointing is always different. Moreover, when I try to search for the  same value in the report, it doesnt show me any results

[Fadel]

Do the given numbers exist in the xml file you try to load ? can you share a copy of that file ?