-
Bug
-
Resolution: Done
-
Highest
-
Beijing Release
-
None
-
Policy Beijing RC0
There's a mismatch in packages/base/src/files/install/mysql/data/180601_upgrade_script.sql:
The CREATE TABLE creates the "dataOrder" column but the INSERT using "dataOrderInfo" as the column name, therefore failing the insert statement.
The issue affect both PE and CSIT tests, see below:
create table `onap_sdk`.`optimizationmodels` ( `id` int(11) not null auto_increment, `modelname` varchar(767) not null, `description` varchar(1024) default null, `dependency` varchar(1024) default null, `imported_by` varchar(45) not null, `attributes` longtext, `ref_attributes` longtext, `sub_attributes` longtext, `version` varchar(45) default null, `annotation` longtext, `enumValues` longtext, `dataOrder` varchar(2000) DEFAULT NULL, primary key (`id`), unique key `optimizationmodels_uniq` (`modelname`,`version`) );
and
INSERT INTO `onap_sdk`.`optimizationmodels` (`modelname`, `description`, `dependency`, `imported_by`, `attributes`, `ref_attributes`, `sub_attributes`, `version`, `annotation`, `enumValues`, `dataOrderInfo`) VALUES ('hpaPolicy', 'CSIT Tests Model', '[]', 'demo', 'identity=string:defaultValue-null:required-true:MANY-false,resources=string:defaultValue-null:required-true:MANY-false', 'policyScope=MANY-true,policyType=POLICYTYPE:MANY-false,flavorFeatures=flavorFeatures-properties:MANY-true', '{\"flavorProperties-properties\":{\"score\":\"string:defaultValue-null:required-true:MANY-false\",\"featureAttributes\":\"featureAttributes-properties:required-false:MANY-true\",\"mandatory\":\"string:defaultValue-null:required-true:MANY-false\",\"hpaFeature\":\"string:defaultValue-null:required-true:MANY-false\",\"architecture\":\"string:defaultValue-null:required-true:MANY-false\"},\"flavorFeatures-properties\":{\"flavorProperties\":\"flavorProperties-properties:required-false:MANY-true\",\"flavorLabel\":\"string:defaultValue-null:required-true:MANY-false\"},\"featureAttributes-properties\":{\"unit\":\"string:defaultValue-null:required-true:MANY-false\",\"attribute\":\"string:defaultValue-null:required-true:MANY-false\",\"value\":\"string:defaultValue-null:required-true:MANY-false\",\"operator\":\"OPERATOR:required-true:MANY-false\"}}\n', 'CSIT', 'policyScope=matching-true', 'OPERATOR=[<,<equal-sign,>,>equal-sign,equal-sign,!equal-sign,any,all,subset,], POLICYTYPE=[hpaPolicy,]', '\"[resources,identity,policyScope,policyType,flavorFeatures,flavorLabel,flavorProperties,architecture,hpaFeature,mandatory,score,featureAttributes,attribute,operator,unit,value]\"');