webMethods Knowlegebase : Unable to start newly installed MWSv10.3 (1795479)

Troubleshooting

Problem

Two problems found:

P1. Unable to start newly installed MWSv10.3 - Seeing "java.sql.SQLException: No suitable driver found for jdbc:wm:sqlserver:"

After successfully installing MWSv10.3, site not able to start MWS as a Windows Service or from the command line and the following error is seen in the sag-osgi.log file:

"2019-02-11 01:39:17,935 INFO [Configuration ] - Out-of-band file changes will be monitored every '60000' milliseconds

2019-02-11 01:39:19,482 INFO [org.e.j.u.log ] - Logging initialized @31391ms

2019-02-11 01:39:19,888 WARN [org.e.j.o.b.i.s.DefaultJettyAtJettyHomeHelper ] - No default jetty created.

2019-02-11 01:39:19,904 INFO [com.w.t.h.Activator ] - Starting HPSTRA bundle

2019-02-11 01:39:20,060 INFO [com.s.w.o.a.s.i.TransportListenerRegistryManager ] - WSSOGI0030: updated( null )

2019-02-11 01:39:21,060 INFO [com.s.j.s.s.ServiceFinder ] - Running in an OSGi environment

2019-02-11 01:39:23,895 ERROR [com.w.p.s.s.c.p.p.ConnectionPoolManager ] - Error creating database connection to: jdbc:wm:sqlserver://COPWM103SQD01\\WM103_TEST;databaseName=WM103_MWS_TEST

java.sql.SQLException: No suitable driver found for jdbc:wm:sqlserver://COPWM103SQD01\\WM103_TEST;databaseName=WM103_MWS_TEST

at java.sql.DriverManager.getConnection(DriverManager.java:689)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.webmethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:111)

at com.webmethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:28)

at com.webmethods.portal.system.pool.impl.LightweightObjectPool.createNewObject(LightweightObjectPool.java:410)

at com.webmethods.portal.system.pool.impl.LightweightObjectPool.checkOut(LightweightObjectPool.java:346)

at com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:191)

at com.webmethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:124)

at com.webmethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:771)

at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:348)

at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:270)

at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initDbConnection(ClusterPhaseProvider.java:318)

at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:306)

at com.webmethods.portal.system.init.impl.ClusterPhaseProvider.preInit(ClusterPhaseProvider.java:72)

at com.webmethods.portal.system.impl.PortalSystemActivator.start(PortalSystemActivator.java:76)

at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:779)

at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:1)

at java.security.AccessController.doPrivileged(Native Method)

at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:772)

at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:729)

at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:933)

at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:309)

at org.eclipse.osgi.container.Module.doStart(Module.java:581)

at org.eclipse.osgi.container.Module.start(Module.java:449)

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1634)

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1614)

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1585)

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1528)

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1)

at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)

at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

2019-02-11 01:39:23,926 INFO [com.w.p.PortalException ] - No registered exception delegate

2019-02-11 01:39:23,942 ERROR [com.w.p.s.i.PortalSystemActivator ] - Unable to create connection to jdbc:wm:sqlserver://COPWM103SQD01\\WM103_TEST;databaseName=WM103_MWS_TEST

java.sql.SQLException: Unable to create connection to jdbc:wm:sqlserver://COPWM103SQD01\\WM103_TEST;databaseName=WM103_MWS_TEST

at com.webmethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:153)