Solved: Products missing after Rehost

bschmidt-2 · ‎Sep 27, 2016

Hi all,

we created a test system and tried to rehost our production system (Windchill 10.2 M030 CPS03).

It worked fine with the user data (LDAP import successful) but we are missing all our products and objects. We can only see the newly created product.

Please see attached screenshot.

Does anyone have a hint what could have gone wrong during rehosting? Did anyone experience the same behavior?

Thanks in advance!

Benjamin

TomU · ‎Sep 28, 2016

The fact that Windchill starts up successfully makes me think the Rehost utility worked fine. I really question if the database was imported correctly. The Rehost utility doesn't make changes to existing products or libraries. It's basically changing server names, file paths, passwords, etc. If the rehosted system fires up correctly, then what you see when you log it is what exists in the database.

Are you allowed access directly to the database? If so, try querying for the products and libraries:

select * from PDMLinkProduct

select * from WTLibrary

View solution in original post

TomU · ‎Sep 27, 2016

Did you copy your production database to your test system (and import it) before running the Rehost utility?

bschmidt-2 · ‎Sep 27, 2016

Expdp and impdp were called during the rehosting.

We did the following steps:

export ldap
import ldap
expdp
impdp
copy vaults

TomU · ‎Sep 27, 2016

What version of the Rehost utility are you using?

Are you positive the database import actually worked? (Maybe do a row count on a few of the larger tables and make sure they agree with production.)

I'm assuming you ran the other required Rehost tasks after step 5 above - InfoEngine, Apache, Database, and Vault...

bschmidt-2 · ‎Sep 28, 2016

RehostingUtility 10.2 M010 it is.

And yes, we ran the other tasks afterwards.

Here's the logfile:

WARN [Echo]: ***************************************************************

WARN [Echo]: ** Starting Rehost Utility 3.0 M010 B05 20160916 1631 (16) **

WARN [Echo]: ***************************************************************

WARN [Echo]: modules=rehost.firstrun

INFO [DBConnectionValidator]: RehostProject: OS Name: Windows Server 2012 R2 windows:true prop dir:D:\install\MED-61138-CD-RehostingUtility_102_M010\conf\rehost.properties

INFO [DBConnectionValidator]: Log may contain passwords? false

INFO [DBConnectionValidator]: Properties for Task:

INFO [DBConnectionValidator]: * Rehost Parameter:rehost.log.passwords=false

* Rehost Parameter:test.prop.values.only=false

target.db.hostname=srv-test.smb.lan

target.db.jdbc.database=

target.db.password=*******

target.db.port=1521

target.db.serviceName=oratest

target.db.username=orauser

target.db.vendor=oracle

INFO [DBConnectionValidator]: Connecting to jdbc:oracle:thin:@srv-test.smb.lan:1521:oratest

INFO [DBConnectionValidator]: Successfully connected to the database.

WARN [Echo]: InfoEngine,Database

INFO [BackupTask]: RehostProject: OS Name: Windows Server 2012 R2 windows:true prop dir:D:\install\MED-61138-CD-RehostingUtility_102_M010\conf\rehost.properties

INFO [BackupTask]: Log may contain passwords? false

INFO [BackupTask]: Properties for Task:

INFO [BackupTask]: * Rehost Parameter:rehost.log.passwords=false

* Rehost Parameter:target.directory.ldap=D:\ptc\Windchill_10.2\WindchillDS

* Rehost Parameter:test.prop.values.only=false

rehost.useCase=rehost.firstrun

target.db.hostname=srv-test.smb.lan

target.db.jdbc.database=

target.db.password=*******

target.db.port=1521

target.db.serviceName=oratest

target.db.username=orauser

target.db.vendor=oracle

INFO [BackupTask]: Rehost home directory is D:\install\MED-61138-CD-RehostingUtility_102_M010

INFO [BackupTask]: Backing up rehost configuration to D:\install\MED-61138-CD-RehostingUtility_102_M010\backups\rehost.firstrun_20160916_1631

INFO [BackupTask]: Discovered tasks: InfoEngine,Database for scenario: rehost.firstrun

INFO [BackupTask]: Enabling ldap backup beause of task InfoEngine

INFO [BackupTask]: Adding tables to backup set: Repository,RemoteObjectId,FvHost,WTProcessStep,CollaborationInfo

INFO [BackupTask]: Properties for exporting LDAP:

INFO [BackupTask]: target.directory.ldap=D:\ptc\Windchill_10.2\WindchillDS

target.ldap.baseDn=cn=configuration,cn=Windchill_10.2,o=ptc

target.ldap.hostname_NO_SUFFIX_=srv-test.smb.lan

target.ldap.password_NO_SUFFIX_=******

target.ldap.port_NO_SUFFIX_=389

target.ldap.username_NO_SUFFIX_=cn=Manager

INFO [BackupTask]: Running command: D:\ptc\Windchill_10.2\WindchillDS\server\bat\export-ldif --ldifFile D:\install\MED-61138-CD-RehostingUtility_102_M010\backups\rehost.firstrun_20160916_1631\backup.ldif --backendID userRoot --appendToLDIF --hostName srv-test.smb.lan --port 4444 --bindDN cn=Manager --bindPassword ****** --trustAll --noPropertiesFile

INFO [BackupTask]: ** command output **

Export task 20160916163134037 scheduled to start immediately

[16/Sep/2016:16:31:33.990 +0200] severity="NOTICE" msgCount=0 msgID=9896349 message="Export task 20160916163134037 started execution"

[16/Sep/2016:16:31:33.990 +0200] severity="INFORMATION" msgCount=1 msgID=10487422 message="Exporting to D:\install\MED-61138-CD-RehostingUtility_102_M010\backups\rehost.firstrun_20160916_1631\backup.ldif"

[16/Sep/2016:16:31:33.990 +0200] severity="NOTICE" msgCount=2 msgID=8847447 message="Exported 372 entries and skipped 0 in 0 seconds (average rate 11625,0/sec)"

[16/Sep/2016:16:31:33.990 +0200] severity="NOTICE" msgCount=3 msgID=9896350 message="Export task 20160916163134037 finished execution"

Export task 20160916163134037 has been successfully completed

** End command output **

Command successful

INFO [BackupTask]: Backing up database tables: [CollaborationInfo, Repository, FvHost, WTProcessStep, RemoteObjectId]

INFO [BackupTask]: Connecting to jdbc:oracle:thin:@srv-test.smb.lan:1521:oratest

INFO [BackupTask]: Ignore following error message if backup table already existed.