We were unable to use the same Service Instance name when creating a service using ONAP.
On investigating, we found that the Deletion of the service-name from the SDNC table - sdnctl.GENERIC_RESOURCE_NAME - failed because context-id and prefix was *null*. We looked at the following DG: * https://gerrit.onap.org/r/gitweb?p=sdnc/oam.git;a=blob;f=platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json;hb=7566807e10aaf852ea75293a3782407fe9ddb7bb and searched for " DELETE from GENERIC_RESOURCE_NAME WHERE type "... However, in the create service flow DG, we do allow to create a row in the above table ( sdnctl.GENERIC_RESOURCE_NAME ) even without context-Id, name_index and prefix. * looking at the node ' *set sql statement* ' in this DG ( https://gerrit.onap.org/r/gitweb?p=sdnc/oam.git;a=blob;f=platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_generate-unique-name.json;hb=7566807e10aaf852ea75293a3782407fe9ddb7bb ) : we see the following SQL statement: * 'insert into GENERIC_RESOURCE_NAME values ( '$generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name , null , null, null )' So now we have a 'Service instance Name' entry in GENERIC_RESOURCE_NAME table of SDNC that cannot be deleted. Because of this, we cannot reuse the same Service Instance name. Is this a known issue? Is there a way to avoid creating an entry in this table as a workaround until the issue is fixed? Any pointers would be helpful. Thanks, Rahul -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#17652): https://lists.onap.org/g/onap-discuss/message/17652 Mute This Topic: https://lists.onap.org/mt/32131591/21656 Mute #sdnc: https://lists.onap.org/mk?hashtag=sdnc&subid=2740164 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
