Skip to main content
J
JimTVancouverCa1-Visitor
1-Visitor
May 12, 2014
Question

Automated rehosting. Bugs and problems help request.

  • May 12, 2014
  • 25 replies
  • 9377 views

Hello all,


I am attempting to do my first system rehost. I want to use the Windchill Rehosting Utility. I have fully read the guide and made detailed notes and the necessary configuration files. I must have missed something because I am receiving an error when I try to run. The error is:


[DBValidator] 2014-05-12 13:04:32,335 ERROR [main] com.ptc.wc.rehost.validate.DBConnectionValidator - Failed to validate db connection:[DBValidator] java.sql.SQLException: ORA-01017: invalid username/password; logon denied

My projects.properties contains:


# Defines the modules for each use scenario. Modules are separated using a comma.

#rename.modules=StartProcessTask:${rehost.script.task1},IERehostTask,StartProcessTask:${rehost.script.task2},DBRehostTask# rename.modules=IERehostTask,ApacheRehostTask,DBRehostTask,OrgRehostTask,StartProcessTask:rehost.script.task1,VaultTaskrehost.modules=StartProcessTask:StartProcessTask:rehost.script.PTCFolderCopy,StartProcessTask:rehost.script.LDAPImport,IERehostTask,ApacheRehostTask,StartProcessTask:rehost.script.ORACLEDBCopy,StartProcessTask:rehost.script.ORACLEDBImport,DBRehostTask,StartProcessTask:rehost.script.WindchillOracleStart,VaultTask,FileServerTask,InstallerRegistryRehostTask

My renamed rehost.properties is attached. Note password lines are all referenced to encrypted passwords set by the setAuth.bat utility as directed in the Windchill Rehosting guide.



For the Oracle database connection I have verified both the PDMLink user account password and the system manager account password, and I have tried both with the setAuth.bat utility and re-ran the rehost.bat utility. Neither of these are successful.



I am working with PTC on this issue, but currently I am in a wait state so thought I'd reach out here for the record.



Has anyone successfully used the automated rehosting utility? If you have did you encounter this '[DBValidator] java.sql.SQLException: ORA-01017: invalid username/password; logon denied' error?



Thanks again!




25 replies

Show previous replies
C
ChrisWatson5-Regular Member
5-Regular Member
May 13, 2014
As the incoming PTC Product Owner for Rehosting - I concur with many of the points raised here. It would be nice if there was a standardized tool, but as Randy points out there does need to be a middle ground between a single script and the many variances in customer reality. The current and pending solutions do provide a box of tools but they need to be tailored heavily to a customer environment and indeed allow for customization since for example we don't support Copy-On-Write FSs out of the box (personally I can't get enough ZFS (although the current Linux implementation is a little buggy)).

Looking forward we are planning to both improve the box of tools and to reduce the level of tailoring - and that's something that I need feedback on.

I will say that I whilst I have 15+ years of Windchill experience under my belt, I have never rehosted a system (I've installed many and upgraded quite a few) - and I thoroughly intend to demonstrate rehosting based on PTC documentation and tools available to customers; at PTC Live Global - when I will expect Mike to make good on that Lobster dinner.

So challenge laid down - I expect to see you all at my session.....

Chris
J
jzupfer1-Visitor
1-Visitor
May 13, 2014
That's great news, Chris-and we'll look forward to getting any and all feedback you have regarding the documentation.

Jane

[
M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
May 13, 2014
Well said 🙂
[cid:image001.png@01CF6EAF.4F29B7E0]

I'll even pay up fully if you complete the simplest possible case:*

- Oracle, Windchill on same host, Windows, no replication, no cluster, no VMWare

- Only PDMLink installed, no Solr, no WBR, no visualization, no WPA

- Windchill data consists of one WTDocument, vaulted on same host (forceContentToVault=true)

- Target is different hostname, same architecture, standard file system

* Using only the documentation currently available to customers and creating no more than 10 tech support cases

Unfortunately, I'll miss PTC/User next month - first time in 12 years.
C
ChrisWatson5-Regular Member
5-Regular Member
May 13, 2014
Linux not Windows - I have standards
And this round will need to run in a VMware guest - but won't use VMware features.

Chris
J
JimTVancouverCa1-VisitorAuthor
1-Visitor
May 13, 2014

Hello Randy,


It sounds like you have a good system worked out. I do see that there are certain things that only have to be done the first time, and other tasks that can happen at other times. The rehosting utility can accomodate some of this by the looks of it. The guide perhaps doesn't cover this in enough detail, that being said it is not an easy topic to learn as many have said and I am experiencing.


- Jim

J
JimTVancouverCa1-VisitorAuthor
1-Visitor
May 13, 2014

Hello Chris,


Congratulations on the new assignment. I wish I could attend this year's PTC Live to see your progress as you work to improve the rehost experience.


You commented, in a way, that you prefer linux. No site I have worked at yet has used Linux for their Windchill servers. Will there be good documentation, testing, and examples provided for those of us in a Microsoft / Oracle only world?


Thanks again.

M
MarcHendrickson1-Visitor
1-Visitor
May 13, 2014
I will say this again, if you used your own technology, I.E. O&V, Technical Publications, etc... that you sell to your customers to provide better documentation of configurable products. You could build not only the streamline scripts for rehosting the Windchill Configurable Product but you could also provide specific admin guides specific to my installation...

Just a thought.
C
ChrisWatson5-Regular Member
5-Regular Member
May 13, 2014
Jim,

Thanks

My personal preference reflects what I would use for demos and research. It doesn't affect what we would document, QA or support - that would of course be the full range of supported systems.

Chris
R
RandyJones20-Turquoise
20-Turquoise
May 13, 2014
On 05/13/14 15:38, Jim Taylor wrote:
>
> Hello Randy,
>
> It sounds like you have a good system worked out. I do see that there are certain things that
> only have to be done the first time, and other tasks that can happen at other times. The
> rehosting utility can accomodate some of this by the looks of it. The guide perhaps doesn't cover
> this in enough detail, that being said it is not an easy topic to learn as many have said and I am
> experiencing.
>

Understanding what is happening in the rehosting process requires some knowledge of many items. A
small subset of these items include:

* Windchill itself
o properties that need changing
* Oracle
o how to tweak config files for hostname changes
o how to change Windchill tables for rehosting
* ldap
o how to export/import/modify data
* Apache
o apache config files
o what makes apache tick
* Good understanding of the OS you are using and its capablities and limitations
o Sites that use Windows to run Windchill are giving themselves a handicap when it comes to
things like rehosting
o For example running on a unix environment such as Solaris gives a whole host of tools that
are not available in Windows. A small selection of some of the more commonly used ones:
+ bash
+ tail
+ find
+ grep
+ awk
+ sed
+ ssh
+ sendmail
o Some other advantages unix OS's have
+ ability to mount a file system anywhere and have it called whatever
# This makes it easy to mount cloned zfs filesystems so a rehosted windchill server
sees the same filesystems, in the same place, and with the same name as the
production system.
+ ability to easily remotely run something via ssh
+ ability to easily remotely login (no bandwith hungry gui needed) via ssh

Rehosting a Windchill system is not a trivial process.

> - Jim
>
>
> -----End Original Message-----


--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
Fax: 785-667-2695
------------------------------------------------------------------------

T
23-Emerald IV
TomU23-Emerald IV
23-Emerald IV
May 13, 2014
I would like to see this demonstrated on Windows as well (with MS SQL server). The only place we run Linux is the VMware kernel, and we try to avoid that as much as possible (use the GUI instead). Everything else here is entirely Microsoft products (workstations, servers, databases, etc.).

Last year we were promised at PTC Live Global (PTC318 Rehosting and System Configuration Management) that anyone who sent a request to the presenter could get an advance "beta" copy of the 2.0 rehost tool on July 1st, 2013. After multiple requests directly to the presenter we never received anything. The production version was supposed to be released in November along with Windchill 10.2 M010. Here we are, almost a year later, and version 2.0 of the rehost utility is still not listed on the downloads page. It's very frustrating to have an entire session devoted to the wonders of the rehost utility, actually be able to watch it run real time, and then not be able to get a copy of it.

Tom U.
Show more replies
Terms & ConditionsAccessibility statement