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.71.130
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)

2023-01-13 13:24:06 718 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-dcbb49bc8-zh5zs with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2023-01-13 13:24:06 726 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2023-01-13 13:24:10 356 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2023-01-13 13:24:10 380 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2023-01-13 13:24:10 382 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2023-01-13 13:24:10 384 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2023-01-13 13:24:10 576 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2023-01-13 13:24:10 577 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 3721 ms
2023-01-13 13:24:13 889 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2023-01-13 13:24:14 260 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat started on port(s): 9102 (https) with context path '/api/holmes-engine-mgmt/v1'
2023-01-13 13:24:14 301 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 9.597 seconds (JVM running for 10.904)
2023-01-13 13:24:14 337 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2023-01-13 13:24:14 360 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2023-01-13 13:24:14 395 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.71.130","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2023-01-13 13:24:14 406 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2023-01-13 13:24:16 526 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
2023-01-13 13:24:16 532 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]
2023-01-13 13:24:16 547 INFO  [org.drools.compiler.kie.builder.impl.InternalKieModuleProvider][main][][] - Creating in memory KieModule for artifact org.onap.holmes:rules:1.0.0-SNAPSHOT
2023-01-13 13:24:16 549 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
2023-01-13 13:24:16 553 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
2023-01-13 13:24:16 555 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 20s and try again.
2023-01-13 13:24:16 555 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:24:16 558 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2023-01-13 13:24:16 708 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2023-01-13 13:24:16 890 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2023-01-13 13:24:16 891 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2023-01-13 13:24:16 966 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
2023-01-13 13:24:17 001 INFO  [org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener][main][][] - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2023-01-13 13:24:17 056 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
2023-01-13 13:24:36 556 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:24:36 558 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2023-01-13 13:24:36 605 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
2023-01-13 13:24:36 607 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 40s and try again.
2023-01-13 13:24:36 607 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:25:14 341 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2023-01-13 13:25:14 361 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)
2023-01-13 13:25:16 608 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:25:16 608 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2023-01-13 13:25:16 642 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
2023-01-13 13:25:16 643 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 60s and try again.
2023-01-13 13:25:16 644 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:26:16 645 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:26:16 645 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2023-01-13 13:26:16 702 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
2023-01-13 13:26:16 713 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 80s and try again.
2023-01-13 13:26:16 713 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.71.130
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)

2023-01-13 13:24:06 718 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-dcbb49bc8-zh5zs with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2023-01-13 13:24:06 726 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2023-01-13 13:24:10 356 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2023-01-13 13:24:10 380 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2023-01-13 13:24:10 382 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2023-01-13 13:24:10 384 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2023-01-13 13:24:10 576 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2023-01-13 13:24:10 577 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 3721 ms
2023-01-13 13:24:13 889 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2023-01-13 13:24:14 260 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat started on port(s): 9102 (https) with context path '/api/holmes-engine-mgmt/v1'
2023-01-13 13:24:14 301 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 9.597 seconds (JVM running for 10.904)
2023-01-13 13:24:14 337 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2023-01-13 13:24:14 360 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2023-01-13 13:24:14 395 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.71.130","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2023-01-13 13:24:14 406 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2023-01-13 13:24:16 526 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
2023-01-13 13:24:16 532 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]
2023-01-13 13:24:16 547 INFO  [org.drools.compiler.kie.builder.impl.InternalKieModuleProvider][main][][] - Creating in memory KieModule for artifact org.onap.holmes:rules:1.0.0-SNAPSHOT
2023-01-13 13:24:16 549 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
2023-01-13 13:24:16 553 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
2023-01-13 13:24:16 555 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 20s and try again.
2023-01-13 13:24:16 555 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:24:16 558 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2023-01-13 13:24:16 708 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2023-01-13 13:24:16 890 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2023-01-13 13:24:16 891 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2023-01-13 13:24:16 966 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
2023-01-13 13:24:17 001 INFO  [org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener][main][][] - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2023-01-13 13:24:17 056 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
2023-01-13 13:24:36 556 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:24:36 558 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2023-01-13 13:24:36 605 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
2023-01-13 13:24:36 607 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 40s and try again.
2023-01-13 13:24:36 607 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:25:14 341 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2023-01-13 13:25:14 361 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)
2023-01-13 13:25:16 608 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:25:16 608 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2023-01-13 13:25:16 642 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
2023-01-13 13:25:16 643 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 60s and try again.
2023-01-13 13:25:16 644 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-01-13 13:26:16 645 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-01-13 13:26:16 645 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 4
2023-01-13 13:26:16 702 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
2023-01-13 13:26:16 713 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 80s and try again.
2023-01-13 13:26:16 713 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...