0000000046: 10.110.26.147: Jan 13 2020 10:55:23.512 -0600: %_127-DEPLOYMENTTYPEINFO-UPDATE-1-3-org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Incorrect syntax near ')'. 0000000063: 10.110.26.147: Jan 13 2020 10:55:23.555 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-6-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000064: 10.110.26.147: Jan 13 2020 10:55:23.556 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-6-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-6][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000038: 10.110.26.147: Jan 13 2020 10:55:23.557 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-6-3-REST_API_INTERNAL_SERVER_ERROR: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet]: There was an uncaught and unrecognized exception thrown by the REST API 0000000039: 10.110.26.147: Jan 13 2020 10:55:23.557 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-6-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-6][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000074: 10.110.26.147: Jan 13 2020 10:55:30.554 -0600: %CCBU_pool-1-thread-48-Infrastructure-897-3-REST_API_EXCEPTION: %[exception=java.lang.InterruptedException][message_string=Error waiting for CdbLib]: The REST API has caught an exception 0000000075: 10.110.26.147: Jan 13 2020 10:55:30.556 -0600: %CCBU_pool-1-thread-48-Infrastructure-897-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=java.lang.InterruptedException at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(Unknown Source) at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(Unknown Source) at java.util.concurrent.CountDownLatch.await(Unknown Source) at com.cisco.ccbu.cce.unifiedconfig.api.CdbLibManager.waitForCdbLib(CdbLibManager.java:89) at com.cisco.ccbu.cce.unifiedconfig.tasks.TaskExecutor.waitForCdbLib(TaskExecutor.java:90) at com.cisco.ccbu.cce.unifiedconfig.tasks.TaskExecutor.run(TaskExecutor.java:45) at com.cisco.ccbu.cce.unifiedconfig.tasks.TaskController$1.run(TaskController.java:191) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164) ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=pool-1-thread-48-Infrastructure-897][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000078: 10.110.26.147: Jan 13 2020 10:55:30.946 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-10-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: Cannot connect to the back-end system; make sure the distributor, logger and router services are running.][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000079: 10.110.26.147: Jan 13 2020 10:55:30.947 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-10-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: Cannot connect to the back-end system; make sure the distributor, logger and router services are running. at com.cisco.ccbu.cce.unifiedconfig.db.restcdb.CdbTransaction.commit(CdbTransaction.java:189) at com.cisco.ccbu.cce.unifiedconfig.api.WebConfigService.createAndCommitTransaction(WebConfigService.java:543) at com.cisco.ccbu.cce.unifiedconfig.api.WebConfigService.handleCreateAndCommitTransactionOnUpdate(WebConfigService.java:641) at com.cisco.ccbu.cce.unifiedconfig.api.WebConfigService.updateObjectAsync(WebConfigService.java:667) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:423) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-10][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000049: 10.110.26.147: Jan 13 2020 11:07:16.292 -0600: %_167-DEPLOYMENTTYPEINFO-UPDATE-1-3-org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Incorrect syntax near ')'. 0000000088: 10.110.26.147: Jan 13 2020 11:07:16.728 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000089: 10.110.26.147: Jan 13 2020 11:07:16.731 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-3][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000055: 10.110.26.147: Jan 13 2020 11:07:16.731 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-REST_API_INTERNAL_SERVER_ERROR: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet]: There was an uncaught and unrecognized exception thrown by the REST API 0000000056: 10.110.26.147: Jan 13 2020 11:07:16.732 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-3][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000052: 10.110.26.147: Jan 13 2020 11:10:40.885 -0600: %_168-DEPLOYMENTTYPEINFO-UPDATE-1-3-org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Incorrect syntax near ')'. 0000000092: 10.110.26.147: Jan 13 2020 11:10:41.322 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-1-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000093: 10.110.26.147: Jan 13 2020 11:10:41.324 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-1-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-1][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000059: 10.110.26.147: Jan 13 2020 11:10:41.324 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-1-3-REST_API_INTERNAL_SERVER_ERROR: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet]: There was an uncaught and unrecognized exception thrown by the REST API 0000000060: 10.110.26.147: Jan 13 2020 11:10:41.325 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-1-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-1][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000055: 10.110.26.147: Jan 13 2020 11:16:47.968 -0600: %_170-DEPLOYMENTTYPEINFO-UPDATE-1-3-org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Incorrect syntax near ')'. 0000000098: 10.110.26.147: Jan 13 2020 11:16:48.362 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-2-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000099: 10.110.26.147: Jan 13 2020 11:16:48.363 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-2-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-2][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000063: 10.110.26.147: Jan 13 2020 11:16:48.364 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-2-3-REST_API_INTERNAL_SERVER_ERROR: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet]: There was an uncaught and unrecognized exception thrown by the REST API 0000000064: 10.110.26.147: Jan 13 2020 11:16:48.364 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-2-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-2][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000058: 10.110.26.147: Jan 13 2020 11:25:09.595 -0600: %_172-DEPLOYMENTTYPEINFO-UPDATE-1-3-org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Incorrect syntax near ')'. 0000000103: 10.110.26.147: Jan 13 2020 11:25:09.959 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-REST_API_EXCEPTION: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet][message_string=uncaught exception thrown by the api]: The REST API has caught an exception 0000000104: 10.110.26.147: Jan 13 2020 11:25:09.960 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-3][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception 0000000069: 10.110.26.147: Jan 13 2020 11:25:09.961 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-REST_API_INTERNAL_SERVER_ERROR: %[exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet]: There was an uncaught and unrecognized exception thrown by the REST API 0000000070: 10.110.26.147: Jan 13 2020 11:25:09.961 -0600: %CCBU_http-bio-127.0.0.1-8080-exec-3-3-EXCEPTION_INFO: %[build_date=Jul 28, 2017 3:37 PM][build_type=rel][exception=com.cisco.ccbu.api.jaxb.error.ApiException: could not extract ResultSet at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.rethrowException(AsyncResponseGenerator.java:91) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:45) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncResponseGenerator.generateResponse(AsyncResponseGenerator.java:28) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncExecutor.getProgress(AsyncExecutor.java:237) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncRequestStatusService.get(AsyncRequestStatusService.java:30) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1480) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1411) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.PerformanceStatisticsFilter.doFilter(PerformanceStatisticsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AbnormalDurationRequestFilter.doFilter(AbnormalDurationRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AccessFilter.doFilter(AccessFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.RequestSizeFilter.doFilter(RequestSizeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.cce.unifiedconfig.api.AuthenticateTimeFilter.doFilter(AuthenticateTimeFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:142) at com.cisco.ccbu.servlet.ElapsedTimeFilter.doFilter(ElapsedTimeFilter.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.ccbu.api.jaxb.ExceptionMarshalerFilter.doFilter(ExceptionMarshalerFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at com.cisco.ccbu.cce.valves.ResponseWrapperValve.invoke(ResponseWrapperValve.java:56) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.Loader.getResultSet(Loader.java:2065) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:909) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) at org.hibernate.loader.Loader.doList(Loader.java:2553) at org.hibernate.loader.Loader.doList(Loader.java:2539) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) at org.hibernate.loader.Loader.list(Loader.java:2364) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) at com.cisco.ccbu.cce.unifiedconfig.db.HibernateSession.getCount(HibernateSession.java:739) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityCountCheckerRule.checkCapacity(CapacityCountCheckerRule.java:104) at com.cisco.ccbu.cce.unifiedconfig.api.capacity.CapacityController.checkCapacity(CapacityController.java:121) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.validateDeploymentCapacity(DeploymentTypeInfoValidator.java:125) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoValidator.systemAndCapacityValidation(DeploymentTypeInfoValidator.java:60) at com.cisco.ccbu.cce.unifiedconfig.api.deploymenttypeinfo.DeploymentTypeInfoService.updateObjectAsync(DeploymentTypeInfoService.java:417) at com.cisco.ccbu.cce.unifiedconfig.async.tasks.SingleBeanUpdateDbTask.doWork(SingleBeanUpdateDbTask.java:27) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.nameThreadAndDoWork(AsyncTask.java:175) at com.cisco.ccbu.cce.unifiedconfig.async.AsyncTask.run(AsyncTask.java:78) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) ... 1 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ... 25 more ][product_name=UCCE WebConfiguration][subsystem_exception_info=][tid=http-bio-127.0.0.1-8080-exec-3][version_number=UCCE WebConfiguration_11_6_1_0_0_0_3073]: Information associated with the following logged exception