Hi Ofir, SO in my context is Service. Yes, the VID is not coming into picture yet. However the service distribution doesn't show any error. The UI shows that the MSO has downloaded the artifacts. The end user doesn't know it's an error situation or normal. Hence I moved ahead and tried to Deploy the Service using VID.
best regards, Ramu From: Sonsino, Ofir [mailto:[email protected]] Sent: Wednesday, February 07, 2018 3:30 AM To: Akula, Ramanjaneyul Reddy (Nokia - US/Irving) <[email protected]>; [email protected] Subject: RE: [onap-discuss] [vid][so] SO failed to deploy new version of VSP 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: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Akula, Ramanjaneyul Reddy (Nokia - US/Irving) Sent: Tuesday, February 06, 2018 4:59 PM To: [email protected]<mailto:[email protected]> 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 ================ 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
_______________________________________________ onap-discuss mailing list [email protected] https://lists.onap.org/mailman/listinfo/onap-discuss
