cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Rehosting from Single tier to multitier system

Vipul
12-Amethyst

Rehosting from Single tier to multitier system

while Rehosting from single server (i.e  Windchill and SQL Server on same machine) to the Multi tier server (i.e different Windchill & SQL Server).

Can someone provide step by step guidance on how to configure and rehost such scenario?

5 REPLIES 5
rhart
14-Alexandrite
(To:Vipul)

The sql db can be moved to another server by exporting the source db and imported to the new server (take a backup of the db then restore it on the new server). Then the db.propeties have to be changed to the new server. I don’t think the the rehost utility is needed for MS SQL but for Oracle there’s some scripts for data pump.

Ajit_Kulkarni
14-Alexandrite
(To:Vipul)

It is very simple.

1. Move your Windchill along with vault to different host.

2. export/import the database 

3. Create new rehost.properties and project.properties with new hosts and db connections

4. You may need to change security certificates if you are using Windchill on SSL.

5. Give rehost a run and resolve any issues. 

 

By the way if its just a separation of db from Windchill server and if you want to keep Windchill server as it is , you may not even need rehost. 

SQL Server import/export and changing DB connection settings in Windchill will work.

 

Regards

Ajit

Thank you sir, I have followed the steps mentioned above and Rehosting is completed but when i start windchill then i am getting the below error, i have attached the error as well as the method server log. Please can you tell me what went wrong.

 

Thanks in advance.

 

2022-03-22 11:50:03,494 INFO [main] wt.pom.properties - Connection: datastore=Microsoft SQL Server(13.00.5103) jdbcVersion=4.3 driver=Microsoft JDBC Driver 7.4 for SQL Server(7.4.1.0) driverVersion=7.4
2022-03-22 11:50:10,275 ERROR [main] wt.method.server.startup.services - Failure to start manager wt.audit.StandardAuditService wt.services.ManagerException: Could not initialize Auditing service.
Nested exception is: wt.util.WTException: (wt.federation.PrincipalManager.PrincipalManagerResource/CONFIG_ERROR_INCORRECT_NAMING_PROVIDER) com.infoengine.util.IEException: Info*Engine configuration error - The default Directory Service Provider URL and/or Service Search Base could not be retrieved from Info*Engine properties. Contact your system administrator.
Nested exception is: (wt.federation.PrincipalManager.PrincipalManagerResource/CONFIG_ERROR_INCORRECT_NAMING_PROVIDER) com.infoengine.util.IEException: Info*Engine configuration error - The default Directory Service Provider URL and/or Service Search Base could not be retrieved from Info*Engine properties. Contact your system administrator.
at wt.federation.PrincipalManager.DirContext.getAdapterInfoMaps(DirContext.java:399)
at wt.federation.PrincipalManager.DirContext.initMapsForDefaultAdapters(DirContext.java:334)
at wt.federation.PrincipalManager.DirContext.init(DirContext.java:304)
at wt.federation.PrincipalManager.DirContext.getPrimaryName(DirContext.java:728)
at wt.org.LdapServices.getAllServices(LdapServices.java:343)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy64.getAllServices(Unknown Source)
at wt.org.StandardOrganizationServicesManager.getDirectoryServiceNames(StandardOrganizationServicesManager.java:5877)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy63.getDirectoryServiceNames(Unknown Source)
at wt.org.GenericDirectoryContextProvider.<init>(GenericDirectoryContextProvider.java:216)
at wt.org.GenericDirectoryContextProvider.<init>(GenericDirectoryContextProvider.java:200)
at wt.org.StandardOrganizationServicesManager.newDirectoryContextProvider(StandardOrganizationServicesManager.java:9062)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy63.newDirectoryContextProvider(Unknown Source)
at wt.session.StandardSessionManager.getExchangeContext(StandardSessionManager.java:483)
at wt.session.StandardSessionManager.getUser(StandardSessionManager.java:454)
at wt.session.StandardSessionManager.getAdministrator(StandardSessionManager.java:326)
at wt.session.StandardSessionManager.setAdministrator(StandardSessionManager.java:289)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy53.setAdministrator(Unknown Source)
at wt.audit.StandardAuditService.performStartupProcess(StandardAuditService.java:294)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
at wt.services.StandardManager.startup(StandardManager.java:459)
at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
at wt.method.MethodServerMain.run(MethodServerMain.java:584)
at wt.method.MethodServerMain.main(MethodServerMain.java:353)

Ajit_Kulkarni
14-Alexandrite
(To:Vipul)

This is pointing to DS error. Have you changed any DS related settings while doing rehost ? 

Following are the DS changes from rehost.properties

 

target.ldap.IEConfDir=W:\PTC\Windchill_12.0.2.0\Windchill
target.ldap.username=cn=Manager
target.ldap.password=LdapAdmin
target.ldap.hostname=DESK-TEST1.com
target.ldap.port=389
source.local.domain=DSLPLM.com
target.ldap.serviceName=DESK-TEST1.com

 

 

Top Tags