Uploaded image for project: 'Network Controller'
  1. Network Controller
  2. SDNC-684

Model distribution failed on insert to NETWORK_MODEL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • Dublin Release
    • Dublin Release
    • None
    • oom-staging-daily

    • SDNC Dublin Spr 2 2/18-3/8

      vCPEInfra Model distribution

      ERROR 2019-03-02 22:29:59.043 +0000 CachedDataSource - <sdnctldb01> failed to execute: INSERT into NETWORK_MODEL (service_uuid, customization_uuid, model_yaml, is_external_network, network_role, is_bound_to_vpn, trunk_network_indicator, network_type, invariant_uuid, uuid, version, network_technology) values ("cbb3d276-2472-483d-a078-c0b5e43b017a", "56919fb6-7e49-427f-9be9-db097358bfa3", "null", "N", "mux_gw", "N", "N", "NEUTRON", "fb5a7904-e90b-45fd-912b-3e61cdae5117", "d4cafd0c-0c2d-4788-a7e3-a51e1555abd9", "1.0", "NEUTRON"); with no arguments.
      java.sql.SQLSyntaxErrorException: (conn=3770) Unknown column 'trunk_network_indicator' in 'field list'
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:158)
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
      at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:192)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
      at com.sun.proxy.$Proxy4.executeUpdate(Unknown Source)
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.executeUpdatePreparedStatement(CachedDataSource.java:224)
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.writeData(CachedDataSource.java:136)
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeDataNoRecovery(DBResourceManager.java:568)
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeData(DBResourceManager.java:521)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncBaseModel.insertToscaData(SdncBaseModel.java:948)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncNodeModel.insertNetworkModelData(SdncNodeModel.java:123)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.processToscaCsar(SdncUebCallback.java:710)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleToscaArtifact(SdncUebCallback.java:627)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleSuccessfulDownload(SdncUebCallback.java:546)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleArtifact(SdncUebCallback.java:504)
      at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.activateCallback(SdncUebCallback.java:304)
      at org.onap.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:748)
      Caused by: java.sql.SQLException: Unknown column 'trunk_network_indicator' in 'field list'
      Query is: INSERT into NETWORK_MODEL (service_uuid, customization_uuid, model_yaml, is_external_network, network_role, is_bound_to_vpn, trunk_network_indicator, network_type, invariant_uuid, uuid, version, network_technology) values ("cbb3d276-2472-483d-a078-c0b5e43b017a", "56919fb6-7e49-427f-9be9-db097358bfa3", "null", "N", "mux_gw", "N", "N", "NEUTRON", "fb5a7904-e90b-45fd-912b-3e61cdae5117", "d4cafd0c-0c2d-4788-a7e3-a51e1555abd9", "1.0", "NEUTRON");
      at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
      at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
      at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
      ... 26 more

            djtimoney Dan Timoney
            bdfreeman1421 bdfreeman1421
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: