Hi VID & SO team, Use case: Adding new version of VSP to existing service and redistribute the new version.
Prep: Create a SO using an existing VSP/VF instance Approach: 1. Update VSP with additional attributes (in my case I added below attributes to the heat templates.) ================ vnf_id: dcaecldemo vf_module_id: ubuntu ================ 1. Update SO with new version of VF instance. 2. Distribute the SO. SO is distributed and deployed successfully in AAI, but then mso it's downloaded but the deployment failed. [cid:[email protected]] Below is the error message from ASCDCController logs. 2018-02-06T03:36:17.360Z|2422104b-745e-4347-a24b-a8fa9cb70dd7|pool-14-thread-9|NotificationHandler||||WARN|DataError|Exception - ASCDC Artifact already deployed|Exception raised: org.hibernate.exception.ConstraintViolationException: could not execute statement - at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72) - at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) - at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) - at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) - at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) - at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463) - at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349) - at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) - at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) - at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) - at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425) - at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) - at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177) - at org.openecomp.mso.db.catalog.CatalogDatabase.commit(CatalogDatabase.java:140) - at org.openecomp.mso.asdc.installer.heat.ToscaResourceInstaller.installTheResource(ToscaResourceInstaller.java:558) - at org.openecomp.mso.asdc.client.ASDCController.deployResourceStructure(ASDCController.java:451) - at org.openecomp.mso.asdc.client.ASDCController.processResourceNotification(ASDCController.java:611) - at org.openecomp.mso.asdc.client.ASDCController.treatNotification(ASDCController.java:568) - at org.openecomp.mso.asdc.client.ASDCController$ASDCNotificationCallBack.activateCallback(ASDCController.java:95) - at org.openecomp.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.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`vnf_resource_customization`, CONSTRAINT `FK_iff1ayhb1hrp5jhea3vvikuni` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`)) - Query is: insert into VNF_RESOURCE_CUSTOMIZATION (MODEL_INSTANCE_NAME, MIN_INSTANCES, MAX_INSTANCES, AVAILABILITY_ZONE_MAX_COUNT, NF_FUNCTION, NF_TYPE, NF_ROLE, NF_NAMING_CODE, VNF_RESOURCE_MODEL_UUID, MODEL_CUSTOMIZATION_UUID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters ['ubuntu 1',<null>,<null>,<null>,'','','','','4e72765e-9be0-43f5-b09c-f9fd9d2c9a4f','fdec7268-699b-40f7-970b-6e54dd2abb7f'] - at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:121) - at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:71) - at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:359) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:348) - at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) - at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) - ... 26 more - Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Cannot add or update a child row: a foreign key constraint fails (`mso_catalog`.`vnf_resource_customization`, CONSTRAINT `FK_iff1ayhb1hrp5jhea3vvikuni` FOREIGN KEY (`VNF_RESOURCE_MODEL_UUID`) REFERENCES `vnf_resource` (`MODEL_UUID`)) - Query is: insert into VNF_RESOURCE_CUSTOMIZATION (MODEL_INSTANCE_NAME, MIN_INSTANCES, MAX_INSTANCES, AVAILABILITY_ZONE_MAX_COUNT, NF_FUNCTION, NF_TYPE, NF_ROLE, NF_NAMING_CODE, VNF_RESOURCE_MODEL_UUID, MODEL_CUSTOMIZATION_UUID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters ['ubuntu 1',<null>,<null>,<null>,'','','','','4e72765e-9be0-43f5-b09c-f9fd9d2c9a4f','fdec7268-699b-40f7-970b-6e54dd2abb7f'] - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1112) - at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:601) - at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:398) - ... 30 more - Do we support the VF update? Attached are my heat/env files. best regards, Ramu +1-214-971-5636
ubuntu.hot.yaml
Description: ubuntu.hot.yaml
ubuntu.env
Description: ubuntu.env
_______________________________________________ onap-discuss mailing list [email protected] https://lists.onap.org/mailman/listinfo/onap-discuss
