@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.66.88
ENABLE_ENCRYPT=true
KEY_PATH=/opt/onap/bin/../conf/holmes.keystore
KEY_PASS=holmes
server:
  port: 9102
  servlet:
    context-path: /api/holmes-engine-mgmt/v1
  ssl:
    key-store: /opt/onap/bin/../conf/holmes.keystore
    key-store-password: holmes
    #PKCS12
    key-store-type: JKS

logging:
  config: classpath:logback-spring.xml

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

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

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

\encoding UTF8;

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

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

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

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

sql_result=0
The database is initialized successfully!

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

2023-03-05 03:38:43 505 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Starting EngineDActiveApp using Java 11.0.6 on onap-holmes-engine-mgmt-dcbb49bc8-f95kg with PID 53 (/opt/onap/lib/holmes-engine-d-1.3.8-SNAPSHOT.jar started by onap in /opt/onap)
2023-03-05 03:38:43 510 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - No active profile set, falling back to 1 default profile: "default"
2023-03-05 03:38:46 189 INFO  [org.springframework.boot.web.embedded.tomcat.TomcatWebServer][main][][] - Tomcat initialized with port(s): 9102 (https)
2023-03-05 03:38:46 210 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Initializing ProtocolHandler ["https-jsse-nio-9102"]
2023-03-05 03:38:46 212 INFO  [org.apache.catalina.core.StandardService][main][][] - Starting service [Tomcat]
2023-03-05 03:38:46 212 INFO  [org.apache.catalina.core.StandardEngine][main][][] - Starting Servlet engine: [Apache Tomcat/9.0.65]
2023-03-05 03:38:46 354 INFO  [org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/api/holmes-engine-mgmt/v1]][main][][] - Initializing Spring embedded WebApplicationContext
2023-03-05 03:38:46 355 INFO  [org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext][main][][] - Root WebApplicationContext: initialization completed in 2753 ms
2023-03-05 03:38:48 884 INFO  [org.apache.coyote.http11.Http11NioProtocol][main][][] - Starting ProtocolHandler ["https-jsse-nio-9102"]
2023-03-05 03:38:49 168 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-03-05 03:38:49 196 INFO  [org.onap.holmes.engine.EngineDActiveApp][main][][] - Started EngineDActiveApp in 6.978 seconds (JVM running for 7.928)
2023-03-05 03:38:49 241 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initializing...
2023-03-05 03:38:49 259 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start to register Holmes Service to MSB...
2023-03-05 03:38:49 283 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.66.88","port":"9102","ttl":"","checkType":"","checkUrl":""}],"enable_ssl":true}
2023-03-05 03:38:49 290 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 1
2023-03-05 03:38:50 567 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: java.net.UnknownHostException: msb-iag.onap
jakarta.ws.rs.ProcessingException: java.net.UnknownHostException: msb-iag.onap
	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: java.net.UnknownHostException: msb-iag.onap
	at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
	at java.base/java.net.Socket.connect(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
	at java.base/sun.net.NetworkClient.doConnect(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(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
2023-03-05 03:38:50 568 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 20s and try again.
2023-03-05 03:38:50 569 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-03-05 03:38:50 654 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-03-05 03:38:50 657 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-03-05 03:38:50 670 INFO  [org.drools.compiler.kie.builder.impl.InternalKieModuleProvider][main][][] - Creating in memory KieModule for artifact org.onap.holmes:rules:1.0.0-SNAPSHOT
2023-03-05 03:38:50 670 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-03-05 03:38:50 678 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - Start creation of KieBase: KBase
2023-03-05 03:38:50 787 INFO  [org.drools.compiler.kie.builder.impl.KieContainerImpl][main][][] - End creation of KieBase: KBase
2023-03-05 03:38:50 880 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Drools engine initialized.
2023-03-05 03:38:50 880 INFO  [org.onap.holmes.engine.manager.DroolsEngine][main][][] - Start deploy existing rules...
2023-03-05 03:38:51 000 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-03-05 03:38:51 025 INFO  [org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener][main][][] - 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2023-03-05 03:38:51 059 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-03-05 03:39:10 569 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-03-05 03:39:10 570 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 2
2023-03-05 03:39:10 585 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: java.net.UnknownHostException: msb-iag.onap
jakarta.ws.rs.ProcessingException: java.net.UnknownHostException: msb-iag.onap
	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: java.net.UnknownHostException: msb-iag.onap
	at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
	at java.base/java.net.Socket.connect(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
	at java.base/sun.net.NetworkClient.doConnect(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(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
2023-03-05 03:39:10 586 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 40s and try again.
2023-03-05 03:39:10 586 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...
2023-03-05 03:39:49 247 INFO  [org.onap.holmes.engine.dcae.ConfigFileScanningTask][pool-1-thread-1][][] - Configurations have changed.
2023-03-05 03:39:49 273 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-03-05 03:39:50 587 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Wake up.
2023-03-05 03:39:50 588 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Holmes Service Registration. Times: 3
2023-03-05 03:39:50 621 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Unexpected exception: java.net.UnknownHostException: msb-iag.onap
jakarta.ws.rs.ProcessingException: java.net.UnknownHostException: msb-iag.onap
	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: java.net.UnknownHostException: msb-iag.onap
	at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
	at java.base/java.net.Socket.connect(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
	at java.base/sun.net.NetworkClient.doConnect(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.http.HttpClient.openServer(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
	at java.base/sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
	at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(Unknown Source)
	at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(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
2023-03-05 03:39:50 622 WARN  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Failed to register the service to MSB. Sleep 60s and try again.
2023-03-05 03:39:50 622 INFO  [org.onap.holmes.common.utils.MsbRegister][pool-2-thread-1][][] - Start sleeping...