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
K
kstevens1-Visitor
1-Visitor
May 13, 2014
I second that. I was at the same presentation and sent numerous e-mails to the presenter. And then in January, our PTC account team "said" they contacted support and 2.0 would be out in April. Not on my download page either.
J
JimTVancouverCa1-VisitorAuthor
1-Visitor
May 15, 2014

So this came in from my clone posting to PTC Communities from Chris R Spartz:



Just replace with the password of your Windchill DB user (pdmlink). After running the xconfmanager command, try running the rehost utility again."




I'm going to try this next.


Look for results later today.

J
JimTVancouverCa1-VisitorAuthor
1-Visitor
May 15, 2014

So I tried this, and it works, well getting past the db validation works anyway:


Now I think I have to xconfmanager set my ldap password, because now it halts with these two errors separated by a bunch of java calls:


...

J
JimTVancouverCa1-VisitorAuthor
1-Visitor
May 20, 2014
Hello Carsten,

I have been assigned to complete other tasks related to our PTC Creo and Windchill products. I'll try this solution as soon as I can and report back here. 

Thanks again!

        
                                                

        

    


            

                                        

            
                        

                                                                                                            
            




        

                    

    
    





    


                                        

                                                        

            
        
    






                                    
Terms & ConditionsAccessibility statement