Uploaded image for project: 'Service Orchestrator'
  1. Service Orchestrator
  2. SO-1400

SO DB failure during service distribution

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • Casablanca Maintenance Release
    • Integration-SB-00 in Windriver lab

      Latest SO docker (v1.3.6) for Casablanca Maintenance Release is failing distribution in Integration-SB-00 in Windriver. It seems a DB/Schema error when storing the SDC models.

       

      2019-01-16T15:14:38.716Z|9c22484c-00cb-4400-975f-95368fa619ad| o.o.so.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

      Caused by: java.sql.SQLDataException: (conn:85) 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-01-16 15:14:38.536',<null>,<null>,'vLoadBalancerMS 0','false','LOADBALANCER','vlb','vLB','VLB','{\"vf_module_id\"\"vLoadBalancer\",\"nf_function\":\"LOADBALANCER\",\"vlb_private_net_cidr\":\"192.168.10.0/24\",\"vlb_private_net_id\":\"zdfw1lb01_private\",\"public_net_id\":\"PUT THE NETWORK ID HERE\",\"onap_private_subnet_id\":\"PUT THE ONAP PRIVATE NETWORK NAME HERE\",\"sec_group\":\"PUT THE ONAP SECURITY GROUP HERE\",\"gre_ipaddr\":\"192.168.10.112\",\"nf_type\":\"VLB\",\"nexus_artifact_repo\":\"https://nexus.onap.org\",\"onap_private_net_cidr\":\"PUT THE ONAP NETWORK CIDR HERE\",\"vdns_name_0\":\"zdfw1lb01dns02\",\"pg_int\":\"192.168.9.109\",\"vdns_private_ip_0\":...

       

      Please see attached logs from so-sdc-controller pod for more details.

            xuyang11 xuyang11
            platania platania
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: