Loading...

Type: Bug
Resolution: Done
Priority: High
Fix Version/s: None
Affects Version/s: El Alto Release, Frankfurt Release
Component/s: None
Labels:
- integration

After correcting the db migration script, I still get the error below, if I try to create the SDNC Naming policy.

PE300 - Data Issue: org.onap.policy.api.PolicyException: PE300 - Data Issue: Micro Service Model: Invalid Model. The model name, SDNC-GenerateName of version, CSIT was not found in the dictionary |

It is set by the policy values.yaml oom chart.

mariadb:

# '&mariadbConfig' means we "store" the values for later use in the file

# with '*mariadbConfig' pointer.

config: &mariadbConfig

userName: policy_user

userPassword: policy_user

mariadbRootPassword: secret

mysqlDatabase: policyadmin <<<<<<<

service: &mariadbService

name: policy-mariadb

portName: mysql-policy

internalPort: 3306

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

From: MALAKOV, YURIY [ym9479@att.com
Sent: Monday, December 30, 2019 5:08 PM
To: SEAUDI Abd El Muhaimen O-EG/HRCS; Pujar, Rashmi
Cc: Sakoto, Bruno
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Should it be pointing to onap_sdk

Yuriy Malakov

SDN-CP Lead Engineer

732-420-3030, [Q-Chat|qto://talk/ym9479]

Yuriy.Malakov@ATT.COM

From: abdelmuhaimen.seaudi@orange.com <abdelmuhaimen.seaudi@orange.com>
Sent: Monday, December 30, 2019 10:06 AM
To: MALAKOV, YURIY <ym9479@att.com>; Pujar, Rashmi <rashmi.pujar@bell.ca>
Cc: Sakoto, Bruno <bruno.sakoto@bell.ca>
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Also, I noticed that PAP pod is down, and its config.json is pointing to a database called “policyadmin”, which doesn’t exist in the policy-mariadb

"databaseProviderParameters": {

"name": "PolicyProviderParameterGroup",

"implementation": "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl",

"databaseDriver": "org.mariadb.jdbc.Driver",

"databaseUrl": "jdbc:mariadb://policy-mariadb:3306/policyadmin",

"databaseUser": "policy_user",

"databasePassword": "cG9saWN5X3VzZXI=",

"persistenceUnit": "PolicyMariaDb"

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

From: MALAKOV, YURIY [ym9479@att.com
Sent: Monday, December 30, 2019 3:36 PM
To: SEAUDI Abd El Muhaimen O-EG/HRCS; Pujar, Rashmi
Cc: Sakoto, Bruno
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

thx

Yuriy Malakov

SDN-CP Lead Engineer

732-420-3030, [Q-Chat|qto://talk/ym9479]

Yuriy.Malakov@ATT.COM

From: abdelmuhaimen.seaudi@orange.com <abdelmuhaimen.seaudi@orange.com>
Sent: Monday, December 30, 2019 8:34 AM
To: MALAKOV, YURIY <ym9479@att.com>; Pujar, Rashmi <rashmi.pujar@bell.ca>
Cc: Sakoto, Bruno <bruno.sakoto@bell.ca>
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

root@olc-rancher:~/oom/kubernetes/policy# kubectl -n onap exec -it onap-policy-policy-mariadb-0 bash

bash-4.2$ mysql -u policy_user -p

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 17987

Server version: 10.1.24-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use onap_sdk;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [onap_sdk]> select * from microservicemodels

-> ;

--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

id

modelname

description

dependency

imported_by

attributes

ref_attributes

sub_attributes

version

enumValues

dataOrderInfo

annotation

ruleFormation

decisionModel

--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1

tca_policy

MicroService TOSCA model

[]

demo

tca_policy=tca_policy:MANY-false,

{"thresholds": \{"severity":"string:defaultValue-null:required-null:MANY-false","fieldPath":"string:defaultValue-null:required-null:MANY-false","thresholdValue":"integer:defaultValue-null:required-null:MANY-false","closedLoopEventStatus":"string:defaultValue-null:required-null:MANY-false","closedLoopControlName":"string:defaultValue-null:required-null:MANY-false","version":"string:defaultValue-null:required-null:MANY-false","direction":"string:defaultValue-null:required-null:MANY-false"}

,"tca_policy":{"domain":"string:defaultValue-null:required-null:MANY-false","metricsPerEventName":"metricsPerEventName:MANY-true"},"metricsPerEventName":{"policyVersion":"string:defaultValue-null:required-null:MANY-false","thresholds":"thresholds:MANY-true","policyName":"string:defaultValue-null:required-null:MANY-false","controlLoopSchemaType":"string:defaultValue-null:required-null:MANY-false","policyScope":"string:defaultValue-null:required-null:MANY-false","eventName":"string:defaultValue-null:required-null:MANY-false"}}

1.1.0

Null

NULL

2

SDNC-GenerateName

SRIOV 1806 Model

[]

demo

policy-instance-name=string:defaultValue-null:required-null:MANY-false:description-null

naming-models=naming-model-entity:MANY-true:description-null,

{"naming-property": \{"property-value":"string:defaultValue-null:required-false:MANY-false:description-null","property-operation":"string:defaultValue-null:required-false:MANY-false:description-null","source-endpoint":"string:defaultValue-null:required-false:MANY-false:description-null","property-name":"string:defaultValue-null:required-true:MANY-false:description-null","increment-sequence":"increment-sequence:required-false:MANY-false:description-null","source-system":"string:defaultValue-null:required-false:MANY-false:description-null"}

,"increment-sequence":{"max":"string:defaultValue-null:required-false:MANY-false:description-null","scope":"SCOPE:defaultValue-null:required-true:MANY-false:description-null","start-value":"string:defaultValue-null:required-true:MANY-false:description-null","length":"integer:defaultValue-null:required-true:MANY-false:description-null","increment":"string:defaultValue-null:required-true:MANY-false:description-null","sequence-type":"string:defaultValue-null:required-false:MANY-false:description-null"},"naming-model-entity":{"naming-properties":"naming-property:required-true:MANY-true:description-null","name-operation":"string:defaultValue-null:required-false:MANY-false:description-null","naming-type":"string:defaultValue-null:required-true:MANY-false:description-null","nfRole":"string:defaultValue-null:required-false:MANY-false:description-null","naming-recipe":"String:defaultValue-null:required-true:MANY-false:description-null"}}

CSIT

SCOPE=[CLOUD_REGION_ID,LOCATION_CLLI,VNF,VM,VFMODULE,PRECEEDING,TRAILING,ENTIRETY,]

"[policy-instance-name,naming-models,nfRole,naming-type,naming-recipe,name-operation,naming-properties,property-name,property-value,property-operation,source-system,source-endpoint,increment-sequence,scope,sequence-type,start-value,max,increment,length]"

naming-type=matching-true, nfRole=matching-true, property-name=matching-true

NULL

--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

2 rows in set (0.00 sec)

MariaDB [onap_sdk]>

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

From: MALAKOV, YURIY [ym9479@att.com
Sent: Monday, December 30, 2019 3:30 PM
To: SEAUDI Abd El Muhaimen O-EG/HRCS; Pujar, Rashmi
Cc: Sakoto, Bruno
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

OK, looks like the policy in Frankfurt for legacy is broken. I will request Policy team to look at it.

By the way Abdel, if I was checking via rancher for this db lookup would I be checking the pdp pod to access the onap_sdk.microservicemodels table?

The model name, SDNC-GenerateName of version, CSIT was not found in the dictionary |

Yuriy Malakov

SDN-CP Lead Engineer

732-420-3030, [Q-Chat|qto://talk/ym9479]

Yuriy.Malakov@ATT.COM

From: abdelmuhaimen.seaudi@orange.com <abdelmuhaimen.seaudi@orange.com>
Sent: Monday, December 30, 2019 8:23 AM
To: MALAKOV, YURIY <ym9479@att.com>; Pujar, Rashmi <rashmi.pujar@bell.ca>
Cc: Sakoto, Bruno <bruno.sakoto@bell.ca>
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

The sql upgrade script did run in my policy

Perform DB UPGRADE on [policy-mariadb] use /opt/app/policy/data/mysql/181002_upgrade_script.sql ...

…

INSERT INTO `onap_sdk`.`microservicemodels` (`modelname`, `description`, `dependency`, `imported_by`, `attributes`, `ref_attributes`, `sub_attributes`, `version`, `enumValues`, `dataOrderInfo`, `annotation`)

VALUES ('SDNC-GenerateName', 'SRIOV 1806 Model', '[]', 'demo', 'policy-instance-name=string:defaultValue-null:required-null:MANY-false:description-null', 'naming-models=naming-model-entity:MANY-true:description-null,', '{"naming-property":

{"property-value":"string:defaultValue-null:required-false:MANY-false:description-null","property-operation":"string:defaultValue-null:required-false:MANY-false:description-null","source-endpoint":"string:defaultValue-null:required-false:MANY-false:description-null","property-name":"string:defaultValue-null:required-true:MANY-false:description-null","increment-sequence":"increment-sequence:required-false:MANY-false:description-null","source-system":"string:defaultValue-null:required-false:MANY-false:description-null"}

,"increment-sequence":{"max":"string:defaultValue-null:required-false:MANY-false:description-null","scope":"SCOPE:defaultValue-null:required-true:MANY-false:description-null","start-value":"string:defaultValue-null:required-true:MANY-false:description-null","length":"integer:defaultValue-null:required-true:MANY-false:description-null","increment":"string:defaultValue-null:required-true:MANY-false:description-null","sequence-type":"string:defaultValue-null:required-false:MANY-false:description-null"},"naming-model-entity":{"naming-properties":"naming-property:required-true:MANY-true:description-null","name-operation":"string:defaultValue-null:required-false:MANY-false:description-null","naming-type":"string:defaultValue-null:required-true:MANY-false:description-null","nfRole":"string:defaultValue-null:required-false:MANY-false:description-null","naming-recipe":"String:defaultValue-null:required-true:MANY-false:description-null"}}', 'CSIT', 'SCOPE=[CLOUD_REGION_ID,LOCATION_CLLI,VNF,VM,VFMODULE,PRECEEDING,TRAILING,ENTIRETY,]', '\"[policy-instance-name,naming-models,nfRole,naming-type,naming-recipe,name-operation,naming-properties,property-name,property-value,property-operation,source-system,source-endpoint,increment-sequence,scope,sequence-type,start-value,max,increment,length]\"','naming-type=matching-true, nfRole=matching-true, property-name=matching-true')

And I can see the microservicemodels table updated OK.

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

From: MALAKOV, YURIY [ym9479@att.com
Sent: Monday, December 30, 2019 3:12 PM
To: SEAUDI Abd El Muhaimen O-EG/HRCS; Pujar, Rashmi
Cc: Sakoto, Bruno
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Abdel,

We need to load the naming policy into the database first. https://github.com/search?q=org%3Aonap+naming-model-entity&type=Code

Can you verify if this file exists and then execute the script to load naming model: packages/base/src/files/install/mysql/data/181002_upgrade_script.sql

Yuriy Malakov

SDN-CP Lead Engineer

732-420-3030, [Q-Chat|qto://talk/ym9479]

Yuriy.Malakov@ATT.COM

From: abdelmuhaimen.seaudi@orange.com <abdelmuhaimen.seaudi@orange.com>
Sent: Monday, December 30, 2019 7:46 AM
To: MALAKOV, YURIY <ym9479@att.com>; Pujar, Rashmi <rashmi.pujar@bell.ca>
Cc: Sakoto, Bruno <bruno.sakoto@bell.ca>
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Hi Yuriyi, when I tried using the push script, I got the error below in my last mail.

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

From: MALAKOV, YURIY [ym9479@att.com
Sent: Monday, December 30, 2019 2:40 PM
To: SEAUDI Abd El Muhaimen O-EG/HRCS; Pujar, Rashmi
Cc: Sakoto, Bruno
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Abdel, Can you try to run the push policy script from oom folder. That should be creating the SDNC Naming Model and naming policy instance in policy.

https://gerrit.onap.org/r/gitweb?p=oom.git;a=blob;f=kubernetes/policy/resources/config/pe/push-policies.sh;h=ec8c914c173709e05398b1ec6701c1b7c261191d;hb=refs/heads/master

Yuriy Malakov

SDN-CP Lead Engineer

732-420-3030, [Q-Chat|qto://talk/ym9479]

Yuriy.Malakov@ATT.COM

From: abdelmuhaimen.seaudi@orange.com <abdelmuhaimen.seaudi@orange.com>
Sent: Monday, December 30, 2019 6:47 AM
To: MALAKOV, YURIY <ym9479@att.com>; Pujar, Rashmi <rashmi.pujar@bell.ca>
Cc: Sakoto, Bruno <bruno.sakoto@bell.ca>
Subject: RE: ONAP Policy-CDS Integration Testing Discussion Frankfurt Release

Even after correcting the db migration script, I still get the error below, if I try to create the SDNC Naming policy.

PE300 - Data Issue: org.onap.policy.api.PolicyException: PE300 - Data Issue: Micro Service Model: Invalid Model. The model name, SDNC-GenerateName of version, CSIT was not found in the dictionary |

Abdelmuhaimen Seaudi

Orange Labs Egypt

Email: abdelmuhaimen.seaudi@orange.com

Mobile: +2012 84644 733

blocks

POLICY-2263 Resolve all integration blockers

Closed

is blocked by

POLICY-2320 policy mariadb cluster does not ignore table cases as required by legacy pdpx/pap components

Closed

relates to

POLICY-2320 policy mariadb cluster does not ignore table cases as required by legacy pdpx/pap components

Closed

POLICY-1466 SQL scripts (*.sql) follows no convention this forces configuration of mariadb to ignore table case

Closed

Details

Description

Attachments

Issue Links

Activity

People

Dates