WARN 2017-11-14 18:38:48.098 +0000 ToscaTemplate - #################################################################################################### DEBUG 2017-11-14 18:38:48.100 +0000 SdcCsarHelperImpl - CSAR conformance level is 4.0 ERROR 2017-11-14 18:38:48.152 +0000 SdcCsarHelperImpl - getServiceInputLeafValue - value not found ERROR 2017-11-14 18:38:48.152 +0000 SdcCsarHelperImpl - getServiceInputLeafValue - value not found INFO 2017-11-14 18:38:48.158 +0000 DBResourceManager - Recovery Mode disabled DEBUG 2017-11-14 18:38:48.160 +0000 DbConfigPool - Initializing DbConfigType INFO 2017-11-14 18:38:48.174 +0000 JdbcDBCachedDataSource - JdbcDBCachedDataSource configured successfully. Using URL: jdbc:mysql://sdnctldb01:3306/sdnctl DEBUG 2017-11-14 18:38:48.176 +0000 DBResourceManager - Timeout set to 60 seconds DEBUG 2017-11-14 18:38:48.312 +0000 CachedDataSource - SQL DataSource connected to 53c2b1e66449, read-only is false, tested successfully DEBUG 2017-11-14 18:38:48.313 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.313 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.341 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 28 DEBUG 2017-11-14 18:38:48.341 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 INFO 2017-11-14 18:38:48.341 +0000 DBResourceManager - Adding MASTER (sdnctldb01) to active queue INFO 2017-11-14 18:38:48.341 +0000 DBResourceManager - Completed wait with 1 active datasource(s) in 180 ms WARN 2017-11-14 18:38:48.341 +0000 SdncUebCallback - DBLIB: JDBC DataSource has been initialized. DEBUG 2017-11-14 18:38:48.342 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.342 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.343 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.343 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.343 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.343 +0000 CachedDataSource - SQL Statement: SELECT * from SERVICE_MODEL where service_uuid = "2e6f324f-2fff-4450-9528-3fd035f46c97"; INFO 2017-11-14 18:38:48.344 +0000 DBResourceManager - Thread DataSourceTester terminated Thread-3 for sdnctldb01 DEBUG 2017-11-14 18:38:48.344 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.344 +0000 DBResourceManager - >> getData : sdnctldb01 3 miliseconds. INFO 2017-11-14 18:38:48.344 +0000 SdncUebCallback - cleanUpExistingToscaData: "2e6f324f-2fff-4450-9528-3fd035f46c97" DEBUG 2017-11-14 18:38:48.345 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.345 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.345 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.345 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.346 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.346 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 0 DEBUG 2017-11-14 18:38:48.346 +0000 DBResourceManager - writeData processing time : sdnctldb01 2 miliseconds. DEBUG 2017-11-14 18:38:48.347 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.347 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.347 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.347 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.348 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.354 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 18:38:48.355 +0000 DBResourceManager - writeData processing time : sdnctldb01 9 miliseconds. INFO 2017-11-14 18:38:48.355 +0000 SdncUebCallback - Call insertToscaData for SERVICE_MODEL serviceUUID = "2e6f324f-2fff-4450-9528-3fd035f46c97" DEBUG 2017-11-14 18:38:48.355 +0000 SdncUebCallback - insertToscaData: INSERT into SERVICE_MODEL (service_uuid, model_yaml, filename, service_instance_name_prefix, name, description, type, category, invariant_uuid, version) values ("2e6f324f-2fff-4450-9528-3fd035f46c97", "null", "service-Vcperescust111301-csar.csar", "Vcperescust111301", "vcperescust111301", "vCpeResCust", "Service", "Network L1-3", "4f9bad51-3eba-4e3b-a8ef-cbf22b53417b", "null"); DEBUG 2017-11-14 18:38:48.355 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.355 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.356 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.356 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.357 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.365 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 7 DEBUG 2017-11-14 18:38:48.365 +0000 DBResourceManager - writeData processing time : sdnctldb01 10 miliseconds. ERROR 2017-11-14 18:38:48.373 +0000 SdcCsarHelperImpl - iterateProcessPath - Path not Found DEBUG 2017-11-14 18:38:48.374 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.374 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.375 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.375 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.375 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.376 +0000 CachedDataSource - SQL Statement: SELECT * from ALLOTTED_RESOURCE_MODEL where customization_uuid = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0"; DEBUG 2017-11-14 18:38:48.377 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.377 +0000 DBResourceManager - >> getData : sdnctldb01 4 miliseconds. INFO 2017-11-14 18:38:48.377 +0000 SdncUebCallback - cleanUpExistingToscaData: "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 18:38:48.377 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.377 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.378 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.378 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.378 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.384 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 18:38:48.384 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. INFO 2017-11-14 18:38:48.384 +0000 SdncUebCallback - Call insertToscaData for ALLOTTED_RESOURCE_MODEL customizationUUID = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 18:38:48.384 +0000 SdncUebCallback - insertToscaData: INSERT into ALLOTTED_RESOURCE_MODEL (customization_uuid, model_yaml, role, ecomp_generated_naming, type, invariant_uuid, uuid, version) values ("4c3f8585-d8a8-4fd9-bad8-87296529c4d0", "null", "BRG", "Y", "BRG", "bb539294-c402-46b4-8409-89127b26ab70", "dd78ff52-6055-46f7-9f73-46ab05e59e48", "1.0"); DEBUG 2017-11-14 18:38:48.385 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.385 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.385 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.385 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.388 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.394 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 18:38:48.395 +0000 DBResourceManager - writeData processing time : sdnctldb01 11 miliseconds. ERROR 2017-11-14 18:38:48.395 +0000 SdcCsarHelperImpl - iterateProcessPath - Path not Found DEBUG 2017-11-14 18:38:48.395 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.395 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.397 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 2 DEBUG 2017-11-14 18:38:48.397 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.398 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.398 +0000 CachedDataSource - SQL Statement: SELECT * from ALLOTTED_RESOURCE_MODEL where customization_uuid = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57"; DEBUG 2017-11-14 18:38:48.399 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.399 +0000 DBResourceManager - >> getData : sdnctldb01 4 miliseconds. INFO 2017-11-14 18:38:48.399 +0000 SdncUebCallback - cleanUpExistingToscaData: "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 18:38:48.400 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.400 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.400 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.400 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.401 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.410 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 8 DEBUG 2017-11-14 18:38:48.410 +0000 DBResourceManager - writeData processing time : sdnctldb01 11 miliseconds. INFO 2017-11-14 18:38:48.410 +0000 SdncUebCallback - Call insertToscaData for ALLOTTED_RESOURCE_MODEL customizationUUID = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 18:38:48.410 +0000 SdncUebCallback - insertToscaData: INSERT into ALLOTTED_RESOURCE_MODEL (customization_uuid, model_yaml, role, ecomp_generated_naming, type, invariant_uuid, uuid, version) values ("f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57", "null", "TunnelXConn", "Y", "TunnelXConn", "09ebcb84-c683-48c4-8120-4318489a56d0", "d0a16427-34ec-4dec-9b83-c2ec04f60525", "1.0"); DEBUG 2017-11-14 18:38:48.410 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.410 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.411 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.411 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.411 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.417 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 18:38:48.417 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. ERROR 2017-11-14 18:38:48.417 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.417 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.418 +0000 SdcCsarHelperImpl - processProperties - property nf_type not found ERROR 2017-11-14 18:38:48.418 +0000 SdcCsarHelperImpl - processProperties - property nf_role not found ERROR 2017-11-14 18:38:48.418 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 18:38:48.418 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 18:38:48.418 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.418 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.419 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.419 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.419 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.419 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "edea09d9-220c-4224-b07a-559bb0e32eee"; DEBUG 2017-11-14 18:38:48.420 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.420 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.420 +0000 SdncUebCallback - cleanUpExistingToscaData: "edea09d9-220c-4224-b07a-559bb0e32eee" DEBUG 2017-11-14 18:38:48.421 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.421 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.421 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.421 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.422 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.427 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.427 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. INFO 2017-11-14 18:38:48.427 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "edea09d9-220c-4224-b07a-559bb0e32eee" DEBUG 2017-11-14 18:38:48.427 +0000 SdncUebCallback - insertToscaData: INSERT into VF_MODEL (customization_uuid, model_yaml, vendor, name, avail_zone_max_count, vendor_version, invariant_uuid, uuid, version) values ("edea09d9-220c-4224-b07a-559bb0e32eee", "null", "integration", "gw1112", "1", "1.0", "970e923a-12de-45bf-b1ed-a4a15f855b57", "3f20980f-6a33-4df6-8522-a3b8afcd4e7b", "1.0"); DEBUG 2017-11-14 18:38:48.427 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.427 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.428 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.428 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.428 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.433 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.433 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 18:38:48.434 +0000 SdcCsarHelperImpl - getVfModulesByVf - VF node template name gw1112 0, normalized name gw11120. Searching groups on service level starting with VF normalized name... ERROR 2017-11-14 18:38:48.435 +0000 SdcCsarHelperImpl - iterateProcessPath - this input has no default ERROR 2017-11-14 18:38:48.435 +0000 SdcCsarHelperImpl - processProperties - property ecomp_generated_vm_assignments not found DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.436 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODULE_MODEL where customization_uuid = "6ceb1a5e-3656-4080-b48b-fda511575093"; DEBUG 2017-11-14 18:38:48.437 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.437 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.437 +0000 SdncUebCallback - cleanUpExistingToscaData: "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 18:38:48.437 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.437 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.438 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.438 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.438 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.443 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.443 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.444 +0000 SdncUebCallback - Call insertToscaData for VF_MODULE_MODEL customizationUUID = "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 18:38:48.444 +0000 SdncUebCallback - insertToscaData: INSERT into VF_MODULE_MODEL (customization_uuid, model_yaml, vf_module_type, invariant_uuid, uuid, version) values ("6ceb1a5e-3656-4080-b48b-fda511575093", "null", "Base", "3eebd379-7c45-411b-aa93-d6bb53e2921a", "4dd51afa-bb30-41f1-b26e-8cb8761f0083", "1"); DEBUG 2017-11-14 18:38:48.444 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.444 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.444 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.444 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.445 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.450 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.450 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. ERROR 2017-11-14 18:38:48.451 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 18:38:48.451 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.452 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.452 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 18:38:48.452 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.452 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.452 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.453 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.453 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.453 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODULE_TO_VFC_MAPPING where vf_module_customization_uuid = "6ceb1a5e-3656-4080-b48b-fda511575093"; DEBUG 2017-11-14 18:38:48.454 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.454 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.454 +0000 SdncUebCallback - cleanUpExistingToscaData: "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 18:38:48.454 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.454 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.455 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.455 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.455 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.460 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.460 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.461 +0000 SdncUebCallback - Call insertToscaData for VF_MODULE_TO_VFC_MAPPING customizationUUID = "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 18:38:48.461 +0000 SdncUebCallback - insertToscaData: insert into VF_MODULE_TO_VFC_MAPPING (vf_module_customization_uuid, vfc_customization_uuid, vm_type, vm_count) values ("6ceb1a5e-3656-4080-b48b-fda511575093", "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb", "", "1") DEBUG 2017-11-14 18:38:48.461 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.461 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.461 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.462 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.462 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.467 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.467 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. ERROR 2017-11-14 18:38:48.468 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 18:38:48.469 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.469 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.469 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 18:38:48.469 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.469 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.469 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.470 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.470 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.470 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb"; DEBUG 2017-11-14 18:38:48.471 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.471 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.471 +0000 SdncUebCallback - cleanUpExistingToscaData: "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb" DEBUG 2017-11-14 18:38:48.471 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.471 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.471 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.471 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.472 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.477 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.477 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.477 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb" DEBUG 2017-11-14 18:38:48.477 +0000 SdncUebCallback - insertToscaData: INSERT into VFC_MODEL (customization_uuid, model_yaml, vm_type_tag, invariant_uuid, uuid, version) values ("03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb", "null", "vgw", "aa28c5d4-ce7a-48d9-8bfe-efa29f2b2c29", "510c7e5c-37cf-486f-89ef-5bca9d31227f", "1.0"); DEBUG 2017-11-14 18:38:48.477 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.477 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.478 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.478 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.478 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.483 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.483 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 18:38:48.483 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId edea09d9-220c-4224-b07a-559bb0e32eee ERROR 2017-11-14 18:38:48.483 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.484 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.484 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 18:38:48.484 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 18:38:48.484 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.484 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.485 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.485 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.485 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.485 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0"; DEBUG 2017-11-14 18:38:48.486 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.486 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.486 +0000 SdncUebCallback - cleanUpExistingToscaData: "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 18:38:48.486 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.486 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.486 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.487 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.487 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.493 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 18:38:48.493 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. INFO 2017-11-14 18:38:48.493 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 18:38:48.493 +0000 SdncUebCallback - insertToscaData: INSERT into VF_MODEL (customization_uuid, model_yaml, vendor, nf_role, name, avail_zone_max_count, vendor_version, nf_type, invariant_uuid, uuid, version) values ("4c3f8585-d8a8-4fd9-bad8-87296529c4d0", "null", "integration", "BRG", "brgallotted111301", "1", "1.0", "BRG", "bb539294-c402-46b4-8409-89127b26ab70", "dd78ff52-6055-46f7-9f73-46ab05e59e48", "1.0"); DEBUG 2017-11-14 18:38:48.493 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.493 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.494 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.494 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.494 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.503 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 7 DEBUG 2017-11-14 18:38:48.503 +0000 DBResourceManager - writeData processing time : sdnctldb01 10 miliseconds. DEBUG 2017-11-14 18:38:48.503 +0000 SdcCsarHelperImpl - getVfModulesByVf - VF node template name brgallotted111301 0, normalized name brgallotted1113010. Searching groups on service level starting with VF normalized name... ERROR 2017-11-14 18:38:48.503 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 18:38:48.503 +0000 SdcCsarHelperImpl - processProperties - property vm_type_tag not found ERROR 2017-11-14 18:38:48.503 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.503 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.504 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 18:38:48.504 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.504 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.504 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.506 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.506 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.506 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "e7610bfe-a60b-4ac8-86a2-77a49bada777"; DEBUG 2017-11-14 18:38:48.507 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.507 +0000 DBResourceManager - >> getData : sdnctldb01 3 miliseconds. INFO 2017-11-14 18:38:48.507 +0000 SdncUebCallback - cleanUpExistingToscaData: "e7610bfe-a60b-4ac8-86a2-77a49bada777" DEBUG 2017-11-14 18:38:48.507 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.507 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.507 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.507 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.508 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.513 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.513 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.514 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "e7610bfe-a60b-4ac8-86a2-77a49bada777" DEBUG 2017-11-14 18:38:48.514 +0000 SdncUebCallback - insertToscaData: INSERT into VFC_MODEL (customization_uuid, model_yaml, invariant_uuid, uuid, version) values ("e7610bfe-a60b-4ac8-86a2-77a49bada777", "null", "0b024d90-9cb1-4382-9739-9cb3f883b801", "8c7458bf-742b-4690-9deb-9595922b9a3f", "1.0"); DEBUG 2017-11-14 18:38:48.514 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.514 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.514 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.514 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.514 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.520 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.520 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 18:38:48.520 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId 4c3f8585-d8a8-4fd9-bad8-87296529c4d0 ERROR 2017-11-14 18:38:48.520 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.521 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 18:38:48.521 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 18:38:48.521 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 18:38:48.521 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.521 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.522 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.522 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.522 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.522 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57"; DEBUG 2017-11-14 18:38:48.523 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.523 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.523 +0000 SdncUebCallback - cleanUpExistingToscaData: "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 18:38:48.523 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.523 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.523 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.524 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.524 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.529 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.529 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.529 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 18:38:48.529 +0000 SdncUebCallback - insertToscaData: INSERT into VF_MODEL (customization_uuid, model_yaml, vendor, nf_role, name, avail_zone_max_count, vendor_version, nf_type, invariant_uuid, uuid, version) values ("f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57", "null", "integration", "TunnelXConn", "tunnelxconn111301", "1", "1.0", "TunnelXConn", "09ebcb84-c683-48c4-8120-4318489a56d0", "d0a16427-34ec-4dec-9b83-c2ec04f60525", "1.0"); DEBUG 2017-11-14 18:38:48.530 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.530 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.530 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 18:38:48.530 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.530 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.535 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.535 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - getVfModulesByVf - VF node template name tunnelxconn111301 0, normalized name tunnelxconn1113010. Searching groups on service level starting with VF normalized name... ERROR 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - processProperties - property vm_type_tag not found ERROR 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 18:38:48.536 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 18:38:48.536 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.536 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.537 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.537 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.537 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.537 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "b22ec078-6bac-4690-81b2-16e757aa5edb"; DEBUG 2017-11-14 18:38:48.538 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.538 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 18:38:48.538 +0000 SdncUebCallback - cleanUpExistingToscaData: "b22ec078-6bac-4690-81b2-16e757aa5edb" DEBUG 2017-11-14 18:38:48.538 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.538 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.539 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.539 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.539 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.544 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.544 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. INFO 2017-11-14 18:38:48.544 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "b22ec078-6bac-4690-81b2-16e757aa5edb" DEBUG 2017-11-14 18:38:48.544 +0000 SdncUebCallback - insertToscaData: INSERT into VFC_MODEL (customization_uuid, model_yaml, invariant_uuid, uuid, version) values ("b22ec078-6bac-4690-81b2-16e757aa5edb", "null", "0b024d90-9cb1-4382-9739-9cb3f883b801", "8c7458bf-742b-4690-9deb-9595922b9a3f", "1.0"); DEBUG 2017-11-14 18:38:48.544 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.544 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 18:38:48.545 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 18:38:48.545 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 18:38:48.545 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@74f29dc7]] DEBUG 2017-11-14 18:38:48.550 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 18:38:48.550 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 18:38:48.550 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57 INFO 2017-11-14 18:38:48.551 +0000 SdncUebConfiguration - Initializing ASDC distribution client INFO 2017-11-14 18:38:48.551 +0000 DistributionClientImpl - DistributionClient - init DEBUG 2017-11-14 18:38:48.553 +0000 DistributionClientImpl - get cluster server list from ASDC DEBUG 2017-11-14 18:38:48.729 +0000 AsdcConnectorClient - about to perform getServerList. requestId= d78f65fb-f904-4a54-8e7b-4c2797d268e8 url= /sdc/v1/distributionUebCluster DEBUG 2017-11-14 18:38:48.729 +0000 HttpAsdcClient - url to send https://c2.vm1.sdc.simpledemo.openecomp.org:8443/sdc/v1/distributionUebCluster DEBUG 2017-11-14 18:38:48.738 +0000 RequestAddCookies - CookieSpec selected: default DEBUG 2017-11-14 18:38:48.744 +0000 RequestAuthCache - Auth cache not set in the context DEBUG 2017-11-14 18:38:48.745 +0000 PoolingHttpClientConnectionManager - Connection request: [route: {s}->https://c2.vm1.sdc.simpledemo.openecomp.org:8443][total kept alive: 0; route allocated: 0 of 2; total allocated: 0 of 20] DEBUG 2017-11-14 18:38:48.753 +0000 PoolingHttpClientConnectionManager - Connection leased: [id: 0][route: {s}->https://c2.vm1.sdc.simpledemo.openecomp.org:8443][total kept alive: 0; route allocated: 1 of 2; total allocated: 1 of 20] DEBUG 2017-11-14 18:38:48.754 +0000 MainClientExec - Opening connection {s}->https://c2.vm1.sdc.simpledemo.openecomp.org:8443 DEBUG 2017-11-14 18:38:48.785 +0000 DefaultManagedHttpClientConnection - http-outgoing-0: Shutdown connection DEBUG 2017-11-14 18:38:48.785 +0000 MainClientExec - Connection discarded DEBUG 2017-11-14 18:38:48.785 +0000 DefaultManagedHttpClientConnection - http-outgoing-0: Close connection DEBUG 2017-11-14 18:38:48.785 +0000 PoolingHttpClientConnectionManager - Connection released: [id: 0][route: {s}->https://c2.vm1.sdc.simpledemo.openecomp.org:8443][total kept alive: 0; route allocated: 0 of 2; total allocated: 0 of 20] ERROR 2017-11-14 18:38:48.785 +0000 HttpAsdcClient - failed to connect to url: /sdc/v1/distributionUebCluster java.net.UnknownHostException: c2.vm1.sdc.simpledemo.openecomp.org: Name or service not known at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) at java.net.InetAddress.getAllByName0(InetAddress.java:1276) at java.net.InetAddress.getAllByName(InetAddress.java:1192) at java.net.InetAddress.getAllByName(InetAddress.java:1126) at org.apache.http.impl.conn.SystemDefaultDnsResolver.resolve(SystemDefaultDnsResolver.java:45) at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:111) at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:353) at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:380) at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236) at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:184) at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:88) at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110) at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:184) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:107) at org.openecomp.sdc.http.HttpAsdcClient.getRequest(HttpAsdcClient.java:278) at org.openecomp.sdc.http.AsdcConnectorClient.performAsdcServerRequest(AsdcConnectorClient.java:143) at org.openecomp.sdc.http.AsdcConnectorClient.getServerList(AsdcConnectorClient.java:94) at org.openecomp.sdc.impl.DistributionClientImpl.initUebServerList(DistributionClientImpl.java:325) at org.openecomp.sdc.impl.DistributionClientImpl.init(DistributionClientImpl.java:241) at org.onap.ccsdk.sli.northbound.uebclient.SdncUebClient.main(SdncUebClient.java:48) ERROR 2017-11-14 18:38:48.790 +0000 AsdcConnectorClient - status from ASDC is org.openecomp.sdc.http.HttpAsdcResponse@466d4ced ERROR 2017-11-14 18:38:48.790 +0000 AsdcConnectorClient - DistributionClientResultImpl [responseStatus=ASDC_CONNECTION_FAILED, responseMessage=ASDC server problem] DEBUG 2017-11-14 18:38:48.793 +0000 AsdcConnectorClient - error from ASDC is: failed to connect INFO 2017-11-14 18:38:48.812 +0000 SdncUebConfiguration - Initialized ASDC distribution client - results = ASDC server problem root@a1b31d106b5b:/opt/app/ueb-listener/logs# mysql> select * from ALLOTTED_RESOURCE_MODEL where customization_uuid in ("4c3f8585-d8a8-4fd9-bad8-87296529c4d0", "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57"); +--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+---------------+------------------------+-------------------+-------------+-------------+--------------------+------------------------+ | customization_uuid | model_yaml | invariant_uuid | uuid | version | naming_policy | ecomp_generated_naming | depending_service | role | type | service_dependency | allotted_resource_type | +--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+---------------+------------------------+-------------------+-------------+-------------+--------------------+------------------------+ | 4c3f8585-d8a8-4fd9-bad8-87296529c4d0 | null | bb539294-c402-46b4-8409-89127b26ab70 | dd78ff52-6055-46f7-9f73-46ab05e59e48 | 1.0 | NULL | Y | NULL | BRG | BRG | NULL | NULL | | f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57 | null | 09ebcb84-c683-48c4-8120-4318489a56d0 | d0a16427-34ec-4dec-9b83-c2ec04f60525 | 1.0 | NULL | Y | NULL | TunnelXConn | TunnelXConn | NULL | NULL | +--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+---------------+------------------------+-------------------+-------------+-------------+--------------------+------------------------+ 2 rows in set (0.00 sec)