Hi,
The results of the robot script “./demo-k8s.sh onap distributeVFWNG”, for your
reference.
root@olc-rancher:~/oom/kubernetes/robot# ./demo-k8s.sh onap distributeVFWNG
Number of parameters:
2
KEY:
distributeVFWNG
++ kubectl --namespace onap get pods
++ grep robot
++ sed 's/ .*//'
+ POD=onap-robot-robot-5b5cbb95fc-drmb8
+ ETEHOME=/var/opt/OpenECOMP_ETE
++ kubectl --namespace onap exec onap-robot-robot-5b5cbb95fc-drmb8 -- bash -c
'ls -1q /share/logs/ | wc -l'
+ export GLOBAL_BUILD_NUMBER=16
+ GLOBAL_BUILD_NUMBER=16
++ printf %04d 16
+ OUTPUT_FOLDER=0016_demo_distributeVFWNG
+ DISPLAY_NUM=106
+ VARIABLEFILES='-V /share/config/vm_properties.py -V
/share/config/integration_robot_properties.py -V
/share/config/integration_preload_parameters.py'
+ kubectl --namespace onap exec onap-robot-robot-5b5cbb95fc-drmb8 --
/var/opt/OpenECOMP_ETE/runTags.sh -V /share/config/vm_properties.py -V
/share/config/integration_robot_properties.py -V
/share/config/integration_preload_parameters.py -d
/share/logs/0016_demo_distributeVFWNG -i distributeVFWNG --display 106
Starting Xvfb on display :106 with res 1280x1024x24
Executing robot tests at log level TRACE
==============================================================================
Testsuites
==============================================================================
Testsuites.Demo :: Executes the VNF Orchestration Test cases including setu...
==============================================================================
Distribute vFWNG CDS Model :: Distribute vFWNG for CDS
resp=[{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_function', u'hidden': False,
u'type': u'string', u'annotations': None, u'empty': False, u'schema':
{u'derivedFrom': None, u'version': None, u'ownerId': None, u'property':
{u'getInputValues': None, u'parentUniqueId': None, u'instanceUniqueId': None,
u'schemaProperty': None, u'schemaType': None, u'propertyId': None,
u'defaultValue': None, u'label': None, u'version': None, u'uniqueId': None,
u'hidden': False, u'type': None, u'annotations': None, u'empty': False,
u'schema': None, u'status': None, u'description': None, u'inputId': None,
u'inputPath': None, u'password': False, u'definition': True, u'name': None,
u'required': False, u'value': None, u'immutable': False, u'getInputProperty':
False, u'ownerId': None}, u'type': None, u'properties': None, u'empty': False,
u'constraints': None}, u'status': None, u'inputs': None, u'description': None,
u'rules': None, u'valueUniqueUid': None, u'inputId': None, u'inputPath': None,
u'path': None, u'password': False, u'properties': None, u'definition': False,
u'name': u'nfc_function', u'required': False, u'value': u'vsn', u'immutable':
False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None},
{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_naming', u'hidden': False, u'type':
u'org.openecomp.datatypes.Naming', u'annotations': None, u'empty': False,
u'schema': {u'derivedFrom': None, u'version': None, u'ownerId': None,
u'property': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'type': None, u'properties':
None, u'empty': False, u'constraints': None}, u'status': None, u'inputs': None,
u'description': u'vfc naming', u'rules': None, u'valueUniqueUid': None,
u'inputId': None, u'inputPath': None, u'path': None, u'password': False,
u'properties': None, u'definition': False, u'name': u'nfc_naming', u'required':
False, u'value':
u'{"ecomp_generated_naming":true,"naming_policy":"SDNC_Policy.ONAP_VSN_NAMING_TIMESTAMP"}',
u'immutable': False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None}]
resp=[{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_function', u'hidden': False,
u'type': u'string', u'annotations': None, u'empty': False, u'schema':
{u'derivedFrom': None, u'version': None, u'ownerId': None, u'property':
{u'getInputValues': None, u'parentUniqueId': None, u'instanceUniqueId': None,
u'schemaProperty': None, u'schemaType': None, u'propertyId': None,
u'defaultValue': None, u'label': None, u'version': None, u'uniqueId': None,
u'hidden': False, u'type': None, u'annotations': None, u'empty': False,
u'schema': None, u'status': None, u'description': None, u'inputId': None,
u'inputPath': None, u'password': False, u'definition': True, u'name': None,
u'required': False, u'value': None, u'immutable': False, u'getInputProperty':
False, u'ownerId': None}, u'type': None, u'properties': None, u'empty': False,
u'constraints': None}, u'status': None, u'inputs': None, u'description': None,
u'rules': None, u'valueUniqueUid': None, u'inputId': None, u'inputPath': None,
u'path': None, u'password': False, u'properties': None, u'definition': False,
u'name': u'nfc_function', u'required': False, u'value': u'vfw', u'immutable':
False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None},
{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_naming', u'hidden': False, u'type':
u'org.openecomp.datatypes.Naming', u'annotations': None, u'empty': False,
u'schema': {u'derivedFrom': None, u'version': None, u'ownerId': None,
u'property': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'type': None, u'properties':
None, u'empty': False, u'constraints': None}, u'status': None, u'inputs': None,
u'description': u'vfc naming', u'rules': None, u'valueUniqueUid': None,
u'inputId': None, u'inputPath': None, u'path': None, u'password': False,
u'properties': None, u'definition': False, u'name': u'nfc_naming', u'required':
False, u'value':
u'{"ecomp_generated_naming":true,"naming_policy":"SDNC_Policy.ONAP_VFW_NAMING_TIMESTAMP"}',
u'immutable': False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None}]
resp=[{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_function', u'hidden': False,
u'type': u'string', u'annotations': None, u'empty': False, u'schema':
{u'derivedFrom': None, u'version': None, u'ownerId': None, u'property':
{u'getInputValues': None, u'parentUniqueId': None, u'instanceUniqueId': None,
u'schemaProperty': None, u'schemaType': None, u'propertyId': None,
u'defaultValue': None, u'label': None, u'version': None, u'uniqueId': None,
u'hidden': False, u'type': None, u'annotations': None, u'empty': False,
u'schema': None, u'status': None, u'description': None, u'inputId': None,
u'inputPath': None, u'password': False, u'definition': True, u'name': None,
u'required': False, u'value': None, u'immutable': False, u'getInputProperty':
False, u'ownerId': None}, u'type': None, u'properties': None, u'empty': False,
u'constraints': None}, u'status': None, u'inputs': None, u'description': None,
u'rules': None, u'valueUniqueUid': None, u'inputId': None, u'inputPath': None,
u'path': None, u'password': False, u'properties': None, u'definition': False,
u'name': u'nfc_function', u'required': False, u'value': u'vpg', u'immutable':
False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None},
{u'getInputValues': None, u'parentUniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'instanceUniqueId': None,
u'schemaProperty': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'schemaType': None,
u'propertyId': None, u'componentInstanceId': None, u'defaultValue': None,
u'label': None, u'componentInstanceName': None, u'version': None, u'uniqueId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369.nfc_naming', u'hidden': False, u'type':
u'org.openecomp.datatypes.Naming', u'annotations': None, u'empty': False,
u'schema': {u'derivedFrom': None, u'version': None, u'ownerId': None,
u'property': {u'getInputValues': None, u'parentUniqueId': None,
u'instanceUniqueId': None, u'schemaProperty': None, u'schemaType': None,
u'propertyId': None, u'defaultValue': None, u'label': None, u'version': None,
u'uniqueId': None, u'hidden': False, u'type': None, u'annotations': None,
u'empty': False, u'schema': None, u'status': None, u'description': None,
u'inputId': None, u'inputPath': None, u'password': False, u'definition': True,
u'name': None, u'required': False, u'value': None, u'immutable': False,
u'getInputProperty': False, u'ownerId': None}, u'type': None, u'properties':
None, u'empty': False, u'constraints': None}, u'status': None, u'inputs': None,
u'description': u'vfc naming', u'rules': None, u'valueUniqueUid': None,
u'inputId': None, u'inputPath': None, u'path': None, u'password': False,
u'properties': None, u'definition': False, u'name': u'nfc_naming', u'required':
False, u'value':
u'{"ecomp_generated_naming":true,"naming_policy":"SDNC_Policy.ONAP_VPG_NAMING_TIMESTAMP"}',
u'immutable': False, u'getInputProperty': False, u'ownerId':
u'f3ee4b9b-9155-4c10-9aae-6d7bd6292369', u'constraints': None}]
Downloaded:service-Vfwng201904171329-csar.csar
| PASS |
------------------------------------------------------------------------------
Testsuites.Demo :: Executes the VNF Orchestration Test cases inclu... | PASS |
1 critical test, 1 passed, 0 failed
1 test total, 1 passed, 0 failed
==============================================================================
Testsuites | PASS |
1 critical test, 1 passed, 0 failed
1 test total, 1 passed, 0 failed
==============================================================================
Output: /share/logs/0016_demo_distributeVFWNG/output.xml
Log: /share/logs/0016_demo_distributeVFWNG/log.html
Report: /share/logs/0016_demo_distributeVFWNG/report.html
root@olc-rancher:~/oom/kubernetes/robot#
Abdelmuhaimen Seaudi
Orange Labs Egypt
Email: [email protected]<mailto:[email protected]>
Mobile: +2012 84644 733
From: SEAUDI Abdelmuhaimen O-EG/HRCS
Sent: Wednesday, April 17, 2019 3:36 PM
To: [email protected]; '[email protected]'
Subject: RE: [onap-discuss] vfw CDS Casablanca
Thanks, the robot is OK now.
Abdelmuhaimen Seaudi
Orange Labs Egypt
Email: [email protected]<mailto:[email protected]>
Mobile: +2012 84644 733
From: [email protected] [mailto:[email protected]] On
Behalf Of Marco Platania
Sent: Wednesday, April 17, 2019 2:34 PM
To: [email protected]; SEAUDI Abdelmuhaimen O-EG/HRCS
Subject: Re: [onap-discuss] vfw CDS Casablanca
Please look at this Jira ticket and update maria DB in SO accordingly:
https://jira.onap.org/browse/SO-1400
Thanks,
Marco
From: <[email protected]> on behalf of Abdelmuhaimen Seaudi
<[email protected]>
Reply-To: "[email protected]" <[email protected]>,
"[email protected]" <[email protected]>
Date: Wednesday, April 17, 2019 at 7:46 AM
To: "[email protected]" <[email protected]>
Subject: [onap-discuss] vfw CDS Casablanca
Hi,
I am using Casablanca, and when I tried running below robot script from
https://wiki.onap.org/display/DW/vFW+CDS+Casablanca<https://urldefense.proofpoint.com/v2/url?u=https-3A__wiki.onap.org_display_DW_vFW-2BCDS-2BCasablanca&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=KgFIQiUJzSC0gUhJaQxg8eC3w16GC3sKgWIcs4iIee0&m=62plib8QUu3c6vSPTrpWc6v3LHPeRH-rJa1enwUKF80&s=hXuippHaKGtUajjwe7Sjsx2wplM8coz_Mn4ZCIMkXPQ&e=>:
./demo-k8s.sh onap distributeVFWNG
The script fails, and I see in SDC there is deploy error "Exception caught
during installation of 94823f95-111b-45c6-beef. Transaction rollback."
2019-04-17T11:31:28.059Z|a2d0b2bf-2480-428a-9a83-4fa14c0c3dec|
org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1406, SQLState:
22001
2019-04-17T11:31:28.060Z|a2d0b2bf-2480-428a-9a83-4fa14c0c3dec|
org.hibernate.engine.jdbc.spi.SqlExceptionHelper - (conn:48351) Data too long
for column 'RESOURCE_INPUT' at row 1
Query is: insert into vnf_resource_customization (AVAILABILITY_ZONE_MAX_COUNT,
CREATION_TIMESTAMP, MAX_INSTANCES, MIN_INSTANCES, MODEL_INSTANCE_NAME,
MULTI_STAGE_DESIGN, NF_FUNCTION, NF_NAMING_CODE, NF_ROLE, NF_TYPE,
RESOURCE_INPUT, VNF_RESOURCE_MODEL_UUID, MODEL_CUSTOMIZATION_UUID) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters [<null>,'2019-04-17
11:31:28.044',<null>,<null>,'94823f95-111b-45c6-beef
0','false','ONAP-FIREWALL','vfw','vFW','FIREWALL','{\"vf_module_id\":\"vFirewallCL\",\"nf_function\":\"ONAP-FIREWALL\",\"vfw_private_ip_1\":\"192.168.20.100\",\"public_net_id\":\"PUT
THE PUBLIC NETWORK ID
HERE\",\"unprotected_private_subnet_id\":\"zdfw1fwl01_unprotected_sub\",\"vfw_private_ip_0\":\"192.168.10.100\",\"onap_private_subnet_id\":\"PUT
THE ONAP PRIVATE NETWORK NAME
HERE\",\"vfw_private_ip_2\":\"10.0.100.1\",\"sec_group\":\"PUT THE ONAP
SECURITY GROUP
HERE\",\"nf_type\":\"FIREWALL\",\"vfw_name_0\":\"zdfw1fwl01fwl01\",\"nexus_artifact_repo\":\"https://nexus.onap.org\",\"onap_private_net_cidr\":\"10<https://urldefense.proofpoint.com/v2/url?u=https-3A__nexus.onap.org_-2522-2C_-2522onap-5Fprivate-5Fnet-5Fcidr_-2522_-252210&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=KgFIQiUJzSC0gUhJaQxg8eC3w16GC3sKgWIcs4iIee0&m=62plib8QUu3c6vSPTrpWc6v3LHPeRH-rJa1enwUKF80&s=SqDdDn6lZxTq6V7nM-ijCk7_32VguNShECgfCfeIeYk&e=>...
2019-04-17T11:31:28.063Z|a2d0b2bf-2480-428a-9a83-4fa14c0c3dec|
o.o.so<https://urldefense.proofpoint.com/v2/url?u=http-3A__o.o.so_&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=KgFIQiUJzSC0gUhJaQxg8eC3w16GC3sKgWIcs4iIee0&m=62plib8QUu3c6vSPTrpWc6v3LHPeRH-rJa1enwUKF80&s=vsefEKDm9x3OQW91CLJZfFDRvmL1p3_gE4uKXd6s9D4&e=>.asdc.installer.heat.ToscaResourceInstaller
- Exception :
org.springframework.dao.DataIntegrityViolationException: could not execute
statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute statement
Any idea why we have this error ?
Abdelmuhaimen Seaudi
Orange Labs Egypt
Email: [email protected]<mailto:[email protected]>
Mobile: +2012 84644 733
_________________________________________________________________________________________________________________________
Ce message et ses pieces jointes peuvent contenir des informations
confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce
message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages
electroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou
falsifie. Merci.
This message and its attachments may contain confidential or privileged
information that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete
this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been
modified, changed or falsified.
Thank you.
_________________________________________________________________________________________________________________________
Ce message et ses pieces jointes peuvent contenir des informations
confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce
message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages
electroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou
falsifie. Merci.
This message and its attachments may contain confidential or privileged
information that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete
this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been
modified, changed or falsified.
Thank you.
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#16617): https://lists.onap.org/g/onap-discuss/message/16617
Mute This Topic: https://lists.onap.org/mt/31210907/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
