2020-01-28 13:12:17,673|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-3||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| processing request id 14c3ccb1-fb34-4e01-93b0-07e94bae3b25
2020-01-28 13:12:17,676|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-3||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| cba file name(vFW_CNF_CDS), version(1.0.2) already present(/opt/app/onap/blueprints/deploy/vFW_CNF_CDS/1.0.2)
2020-01-28 13:12:17,677|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-3||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| blueprint base path /opt/app/onap/blueprints/deploy/vFW_CNF_CDS/1.0.2
2020-01-28 13:12:17,679|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-3||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| Reading blueprint type(DEFAULT) path(/opt/app/onap/blueprints/deploy/vFW_CNF_CDS/1.0.2) and entry definition file (Definitions/vFW_CNF_CDS.json)
2020-01-28 13:12:17,695|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-3||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| Deriving input data for workflow: (resource-assignment)
2020-01-28 13:12:17,696|||DefaultDispatcher-worker-13||||INFO||||||| Execute node(START) -> executed state(SUCCESS)
2020-01-28 13:12:17,697|||DefaultDispatcher-worker-13||||INFO||||||| Executing workflow(resource-assignment[14c3ccb1-fb34-4e01-93b0-07e94bae3b25])'s step($resource-assignment)
2020-01-28 13:12:17,697|||DefaultDispatcher-worker-13||||INFO||||||| executing node template(resource-assignment) component(component-resource-resolution) interface(ResourceResolutionComponent) operation(process) on host (SELF) with timeout(180) sec.
2020-01-28 13:12:17,698|||DefaultDispatcher-worker-13||||INFO||||||| preparing request id(14c3ccb1-fb34-4e01-93b0-07e94bae3b25) for workflow(resource-assignment) step(resource-assignment)
2020-01-28 13:12:17,698|||DefaultDispatcher-worker-13||||INFO||||||| resolveNodeTemplateInterfaceOperationInputs for node template (resource-assignment), interface name(ResourceResolutionComponent), operationName(process)
2020-01-28 13:12:17,698|||DefaultDispatcher-worker-13||||INFO||||||| input definition for node template (resource-assignment), values ({artifact-prefix-names={"get_input":"template-prefix"}})
2020-01-28 13:12:17,701|||DefaultDispatcher-worker-13||||INFO||||||| Resolving resource for template artifact(vnf-template) with resource assignment artifact(vnf-mapping)
2020-01-28 13:12:17,765|||DefaultDispatcher-worker-13||||INFO||||||| Batched Sequence : ([[[
    name = *
    status = null
    required = null
    dependencies = null
    dictionaryName = null
    dictionarySource = null
]], [[
    name = int_private1_net_id
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private1_net_id
    dictionarySource = default
]], [[
    name = cloud_env
    status = null
    required = false
    dependencies = []
    dictionaryName = cloud_env
    dictionarySource = input
]], [[
    name = int_private2_net_id
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private2_net_id
    dictionarySource = default
], [
    name = vpg_int_private1_ip_0
    status = null
    required = false
    dependencies = []
    dictionaryName = vpg_int_private1_ip_0
    dictionarySource = default
]], [[
    name = install_script_version
    status = null
    required = false
    dependencies = []
    dictionaryName = install_script_version
    dictionarySource = input
]], [[
    name = int_private1_net_cidr
    status = null
    required = false
    dependencies = []
    dictionaryName = int_private1_net_cidr
    dictionarySource = processor-db
], [
    name = management-prefix-id
    status = null
    required = false
    dependencies = []
    dictionaryName = management-prefix-id
    dictionarySource = processor-db
]], [[
    name = vfw_int_private1_ip_0
    status = null
    required = false
    dependencies = []
    dictionaryName = vfw_int_private1_ip_0
    dictionarySource = default
]], [[
    name = key_name
    status = null
    required = false
    dependencies = []
    dictionaryName = key_name
    dictionarySource = input
], [
    name = vnf-model-customization-uuid
    status = null
    required = false
    dependencies = []
    dictionaryName = vnf-model-customization-uuid
    dictionarySource = input
], [
    name = pub_key
    status = null
    required = false
    dependencies = []
    dictionaryName = pub_key
    dictionarySource = input
], [
    name = demo_artifacts_version
    status = null
    required = false
    dependencies = []
    dictionaryName = demo_artifacts_version
    dictionarySource = input
], [
    name = service-instance-id
    status = null
    required = false
    dependencies = []
    dictionaryName = service-instance-id
    dictionarySource = input
], [
    name = onap_private_net_id
    status = null
    required = false
    dependencies = []
    dictionaryName = onap_private_net_id
    dictionarySource = input
]], [[
    name = k8s-rb-profile-name
    status = null
    required = null
    dependencies = []
    dictionaryName = k8s-rb-profile-name
    dictionarySource = default
]], [[
    name = private2-prefix-id
    status = null
    required = false
    dependencies = []
    dictionaryName = private2-prefix-id
    dictionarySource = processor-db
]], [[
    name = int_private2_subnet_id
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private2_subnet_id
    dictionarySource = default
], [
    name = vf-naming-policy
    status = null
    required = false
    dependencies = []
    dictionaryName = vf-naming-policy
    dictionarySource = default
]], [[
    name = int_private2_net_cidr
    status = null
    required = false
    dependencies = []
    dictionaryName = int_private2_net_cidr
    dictionarySource = processor-db
]], [[
    name = onap_private_gw_ip
    status = null
    required = null
    dependencies = []
    dictionaryName = onap_private_gw_ip
    dictionarySource = default
], [
    name = int_private2_gw_ip
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private2_gw_ip
    dictionarySource = default
]], [[
    name = flavor_name
    status = null
    required = false
    dependencies = []
    dictionaryName = flavor_name
    dictionarySource = input
], [
    name = image_name
    status = null
    required = false
    dependencies = []
    dictionaryName = image_name
    dictionarySource = input
]], [[
    name = vpg_onap_private_ip_0
    status = null
    required = false
    dependencies = []
    dictionaryName = vpg_onap_private_ip_0
    dictionarySource = default
]], [[
    name = onap_private_net_cidr
    status = null
    required = false
    dependencies = []
    dictionaryName = onap_private_net_cidr
    dictionarySource = processor-db
]], [[
    name = nexus_artifact_repo
    status = null
    required = false
    dependencies = []
    dictionaryName = nexus_artifact_repo
    dictionarySource = default
], [
    name = int_private1_gw_ip
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private1_gw_ip
    dictionarySource = default
]], [[
    name = sec_group
    status = null
    required = false
    dependencies = []
    dictionaryName = sec_group
    dictionarySource = input
]], [[
    name = vsn_int_private2_ip_0
    status = null
    required = false
    dependencies = []
    dictionaryName = vsn_int_private2_ip_0
    dictionarySource = default
]], [[
    name = aic-cloud-region
    status = null
    required = false
    dependencies = []
    dictionaryName = aic-cloud-region
    dictionarySource = input
], [
    name = onap_private_subnet_id
    status = null
    required = false
    dependencies = []
    dictionaryName = onap_private_subnet_id
    dictionarySource = input
]], [[
    name = vnf_name
    status = null
    required = false
    dependencies = []
    dictionaryName = vnf_name
    dictionarySource = default
]], [[
    name = public_net_id
    status = null
    required = false
    dependencies = []
    dictionaryName = public_net_id
    dictionarySource = input
]], [[
    name = int_private1_subnet_id
    status = null
    required = null
    dependencies = []
    dictionaryName = int_private1_subnet_id
    dictionarySource = default
], [
    name = vfw_int_private2_ip_0
    status = null
    required = false
    dependencies = []
    dictionaryName = vfw_int_private2_ip_0
    dictionarySource = default
]], [[
    name = vnf-id
    status = null
    required = false
    dependencies = []
    dictionaryName = vnf-id
    dictionarySource = input
]], [[
    name = k8s-rb-profile-namespace
    status = null
    required = null
    dependencies = [service-instance-id, vnf-id]
    dictionaryName = k8s-rb-profile-namespace
    dictionarySource = default
]], [[
    name = private1-prefix-id
    status = null
    required = false
    dependencies = []
    dictionaryName = private1-prefix-id
    dictionarySource = processor-db
]]])
2020-01-28 13:12:17,769|||DefaultDispatcher-worker-13||||INFO||||||| Setting Resource Value ("${int_private1_net_id}") for Resource Name (int_private1_net_id), definition(int_private1_net_id) of type (string)
2020-01-28 13:12:17,771|||DefaultDispatcher-worker-13||||INFO||||||| Setting Resource Value ("openstack") for Resource Name (cloud_env), definition(cloud_env) of type (string)
2020-01-28 13:12:17,771|||DefaultDispatcher-worker-13||||INFO||||||| Setting Resource Value ("${vpg_int_private1_ip_0}") for Resource Name (vpg_int_private1_ip_0), definition(vpg_int_private1_ip_0) of type (string)
2020-01-28 13:12:17,771|||DefaultDispatcher-worker-13||||INFO||||||| Setting Resource Value ("${int_private2_net_id}") for Resource Name (int_private2_net_id), definition(int_private2_net_id) of type (string)
2020-01-28 13:12:17,772|||DefaultDispatcher-worker-13||||INFO||||||| Setting Resource Value ("adipisci") for Resource Name (install_script_version), definition(install_script_version) of type (string)
2020-01-28 13:12:17,773|||DefaultDispatcher-worker-13||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "management"), input-key-mapping:({}), output-key-mapping:({management-prefix-id=prefix_id})
2020-01-28 13:12:17,774|||DefaultDispatcher-worker-8||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private1"), input-key-mapping:({}), output-key-mapping:({int_private1_net_cidr=prefix})
2020-01-28 13:12:17,777|||DefaultDispatcher-worker-13||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = management-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = management-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2039) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = management-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = management-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2039) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2039) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2039) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "management"
java thread: DefaultDispatcher-worker-13
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,778|||DefaultDispatcher-worker-8||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = int_private1_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = int_private1_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2040) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = int_private1_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = int_private1_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2040) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2040) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2040) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private1"
java thread: DefaultDispatcher-worker-8
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,778|||DefaultDispatcher-worker-8||||INFO||||||| Setting Resource Value ("${vfw_int_private1_ip_0}") for Resource Name (vfw_int_private1_ip_0), definition(vfw_int_private1_ip_0) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-8||||INFO||||||| Setting Resource Value ("amet") for Resource Name (onap_private_net_id), definition(onap_private_net_id) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-8||||INFO||||||| Setting Resource Value ("voluptatum") for Resource Name (key_name), definition(key_name) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-4||||INFO||||||| Setting Resource Value ("et") for Resource Name (demo_artifacts_version), definition(demo_artifacts_version) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-15||||INFO||||||| Setting Resource Value ("qui") for Resource Name (pub_key), definition(pub_key) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-11||||INFO||||||| Setting Resource Value ("7716dab6-6c02-42a8-9e16-bc1750782e8d") for Resource Name (service-instance-id), definition(service-instance-id) of type (string)
2020-01-28 13:12:17,779|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("3cb2a246-ee2e-4234-a529-de7f41b40de4") for Resource Name (vnf-model-customization-uuid), definition(vnf-model-customization-uuid) of type (string)
2020-01-28 13:12:17,780|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("vfw-cnf-cds-base-profile") for Resource Name (k8s-rb-profile-name), definition(k8s-rb-profile-name) of type (string)
2020-01-28 13:12:17,781|||DefaultDispatcher-worker-2||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private2"), input-key-mapping:({}), output-key-mapping:({private2-prefix-id=prefix_id})
2020-01-28 13:12:17,783|||DefaultDispatcher-worker-2||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = private2-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = private2-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2041) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = private2-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = private2-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2041) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2041) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2041) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private2"
java thread: DefaultDispatcher-worker-2
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,784|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("SDNC_Policy.Config_MS_ONAP_VNF_NAMING_TIMESTAMP") for Resource Name (vf-naming-policy), definition(vf-naming-policy) of type (string)
2020-01-28 13:12:17,784|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("${int_private2_subnet_id}") for Resource Name (int_private2_subnet_id), definition(int_private2_subnet_id) of type (string)
2020-01-28 13:12:17,785|||DefaultDispatcher-worker-3||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private2"), input-key-mapping:({}), output-key-mapping:({int_private2_net_cidr=prefix})
2020-01-28 13:12:17,788|||DefaultDispatcher-worker-3||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = int_private2_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = int_private2_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2042) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = int_private2_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = int_private2_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2042) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private2"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2042) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2042) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "private2"
java thread: DefaultDispatcher-worker-3
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,789|||DefaultDispatcher-worker-3||||INFO||||||| Setting Resource Value ("192.168.20.1/24") for Resource Name (int_private2_gw_ip), definition(int_private2_gw_ip) of type (string)
2020-01-28 13:12:17,789|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("10.10.0.1/16") for Resource Name (onap_private_gw_ip), definition(onap_private_gw_ip) of type (string)
2020-01-28 13:12:17,790|||DefaultDispatcher-worker-2||||INFO||||||| Setting Resource Value ("veritatis") for Resource Name (image_name), definition(image_name) of type (string)
2020-01-28 13:12:17,790|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("animi") for Resource Name (flavor_name), definition(flavor_name) of type (string)
2020-01-28 13:12:17,790|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("vpg_onap_private_ip_0") for Resource Name (vpg_onap_private_ip_0), definition(vpg_onap_private_ip_0) of type (string)
2020-01-28 13:12:17,791|||DefaultDispatcher-worker-16||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "management"), input-key-mapping:({}), output-key-mapping:({onap_private_net_cidr=prefix})
2020-01-28 13:12:17,796|||DefaultDispatcher-worker-16||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = onap_private_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = onap_private_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2043) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = onap_private_net_cidr
    status = failure
    required = false
    dependencies = []
    dictionaryName = onap_private_net_cidr
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2043) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "management"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2043) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2043) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix as prefix from sdnctl.IPAM_IP_POOL where description = "management"
java thread: DefaultDispatcher-worker-16
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,796|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("192.168.10.1/24") for Resource Name (int_private1_gw_ip), definition(int_private1_gw_ip) of type (string)
2020-01-28 13:12:17,797|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("https://nexus.onap.org") for Resource Name (nexus_artifact_repo), definition(nexus_artifact_repo) of type (string)
2020-01-28 13:12:17,798|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("omnis") for Resource Name (sec_group), definition(sec_group) of type (string)
2020-01-28 13:12:17,798|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("${vsn_int_private2_ip_0}") for Resource Name (vsn_int_private2_ip_0), definition(vsn_int_private2_ip_0) of type (string)
2020-01-28 13:12:17,798|||DefaultDispatcher-worker-16||||INFO||||||| Setting Resource Value ("incidunt") for Resource Name (onap_private_subnet_id), definition(onap_private_subnet_id) of type (string)
2020-01-28 13:12:17,799|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("k8sregionfour") for Resource Name (aic-cloud-region), definition(aic-cloud-region) of type (string)
2020-01-28 13:12:17,799|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("${vnf_name}") for Resource Name (vnf_name), definition(vnf_name) of type (string)
2020-01-28 13:12:17,799|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("sed") for Resource Name (public_net_id), definition(public_net_id) of type (string)
2020-01-28 13:12:17,800|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("${vfw_int_private2_ip_0}") for Resource Name (vfw_int_private2_ip_0), definition(vfw_int_private2_ip_0) of type (string)
2020-01-28 13:12:17,800|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("${int_private1_subnet_id}") for Resource Name (int_private1_subnet_id), definition(int_private1_subnet_id) of type (string)
2020-01-28 13:12:17,800|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("22979c92-fc3c-4400-bc7f-13aff8a1d1c8") for Resource Name (vnf-id), definition(vnf-id) of type (string)
2020-01-28 13:12:17,801|||DefaultDispatcher-worker-5||||INFO||||||| Setting Resource Value ("default") for Resource Name (k8s-rb-profile-namespace), definition(k8s-rb-profile-namespace) of type (string)
2020-01-28 13:12:17,802|||DefaultDispatcher-worker-5||||INFO||||||| DatabaseResource (processor-db) dictionary information: Query:(select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private1"), input-key-mapping:({}), output-key-mapping:({private1-prefix-id=prefix_id})
2020-01-28 13:12:17,808|||DefaultDispatcher-worker-5||||ERROR||||||| failed in rr-processor-source-db : Failed in template key ([
    name = private1-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = private1-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2044) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
org.onap.ccsdk.cds.controllerblueprints.core.BluePrintProcessorException: Failed in template key ([
    name = private1-prefix-id
    status = failure
    required = false
    dependencies = []
    dictionaryName = private1-prefix-id
    dictionarySource = processor-db
]) assignments with: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2044) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:68)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB(DatabaseResourceAssignmentProcessor.kt:46)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.ResourceAssignmentProcessor.applyNB(ResourceAssignmentProcessor.kt:117)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.ResourceResolutionServiceImpl$resolveResourceAssignments$2$invokeSuspend$$inlined$forEach$lambda$1.invokeSuspend(ResourceResolutionService.kt:278)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(Dispatched.kt:241)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:594)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.access$runSafely(CoroutineScheduler.kt:60)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:740)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private1"]; nested exception is java.sql.SQLSyntaxErrorException: (conn=2044) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:693)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:215)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:295)
        at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:302)
        at org.onap.ccsdk.cds.blueprintsprocessor.db.AbstractDBLibGenericService.query(BluePrintDBLibGenericService.kt:38)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.setValueFromDB(DatabaseResourceAssignmentProcessor.kt:100)
        at org.onap.ccsdk.cds.blueprintsprocessor.functions.resource.resolution.processor.DatabaseResourceAssignmentProcessor.processNB$suspendImpl(DatabaseResourceAssignmentProcessor.kt:62)
        ... 9 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=2044) Table 'sdnctl.IPAM_IP_POOL' doesn't exist
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
        at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:677)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)
        ... 18 common frames omitted
Caused by: java.sql.SQLException: Table 'sdnctl.IPAM_IP_POOL' doesn't exist
Query is: select sdnctl.IPAM_IP_POOL.prefix_id as prefix_id from sdnctl.IPAM_IP_POOL where description = "private1"
java thread: DefaultDispatcher-worker-5
        at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
        at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
        ... 22 common frames omitted
2020-01-28 13:12:17,809|||DefaultDispatcher-worker-5||||INFO||||||| Generated Resource Param Data ({
  "cloud_env" : "openstack",
  "management-prefix-id" : "${management-prefix-id}",
  "key_name" : "voluptatum",
  "flavor_name" : "animi",
  "nexus_artifact_repo" : "https://nexus.onap.org",
  "vpg_onap_private_ip_0" : "vpg_onap_private_ip_0",
  "int_private1_net_cidr" : "${int_private1_net_cidr}",
  "onap_private_net_cidr" : "${onap_private_net_cidr}",
  "int_private2_net_cidr" : "${int_private2_net_cidr}",
  "demo_artifacts_version" : "et",
  "image_name" : "veritatis",
  "install_script_version" : "adipisci",
  "pub_key" : "qui",
  "public_net_id" : "sed",
  "sec_group" : "omnis",
  "vnf-id" : "22979c92-fc3c-4400-bc7f-13aff8a1d1c8",
  "vnf-model-customization-uuid" : "3cb2a246-ee2e-4234-a529-de7f41b40de4",
  "vf-naming-policy" : "SDNC_Policy.Config_MS_ONAP_VNF_NAMING_TIMESTAMP",
  "vnf_name" : "${vnf_name}",
  "vpg_int_private1_ip_0" : "${vpg_int_private1_ip_0}",
  "aic-cloud-region" : "k8sregionfour",
  "onap_private_net_id" : "amet",
  "onap_private_subnet_id" : "incidunt",
  "vfw_int_private2_ip_0" : "${vfw_int_private2_ip_0}",
  "vfw_int_private1_ip_0" : "${vfw_int_private1_ip_0}",
  "vsn_int_private2_ip_0" : "${vsn_int_private2_ip_0}",
  "service-instance-id" : "7716dab6-6c02-42a8-9e16-bc1750782e8d",
  "private1-prefix-id" : "${private1-prefix-id}",
  "private2-prefix-id" : "${private2-prefix-id}",
  "k8s-rb-profile-name" : "vfw-cnf-cds-base-profile",
  "k8s-rb-profile-namespace" : "default",
  "int_private1_gw_ip" : "192.168.10.1/24",
  "int_private1_net_id" : "${int_private1_net_id}",
  "int_private1_subnet_id" : "${int_private1_subnet_id}",
  "int_private2_gw_ip" : "192.168.20.1/24",
  "int_private2_net_id" : "${int_private2_net_id}",
  "int_private2_subnet_id" : "${int_private2_subnet_id}",
  "onap_private_gw_ip" : "10.10.0.1/16"
})
2020-01-28 13:12:17,829|||DefaultDispatcher-worker-5||||INFO||||||| Preparing Response...
2020-01-28 13:12:17,829|||DefaultDispatcher-worker-5||||INFO||||||| resolveNodeTemplateInterfaceOperationOutputs for node template (resource-assignment),interface name (ResourceResolutionComponent), operationName(process)
2020-01-28 13:12:17,829|||DefaultDispatcher-worker-5||||INFO||||||| Execute node(resource-assignment) -> executed state(SUCCESS)
2020-01-28 13:12:17,830|||DefaultDispatcher-worker-5||||INFO||||||| Executing workflow(resource-assignment[14c3ccb1-fb34-4e01-93b0-07e94bae3b25])'s step($profile-upload)
2020-01-28 13:12:17,830|||DefaultDispatcher-worker-5||||INFO||||||| executing node template(profile-upload) component(component-script-executor) interface(ComponentScriptExecutor) operation(process) on host (SELF) with timeout(180) sec.
2020-01-28 13:12:17,831|||DefaultDispatcher-worker-5||||INFO||||||| preparing request id(14c3ccb1-fb34-4e01-93b0-07e94bae3b25) for workflow(resource-assignment) step(profile-upload)
2020-01-28 13:12:17,831|||DefaultDispatcher-worker-5||||INFO||||||| resolveNodeTemplateInterfaceOperationInputs for node template (profile-upload), interface name(ComponentScriptExecutor), operationName(process)
2020-01-28 13:12:17,831|||DefaultDispatcher-worker-5||||INFO||||||| input definition for node template (profile-upload), values ({script-type="kotlin", script-class-reference="org.onap.ccsdk.cds.blueprintsprocessor.services.execution.scripts.K8sProfileUpload", dynamic-properties="*profile-upload-properties"})
2020-01-28 13:12:17,832|||DefaultDispatcher-worker-5||||INFO||||||| creating component function of script type(kotlin), reference name(org.onap.ccsdk.cds.blueprintsprocessor.services.execution.scripts.K8sProfileUpload) and instanceDependencies([])
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| executing K8s Profile Upload script
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| Preparing Response...
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| resolveNodeTemplateInterfaceOperationOutputs for node template (profile-upload),interface name (ComponentScriptExecutor), operationName(process)
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| Execute node(profile-upload) -> executed state(SUCCESS)
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| Execute node(END) -> executed state(SUCCESS)
2020-01-28 13:12:17,834|||DefaultDispatcher-worker-5||||INFO||||||| workflow(14c3ccb1-fb34-4e01-93b0-07e94bae3b25) nodes completed with (0)exceptions
2020-01-28 13:12:17,835|4b71623d-4bc6-4fc2-9124-e3811c51fb8b||DefaultDispatcher-worker-4||/api/v1/execution-service/process||INFO|||onap-cds-cds-blueprints-processor-754f4dfbfb-979h8|||| resolveWorkflowOutputs for workflow(resource-assignment)