Migrating Issue Thingworx 7.3 to 8.3

avbee · ‎Jul 12, 2018

Hi,

I have a problem after finish with Thingworx PostgreSQL 8.3 installation, i plan to import all the entities i have backup before.But the import is failed.
I backup the entities with file entities.twx from Thingworx PostgreSQL 7.3.

Here is the log:

2018-07-12 12:25:30.444+0000 [L: INFO] [O: c.t.w.Importer] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Starting entity import
2018-07-12 12:25:30.464+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions Group [Users]
2018-07-12 12:25:30.465+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object Group [Users]
2018-07-12 12:25:30.480+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions Group [Developers]
2018-07-12 12:25:30.481+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object Group [Developers]
2018-07-12 12:25:30.481+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions Group [Designers]
2018-07-12 12:25:30.481+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object Group [Designers]
2018-07-12 12:25:30.483+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions Group [Administrators]
2018-07-12 12:25:30.484+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object Group [Administrators]
2018-07-12 12:25:30.485+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions Group [SecurityAdministrators]
2018-07-12 12:25:30.485+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object Group [SecurityAdministrators]
2018-07-12 12:25:30.486+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Ignoring Group [Users]
2018-07-12 12:25:30.486+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Ignoring Group [Developers]
2018-07-12 12:25:30.486+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Ignoring Group [Designers]
2018-07-12 12:25:30.486+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Ignoring Group [Administrators]
2018-07-12 12:25:30.486+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Ignoring Group [SecurityAdministrators]
2018-07-12 12:25:30.584+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions User [System]
2018-07-12 12:25:30.585+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object User [System]
2018-07-12 12:25:30.590+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Overwrite System Objects : Ignoring Imported Object Except for Permissions User [SuperUser]
2018-07-12 12:25:30.591+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Cannot Create System Objects : Ignoring Imported Object User [SuperUser]
2018-07-12 12:25:30.606+0000 [L: ERROR] [O: c.t.c.ImportProcessor] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Unable to process import: User [BMW] Already Exists, With Different Case
2018-07-12 12:25:30.608+0000 [L: ERROR] [O: c.t.w.Importer] [I: ] [U: bmw] [S: ] [T: http-nio-8080-exec-4] Entity import failed

Can someone help me to solve this problem?

*FYI: with or without check Use default Persistence Provider and Include Subsystems has the same result.

supandey · ‎Jul 12, 2018

@avbee wrote:

*FYI: with or without check Use default Persistence Provider and Include Subsystems has the same result.

Hi @avbee

The warnings / errors are only on the system objects, use default persistence provider option just tells the import utility to import in available default persistence provider (on new ThingWorx instance) in case entities on your previous systems had different persistence provider than the default one (since you are allowed to have more than 1 persistence provider).

Include subsystems is whether or not to import the configuration from old ThingWorx subsystems to new ThingWorx installation

The warnings you have shared is on the system objects & user which as the warning highlights already exists :)

Are you seeing more errors other than what you have shared below?

avbee · ‎Jul 12, 2018

@supandey yes, here is it.

supandey · ‎Jul 12, 2018

Most the warns appear to be on the system objects, for rest of the custom entities error out during import is because they already exist in the system.

Are you running into some specific issue while working with these imported entities?

avbee · ‎Jul 12, 2018

I'm not sure i get your point about specific issue, because the thingworx 8.3 is fresh installation. And the first thing i did in the new platform is import the backup i've made in the old version thingworx.

The steps i went through:
1. Import from file
2. Import type : entity
3. Pick the option from single file
4. Choose the file
5. Hit Import button

After waiting a few minutes, it returns failed.

...rest of the custom entities error out during import is because they already exist in the system. <-- i can't find anything in new thingworx besides default one.

supandey · ‎Jul 12, 2018

By custom entities I meant all the entities that you created on 7.3 which you are trying to import to 8.3. For e.g. if i pick this error :

2018-07-12 09:45:57.724+0000 [L: ERROR] [O: c.t.c.ImportProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-2] Unable to process import: MediaEntity [SC_meter_map] Already Exists, With Different Case

I would assume its something you have created in 7.3 so its not a system object and as the error message highlights that the entity in 8.3 seems to already exist with same name

Now if i pick another :

2018-07-12 09:45:53.663+0000 [L: WARN] [O: c.t.c.ImportProcessor] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-2] Cannot Create System Objects : Ignoring Imported Object StyleDefinition [StatusError]

As the message highlights its a system objects so it will not import because it already exist. You may not see it if you navigate to the StyleDefinition in the Composer, that is because there is a filter to hide the system object. Of course you can change it to list all the entities.

I'm not aware how the backup was taken, meaning the exports from the old system and which persistence provider your 7.3 had, but if you have followed all the upgrade procedure defined in ThingWorx : Upgrading to ThingWorx 8.3 and if you still don't see any of your actual entities, i.e. entities other than system object. I would recommend opening a support case with us so someone could review the export / import procedure.

SaranKarthick · ‎Aug 30, 2018

Hi @supandey,

I have a question. If i develop some entities in TWX 8.2 composer and export it as xml files, then I import the same in TWX 8.3 composer will i get any errors. Is there any compatibility issue we may need to see for?

Regards,

Saran

supandey · ‎Aug 30, 2018

Hi @SaranKarthick if its not a system object and if doesn't already exists on the target system where you are importing it, it should work fine.

When importing to more recent version like 8.3 or 8.3.1 you might run into import issues concerning the password field (i.e. if your exported entities contains password fields), for this you might want to check this article ThingWorx Error "Internal error.java.lang.Exception: Conversion Error on Field password: Unable to Convert from com.sun.org.apache.xerces.internal.dom.DeferredElmentSimpl to PASSWORD" Occurs When Importing Entities to a New Server