Skip to main content
12-Amethyst
August 28, 2023
Solved

windchill 12.1.2.0 Installation with sqlserver2019

  • August 28, 2023
  • 2 replies
  • 2059 views

hello Team,

 

we are trying to install windchill12.1.2.0 with

sqlserver 2019.

java - amazon-corretto-11.0.18.10.1-windows-x64-jdk

 

PSI is gatting failed during data loading stage.

 

attaching mslogs here:

 

2023-08-28 23:11:30,216 ERROR [main] wt.fv.StandardFvService  - Local host is not found in Data Base (wt.fv.fvResource/12) wt.fv.FvException:
Local host is not found in Data Base
at wt.fv.StandardFvService.getMyFvHost(StandardFvService.java:7206)
at wt.fv.StandardFvService.performStartupProcess(StandardFvService.java:1894)
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)
 
2023-08-28 23:11:30,466 INFO  [main] wt.fv.info  - Secret key already present in cache
2023-08-28 23:11:30,676 ERROR [main] wt.intersvrcom  - Could not create SiteToSitePrincipalLink as container does not have administrator group(OK If installation)
2023-08-28 23:11:30,731 INFO  [main] wt.wvs.workeragent.StandardCadAgentService  - WVS CadAgent starting
2023-08-28 23:11:30,766 INFO  [main] com.ptc.core.meta.server.impl.StandardTypeIdentifierUtilityService  - Starting initTypeDefinitions()
2023-08-28 23:11:30,781 INFO  [main] com.ptc.core.lwc.server.cache.ModeledTypeInitializationWorker$TypeInitializerRealWorker  - staticInit() Starting initTypeDefinitions()
2023-08-28 23:11:33,036 ERROR [main] com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService  - The cabinet could not be found. Container: "Site" Cabinet name: "wcadmin" wt.folder.FolderNotFoundException:
The cabinet could not be found. Container: "Site" Cabinet name: "wcadmin"
at wt.folder.DefaultFolderCache.getUserToCabinetMap(DefaultFolderCache.java:1410)
at wt.folder.StandardFolderService.getUserToCabinetMap(StandardFolderService.java:1823)
at wt.folder.StandardFolderService.getPersonalCabinet(StandardFolderService.java:885)
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.$Proxy60.getPersonalCabinet(Unknown Source)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.persistNewTypeDefinition(WTTypeManagementDBService.java:3813)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.createTypeDefinition(WTTypeManagementDBService.java:712)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.initTypeDefinition(WTTypeManagementDBService.java:3498)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.initTypeDefinition(WTTypeManagementDBService.java:3649)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.initTypeDefinitionsWorker(WTTypeManagementDBService.java:3412)
at com.ptc.core.lwc.server.cache.ModeledTypeInitializationWorker$TypeInitializerRealWorker.staticInit(ModeledTypeInitializationWorker.java:126)
at com.ptc.core.lwc.server.cache.ModeledTypeInitializationWorker$TypeInitializerRealWorker.<clinit>(ModeledTypeInitializationWorker.java:102)
at com.ptc.core.lwc.server.cache.ModeledTypeInitializationWorker.ensureInitTypeDefsRRun(ModeledTypeInitializationWorker.java:85)
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 com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.invokeTypeDefInitWorker(WTTypeManagementDBService.java:3331)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService._initTypeDefinitions(WTTypeManagementDBService.java:3316)
at com.ptc.core.meta.type.mgmt.server.impl.service.WTTypeManagementDBService.initTypeDefinitions(WTTypeManagementDBService.java:3304)
at com.ptc.core.meta.type.mgmt.server.impl.TypedUtilityImplementation.initTypeDefinitions(TypedUtilityImplementation.java:326)
at wt.type.TypedUtility.initTypeDefinitions(TypedUtility.java:188)
at com.ptc.core.meta.server.impl.StandardTypeIdentifierUtilityService.performStartupProcess(StandardTypeIdentifierUtilityService.java:104)
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)

 

 

2023-08-28 23:11:33,126 INFO [main] wt.system.err - 2023-41-28 17:41:33 INFO com.wincomplm.wex.kernel.impl.utils.WexKernelProperties - No kernel properties are available.
2023-08-28 23:11:33,131 INFO [main] wt.system.err - 2023-41-28 17:41:33 INFO com.wincomplm.wex.kernel.impl.manager.WexKernelManager - Starting WEX Kernel with install area on startup disabled.
2023-08-28 23:11:33,131 INFO [main] wt.system.err - 2023-41-28 17:41:33 INFO com.wincomplm.wex.kernel.impl.manager.WexKernelManager - Initializing Wex Kernel...
2023-08-28 23:11:33,156 INFO [main] wt.system.err - 2023-41-28 17:41:33 ERROR com.wincomplm.wex.kernel.impl.manager.WexKernelManager - Failed to initialize the Wex Kernel (ok if installation)
2023-08-28 23:11:33,156 INFO [main] wt.system.err - java.lang.SecurityException: Only site administrators can lock the kernel for writing
2023-08-28 23:11:33,161 INFO [main] wt.system.err - at com.wincomplm.wex.kernel.impl.manager.WexKernelManager.lockWrite(Unknown Source)
2023-08-28 23:11:33,161 INFO [main] wt.system.err - at com.wincomplm.wex.kernel.impl.manager.WexKernelManager.update(Unknown Source)
2023-08-28 23:11:33,161 INFO [main] wt.system.err - at com.wincomplm.wex.kernel.impl.manager.WexKernelManager.doStartupProcess(Unknown Source)
2023-08-28 23:11:33,161 INFO [main] wt.system.err - at com.wincomplm.wex.kernel.impl.manager.WexKernelManager.performStartupProcess(Unknown Source)
2023-08-28 23:11:33,161 INFO [main] wt.system.err - at wt.services.StandardManager.startup(StandardManager.java:459)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.services.ManagerImplementation.startup(ManagerImplementation.java:363)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.services.DefaultStartupHandler.startup(DefaultStartupHandler.java:112)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:167)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.services.StandardManager.startup(StandardManager.java:459)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.method.MethodServerMain.run(MethodServerMain.java:584)
2023-08-28 23:11:33,166 INFO [main] wt.system.err - at wt.method.MethodServerMain.main(MethodServerMain.java:353)
2023-08-28 23:11:33,171 INFO [NmActionService.initXml] com.ptc.netmarkets.util.misc.StandardNmActionService.xmlInit - Started InitializeXML With stax Parsing

 

 

Best answer by Ritpd

Issue is resolved.

Its about a certificate which was missing from the server.After debugging for 2 weeks we found , Windchill try to validate some cerificate chain mentioned in  Flexcore.dll .

path is : <Windchill>\codebase\wt\licenseusage\lib\FlxCore64.dll

2 replies

jbailey
18-Opal
September 19, 2023

Make sure you follow the steps for allowing direct access to the sql db during install ( I think that is the mixed-mode auth config)

 

https://www.ptc.com/en/support/article/CS67767?source=search

 

Is the SQL on a remote server?

13-Aquamarine
September 20, 2023

Are you still having issues with this? I see that it's gone nearly a month since you posted. 

Similar logs to what you've posted appears in an article regarding Java imcompatibility. I see that you posted that you're using the appropriate 64-bit JDK. Are you sure that you're pointing to the correct Java installation, in case more than one JDK has been installed?

Which LDAP are you using with Windchill? 

The attached MS logs are somewhat short. Are these the only errors in your logs? 

 

Ritpd12-AmethystAuthorAnswer
12-Amethyst
September 21, 2023

Issue is resolved.

Its about a certificate which was missing from the server.After debugging for 2 weeks we found , Windchill try to validate some cerificate chain mentioned in  Flexcore.dll .

path is : <Windchill>\codebase\wt\licenseusage\lib\FlxCore64.dll

13-Aquamarine
December 11, 2024

Hi, 

 

So did you resolve this issue after finding out about the certificate or did you just leave as is? 

 

Best, 

 

-=Deepen