topic Re: Products missing after Rehost in Windchill

Products missing after Rehost

bschmidt-2 — Wed, 02 May 2018 11:25:29 GMT

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

Re: Products missing after Rehost

TomU — Tue, 27 Sep 2016 13:56:39 GMT

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

Re: Products missing after Rehost

bschmidt-2 — Tue, 27 Sep 2016 14:11:01 GMT

Expdp and impdp were called during the rehosting.

We did the following steps:

export ldap
import ldap
expdp
impdp
copy vaults

Re: Products missing after Rehost

TomU — Tue, 27 Sep 2016 14:27:53 GMT

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...

Re: Products missing after Rehost

MikeLockwood — Tue, 27 Sep 2016 15:14:22 GMT

Hopefully PTC is reading this...

I absolutely love what the Re-host utility brings to the table - and applaud PTC for developing it. I've finally become relatively expert using it.

But, the documentation is extremely hard to follow. It takes extreme perseverance to be able to get from the documentation what to actually do and how to do it. The people writing it really tried - you can see that. Just needs some more attention actually sitting with someone trying to follow it. There is so much in the guide about the advanced functionality (e.g. scripting) but it's very hard to get to the point where a very bare-bones basic re-host process is working.

Re: Products missing after Rehost

bschmidt-2 — Wed, 28 Sep 2016 06:14:30 GMT

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.