Hi Ramu, It seems to me the origin of the issue is in either SDC or (M)SO. The flow you described doesn't get to the stage where VID is involved. BTW, what do you mean by "create a SO" ? What's SO in that context?
Thanks, Ofir From: onap-discuss-boun...@lists.onap.org [mailto:onap-discuss-boun...@lists.onap.org] On Behalf Of Akula, Ramanjaneyul Reddy (Nokia - US/Irving) Sent: Tuesday, February 06, 2018 4:59 PM To: onap-discuss@lists.onap.org Subject: [onap-discuss] [vid][so] SO failed to deploy new version of VSP 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 ================ 2. Update SO with new version of VF instance. 3. Distribute the SO. SO is distributed and deployed successfully in AAI, but then mso it's downloaded but the deployment failed. [cid:image001.png@01D3A006.63BC0230] 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
_______________________________________________ onap-discuss mailing list onap-discuss@lists.onap.org https://lists.onap.org/mailman/listinfo/onap-discuss