WARN 2017-11-14 16:04:29.070 +0000 ToscaTemplate - #################################################################################################### DEBUG 2017-11-14 16:04:29.072 +0000 SdcCsarHelperImpl - CSAR conformance level is 4.0 ERROR 2017-11-14 16:04:29.129 +0000 SdcCsarHelperImpl - getServiceInputLeafValue - value not found ERROR 2017-11-14 16:04:29.129 +0000 SdcCsarHelperImpl - getServiceInputLeafValue - value not found INFO 2017-11-14 16:04:29.135 +0000 DBResourceManager - Recovery Mode disabled DEBUG 2017-11-14 16:04:29.137 +0000 DbConfigPool - Initializing DbConfigType INFO 2017-11-14 16:04:29.152 +0000 JdbcDBCachedDataSource - JdbcDBCachedDataSource configured successfully. Using URL: jdbc:mysql://sdnctldb01:3306/sdnctl DEBUG 2017-11-14 16:04:29.154 +0000 DBResourceManager - Timeout set to 60 seconds DEBUG 2017-11-14 16:04:29.286 +0000 CachedDataSource - SQL DataSource connected to 53c2b1e66449, read-only is false, tested successfully DEBUG 2017-11-14 16:04:29.286 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.287 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.314 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 27 DEBUG 2017-11-14 16:04:29.314 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 INFO 2017-11-14 16:04:29.314 +0000 DBResourceManager - Adding MASTER (sdnctldb01) to active queue INFO 2017-11-14 16:04:29.315 +0000 DBResourceManager - Completed wait with 1 active datasource(s) in 177 ms WARN 2017-11-14 16:04:29.315 +0000 SdncUebCallback - DBLIB: JDBC DataSource has been initialized. DEBUG 2017-11-14 16:04:29.315 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.315 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.316 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.316 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.316 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.316 +0000 CachedDataSource - SQL Statement: SELECT * from SERVICE_MODEL where service_uuid = "2e6f324f-2fff-4450-9528-3fd035f46c97"; INFO 2017-11-14 16:04:29.317 +0000 DBResourceManager - Thread DataSourceTester terminated Thread-3 for sdnctldb01 DEBUG 2017-11-14 16:04:29.317 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.317 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.318 +0000 SdncUebCallback - Call insertToscaData for SERVICE_MODEL serviceUUID = "2e6f324f-2fff-4450-9528-3fd035f46c97" DEBUG 2017-11-14 16:04:29.318 +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 16:04:29.318 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.318 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.319 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.319 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.319 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.327 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 8 DEBUG 2017-11-14 16:04:29.327 +0000 DBResourceManager - writeData processing time : sdnctldb01 9 miliseconds. ERROR 2017-11-14 16:04:29.333 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.333 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found DEBUG 2017-11-14 16:04:29.333 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.333 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.334 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.334 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.334 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.334 +0000 CachedDataSource - SQL Statement: SELECT * from ALLOTTED_RESOURCE_MODEL where customization_uuid = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0"; DEBUG 2017-11-14 16:04:29.335 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.336 +0000 DBResourceManager - >> getData : sdnctldb01 3 miliseconds. INFO 2017-11-14 16:04:29.336 +0000 SdncUebCallback - Call insertToscaData for ALLOTTED_RESOURCE_MODEL customizationUUID = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 16:04:29.336 +0000 SdncUebCallback - insertToscaData: INSERT into ALLOTTED_RESOURCE_MODEL (customization_uuid, model_yaml, type, invariant_uuid, uuid, version) values ("4c3f8585-d8a8-4fd9-bad8-87296529c4d0", "null", "VF", "bb539294-c402-46b4-8409-89127b26ab70", "dd78ff52-6055-46f7-9f73-46ab05e59e48", "1.0"); DEBUG 2017-11-14 16:04:29.336 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.336 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.337 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.337 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.337 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.343 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.343 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. ERROR 2017-11-14 16:04:29.343 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.344 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found DEBUG 2017-11-14 16:04:29.344 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.344 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.345 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.345 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.345 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.345 +0000 CachedDataSource - SQL Statement: SELECT * from ALLOTTED_RESOURCE_MODEL where customization_uuid = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57"; DEBUG 2017-11-14 16:04:29.346 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.346 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.346 +0000 SdncUebCallback - Call insertToscaData for ALLOTTED_RESOURCE_MODEL customizationUUID = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 16:04:29.346 +0000 SdncUebCallback - insertToscaData: INSERT into ALLOTTED_RESOURCE_MODEL (customization_uuid, model_yaml, type, invariant_uuid, uuid, version) values ("f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57", "null", "VF", "09ebcb84-c683-48c4-8120-4318489a56d0", "d0a16427-34ec-4dec-9b83-c2ec04f60525", "1.0"); DEBUG 2017-11-14 16:04:29.346 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.346 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.347 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.347 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.347 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.353 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.353 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. ERROR 2017-11-14 16:04:29.354 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.354 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.355 +0000 SdcCsarHelperImpl - processProperties - property nf_type not found ERROR 2017-11-14 16:04:29.355 +0000 SdcCsarHelperImpl - processProperties - property nf_role not found ERROR 2017-11-14 16:04:29.355 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 16:04:29.355 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 16:04:29.355 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.355 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.356 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.358 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.361 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.361 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "edea09d9-220c-4224-b07a-559bb0e32eee"; DEBUG 2017-11-14 16:04:29.362 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.363 +0000 DBResourceManager - >> getData : sdnctldb01 8 miliseconds. INFO 2017-11-14 16:04:29.363 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "edea09d9-220c-4224-b07a-559bb0e32eee" DEBUG 2017-11-14 16:04:29.363 +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 16:04:29.364 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.364 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.367 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 3 DEBUG 2017-11-14 16:04:29.367 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.369 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.375 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.376 +0000 DBResourceManager - writeData processing time : sdnctldb01 13 miliseconds. DEBUG 2017-11-14 16:04:29.377 +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 16:04:29.380 +0000 SdcCsarHelperImpl - iterateProcessPath - this input has no default ERROR 2017-11-14 16:04:29.380 +0000 SdcCsarHelperImpl - processProperties - property ecomp_generated_vm_assignments not found DEBUG 2017-11-14 16:04:29.380 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.380 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.381 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.381 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.381 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.381 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODULE_MODEL where customization_uuid = "6ceb1a5e-3656-4080-b48b-fda511575093"; DEBUG 2017-11-14 16:04:29.382 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.382 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.382 +0000 SdncUebCallback - Call insertToscaData for VF_MODULE_MODEL customizationUUID = "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 16:04:29.382 +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 16:04:29.382 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.382 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.383 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.384 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.384 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.390 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.390 +0000 DBResourceManager - writeData processing time : sdnctldb01 8 miliseconds. ERROR 2017-11-14 16:04:29.391 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 16:04:29.392 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.392 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.392 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 16:04:29.392 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.392 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.393 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.393 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.393 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.393 +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 16:04:29.394 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.394 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.394 +0000 SdncUebCallback - Call insertToscaData for VF_MODULE_TO_VFC_MAPPING customizationUUID = "6ceb1a5e-3656-4080-b48b-fda511575093" DEBUG 2017-11-14 16:04:29.394 +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 16:04:29.394 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.394 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.394 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.395 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.395 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.400 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 16:04:29.401 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. ERROR 2017-11-14 16:04:29.402 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 16:04:29.402 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.402 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.402 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 16:04:29.402 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.402 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.403 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.403 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.403 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.403 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb"; DEBUG 2017-11-14 16:04:29.404 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.404 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.404 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "03d6b2e1-a3a8-4ff7-8212-35c463fb5cbb" DEBUG 2017-11-14 16:04:29.404 +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 16:04:29.404 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.404 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.405 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.405 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.405 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.410 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 16:04:29.411 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. DEBUG 2017-11-14 16:04:29.411 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId edea09d9-220c-4224-b07a-559bb0e32eee ERROR 2017-11-14 16:04:29.411 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.411 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.411 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 16:04:29.411 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.412 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0"; DEBUG 2017-11-14 16:04:29.413 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.413 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.413 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "4c3f8585-d8a8-4fd9-bad8-87296529c4d0" DEBUG 2017-11-14 16:04:29.413 +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 16:04:29.414 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.414 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.414 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.414 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.414 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.420 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.420 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. DEBUG 2017-11-14 16:04:29.420 +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 16:04:29.420 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 16:04:29.421 +0000 SdcCsarHelperImpl - processProperties - property vm_type_tag not found ERROR 2017-11-14 16:04:29.421 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.421 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.421 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.422 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "e7610bfe-a60b-4ac8-86a2-77a49bada777"; DEBUG 2017-11-14 16:04:29.423 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.423 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.423 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "e7610bfe-a60b-4ac8-86a2-77a49bada777" DEBUG 2017-11-14 16:04:29.423 +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 16:04:29.424 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.424 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.424 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.424 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.424 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.430 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.431 +0000 DBResourceManager - writeData processing time : sdnctldb01 8 miliseconds. DEBUG 2017-11-14 16:04:29.431 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId 4c3f8585-d8a8-4fd9-bad8-87296529c4d0 ERROR 2017-11-14 16:04:29.431 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.431 +0000 SdcCsarHelperImpl - processProperties - property vnf_ecomp_naming not found ERROR 2017-11-14 16:04:29.431 +0000 SdcCsarHelperImpl - processProperties - property nf_naming_code not found ERROR 2017-11-14 16:04:29.431 +0000 SdcCsarHelperImpl - processProperties - property nf_function not found DEBUG 2017-11-14 16:04:29.431 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.431 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.432 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.432 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.432 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.432 +0000 CachedDataSource - SQL Statement: SELECT * from VF_MODEL where customization_uuid = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57"; DEBUG 2017-11-14 16:04:29.433 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 1 DEBUG 2017-11-14 16:04:29.433 +0000 DBResourceManager - >> getData : sdnctldb01 2 miliseconds. INFO 2017-11-14 16:04:29.433 +0000 SdncUebCallback - Call insertToscaData for VF_MODEL customizationUUID = "f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57" DEBUG 2017-11-14 16:04:29.433 +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 16:04:29.433 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.433 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.434 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 1 DEBUG 2017-11-14 16:04:29.434 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.434 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.440 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 5 DEBUG 2017-11-14 16:04:29.440 +0000 DBResourceManager - writeData processing time : sdnctldb01 7 miliseconds. DEBUG 2017-11-14 16:04:29.440 +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 16:04:29.440 +0000 SdcCsarHelperImpl - processProperties - property vm_type not found ERROR 2017-11-14 16:04:29.440 +0000 SdcCsarHelperImpl - processProperties - property vm_type_tag not found ERROR 2017-11-14 16:04:29.440 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.440 +0000 SdcCsarHelperImpl - processProperties - property vfc_naming not found ERROR 2017-11-14 16:04:29.441 +0000 SdcCsarHelperImpl - processProperties - property nfc_code not found DEBUG 2017-11-14 16:04:29.441 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.441 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.441 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.441 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.442 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.442 +0000 CachedDataSource - SQL Statement: SELECT * from VFC_MODEL where customization_uuid = "b22ec078-6bac-4690-81b2-16e757aa5edb"; DEBUG 2017-11-14 16:04:29.442 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 0 DEBUG 2017-11-14 16:04:29.442 +0000 DBResourceManager - >> getData : sdnctldb01 1 miliseconds. INFO 2017-11-14 16:04:29.442 +0000 SdncUebCallback - Call insertToscaData for VFC_MODEL customizationUUID = "b22ec078-6bac-4690-81b2-16e757aa5edb" DEBUG 2017-11-14 16:04:29.442 +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 16:04:29.443 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.443 +0000 CachedDataSource - SQL Statement: SELECT @@global.read_only, @@global.hostname DEBUG 2017-11-14 16:04:29.443 +0000 CachedDataSource - SQL SUCCESS. rows returned: 1, time(ms): 0 DEBUG 2017-11-14 16:04:29.443 +0000 CachedDataSource - SQL MASTER : sdnctldb01 on server 53c2b1e66449 DEBUG 2017-11-14 16:04:29.443 +0000 CachedDataSource - Obtained connection : ProxyConnection[PooledConnection[org.mariadb.jdbc.MariaDbConnection@62653a73]] DEBUG 2017-11-14 16:04:29.449 +0000 CachedDataSource - SQL SUCCESS. rows returned: 0, time(ms): 6 DEBUG 2017-11-14 16:04:29.449 +0000 DBResourceManager - writeData processing time : sdnctldb01 6 miliseconds. DEBUG 2017-11-14 16:04:29.449 +0000 SdcCsarHelperImpl - getCpListByVf cps not exist for vfCustomizationId f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57 INFO 2017-11-14 16:04:29.450 +0000 SdncUebConfiguration - Initializing ASDC distribution client INFO 2017-11-14 16:04:29.450 +0000 DistributionClientImpl - DistributionClient - init DEBUG 2017-11-14 16:04:29.452 +0000 DistributionClientImpl - get cluster server list from ASDC DEBUG 2017-11-14 16:04:29.632 +0000 AsdcConnectorClient - about to perform getServerList. requestId= 0db3ca10-479c-4329-9885-48771ecd53bb url= /sdc/v1/distributionUebCluster DEBUG 2017-11-14 16:04:29.632 +0000 HttpAsdcClient - url to send https://c2.vm1.sdc.simpledemo.openecomp.org:8443/sdc/v1/distributionUebCluster DEBUG 2017-11-14 16:04:29.641 +0000 RequestAddCookies - CookieSpec selected: default DEBUG 2017-11-14 16:04:29.647 +0000 RequestAuthCache - Auth cache not set in the context DEBUG 2017-11-14 16:04:29.648 +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 16:04:29.656 +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 16:04:29.657 +0000 MainClientExec - Opening connection {s}->https://c2.vm1.sdc.simpledemo.openecomp.org:8443 DEBUG 2017-11-14 16:04:29.687 +0000 DefaultManagedHttpClientConnection - http-outgoing-0: Shutdown connection DEBUG 2017-11-14 16:04:29.687 +0000 MainClientExec - Connection discarded DEBUG 2017-11-14 16:04:29.687 +0000 DefaultManagedHttpClientConnection - http-outgoing-0: Close connection DEBUG 2017-11-14 16:04:29.688 +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; to 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 | NULL | NULL | NULL | VF | NULL | NULL | | f3ef75e8-5cb5-4c1b-9a5a-5ddcefb70b57 | null | 09ebcb84-c683-48c4-8120-4318489a56d0 | d0a16427-34ec-4dec-9b83-c2ec04f60525 | 1.0 | NULL | NULL | NULL | NULL | VF | NULL | NULL | +--------------------------------------+------------+--------------------------------------+--------------------------------------+---------+---------------+------------------------+-------------------+------+------+--------------------+------------------------+ 2 rows in set (0.00 sec)