11:49:34.532 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.core.dblib.CachedDataSource - <sdnctldb01> Failed to execute: INSERT into VFC_TO_NETWORK_ROLE_MAPPING (vfc_customization_uuid, network_role, vm_type, subinterface_indicator, ipv4_count, ipv6_count, ipv4_use_dhcp, ipv4_ip_version) values ("60d8aee1-ee2f-4241-976e-66eb72bf230f", "default-network-role", "vfw", "N", "0", "0", "N", "4"); with no arguments.
java.sql.SQLSyntaxErrorException: (conn=107845) Unknown column 'subinterface_indicator' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:158) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:192) ~[mariadb-java-client-2.1.1.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_212]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_212]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:?]
at com.sun.proxy.$Proxy8.executeUpdate(Unknown Source) ~[?:?]
at org.onap.ccsdk.sli.core.dblib.CachedDataSource.executeUpdatePreparedStatement(CachedDataSource.java:243) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.CachedDataSource.writeData(CachedDataSource.java:155) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeDataNoRecovery(DBResourceManager.java:629) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeData(DBResourceManager.java:582) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncBaseModel.insertToscaData(SdncBaseModel.java:1054) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFCModel.insertVFCtoNetworkRoleMappingData(SdncVFCModel.java:219) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertVFCData(SdncVFModel.java:357) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertData(SdncVFModel.java:99) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.processToscaCsar(SdncUebCallback.java:754) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleToscaArtifact(SdncUebCallback.java:631) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleSuccessfulDownload(SdncUebCallback.java:550) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleArtifact(SdncUebCallback.java:508) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.activateCallback(SdncUebCallback.java:308) [ueb-listener-0.5.1.jar:?]
at org.onap.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71) [sdc-distribution-client-1.3.0.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_212]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_212]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_212]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_212]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
Caused by: java.sql.SQLException: Unknown column 'subinterface_indicator' in 'field list'
Query is: INSERT into VFC_TO_NETWORK_ROLE_MAPPING (vfc_customization_uuid, network_role, vm_type, subinterface_indicator, ipv4_count, ipv6_count, ipv4_use_dhcp, ipv4_ip_version) values ("60d8aee1-ee2f-4241-976e-66eb72bf230f", "default-network-role", "vfw", "N", "0", "0", "N", "4");
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218) ~[mariadb-java-client-2.1.1.jar:?]
... 29 more
11:49:34.538 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.core.dblib.DBResourceManager - Generated alarm: sdnctldb01 - (conn=107845) Unknown column 'subinterface_indicator' in 'field list'
11:49:34.538 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.northbound.uebclient.SdncBaseModel - Could not insert Tosca data into the database
11:49:34.538 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.northbound.uebclient.SdncVFCModel - Could not insert Tosca CSAR data into the VFC_TO_NETWORK_ROLE_MAPPING table
11:49:34.538 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel - Could not insert Tosca CSAR VFC data
11:49:34.538 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - iterateProcessPath - Path not Found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property nf_type is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property nf_role is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property nf_naming_code is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property nf_function is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property sdnc_model_name is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property sdnc_model_version is not found
11:49:34.539 [pool-2-thread-5] ERROR org.onap.sdc.tosca.parser.utils.PropertyUtils - processProperties - property sdnc_artifact_name is not found
11:49:34.649 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.core.dblib.CachedDataSource - <sdnctldb01> Failed to execute: INSERT into VFC_TO_NETWORK_ROLE_MAPPING (vfc_customization_uuid, network_role, vm_type, subinterface_indicator, ipv4_count, ipv6_count, ipv4_use_dhcp, network_role_tag, ipv4_ip_version) values ("ec8f96c8-ff33-409d-a6b3-ce40939f9635", "default-network-role", "vpg", "N", "0", "0", "N", "unprotected_private", "4"); with no arguments.
java.sql.SQLSyntaxErrorException: (conn=107845) Unknown column 'subinterface_indicator' in 'field list'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:158) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:192) ~[mariadb-java-client-2.1.1.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_212]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_212]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:?]
at com.sun.proxy.$Proxy8.executeUpdate(Unknown Source) ~[?:?]
at org.onap.ccsdk.sli.core.dblib.CachedDataSource.executeUpdatePreparedStatement(CachedDataSource.java:243) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.CachedDataSource.writeData(CachedDataSource.java:155) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeDataNoRecovery(DBResourceManager.java:629) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.core.dblib.DBResourceManager.writeData(DBResourceManager.java:582) [dblib-provider-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncBaseModel.insertToscaData(SdncBaseModel.java:1054) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFCModel.insertVFCtoNetworkRoleMappingData(SdncVFCModel.java:219) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertVFCData(SdncVFModel.java:357) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncVFModel.insertData(SdncVFModel.java:99) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.processToscaCsar(SdncUebCallback.java:754) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleToscaArtifact(SdncUebCallback.java:631) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleSuccessfulDownload(SdncUebCallback.java:550) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.handleArtifact(SdncUebCallback.java:508) [ueb-listener-0.5.1.jar:?]
at org.onap.ccsdk.sli.northbound.uebclient.SdncUebCallback.activateCallback(SdncUebCallback.java:308) [ueb-listener-0.5.1.jar:?]
at org.onap.sdc.impl.NotificationConsumer.run(NotificationConsumer.java:71) [sdc-distribution-client-1.3.0.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_212]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_212]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_212]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_212]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_212]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
Caused by: java.sql.SQLException: Unknown column 'subinterface_indicator' in 'field list'
Query is: INSERT into VFC_TO_NETWORK_ROLE_MAPPING (vfc_customization_uuid, network_role, vm_type, subinterface_indicator, ipv4_count, ipv6_count, ipv4_use_dhcp, network_role_tag, ipv4_ip_version) values ("ec8f96c8-ff33-409d-a6b3-ce40939f9635", "default-network-role", "vpg", "N", "0", "0", "N", "unprotected_private", "4");
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217) ~[mariadb-java-client-2.1.1.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218) ~[mariadb-java-client-2.1.1.jar:?]
... 29 more
11:49:34.650 [pool-2-thread-5] ERROR org.onap.ccsdk.sli.core.dblib.DBResourceManager - Generated alarm: sdnctldb01 - (conn=107845) Unknown column 'subinterface_indicator' in 'field list'