Results

By type

          @RUNHOME@ /opt/onap/bin
@JAVA_HOME@ /usr/local/openjdk-11
@JAVA@ /usr/local/openjdk-11/bin/java
@JAVA_OPTS@ -Xms256m -Xmx1g
@class_path@ /opt/onap/bin/../lib/animal-sniffer-annotations-1.18.jar /opt/onap/bin/../lib/annotations-2.0.1.jar /opt/onap/bin/../lib/antlr-runtime-3.5.2.jar /opt/onap/bin/../lib/antlr4-runtime-4.9.jar /opt/onap/bin/../lib/aopalliance-repackaged-3.0.3.jar /opt/onap/bin/../lib/caffeine-2.9.3.jar /opt/onap/bin/../lib/checker-qual-3.5.0.jar /opt/onap/bin/../lib/commons-codec-1.15.jar /opt/onap/bin/../lib/commons-collections-3.2.2.jar /opt/onap/bin/../lib/commons-lang3-3.12.0.jar /opt/onap/bin/../lib/drools-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-dynamic-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-reflective-7.62.0.Final.jar /opt/onap/bin/../lib/drools-ecj-7.62.0.Final.jar /opt/onap/bin/../lib/drools-mvel-7.62.0.Final.jar /opt/onap/bin/../lib/drools-templates-7.62.0.Final.jar /opt/onap/bin/../lib/ecj-4.5.1.jar /opt/onap/bin/../lib/error_prone_annotations-2.3.2.jar /opt/onap/bin/../lib/failureaccess-1.0.1.jar /opt/onap/bin/../lib/geantyref-1.3.11.jar /opt/onap/bin/../lib/gson-2.8.6.jar /opt/onap/bin/../lib/guava-28.1-jre.jar /opt/onap/bin/../lib/hk2-api-3.0.3.jar /opt/onap/bin/../lib/hk2-locator-3.0.3.jar /opt/onap/bin/../lib/hk2-utils-3.0.3.jar /opt/onap/bin/../lib/holmes-actions-1.4.4.jar /opt/onap/bin/../lib/holmes-engine-d-1.3.8-SNAPSHOT.jar /opt/onap/bin/../lib/j2objc-annotations-1.3.jar /opt/onap/bin/../lib/jackson-annotations-2.13.3.jar /opt/onap/bin/../lib/jackson-core-2.13.3.jar /opt/onap/bin/../lib/jackson-databind-2.13.3.jar /opt/onap/bin/../lib/jackson-module-jakarta-xmlbind-annotations-2.13.3.jar /opt/onap/bin/../lib/jakarta.activation-1.2.2.jar /opt/onap/bin/../lib/jakarta.activation-api-2.1.0.jar /opt/onap/bin/../lib/jakarta.annotation-api-2.1.1.jar /opt/onap/bin/../lib/jakarta.inject-api-2.0.1.jar /opt/onap/bin/../lib/jakarta.validation-api-2.0.2.jar /opt/onap/bin/../lib/jakarta.ws.rs-api-3.1.0.jar /opt/onap/bin/../lib/jakarta.xml.bind-api-4.0.0.jar /opt/onap/bin/../lib/javassist-3.24.1-GA.jar /opt/onap/bin/../lib/javax.activation-api-1.2.0.jar /opt/onap/bin/../lib/javax.servlet-api-4.0.1.jar /opt/onap/bin/../lib/jaxb-api-2.3.1.jar /opt/onap/bin/../lib/jdbi3-core-3.19.0.jar /opt/onap/bin/../lib/jdbi3-postgres-3.19.0.jar /opt/onap/bin/../lib/jdbi3-sqlobject-3.19.0.jar /opt/onap/bin/../lib/jersey-client-3.0.5.jar /opt/onap/bin/../lib/jersey-common-3.0.5.jar /opt/onap/bin/../lib/jersey-container-servlet-core-3.0.5.jar /opt/onap/bin/../lib/jersey-entity-filtering-3.0.5.jar /opt/onap/bin/../lib/jersey-hk2-3.0.5.jar /opt/onap/bin/../lib/jersey-media-json-jackson-3.0.5.jar /opt/onap/bin/../lib/jersey-server-3.0.5.jar /opt/onap/bin/../lib/jsr305-3.0.2.jar /opt/onap/bin/../lib/jul-to-slf4j-1.7.36.jar /opt/onap/bin/../lib/kie-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-internal-7.62.0.Final.jar /opt/onap/bin/../lib/kie-memory-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-maven-support-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-xstream-7.62.0.Final.jar /opt/onap/bin/../lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar /opt/onap/bin/../lib/log4j-api-2.17.2.jar /opt/onap/bin/../lib/log4j-to-slf4j-2.17.2.jar /opt/onap/bin/../lib/logback-classic-1.2.11.jar /opt/onap/bin/../lib/logback-core-1.2.11.jar /opt/onap/bin/../lib/lombok-1.18.16.jar /opt/onap/bin/../lib/msb-java-sdk-1.2.5.jar /opt/onap/bin/../lib/mvel2-2.4.13.Final.jar /opt/onap/bin/../lib/mxparser-1.2.2.jar /opt/onap/bin/../lib/okhttp-3.14.1.jar /opt/onap/bin/../lib/okio-1.17.2.jar /opt/onap/bin/../lib/osgi-resource-locator-1.0.3.jar /opt/onap/bin/../lib/postgresql-42.3.6.jar /opt/onap/bin/../lib/reflections-0.9.9.jar /opt/onap/bin/../lib/slf4j-api-1.7.25.jar /opt/onap/bin/../lib/snakeyaml-1.30.jar /opt/onap/bin/../lib/spring-aop-5.3.22.jar /opt/onap/bin/../lib/spring-beans-5.3.22.jar /opt/onap/bin/../lib/spring-boot-2.7.2.jar /opt/onap/bin/../lib/spring-boot-autoconfigure-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-logging-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-tomcat-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-web-2.7.2.jar /opt/onap/bin/../lib/spring-context-5.3.22.jar /opt/onap/bin/../lib/spring-core-5.3.22.jar /opt/onap/bin/../lib/spring-expression-5.3.22.jar /opt/onap/bin/../lib/spring-jcl-5.3.22.jar /opt/onap/bin/../lib/spring-jdbc-5.3.22.jar /opt/onap/bin/../lib/spring-tx-5.3.22.jar /opt/onap/bin/../lib/spring-web-5.3.22.jar /opt/onap/bin/../lib/spring-webmvc-5.3.22.jar /opt/onap/bin/../lib/tomcat-embed-core-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-el-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-websocket-9.0.65.jar /opt/onap/bin/../lib/xmlpull-1.1.3.1.jar /opt/onap/bin/../lib/xstream-1.4.19.jar
DB_PORT=5432
SERVICE_IP=10.233.70.15
ENABLE_ENCRYPT=true
KEY_PATH=/opt/onap/bin/../conf/holmes.keystore
KEY_PASS=holmes
server:
  port: 9102
  servlet:
    context-path: /api/holmes-engine-mgmt/v1
  ssl:
    key-store: /opt/onap/bin/../conf/holmes.keystore
    key-store-password: holmes
    #PKCS12
    key-store-type: JKS

logging:
  config: classpath:logback-spring.xml

spring:
  application:
    name: Holmes Engine Management
  datasource:
    dirver-class-name: org.postgresql.Driver
    url: jdbc:postgresql://tcp-pgset-primary:5432/holmes
    username: holmes
    password: JudiTirv3~Kuho
  mvc:
    throw-exception-if-no-handler-found: trueInitializing the holmes engine management database...
--
-- Copyright 2017 ZTE Corporation.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
\c postgres

/******************CREATE NEW DATABASE AND USER***************************/
CREATE DATABASE holmes;

CREATE ROLE holmes with PASSWORD 'JudiTirv3~Kuho' LOGIN;

\encoding UTF8;

/******************CREATE NEW TABLE***************************/
\c holmes;

CREATE TABLE IF NOT EXISTS ALARM_INFO (
  EVENTID VARCHAR(150) NOT NULL,
  EVENTNAME VARCHAR(150) NOT NULL,
  ALARMISCLEARED SMALLINT NOT NULL,
  ROOTFLAG SMALLINT NOT NULL,
  STARTEPOCHMICROSEC BIGINT NOT NULL,
  LASTEPOCHMICROSEC BIGINT NOT NULL,
  SOURCEID VARCHAR(150)  NOT NULL,
  SOURCENAME VARCHAR(150)  NOT NULL,
  SEQUENCE SMALLINT NOT NULL,
  PRIMARY KEY (EVENTID, SEQUENCE, SOURCENAME)
);

CREATE TABLE IF NOT EXISTS ENGINE_ENTITY (
  ID VARCHAR(150) NOT NULL,
  IP VARCHAR(128) NOT NULL,
  PORT SMALLINT NOT NULL,
  LASTMODIFIED BIGINT NOT NULL,
  PRIMARY KEY (ID)
);

GRANT ALL PRIVILEGES ON ALARM_INFO TO holmes;
GRANT ALL PRIVILEGES ON ENGINE_ENTITY TO holmes;
dbname=holmes
user=holmes
password=JudiTirv3~Kuho
port=5432
host=tcp-pgset-primary
You are now connected to database "postgres" as user "holmes".
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:19: ERROR:  permission denied to create database
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:21: ERROR:  permission denied to create role
You are now connected to database "holmes" as user "holmes".
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:39: NOTICE:  relation "alarm_info" already exists, skipping
CREATE TABLE
CREATE TABLE
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:47: NOTICE:  relation "engine_entity" already exists, skipping
GRANT
GRANT
 eventid | eventname | alarmiscleared | rootflag | startepochmicrosec | lastepochmicrosec | sourceid | sourcename | sequence 
---------+-----------+----------------+----------+--------------------+-------------------+----------+------------+----------
(0 rows)

sql_result=0
The database is initialized successfully!

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.7.2)

2022-10-27 17:05:58 528 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-65cb68c965-5d2s6 with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2022-10-27 17:05:58 534 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2022-10-27 17:06:00 755 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2022-10-27 17:06:00 774 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2022-10-27 17:06:00 775 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2022-10-27 17:06:00 775 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2022-10-27 17:06:00 894 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2022-10-27 17:06:00 895 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2276 ms
2022-10-27 17:06:03 087 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2022-10-27 17:06:03 326 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat started on port(s): 9102 (https) with context path '/api/holmes-engine-mgmt/v1'
2022-10-27 17:06:03 345 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 6.457 seconds (JVM running for 7.358)
2022-10-27 17:06:03 377 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2022-10-27 17:06:03 391 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2022-10-27 17:06:03 407 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Registration information: {"serviceName":"holmes-engine-mgmt","version":"v1","url":"/api/holmes-engine-mgmt/v1","protocol":"REST","visualRange":"0|1","lb_policy":"round-robin","path":"/api/holmes-engine-mgmt/v1","nodes":[{"ip":"10.233.70.15","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2022-10-27 17:06:03 414 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2022-10-27 17:06:04 592 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 17:06:04 593 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 20s and try again.
2022-10-27 17:06:04 594 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 17:06:04 628 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Artifact not fetched from maven: org.onap.holmes:rules:1.0.0-SNAPSHOT. To enable the KieScanner you need kie-ci on the classpath
2022-10-27 17:06:04 633 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Adding KieModule from resource: ByteArrayResource[bytes=[80, 75, 3, 4, 20, 0, 8, 8, 8, 0, ...], encoding=null]
2022-10-27 17:06:04 643 INFO  [org.drools.compiler.kie.builder.impl.InternalKieModuleProvider][main][][] - Creating in memory KieModule for artifact org.onap.holmes:rules:1.0.0-SNAPSHOT
2022-10-27 17:06:04 643 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Artifact not fetched from maven: org.onap.holmes:rules:1.0.0-SNAPSHOT. To enable the KieScanner you need kie-ci on the classpath
2022-10-27 17:06:04 651 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2022-10-27 17:06:04 749 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2022-10-27 17:06:04 839 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2022-10-27 17:06:04 839 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2022-10-27 17:06:04 892 ERROR [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Failed to startup the engine of Holmes: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15 [statement:"SELECT * FROM APLUS_RULE WHERE enable=:enable", arguments:{positional:{0:1}, named:{enable:1}, finder:[]}]
org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15 [statement:"SELECT * FROM APLUS_RULE WHERE enable=:enable", arguments:{positional:{0:1}, named:{enable:1}, finder:[]}]
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1790)
	at org.jdbi.v3.core.result.ResultProducers.lambda$getResultSet$2(ResultProducers.java:64)
	at org.jdbi.v3.core.result.ResultIterable.lambda$of$0(ResultIterable.java:54)
	at org.jdbi.v3.core.result.ResultIterable.stream(ResultIterable.java:228)
	at org.jdbi.v3.core.result.ResultIterable.collect(ResultIterable.java:284)
	at org.jdbi.v3.sqlobject.statement.internal.ResultReturner$CollectedResultReturner.mappedResult(ResultReturner.java:275)
	at org.jdbi.v3.sqlobject.statement.internal.SqlQueryHandler.lambda$configureReturner$0(SqlQueryHandler.java:61)
	at org.jdbi.v3.sqlobject.statement.internal.CustomizingStatementHandler.invoke(CustomizingStatementHandler.java:178)
	at org.jdbi.v3.sqlobject.statement.internal.SqlQueryHandler.invoke(SqlQueryHandler.java:27)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.lambda$invoke$0(SqlObjectInitData.java:132)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:44)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:26)
	at org.jdbi.v3.core.LazyHandleSupplier.lambda$invokeInContext$1(LazyHandleSupplier.java:77)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:44)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:26)
	at org.jdbi.v3.core.LazyHandleSupplier.invokeInContext(LazyHandleSupplier.java:76)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.call(SqlObjectInitData.java:138)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.invoke(SqlObjectInitData.java:132)
	at org.jdbi.v3.sqlobject.SqlObjectFactory.lambda$attach$2(SqlObjectFactory.java:110)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$invoke$5(OnDemandExtensions.java:98)
	at org.jdbi.v3.core.internal.exceptions.Unchecked.lambda$function$4(Unchecked.java:76)
	at org.jdbi.v3.core.internal.OnDemandExtensions.invoke(OnDemandExtensions.java:98)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$2(OnDemandExtensions.java:82)
	at org.jdbi.v3.core.Jdbi.callWithExtension(Jdbi.java:476)
	at org.jdbi.v3.core.Jdbi.withExtension(Jdbi.java:463)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$3(OnDemandExtensions.java:82)
	at com.sun.proxy.$Proxy82.queryRuleByEnable(Unknown Source)
	at org.onap.holmes.engine.db.CorrelationRuleDaoService.queryRuleByRuleEnable(CorrelationRuleDaoService.java:33)
	at org.onap.holmes.engine.wrapper.RuleMgtWrapper.queryRuleByEnable(RuleMgtWrapper.java:40)
	at org.onap.holmes.engine.manager.DroolsEngine.initRules(DroolsEngine.java:126)
	at org.onap.holmes.engine.manager.DroolsEngine.run(DroolsEngine.java:93)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:752)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
	at org.onap.holmes.engine.EngineDActiveApp.main(EngineDActiveApp.java:38)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:156)
	at org.jdbi.v3.core.statement.SqlLoggerUtil.wrap(SqlLoggerUtil.java:31)
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1782)
	... 44 common frames omitted
2022-10-27 17:06:04 911 INFO  [org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener][main][][] - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-10-27 17:06:04 946 ERROR [org.springframework.boot.SpringApplication][main][][] - Application run failed
java.lang.IllegalStateException: Failed to execute ApplicationRunner
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:765)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:752)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
	at org.onap.holmes.engine.EngineDActiveApp.main(EngineDActiveApp.java:38)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: jakarta.ws.rs.WebApplicationException: HTTP 499 
	at org.onap.holmes.common.utils.ExceptionUtil.buildExceptionResponse(ExceptionUtil.java:32)
	at org.onap.holmes.engine.manager.DroolsEngine.run(DroolsEngine.java:101)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762)
	... 13 common frames omitted
2022-10-27 17:06:24 594 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 17:06:24 595 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2022-10-27 17:06:24 622 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 17:06:24 623 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 40s and try again.
2022-10-27 17:06:24 624 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 17:07:03 378 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2022-10-27 17:07:03 396 WARN  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Failed to deal with the new configurations.
java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@563f38c4 has been closed already
	at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1138)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1171)
	at org.onap.holmes.common.utils.SpringContextUtil.getBean(SpringContextUtil.java:39)
	at org.onap.holmes.engine.dcae.ConfigFileScanningTask.addSubscribers(ConfigFileScanningTask.java:80)
	at org.onap.holmes.engine.dcae.ConfigFileScanningTask.run(ConfigFileScanningTask.java:65)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
2022-10-27 17:07:04 624 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 17:07:04 625 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2022-10-27 17:07:04 651 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 17:07:04 652 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 60s and try again.
2022-10-27 17:07:04 652 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 17:08:04 653 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 17:08:04 654 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2022-10-27 17:08:04 680 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 17:08:04 682 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 80s and try again.
2022-10-27 17:08:04 682 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...

        
      
          @RUNHOME@ /opt/onap/bin
@JAVA_HOME@ /usr/local/openjdk-11
@JAVA@ /usr/local/openjdk-11/bin/java
@JAVA_OPTS@ -Xms256m -Xmx1g
@class_path@ /opt/onap/bin/../lib/animal-sniffer-annotations-1.18.jar /opt/onap/bin/../lib/annotations-2.0.1.jar /opt/onap/bin/../lib/antlr-runtime-3.5.2.jar /opt/onap/bin/../lib/antlr4-runtime-4.9.jar /opt/onap/bin/../lib/aopalliance-repackaged-3.0.3.jar /opt/onap/bin/../lib/caffeine-2.9.3.jar /opt/onap/bin/../lib/checker-qual-3.5.0.jar /opt/onap/bin/../lib/commons-codec-1.15.jar /opt/onap/bin/../lib/commons-collections-3.2.2.jar /opt/onap/bin/../lib/commons-lang3-3.12.0.jar /opt/onap/bin/../lib/drools-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-dynamic-7.62.0.Final.jar /opt/onap/bin/../lib/drools-core-reflective-7.62.0.Final.jar /opt/onap/bin/../lib/drools-ecj-7.62.0.Final.jar /opt/onap/bin/../lib/drools-mvel-7.62.0.Final.jar /opt/onap/bin/../lib/drools-templates-7.62.0.Final.jar /opt/onap/bin/../lib/ecj-4.5.1.jar /opt/onap/bin/../lib/error_prone_annotations-2.3.2.jar /opt/onap/bin/../lib/failureaccess-1.0.1.jar /opt/onap/bin/../lib/geantyref-1.3.11.jar /opt/onap/bin/../lib/gson-2.8.6.jar /opt/onap/bin/../lib/guava-28.1-jre.jar /opt/onap/bin/../lib/hk2-api-3.0.3.jar /opt/onap/bin/../lib/hk2-locator-3.0.3.jar /opt/onap/bin/../lib/hk2-utils-3.0.3.jar /opt/onap/bin/../lib/holmes-actions-1.4.4.jar /opt/onap/bin/../lib/holmes-engine-d-1.3.8-SNAPSHOT.jar /opt/onap/bin/../lib/j2objc-annotations-1.3.jar /opt/onap/bin/../lib/jackson-annotations-2.13.3.jar /opt/onap/bin/../lib/jackson-core-2.13.3.jar /opt/onap/bin/../lib/jackson-databind-2.13.3.jar /opt/onap/bin/../lib/jackson-module-jakarta-xmlbind-annotations-2.13.3.jar /opt/onap/bin/../lib/jakarta.activation-1.2.2.jar /opt/onap/bin/../lib/jakarta.activation-api-2.1.0.jar /opt/onap/bin/../lib/jakarta.annotation-api-2.1.1.jar /opt/onap/bin/../lib/jakarta.inject-api-2.0.1.jar /opt/onap/bin/../lib/jakarta.validation-api-2.0.2.jar /opt/onap/bin/../lib/jakarta.ws.rs-api-3.1.0.jar /opt/onap/bin/../lib/jakarta.xml.bind-api-4.0.0.jar /opt/onap/bin/../lib/javassist-3.24.1-GA.jar /opt/onap/bin/../lib/javax.activation-api-1.2.0.jar /opt/onap/bin/../lib/javax.servlet-api-4.0.1.jar /opt/onap/bin/../lib/jaxb-api-2.3.1.jar /opt/onap/bin/../lib/jdbi3-core-3.19.0.jar /opt/onap/bin/../lib/jdbi3-postgres-3.19.0.jar /opt/onap/bin/../lib/jdbi3-sqlobject-3.19.0.jar /opt/onap/bin/../lib/jersey-client-3.0.5.jar /opt/onap/bin/../lib/jersey-common-3.0.5.jar /opt/onap/bin/../lib/jersey-container-servlet-core-3.0.5.jar /opt/onap/bin/../lib/jersey-entity-filtering-3.0.5.jar /opt/onap/bin/../lib/jersey-hk2-3.0.5.jar /opt/onap/bin/../lib/jersey-media-json-jackson-3.0.5.jar /opt/onap/bin/../lib/jersey-server-3.0.5.jar /opt/onap/bin/../lib/jsr305-3.0.2.jar /opt/onap/bin/../lib/jul-to-slf4j-1.7.36.jar /opt/onap/bin/../lib/kie-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-internal-7.62.0.Final.jar /opt/onap/bin/../lib/kie-memory-compiler-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-maven-support-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-api-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-project-datamodel-commons-7.62.0.Final.jar /opt/onap/bin/../lib/kie-soup-xstream-7.62.0.Final.jar /opt/onap/bin/../lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar /opt/onap/bin/../lib/log4j-api-2.17.2.jar /opt/onap/bin/../lib/log4j-to-slf4j-2.17.2.jar /opt/onap/bin/../lib/logback-classic-1.2.11.jar /opt/onap/bin/../lib/logback-core-1.2.11.jar /opt/onap/bin/../lib/lombok-1.18.16.jar /opt/onap/bin/../lib/msb-java-sdk-1.2.5.jar /opt/onap/bin/../lib/mvel2-2.4.13.Final.jar /opt/onap/bin/../lib/mxparser-1.2.2.jar /opt/onap/bin/../lib/okhttp-3.14.1.jar /opt/onap/bin/../lib/okio-1.17.2.jar /opt/onap/bin/../lib/osgi-resource-locator-1.0.3.jar /opt/onap/bin/../lib/postgresql-42.3.6.jar /opt/onap/bin/../lib/reflections-0.9.9.jar /opt/onap/bin/../lib/slf4j-api-1.7.25.jar /opt/onap/bin/../lib/snakeyaml-1.30.jar /opt/onap/bin/../lib/spring-aop-5.3.22.jar /opt/onap/bin/../lib/spring-beans-5.3.22.jar /opt/onap/bin/../lib/spring-boot-2.7.2.jar /opt/onap/bin/../lib/spring-boot-autoconfigure-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-logging-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-tomcat-2.7.2.jar /opt/onap/bin/../lib/spring-boot-starter-web-2.7.2.jar /opt/onap/bin/../lib/spring-context-5.3.22.jar /opt/onap/bin/../lib/spring-core-5.3.22.jar /opt/onap/bin/../lib/spring-expression-5.3.22.jar /opt/onap/bin/../lib/spring-jcl-5.3.22.jar /opt/onap/bin/../lib/spring-jdbc-5.3.22.jar /opt/onap/bin/../lib/spring-tx-5.3.22.jar /opt/onap/bin/../lib/spring-web-5.3.22.jar /opt/onap/bin/../lib/spring-webmvc-5.3.22.jar /opt/onap/bin/../lib/tomcat-embed-core-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-el-9.0.65.jar /opt/onap/bin/../lib/tomcat-embed-websocket-9.0.65.jar /opt/onap/bin/../lib/xmlpull-1.1.3.1.jar /opt/onap/bin/../lib/xstream-1.4.19.jar
DB_PORT=5432
SERVICE_IP=10.233.70.15
ENABLE_ENCRYPT=true
KEY_PATH=/opt/onap/bin/../conf/holmes.keystore
KEY_PASS=holmes
server:
  port: 9102
  servlet:
    context-path: /api/holmes-engine-mgmt/v1
  ssl:
    key-store: /opt/onap/bin/../conf/holmes.keystore
    key-store-password: holmes
    #PKCS12
    key-store-type: JKS

logging:
  config: classpath:logback-spring.xml

spring:
  application:
    name: Holmes Engine Management
  datasource:
    dirver-class-name: org.postgresql.Driver
    url: jdbc:postgresql://tcp-pgset-primary:5432/holmes
    username: holmes
    password: JudiTirv3~Kuho
  mvc:
    throw-exception-if-no-handler-found: trueInitializing the holmes engine management database...
--
-- Copyright 2017 ZTE Corporation.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
\c postgres

/******************CREATE NEW DATABASE AND USER***************************/
CREATE DATABASE holmes;

CREATE ROLE holmes with PASSWORD 'JudiTirv3~Kuho' LOGIN;

\encoding UTF8;

/******************CREATE NEW TABLE***************************/
\c holmes;

CREATE TABLE IF NOT EXISTS ALARM_INFO (
  EVENTID VARCHAR(150) NOT NULL,
  EVENTNAME VARCHAR(150) NOT NULL,
  ALARMISCLEARED SMALLINT NOT NULL,
  ROOTFLAG SMALLINT NOT NULL,
  STARTEPOCHMICROSEC BIGINT NOT NULL,
  LASTEPOCHMICROSEC BIGINT NOT NULL,
  SOURCEID VARCHAR(150)  NOT NULL,
  SOURCENAME VARCHAR(150)  NOT NULL,
  SEQUENCE SMALLINT NOT NULL,
  PRIMARY KEY (EVENTID, SEQUENCE, SOURCENAME)
);

CREATE TABLE IF NOT EXISTS ENGINE_ENTITY (
  ID VARCHAR(150) NOT NULL,
  IP VARCHAR(128) NOT NULL,
  PORT SMALLINT NOT NULL,
  LASTMODIFIED BIGINT NOT NULL,
  PRIMARY KEY (ID)
);

GRANT ALL PRIVILEGES ON ALARM_INFO TO holmes;
GRANT ALL PRIVILEGES ON ENGINE_ENTITY TO holmes;
dbname=holmes
user=holmes
password=JudiTirv3~Kuho
port=5432
host=tcp-pgset-primary
You are now connected to database "postgres" as user "holmes".
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:19: ERROR:  permission denied to create database
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:21: ERROR:  permission denied to create role
You are now connected to database "holmes" as user "holmes".
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:39: NOTICE:  relation "alarm_info" already exists, skipping
CREATE TABLE
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:47: NOTICE:  relation "engine_entity" already exists, skipping
CREATE TABLE
GRANT
GRANT
 eventid | eventname | alarmiscleared | rootflag | startepochmicrosec | lastepochmicrosec | sourceid | sourcename | sequence 
---------+-----------+----------------+----------+--------------------+-------------------+----------+------------+----------
(0 rows)

sql_result=0
The database is initialized successfully!

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.7.2)

2022-10-27 16:57:48 225 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-65cb68c965-5d2s6 with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2022-10-27 16:57:48 231 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2022-10-27 16:57:50 509 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2022-10-27 16:57:50 529 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2022-10-27 16:57:50 530 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2022-10-27 16:57:50 531 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2022-10-27 16:57:50 648 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2022-10-27 16:57:50 648 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2330 ms
2022-10-27 16:57:52 882 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2022-10-27 16:57:53 083 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat started on port(s): 9102 (https) with context path '/api/holmes-engine-mgmt/v1'
2022-10-27 16:57:53 110 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 6.271 seconds (JVM running for 7.169)
2022-10-27 16:57:53 144 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2022-10-27 16:57:53 157 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2022-10-27 16:57:53 177 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Registration information: {"serviceName":"holmes-engine-mgmt","version":"v1","url":"/api/holmes-engine-mgmt/v1","protocol":"REST","visualRange":"0|1","lb_policy":"round-robin","path":"/api/holmes-engine-mgmt/v1","nodes":[{"ip":"10.233.70.15","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2022-10-27 16:57:53 183 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2022-10-27 16:57:54 327 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 16:57:54 329 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 20s and try again.
2022-10-27 16:57:54 329 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 16:57:54 345 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Artifact not fetched from maven: org.onap.holmes:rules:1.0.0-SNAPSHOT. To enable the KieScanner you need kie-ci on the classpath
2022-10-27 16:57:54 348 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Adding KieModule from resource: ByteArrayResource[bytes=[80, 75, 3, 4, 20, 0, 8, 8, 8, 0, ...], encoding=null]
2022-10-27 16:57:54 357 INFO  [org.drools.compiler.kie.builder.impl.InternalKieModuleProvider][main][][] - Creating in memory KieModule for artifact org.onap.holmes:rules:1.0.0-SNAPSHOT
2022-10-27 16:57:54 358 INFO  [org.drools.compiler.kie.builder.impl.KieRepositoryImpl][main][][] - Artifact not fetched from maven: org.onap.holmes:rules:1.0.0-SNAPSHOT. To enable the KieScanner you need kie-ci on the classpath
2022-10-27 16:57:54 365 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2022-10-27 16:57:54 461 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2022-10-27 16:57:54 561 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2022-10-27 16:57:54 561 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2022-10-27 16:57:54 615 ERROR [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Failed to startup the engine of Holmes: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15 [statement:"SELECT * FROM APLUS_RULE WHERE enable=:enable", arguments:{positional:{0:1}, named:{enable:1}, finder:[]}]
org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15 [statement:"SELECT * FROM APLUS_RULE WHERE enable=:enable", arguments:{positional:{0:1}, named:{enable:1}, finder:[]}]
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1790)
	at org.jdbi.v3.core.result.ResultProducers.lambda$getResultSet$2(ResultProducers.java:64)
	at org.jdbi.v3.core.result.ResultIterable.lambda$of$0(ResultIterable.java:54)
	at org.jdbi.v3.core.result.ResultIterable.stream(ResultIterable.java:228)
	at org.jdbi.v3.core.result.ResultIterable.collect(ResultIterable.java:284)
	at org.jdbi.v3.sqlobject.statement.internal.ResultReturner$CollectedResultReturner.mappedResult(ResultReturner.java:275)
	at org.jdbi.v3.sqlobject.statement.internal.SqlQueryHandler.lambda$configureReturner$0(SqlQueryHandler.java:61)
	at org.jdbi.v3.sqlobject.statement.internal.CustomizingStatementHandler.invoke(CustomizingStatementHandler.java:178)
	at org.jdbi.v3.sqlobject.statement.internal.SqlQueryHandler.invoke(SqlQueryHandler.java:27)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.lambda$invoke$0(SqlObjectInitData.java:132)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:44)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:26)
	at org.jdbi.v3.core.LazyHandleSupplier.lambda$invokeInContext$1(LazyHandleSupplier.java:77)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:44)
	at org.jdbi.v3.core.internal.Invocations.invokeWith(Invocations.java:26)
	at org.jdbi.v3.core.LazyHandleSupplier.invokeInContext(LazyHandleSupplier.java:76)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.call(SqlObjectInitData.java:138)
	at org.jdbi.v3.sqlobject.internal.SqlObjectInitData$1.invoke(SqlObjectInitData.java:132)
	at org.jdbi.v3.sqlobject.SqlObjectFactory.lambda$attach$2(SqlObjectFactory.java:110)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$invoke$5(OnDemandExtensions.java:98)
	at org.jdbi.v3.core.internal.exceptions.Unchecked.lambda$function$4(Unchecked.java:76)
	at org.jdbi.v3.core.internal.OnDemandExtensions.invoke(OnDemandExtensions.java:98)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$2(OnDemandExtensions.java:82)
	at org.jdbi.v3.core.Jdbi.callWithExtension(Jdbi.java:476)
	at org.jdbi.v3.core.Jdbi.withExtension(Jdbi.java:463)
	at org.jdbi.v3.core.internal.OnDemandExtensions.lambda$createProxy$3(OnDemandExtensions.java:82)
	at com.sun.proxy.$Proxy82.queryRuleByEnable(Unknown Source)
	at org.onap.holmes.engine.db.CorrelationRuleDaoService.queryRuleByRuleEnable(CorrelationRuleDaoService.java:33)
	at org.onap.holmes.engine.wrapper.RuleMgtWrapper.queryRuleByEnable(RuleMgtWrapper.java:40)
	at org.onap.holmes.engine.manager.DroolsEngine.initRules(DroolsEngine.java:126)
	at org.onap.holmes.engine.manager.DroolsEngine.run(DroolsEngine.java:93)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:752)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
	at org.onap.holmes.engine.EngineDActiveApp.main(EngineDActiveApp.java:38)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "aplus_rule" does not exist
  Position: 15
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:167)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:156)
	at org.jdbi.v3.core.statement.SqlLoggerUtil.wrap(SqlLoggerUtil.java:31)
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1782)
	... 44 common frames omitted
2022-10-27 16:57:54 640 INFO  [org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener][main][][] - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-10-27 16:57:54 677 ERROR [org.springframework.boot.SpringApplication][main][][] - Application run failed
java.lang.IllegalStateException: Failed to execute ApplicationRunner
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:765)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:752)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
	at org.onap.holmes.engine.EngineDActiveApp.main(EngineDActiveApp.java:38)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: jakarta.ws.rs.WebApplicationException: HTTP 499 
	at org.onap.holmes.common.utils.ExceptionUtil.buildExceptionResponse(ExceptionUtil.java:32)
	at org.onap.holmes.engine.manager.DroolsEngine.run(DroolsEngine.java:101)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762)
	... 13 common frames omitted
2022-10-27 16:58:14 330 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 16:58:14 331 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2022-10-27 16:58:14 354 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 16:58:14 355 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 40s and try again.
2022-10-27 16:58:14 355 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 16:58:53 147 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2022-10-27 16:58:53 164 WARN  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Failed to deal with the new configurations.
java.lang.IllegalStateException: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@563f38c4 has been closed already
	at org.springframework.context.support.AbstractApplicationContext.assertBeanFactoryActive(AbstractApplicationContext.java:1138)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1171)
	at org.onap.holmes.common.utils.SpringContextUtil.getBean(SpringContextUtil.java:39)
	at org.onap.holmes.engine.dcae.ConfigFileScanningTask.addSubscribers(ConfigFileScanningTask.java:80)
	at org.onap.holmes.engine.dcae.ConfigFileScanningTask.run(ConfigFileScanningTask.java:65)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
2022-10-27 16:58:54 355 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 16:58:54 356 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2022-10-27 16:58:54 375 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 16:58:54 376 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 60s and try again.
2022-10-27 16:58:54 376 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-27 16:59:54 377 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-27 16:59:54 378 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2022-10-27 16:59:54 397 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:269)
	at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java:297)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$0(JerseyInvocation.java:662)
	at org.glassfish.jersey.client.JerseyInvocation.call(JerseyInvocation.java:697)
	at org.glassfish.jersey.client.JerseyInvocation.lambda$runInScope$3(JerseyInvocation.java:691)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
	at org.glassfish.jersey.client.JerseyInvocation.runInScope(JerseyInvocation.java:691)
	at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:661)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:439)
	at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:345)
	at org.onap.holmes.common.utils.JerseyClient.post(JerseyClient.java:147)
	at org.onap.holmes.common.utils.MsbRegister.register2Msb(MsbRegister.java:69)
	at org.onap.holmes.engine.Initializer.lambda$run$0(Initializer.java:56)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.handleEOF(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
	at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.handleException(HttpUrlConnector.java:549)
	at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java:375)
	at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java:267)
	... 18 common frames omitted
	Suppressed: java.net.SocketException: Broken pipe (Write failed)
		at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
		at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
		at java.base/java.net.SocketOutputStream.write(Unknown Source)
		at java.base/sun.security.ssl.SSLSocketOutputRecord.encodeAlert(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
		... 28 common frames omitted
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
	... 30 common frames omitted
2022-10-27 16:59:54 399 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 80s and try again.
2022-10-27 16:59:54 399 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...