Failed: PKIX path building failed error MWS webMethods10.15

jshah1 · January 31, 2024, 10:08pm

Product/components:
Product: webMethods 10.15 being installed on a RHEL 8 server

Detailed explanation of the problem:
Trying to upgrade from webMethods 10.05 to 10.15. Recently installed webMethods 10.15 and configured db connection. Everything seems successful. Integration server runs well without any errors and I’m able to login and play around with the UI. However, whenever I run MWS it crashes shortly after with the below error:

Furthermore, I can go to security > JDBC pools on UI and test my connections and they all come back successful. On top of that the certificates have also been configured and they don’t expire until at least an year. Please let me know if you need any other files and I’ll be happy to provide them. If anyone has any idea on how to fix this, that’ll be very helpful. Thank you!!

Error Line:
(I have removed url and serviceName for privacy purposes)

*Error creating database connection to: jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]*
*java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]SSL handshake for https://[DBURL]:2484/ failed: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target*

Here’s the full sag-osgi.log file and picture confirming certs setup in UI:
(I have removed url and serviceName for privacy purposes)

2024-01-31 20:21:21,210 INFO  [Configuration                                               ] - Out-of-band file changes will be monitored every '5000' milliseconds
2024-01-31 20:21:21,299 WARN  [OPM.Master Password                                         ] - loadObjects(/apps/scope/webMethods1015new/MWS/server/default/config/scg/security/passman/mpw.dat) threw this: type(com.webmethods.sc.security.passman.masterpw.MasterPasswordException), msg(Retrieved null/empty master file: /apps/scope/webMethods1015new/MWS/server/default/config/scg/security/passman/mpw.dat)
2024-01-31 20:21:21,300 WARN  [OPM.Master Password                                         ] - loadObjects(/apps/scope/webMethods1015new/MWS/server/default/config/scg/security/passman/mpw.dat.bak) threw this: type(com.webmethods.sc.security.passman.masterpw.MasterPasswordException), msg(Retrieved null/empty master file: /apps/scope/webMethods1015new/MWS/server/default/config/scg/security/passman/mpw.dat.bak)
2024-01-31 20:21:21,977 WARN  [OPM                                                         ] - Found invalid last-changed date, null, using default
2024-01-31 20:21:21,983 WARN  [OPM                                                         ] - Found invalid expire interval, null, using default
2024-01-31 20:21:22,138 INFO  [com.s.p.j.i.LoginModuleFactoryRegistryImpl                  ] - LoginModuleFactoryRegistryImpl opened
2024-01-31 20:21:22,140 INFO  [com.s.p.j.i.Activator                                       ] - ManagedServiceFactory service registered com.softwareag.platform.jaas.internal.ManagedConfiguration@416a9d4f
2024-01-31 20:21:22,232 INFO  [com.s.p.j.e.i.LoginModuleBundleTracker                      ] - Processing bundle com.softwareag.security.authz.store(10.15.0.0000-0476)
2024-01-31 20:21:22,242 INFO  [com.s.s.s.i.e.ESAPIConfigurator                             ] - Using 'file:/apps/scope/webMethods1015new/profiles/MWS_default/configuration//ESAPI.properties'
2024-01-31 20:21:22,242 INFO  [com.s.s.s.i.e.ESAPIConfigurator                             ] - Using internal ESAPI.properties
2024-01-31 20:21:22,271 INFO  [com.s.p.j.e.i.LoginModuleBundleTracker                      ] - Processing bundle com.softwareag.security.sin.idp.saml.lm(10.15.0.0000-0476)
2024-01-31 20:21:22,274 INFO  [com.s.p.j.e.i.LoginModuleBundleTracker                      ] - Processing bundle com.softwareag.security.sin.is.ldap(10.15.0.0000-0476)
2024-01-31 20:21:22,287 INFO  [com.s.p.j.e.i.LoginModuleBundleTracker                      ] - Processing bundle com.softwareag.security.sin.misc(10.15.0.0006-0547)
2024-01-31 20:21:22,307 INFO  [com.s.p.j.e.i.LoginModuleBundleTracker                      ] - Processing bundle com.softwareag.security.web.sso.saml2(10.15.0.0006-0547)
2024-01-31 20:21:23,199 INFO  [com.s.w.o.a.s.i.TransportListenerRegistryManager            ] - WSSOGI0030: updated( null )
2024-01-31 20:21:23,396 INFO  [com.w.p.s.i.i.ClusterPhaseProvider                          ] - Standby mode on startup is false
2024-01-31 20:21:30,097 **ERROR [com.w.p.s.s.c.p.p.ConnectionPoolManager                     ] - Error creating database connection to: jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]**
**java.sql.SQLNonTransientConnectionException: [SoftwareAG][Oracle JDBC Driver]SSL handshake for https://[DBURL]:2484/ failed: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target**
	at com.wm.dd.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1098|:1044) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1098|:976) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1098|:1128) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1098|:851) ~[?:?]
	at com.wm.dd.jdbc.oracle.OracleImplConnection.a(|Oracle|6.0.0.1098|:5404) ~[?:?]
	at com.wm.dd.jdbc.oracle.OracleImplConnection.bc(|Oracle|6.0.0.1098|:5191) ~[?:?]
	at com.wm.dd.jdbc.oracle.OracleImplConnection.a(|Oracle|6.0.0.1098|:3398) ~[?:?]
	at com.wm.dd.jdbc.oracle.OracleImplConnection.open(|Oracle|6.0.0.1098|:2577) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseConnection.c(|Oracle|6.0.0.1098|:5063) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseConnection.dQ(|Oracle|6.0.0.1098|:1539) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseConnection.i(|Oracle|6.0.0.1098|:1461) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseConnection.a(|Oracle|6.0.0.1098|:989) ~[?:?]
	at com.wm.dd.jdbc.oracle.base.BaseDriver.connect(|Oracle|6.0.0.1098|:350) ~[?:?]
	at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]
	at java.sql.DriverManager.getConnection(DriverManager.java:228) ~[java.sql:?]
	at com.webmethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:159) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:33) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.pool.impl.LightweightObjectPool.createNewObject(LightweightObjectPool.java:419) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.pool.impl.LightweightObjectPool.checkOut(LightweightObjectPool.java:346) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:193) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:126) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:700) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:331) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:248) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initDbConnection(ClusterPhaseProvider.java:388) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:376) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.preInit(ClusterPhaseProvider.java:111) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.impl.PortalSystemActivator.start(PortalSystemActivator.java:76) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:815) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
	at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:765) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1022) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:363) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.Module.doStart(Module.java:589) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.Module.start(Module.java:457) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1784) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1764) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1726) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1657) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1558) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:233) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:343) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
2024-01-31 20:21:30,109 INFO  [com.w.p.PortalException                                     ] - No registered exception delegate
**2024-01-31 20:21:30,111 ERROR [com.w.p.s.i.PortalSystemActivator                           ] - Unable to create connection to jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]**
**com.webmethods.portal.system.init.InitializationException: Unable to create connection to jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]**
	at com.webmethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:704) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:331) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:248) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initDbConnection(ClusterPhaseProvider.java:388) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:376) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.preInit(ClusterPhaseProvider.java:111) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.system.impl.PortalSystemActivator.start(PortalSystemActivator.java:76) [com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:815) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
	at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:765) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1022) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:363) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.Module.doStart(Module.java:589) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.Module.start(Module.java:457) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1784) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1764) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1726) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1657) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1558) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:233) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
	at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:343) [org.eclipse.osgi_3.13.300.0000-0012.jar:3.13.300.0000-0012]
**Caused by: java.sql.SQLException: Unable to create connection to jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]**
**	at com.webmethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:158)** ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	at com.webmethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:700) ~[com.webmethods.caf.server_10.15.0.0006-0287.jar:10.15.0.0006-0287]
	... 22 more

Holger_von_Thomsen · February 1, 2024, 1:33pm

Hi,

can you share your mws.db.xml from the MWS/server/default/config directory, please?

Additionally check the MWS/server/default/bin/server.properties.sh and the profiles/MWS_default/configuration/custom_wrapper.conf for correct settings of Keystore and Truststore.

The configuration visible in IS does not relate to the MWS configuration.

Regards,
Holger

jshah1 · February 1, 2024, 4:40pm

Thank you for your response! I checked the files you mentioned and I did have wrong certificates in there so I fixed it and tried to restart it.It fixed the previous error, however, it still doesn’t start with the below error:

INFO   | jvm 1    | 2024/02/01 16:14:55 | !ENTRY com.softwareag.platform.hook.locations 1 0 2024-02-01 16:14:55.524
INFO   | jvm 1    | 2024/02/01 16:14:55 | !MESSAGE Replacing system property sag.install.area->@url:osgi.install.area/../.. with sag.install.area->file:/apps/scope/webMethods1015new/
INFO   | jvm 1    | 2024/02/01 16:14:55 | 
INFO   | jvm 1    | 2024/02/01 16:14:55 | !ENTRY com.softwareag.platform.hook.locations 1 0 2024-02-01 16:14:55.527
INFO   | jvm 1    | 2024/02/01 16:14:55 | !MESSAGE Discovered location: sag.install.area=file:/apps/scope/webMethods1015new/
INFO   | jvm 1    | 2024/02/01 16:14:55 | 
INFO   | jvm 1    | 2024/02/01 16:14:55 | !ENTRY com.softwareag.platform.hook.locations 1 0 2024-02-01 16:14:55.528
INFO   | jvm 1    | 2024/02/01 16:14:55 | !MESSAGE Registered location sag.install.area=file:/apps/scope/webMethods1015new/
INFO   | jvm 1    | 2024/02/01 16:14:55 | [Thu Feb 01 16:14:55 UTC 2024] [INFO] Bootstrap: Initialized shutdown handler to com.softwareag.platform.hook.shutdown.HookConfiguratorImpl$$Lambda$85/0x00000001001de840@6a5f924
INFO   | jvm 1    | 2024/02/01 16:14:55 | [Thu Feb 01 16:14:55 UTC 2024] [INFO] Bootstrap: Exteral shutdown disabled. No shutdown anchor set with system property 'com.softwareag.platform.bootstrap.anchor'.
INFO   | jvm 1    | 2024/02/01 16:14:55 | 
INFO   | jvm 1    | 2024/02/01 16:14:55 | !ENTRY com.softwareag.platform.hook.shutdown 1 0 2024-02-01 16:14:55.549
INFO   | jvm 1    | 2024/02/01 16:14:55 | !MESSAGE Initialized graceful shutdown handler.
INFO   | jvm 1    | 2024/02/01 16:14:56 | [ProxyLogManager] setDelegate: com.softwareag.platform.jul.proxy.DefaultLogManager@1e802ef9 -> com.webmethods.sc.logging.jul.HandlerLogManager@4a16f3c9
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: WARNING: System property [org.owasp.esapi.opsteam] is not set
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: WARNING: System property [org.owasp.esapi.devteam] is not set
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: SecurityConfiguration for ESAPI.Logger not found in ESAPI.properties. Using default: org.owasp.esapi.logging.java.JavaLogFactory
INFO   | jvm 1    | 2024/02/01 16:14:59 | [ProxyLogManager] readConfiguration(org.eclipse.osgi.storage.bundlefile.ZipBundleFile$ZipBundleEntryInputStream@2a334621) -> com.webmethods.sc.logging.jul.HandlerLogManager@4a16f3c9
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: SecurityConfiguration for ESAPI.Logger not found in ESAPI.properties. Using default: org.owasp.esapi.logging.java.JavaLogFactory
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: SecurityConfiguration for ESAPI.Logger not found in ESAPI.properties. Using default: org.owasp.esapi.logging.java.JavaLogFactory
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: SecurityConfiguration for ESAPI.Logger not found in ESAPI.properties. Using default: org.owasp.esapi.logging.java.JavaLogFactory
INFO   | jvm 1    | 2024/02/01 16:14:59 | ESAPI: SecurityConfiguration for ESAPI.Logger not found in ESAPI.properties. Using default: org.owasp.esapi.logging.java.JavaLogFactory
INFO   | jvm 1    | 2024/02/01 16:14:59 | 2024-02-01 16:14:59.231:INFO::Start Level: Equinox Container: 254640f2-99fb-41b1-90e4-c949a8032a99: Logging initialized @5726ms to org.eclipse.jetty.util.log.StdErrLog
INFO   | jvm 1    | 2024/02/01 16:14:59 | 2024-02-01 16:14:59.232:WARN:oejob.JettyBootstrapActivator:Start Level: Equinox Container: 254640f2-99fb-41b1-90e4-c949a8032a99: OSGi support for java.util.ServiceLoader may not be present. You may experience runtime errors.
INFO   | jvm 1    | 2024/02/01 16:15:00 | 2024-02-01 16:15:00.055:WARN:oejobis.DefaultJettyAtJettyHomeHelper:Start Level: Equinox Container: 254640f2-99fb-41b1-90e4-c949a8032a99: No default jetty created.
INFO   | jvm 1    | 2024/02/01 16:15:02 | [ProxyLogManager] reset() -> com.webmethods.sc.logging.jul.HandlerLogManager@4a16f3c9
INFO   | jvm 1    | 2024/02/01 16:15:02 | Shutdown Manager running all shutdown hooks
INFO   | jvm 1    | 2024/02/01 16:15:02 | WARNING: An illegal reflective access operation has occurred
INFO   | jvm 1    | 2024/02/01 16:15:02 | WARNING: Illegal reflective access by electric.xml.dom.DomParserWrapper (file:/apps/scope/webMethods1015new/profiles/MWS_default/../../common/runtime/bundles/glue/eclipse/plugins/com.webmethods.sc.glue_8.0.0.9000-0255.jar) to method com.sun.org.apache.xerces.internal.dom.CoreDocumentImpl.getXmlEncoding()
INFO   | jvm 1    | 2024/02/01 16:15:02 | WARNING: Please consider reporting this to the maintainers of electric.xml.dom.DomParserWrapper
INFO   | jvm 1    | 2024/02/01 16:15:02 | WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
INFO   | jvm 1    | 2024/02/01 16:15:02 | WARNING: All illegal access operations will be denied in a future release
INFO   | jvm 1    | 2024/02/01 16:15:03 | [STARTUP] Glue 8.0 Fix 9000 build 255 
INFO   | jvm 1    | 2024/02/01 16:15:03 | [Thu Feb 01 16:15:03 UTC 2024] [INFO] Bootstrap: Stopping...
ERROR  | wrapper  | 2024/02/01 16:15:37 | Shutdown failed: Timed out waiting for signal from JVM.
ERROR  | wrapper  | 2024/02/01 16:15:37 | JVM did not exit on request, termination requested.
STATUS | wrapper  | 2024/02/01 16:15:37 | JVM received a signal SIGKILL (9).
STATUS | wrapper  | 2024/02/01 16:15:37 | JVM process is gone.
STATUS | wrapper  | 2024/02/01 16:15:37 | JVM exited after being requested to terminate.
STATUS | wrapper  | 2024/02/01 16:15:37 | <-- Wrapper Stopped

Here’s the mws.db.xml file that you wanted:

<?xml version="1.0" encoding="UTF-8" standalone="no"?><CONFIG>
    <CONNECTION default="true" displayname="Default" id="1" name="default" type="oracle">
        <SQLWORKERCLASS>com.webmethods.portal.service.sql.core.BaseSqlWorker</SQLWORKERCLASS>
        <CONNPROVIDERCLASS>com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider</CONNPROVIDERCLASS>
        <PARAMS>
            <DRIVER>com.wm.dd.jdbc.oracle.OracleDriver</DRIVER>
            <URL>jdbc:wm:oracle://[DBURL]:2484;serviceName=[NAME];EncryptionMethod=SSL;CryptoProtocolVersion=TLSv1.2;ValidateServerCertificate=true;HostNameInCertificate=[DBURL]</URL>
            <USER>WEBM_COPY</USER>
			<!-- Password could be specified in clear text, it will be automatically encrypted during MWS startup -->
            <PASSWORD>{AES}TSpl3ngCD3RB4bYaSJLW9Q==</PASSWORD>
            <CACHESTATEMENTS>false</CACHESTATEMENTS>
            <TESTSQL>SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1</TESTSQL>            
            <MAXCONNECTIONS>100</MAXCONNECTIONS>
            <MINCONNECTIONS>0</MINCONNECTIONS>
            <!-- Max amount of idle time (in seconds) of the objects pooled by this pool -->
            <IDLETIMEOUT>60</IDLETIMEOUT>
            <!-- Time (in seconds) between eviction runs -->
            <CLEANUPPERIOD>10</CLEANUPPERIOD>
        </PARAMS>
    </CONNECTION>
</CONFIG>

Please let me know if you need any other files from me!

Sandeep_Deepala · February 1, 2024, 8:00pm

One time Database configurator run completed successfully, before starting MWS?
Is your IS and MWS run on same RHEL instance ?

jshah1 · February 1, 2024, 8:23pm

Yes one time database configurator ran successfully and both MWS and IS are on the same instance in the same location.

Gowtham2 · April 29, 2024, 6:29am

Any solution for this issue

Holger_von_Thomsen · April 29, 2024, 9:08am

Hi,

do you have a JDBC Connection in IS JDBC Connection pools pointing to the MWS Database schema using the same SSL connection parameters?
If yes, is this one working?

Usually, the “PKIX path building failed” error indicates, that the certificate presented by the server cannot be verified to a valid CA chain defined in truststores and/or cacerts file of the JVM.

BTW: Port 2484 is a very uncommon port for an Oracle Database.

Regards,
Holger