Description:

APPC encounters a "java.sql.SQLException: No suitable driver found" error when trying to connecting to the APPC database.  The issue is only seen in OOM deployments not in heat.  This error prevents APPC transaction from being processed.

Error Seen:
<log4j:event logger="org.onap.appc.requesthandler.impl.AbstractRequestHandlerImpl" timestamp="1525283109659" level="ERROR" thread="qtp1338452796-1607">^M <log4j:message><![CDATA[Exception : Error connecting to JDBC using properties for schema [sdnctl]]]></log4j:message>^M <log4j:throwable><![CDATA[org.onap.appc.dao.util.exception.JdbcRuntimeException: Error connecting to JDBC using properties for schema [sdnctl]^M at org.onap.appc.dao.util.AppcJdbcConnectionFactory.openDbConnection(AppcJdbcConnectionFactory.java:53)^M at org.onap.appc.lockmanager.impl.sql.JdbcLockManager.openDbConnection(JdbcLockManager.java:49)^M at org.onap.appc.lockmanager.impl.sql.optimistic.SqlLockManager.getLockOwner(SqlLockManager.java:106)^M at org.onap.appc.lockmanager.impl.sql.optimistic.MySqlLockManager.getLockOwner(MySqlLockManager.java:29)^M at Proxyd35fea8d_8f26_44cd_a402_852f3ecfb231.getLockOwner(Unknown Source)^M at Proxy4305d471_d123_46d7_92ff_808141d09f25.getLockOwner(Unknown Source)^M at org.onap.appc.requesthandler.impl.RequestValidatorImpl.validateVNFLock(RequestValidatorImpl.java:234)^M at org.onap.appc.requesthandler.impl.RequestValidatorImpl.validateRequest(RequestValidatorImpl.java:196)^M at org.onap.appc.requesthandler.impl.AbstractRequestHandlerImpl.handleRequest(AbstractRequestHandlerImpl.java:154)^M at Proxy128344e7_1880_429a_bc99_6df88a4cef33.handleRequest(Unknown Source)^M at org.onap.appc.provider.lcm.service.RequestExecutor.executeRequest(RequestExecutor.java:85)^M at org.onap.appc.provider.AppcProviderLcm.executeRequest(AppcProviderLcm.java:1170)^M at org.onap.appc.provider.AppcProviderLcm.stop(AppcProviderLcm.java:735)^M at org.opendaylight.yangtools.yang.binding.util.RpcMethodInvokerWithInput.invokeOn(RpcMethodInvokerWithInput.java:31)^M at org.opendaylight.yangtools.yang.binding.util.AbstractMappedRpcInvoker.invokeRpc(AbstractMappedRpcInvoker.java:52)^M at org.opendaylight.controller.md.sal.binding.impl.BindingDOMRpcImplementationAdapter.invoke(BindingDOMRpcImplementationAdapter.java:83)^M at org.opendaylight.controller.md.sal.binding.impl.BindingDOMRpcImplementationAdapter.invokeRpc(BindingDOMRpcImplementationAdapter.java:70)^M at org.opendaylight.controller.md.sal.dom.broker.impl.GlobalDOMRpcRoutingTableEntry.invokeRpc(GlobalDOMRpcRoutingTableEntry.java:39)^M at org.opendaylight.controller.md.sal.dom.broker.impl.DOMRpcRoutingTable.invokeRpc(DOMRpcRoutingTable.java:177)^M at org.opendaylight.controller.md.sal.dom.broker.impl.DOMRpcRouter.invokeRpc(DOMRpcRouter.java:102)^M at Proxyca30ab23_f7f5_4dc7_a1ec_7ac0cd9591b3.invokeRpc(Unknown Source)^M at Proxy6b2175f7_65a6_4a47_915c_759a49fc52d6.invokeRpc(Unknown Source)^M at org.opendaylight.netconf.sal.restconf.impl.BrokerFacade.invokeRpc(BrokerFacade.java:526)[279:org.opendaylight.netconf.sal-rest-connector:1.6.1]^M at org.opendaylight.netconf.sal.restconf.impl.RestconfImpl.invokeRpc(RestconfImpl.java:469)[279:org.opendaylight.netconf.sal-rest-connector:1.6.1]^M at org.opendaylight.netconf.sal.restconf.impl.StatisticsRestconfServiceWrapper.invokeRpc(StatisticsRestconfServiceWrapper.java:83)[279:org.opendaylight.netconf.sal-rest-connector:1.6.1]^M at org.opendaylight.netconf.sal.rest.impl.RestconfCompositeWrapper.invokeRpc(RestconfCompositeWrapper.java:64)[279:org.opendaylight.netconf.sal-rest-connector:1.6.1]^M at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.8.0_162]^M at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[:1.8.0_162]^M at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.8.0_162]^M at java.lang.reflect.Method.invoke(Method.java:498)[:1.8.0_162]^M at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.uri.rules.ResourceObjectRule.accept(ResourceObjectRule.java:100)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)[77:com.sun.jersey.jersey-server:1.17.0]^M at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)[78:com.sun.jersey.servlet:1.17.0]^M at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)[78:com.sun.jersey.servlet:1.17.0]^M at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)[78:com.sun.jersey.servlet:1.17.0]^M at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)[106:javax.servlet-api:3.1.0]^M
2:46:49 PM - Preformatted mode set to: false
2:47:17 PM - Preformatted mode set to: true
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)[131:org.apache.shiro.web:1.3.2]^M at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)[151:org.eclipse.jetty.servlet:9.2.21.v20170120]^M at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)[151:org.eclipse.jetty.servlet:9.2.21.v20170120]^M at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:72)[303:org.ops4j.pax.web.pax-web-jetty:4.3.4]^M at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)[149:org.eclipse.jetty.security:9.2.21.v20170120]^M at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:287)[303:org.ops4j.pax.web.pax-web-jetty:4.3.4]^M at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)[151:org.eclipse.jetty.servlet:9.2.21.v20170120]^M at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)[303:org.ops4j.pax.web.pax-web-jetty:4.3.4]^M at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.Server.handle(Server.java:499)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258)[150:org.eclipse.jetty.server:9.2.21.v20170120]^M at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)[142:org.eclipse.jetty.io:9.2.21.v20170120]^M at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)[155:org.eclipse.jetty.util:9.2.21.v20170120]^M at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)[155:org.eclipse.jetty.util:9.2.21.v20170120]^M at java.lang.Thread.run(Thread.java:748)[:1.8.0_162]^M Caused by: java.sql.SQLException: No suitable driver found for ^M at java.sql.DriverManager.getConnection(DriverManager.java:689)[:1.8.0_162]^M at java.sql.DriverManager.getConnection(DriverManager.java:247)[:1.8.0_162]^M at org.onap.appc.dao.util.DBUtils.getConnection(DBUtils.java:66)^M at org.onap.appc.dao.util.AppcJdbcConnectionFactory.openDbConnection(AppcJdbcConnectionFactory.java:51)^M