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.69.133
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".
CREATE TABLE
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:39: NOTICE:  relation "alarm_info" already exists, skipping
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-30 01:52:11 749 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-65cb68c965-pr777 with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2022-10-30 01:52:11 754 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2022-10-30 01:52:13 767 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2022-10-30 01:52:13 784 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2022-10-30 01:52:13 785 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2022-10-30 01:52:13 786 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2022-10-30 01:52:13 894 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2022-10-30 01:52:13 895 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2061 ms
2022-10-30 01:52:16 094 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2022-10-30 01:52:16 289 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-30 01:52:16 310 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 5.801 seconds (JVM running for 6.648)
2022-10-30 01:52:16 337 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2022-10-30 01:52:16 349 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2022-10-30 01:52:16 367 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.69.133","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2022-10-30 01:52:16 372 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2022-10-30 01:52:17 440 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-30 01:52:17 442 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-30 01:52:17 442 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:52:17 484 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-30 01:52:17 487 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-30 01:52:17 497 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-30 01:52:17 497 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-30 01:52:17 504 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2022-10-30 01:52:17 607 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2022-10-30 01:52:17 701 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2022-10-30 01:52:17 701 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2022-10-30 01:52:17 755 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-30 01:52:17 774 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-30 01:52:17 806 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-30 01:52:37 442 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:52:37 443 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2022-10-30 01:52:37 463 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-30 01:52:37 465 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-30 01:52:37 465 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:53:16 339 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2022-10-30 01:53:16 360 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-30 01:53:17 465 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:53:17 466 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2022-10-30 01:53:17 495 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-30 01:53:17 496 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-30 01:53:17 496 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:54:17 496 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:54:17 497 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2022-10-30 01:54:17 515 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-30 01:54:17 516 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-30 01:54:17 516 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.69.133
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".
CREATE TABLE
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_engine-createobj.sql:39: NOTICE:  relation "alarm_info" already exists, skipping
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-30 01:52:11 749 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-65cb68c965-pr777 with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2022-10-30 01:52:11 754 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2022-10-30 01:52:13 767 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2022-10-30 01:52:13 784 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2022-10-30 01:52:13 785 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2022-10-30 01:52:13 786 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2022-10-30 01:52:13 894 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2022-10-30 01:52:13 895 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2061 ms
2022-10-30 01:52:16 094 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2022-10-30 01:52:16 289 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-30 01:52:16 310 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 5.801 seconds (JVM running for 6.648)
2022-10-30 01:52:16 337 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2022-10-30 01:52:16 349 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2022-10-30 01:52:16 367 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.69.133","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2022-10-30 01:52:16 372 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2022-10-30 01:52:17 440 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-30 01:52:17 442 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-30 01:52:17 442 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:52:17 484 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-30 01:52:17 487 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-30 01:52:17 497 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-30 01:52:17 497 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-30 01:52:17 504 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2022-10-30 01:52:17 607 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2022-10-30 01:52:17 701 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2022-10-30 01:52:17 701 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2022-10-30 01:52:17 755 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-30 01:52:17 774 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-30 01:52:17 806 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-30 01:52:37 442 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:52:37 443 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2022-10-30 01:52:37 463 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-30 01:52:37 465 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-30 01:52:37 465 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:53:16 339 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2022-10-30 01:53:16 360 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-30 01:53:17 465 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:53:17 466 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2022-10-30 01:53:17 495 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-30 01:53:17 496 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-30 01:53:17 496 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2022-10-30 01:54:17 496 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2022-10-30 01:54:17 497 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2022-10-30 01:54:17 515 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-30 01:54:17 516 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-30 01:54:17 516 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...