Rehosting from Single tier to multitier system

Forum|Forum|4 years ago
March 13, 2022
2 replies
1706 views

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?

Other

R

rhart

16-Pearl

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.

A

Ajit_Kulkarni

16-Pearl

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

V

Vipul

Author

13-Aquamarine

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)