Fix reuse InstanceName when re-creating a service

[sdnc/oam.git] / platform-logic / generic-resource-api / src / main / json / GENERIC-RESOURCE-API_rollback-generated-names.json

diff --git a/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json b/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json
index dacb337..756b5a0 100644 (file)
--- a/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json
+++ b/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json
@@ -1 +1,1646 @@
-[{"id":"367177f7.563698","type":"dgstart","name":"DGSTART","outputs":1,"x":163.75,"y":68.75,"z":"d0c367b0.d55ca8","wires":[["60ca91f4.f6268"]]},{"id":"468f67a9.c0fe68","type":"method","name":"method rollback-generated-names","xml":"<method rpc='rollback-generated-names' mode='sync'>\n","comments":"","outputs":1,"x":288.82142639160156,"y":140.1785717010498,"z":"d0c367b0.d55ca8","wires":[["d2988a7c.2fd408"]]},{"id":"d2988a7c.2fd408","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","comments":"","outputs":1,"x":288.0357208251953,"y":221.60715103149414,"z":"d0c367b0.d55ca8","wires":[["d1a57281.50136","ceb3fba9.761848","dbce21dd.bda28","7ce1313f.711c4","796e66f5.e5b048"]]},{"id":"d1a57281.50136","type":"switchNode","name":"switch rollback-generated-names-input.context-id","xml":"<switch test='`$rollback-generated-names-input.context-id`'>\n","comments":"","outputs":1,"x":609.5833129882812,"y":220.6666603088379,"z":"d0c367b0.d55ca8","wires":[["dbafe83a.757ed8"]]},{"id":"ceb3fba9.761848","type":"switchNode","name":"switch rollback-generated-names-input.naming-type","xml":"<switch test='`$rollback-generated-names-input.naming-type`'>\n","comments":"","outputs":1,"x":616.7500152587891,"y":280.50000381469727,"z":"d0c367b0.d55ca8","wires":[["23bb964b.7a2caa","b0705a0b.157f48","34b9c028.357d9","70f01569.bbfe5c","1710e5d3.77dcfa","170cdd4d.2b21a3","de873242.c7b5f","fc133415.70f288"]]},{"id":"dbafe83a.757ed8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":888.0000152587891,"y":221.25000381469727,"z":"d0c367b0.d55ca8","wires":[["5d590d62.dfd0a4"]]},{"id":"5d590d62.dfd0a4","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.context-id can not be null\" />\n","comments":"","x":1054.6543159484863,"y":220.64523601531982,"z":"d0c367b0.d55ca8","wires":[]},{"id":"23bb964b.7a2caa","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":931.5,"y":280.25,"z":"d0c367b0.d55ca8","wires":[["a0afb9b9.38f3f8"]]},{"id":"a0afb9b9.38f3f8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.naming-type can not be null\" />\n","comments":"","x":1097.7500190734863,"y":280.25000381469727,"z":"d0c367b0.d55ca8","wires":[]},{"id":"b0705a0b.157f48","type":"outcome","name":"VM_INSTANCE","xml":"<outcome value='VM_INSTANCE'>","comments":"","outputs":1,"x":959.5000381469727,"y":327.8571434020996,"z":"d0c367b0.d55ca8","wires":[["bdd8786c.e5b358"]]},{"id":"34b9c028.357d9","type":"outcome","name":"VNFC_INSTANCE","xml":"<outcome value='VNFC_INSTANCE'>","comments":"","outputs":1,"x":969.7500305175781,"y":375.35714530944824,"z":"d0c367b0.d55ca8","wires":[["5edf9755.0901f8"]]},{"id":"bdd8786c.e5b358","type":"set","name":"set tmp.rb.naming-index-table-name and prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VM_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vm_name_prefix' />\n","comments":"","x":1381.000015258789,"y":328.0000057220459,"z":"d0c367b0.d55ca8","wires":[]},{"id":"5edf9755.0901f8","type":"set","name":"set tmp.rb.naming-index-table-name and prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VNFC_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnfc_name_prefix' />\n\n","comments":"","x":1383.250015258789,"y":375.25000762939453,"z":"d0c367b0.d55ca8","wires":[]},{"id":"70f01569.bbfe5c","type":"outcome","name":"Other","xml":"<outcome value='Other'>","comments":"","outputs":1,"x":937,"y":619.5,"z":"d0c367b0.d55ca8","wires":[["3136ec47.d68c14"]]},{"id":"3136ec47.d68c14","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`'Unknown rollbck-generated-name-input.naming-type: ' + $rollback-generated-names-input.naming-type`\" />\n","comments":"","x":1103.2500190734863,"y":619.5000038146973,"z":"d0c367b0.d55ca8","wires":[]},{"id":"77bdf758.54df88","type":"set","name":"set tmp.rb.sql","xml":"<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'SELECT * from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />","comments":"","x":1130.416660308838,"y":1156.5833010673523,"z":"d0c367b0.d55ca8","wires":[]},{"id":"c12778f6.0a1338","type":"get-resource","name":"GET INDEX TABLE.index_number","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\" pfx='db.grn.index-table'>\n\n","comments":"","outputs":1,"x":1199.0951309204102,"y":1204.4523363113403,"z":"d0c367b0.d55ca8","wires":[["4ba02bfe.2fafb4","6a6129db.ee97d8"]]},{"id":"23b3074b.857058","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":939.4166564941406,"y":1157.0833015441895,"z":"d0c367b0.d55ca8","wires":[["77bdf758.54df88","c12778f6.0a1338"]]},{"id":"8e098c23.2f40a","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error reading the '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' table with ' + $rollback-generated-names.name-prefix-column\n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ '. MANUAL clean up is required!'`\" />\n\n","comments":"","x":1615.6666641235352,"y":1205.3334102630615,"z":"d0c367b0.d55ca8","wires":[]},{"id":"d5340d0c.48452","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'No entries found in ' \n\t+ $rollback-generated-names.index-table-name \n\t+ ' with ' \n\t+ $rollback-generated-names.name-prefix-column \n\t+ ' = ' \n\t+ $tmp.rb.grn.prefix `\" />\n\n","comments":"","x":1615.3451309204102,"y":1251.1190853118896,"z":"d0c367b0.d55ca8","wires":[]},{"id":"4ba02bfe.2fafb4","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1442.6666641235352,"y":1204.8334102630615,"z":"d0c367b0.d55ca8","wires":[["8e098c23.2f40a"]]},{"id":"6a6129db.ee97d8","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1449.5120658874512,"y":1251.3215522766113,"z":"d0c367b0.d55ca8","wires":[["d5340d0c.48452"]]},{"id":"7ce1313f.711c4","type":"get-resource","name":"GET GENERIC_RESOURCE_NAME distinct prefix","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT distinct prefix from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id'\n  pfx='db.grn.distinct-prefix[]'>","comments":"","outputs":1,"x":607.4166259765625,"y":741.333324432373,"z":"d0c367b0.d55ca8","wires":[["4ad7538e.f3d82c","65bbc13b.28e13"]]},{"id":"4ad7538e.f3d82c","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":887.1666259765625,"y":741.3333168029785,"z":"d0c367b0.d55ca8","wires":[["173e772a.cd4d19"]]},{"id":"173e772a.cd4d19","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table to retrieve distinct prefix\"/>","comments":"","x":1056.6666259765625,"y":741.3333168029785,"z":"d0c367b0.d55ca8","wires":[]},{"id":"65bbc13b.28e13","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":895.1666030883789,"y":787.8333101272583,"z":"d0c367b0.d55ca8","wires":[["7e2b366.e1ab2c8"]]},{"id":"611ed5aa.78878c","type":"comment","name":"pfx = db.grn.distinct-prefix[]","info":"","comments":"","x":599.6666717529297,"y":778.833324432373,"z":"d0c367b0.d55ca8","wires":[]},{"id":"796e66f5.e5b048","type":"for","name":"for each distinct prefix","xml":"<for index='prefix-index' start='0' end='`$db.grn.distinct-prefix_length`' >\n","comments":"","outputs":1,"x":511.9166564941406,"y":903.8333072662354,"z":"d0c367b0.d55ca8","wires":[["863a787.4a89d88"]]},{"id":"10bc4004.cfe86","type":"get-resource","name":"GET GENERIC_RESOURCE_NAME  (name_index)","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type   \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.subset[]'>","comments":"","outputs":1,"x":1056.9166526794434,"y":1043.5832977294922,"z":"d0c367b0.d55ca8","wires":[["5207f077.d162b","57b22cdd.a0b3b4"]]},{"id":"5207f077.d162b","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1374.6666526794434,"y":1043.5832901000977,"z":"d0c367b0.d55ca8","wires":[["37f91f4f.dc317"]]},{"id":"37f91f4f.dc317","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>","comments":"","x":1544.1666526794434,"y":1043.5832901000977,"z":"d0c367b0.d55ca8","wires":[]},{"id":"57b22cdd.a0b3b4","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1382.6666297912598,"y":1090.0832834243774,"z":"d0c367b0.d55ca8","wires":[["e0189d81.4cff1"]]},{"id":"e0189d81.4cff1","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"`'No entry found in GENERIC_RESOURCE_NAME where context_id = ' + $rollback-generated-names-input.context-id + ' and type = ' + $rollback-generated-names-input.naming-type + ' and prefix = ' + $db.grn.distinct-prefix[$prefix-index].prefix`\"/>","comments":"","x":1545.9166679382324,"y":1089.8332996368408,"z":"d0c367b0.d55ca8","wires":[]},{"id":"2b90b34b.d7633c","type":"comment","name":"pfx = db.grn.subset[]","info":"","comments":"","x":1127.9166679382324,"y":1081.0833072662354,"z":"d0c367b0.d55ca8","wires":[]},{"id":"863a787.4a89d88","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":722.1666488647461,"y":903.5832977294922,"z":"d0c367b0.d55ca8","wires":[["10bc4004.cfe86","f27ef71e.c804b8","23b3074b.857058","a6b9f4f4.6ad9c8","9b466971.d86f98","92644ca8.ceecd","d045a533.059c38","5592a6f6.a24438","14f7ce44.68bc82","18dcbbfc.8a54f4","37760911.be5b06"]]},{"id":"f27ef71e.c804b8","type":"set","name":"set tmp.rb.grn.prefix","xml":"<set>\n<parameter name='tmp.rb.grn.prefix' value='`$db.grn.distinct-prefix[$prefix-index].prefix`' />\n","comments":"","x":959.4166374206543,"y":994.3333034515381,"z":"d0c367b0.d55ca8","wires":[]},{"id":"e83d55fd.8d2e08","type":"switchNode","name":"switch: tmp.rb.net-index == 0","xml":"<switch test=\"`$tmp.rb.net-index == 0`\">","comments":"","outputs":1,"x":1418.3334503173828,"y":1454.4166259765625,"z":"d0c367b0.d55ca8","wires":[["e05f58d7.4e07f8","f48212b5.20b62"]]},{"id":"676ed71d.e6ce68","type":"comment","name":"pfx = db.grn.index-table","info":"","comments":"","x":1235.1666412353516,"y":1241.0832901000977,"z":"d0c367b0.d55ca8","wires":[]},{"id":"9b466971.d86f98","type":"set","name":"set tmp.rb.grn.max-index","xml":"<set>\n<parameter name='tmp.rb.grn.max-index' \n\tvalue='`$db.grn.subset[$db.grn.subset_length - 1].name-index`' />\n","comments":"","x":967.9166564941406,"y":1311.0833044052124,"z":"d0c367b0.d55ca8","wires":[]},{"id":"a6b9f4f4.6ad9c8","type":"set","name":"clear tmp.rb.","xml":"<set>\n<parameter name='tmp.rb.' value='' />\n","comments":"","x":934.4166221618652,"y":947.583288192749,"z":"d0c367b0.d55ca8","wires":[]},{"id":"dbce21dd.bda28","type":"set","name":"clear db.grn.","xml":"<set>\n<parameter name='db.grn.' value='' />\n","comments":"","x":490.55554962158203,"y":687.7777805328369,"z":"d0c367b0.d55ca8","wires":[]},{"id":"92644ca8.ceecd","type":"set","name":"clear db.grn.subset.","xml":"<set>\n<parameter name='db.grn.subset.' value='' />\n","comments":"","x":955.4166564941406,"y":903.8332967758179,"z":"d0c367b0.d55ca8","wires":[]},{"id":"dd5310c5.e7bc1","type":"set","name":"set tmp.rb.sql for delete","xml":"<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t","comments":"","x":2031.0832824707031,"y":1454.4166088104248,"z":"d0c367b0.d55ca8","wires":[]},{"id":"985fa2e8.98689","type":"get-resource","name":"DELETE from INDEX TABLE","xml":"<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n","comments":"","outputs":1,"x":2047.2618103027344,"y":1500.0356426239014,"z":"d0c367b0.d55ca8","wires":[["3c1ebfe4.59e22","4c9bbe94.157e"]]},{"id":"27f4d519.bb790a","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number\n\t+ '. MANUAL clean up is required!'`\" />\n\n","comments":"","x":2455.8333435058594,"y":1499.9167165756226,"z":"d0c367b0.d55ca8","wires":[]},{"id":"3c1ebfe4.59e22","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2282.8333435058594,"y":1500.4167165756226,"z":"d0c367b0.d55ca8","wires":[["27f4d519.bb790a"]]},{"id":"4c9bbe94.157e","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":2289.6787452697754,"y":1546.9048585891724,"z":"d0c367b0.d55ca8","wires":[["9e5f981.150f268"]]},{"id":"85575d12.d5857","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1798.5833358764648,"y":1454.1666259765625,"z":"d0c367b0.d55ca8","wires":[["dd5310c5.e7bc1","985fa2e8.98689"]]},{"id":"d045a533.059c38","type":"set","name":"set tmp.rb.delta-index = index-number - max-index","xml":"<set>\n<parameter name='tmp.rb.delta-index' \n\tvalue='`$db.grn.index-table.index-number - $tmp.rb.grn.max-index`' />\n","comments":"","x":1045.9166564941406,"y":1356.333303451538,"z":"d0c367b0.d55ca8","wires":[]},{"id":"e05f58d7.4e07f8","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":1632.0833129882812,"y":1454.4166069030762,"z":"d0c367b0.d55ca8","wires":[["85575d12.d5857"]]},{"id":"18dcbbfc.8a54f4","type":"get-resource","name":"DELETE from GENERIC_RESOURCE_NAME","xml":"<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='DELETE from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix'>\n","comments":"","outputs":1,"x":1028.7618713378906,"y":1792.2856998443604,"z":"d0c367b0.d55ca8","wires":[["62bd7357.1b6afc","e9732f88.feaff"]]},{"id":"b81d8b08.9ca378","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting GENERIC_RESOURCE_NAME WHERE type = '\n\t+ $rollback-generated-names-input.naming-type  \n\t+ ' AND context_id = ' + $rollback-generated-names-input.context-id \n\t+ ' AND prefix = '+ $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n","comments":"","x":1480.3334045410156,"y":1793.1667737960815,"z":"d0c367b0.d55ca8","wires":[]},{"id":"62bd7357.1b6afc","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1307.3334045410156,"y":1792.6667737960815,"z":"d0c367b0.d55ca8","wires":[["b81d8b08.9ca378"]]},{"id":"e9732f88.feaff","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1314.1787490844727,"y":1839.1549606323242,"z":"d0c367b0.d55ca8","wires":[["ae5976af.669a08"]]},{"id":"24f6c0c3.95f7f","type":"comment","name":"Delete prefix from INDEX TABLE","info":"","comments":"","x":2301.3334197998047,"y":1456.4166803359985,"z":"d0c367b0.d55ca8","wires":[]},{"id":"ee44b770.263dc8","type":"comment","name":"Silence SUCCESS","info":"","comments":"","x":2546.333351135254,"y":1558.4166240692139,"z":"d0c367b0.d55ca8","wires":[]},{"id":"9e5f981.150f268","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":2438.5833473205566,"y":1546.6666259765625,"z":"d0c367b0.d55ca8","wires":[[]]},{"id":"f48212b5.20b62","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1631.083396911621,"y":1639.666648864746,"z":"d0c367b0.d55ca8","wires":[["2679c184.7566ce"]]},{"id":"ce016bf1.726fe8","type":"comment","name":"index_number > $db.grn.subset_length; i.e hole in the middle. DO NOTHING","info":"","comments":"","x":1221.8334197998047,"y":1578.4166812896729,"z":"d0c367b0.d55ca8","wires":[]},{"id":"d0ffe154.2017d","type":"comment","name":"Silence SUCCESS","info":"","comments":"","x":1570.333251953125,"y":1850.6666584014893,"z":"d0c367b0.d55ca8","wires":[]},{"id":"ae5976af.669a08","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1462.5832481384277,"y":1838.916660308838,"z":"d0c367b0.d55ca8","wires":[[]]},{"id":"5592a6f6.a24438","type":"switchNode","name":"switch: tmp.rb.delta-index == 0","xml":"<switch test=\"`$tmp.rb.delta-index == 0`\">","comments":"","outputs":1,"x":984.3333282470703,"y":1454.6666240692139,"z":"d0c367b0.d55ca8","wires":[["54669b2b.1c7664","5cd2e8b2.3aabf8"]]},{"id":"54669b2b.1c7664","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":1211.5833129882812,"y":1454.6666069030762,"z":"d0c367b0.d55ca8","wires":[["e83d55fd.8d2e08"]]},{"id":"13ee581e.78bb98","type":"set","name":"set tmp.rb.sql for update","xml":"<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.net-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />","comments":"","x":2037.833351135254,"y":1639.666633605957,"z":"d0c367b0.d55ca8","wires":[]},{"id":"d1d5de27.6d65f","type":"get-resource","name":"Update INDEX TABLE","xml":"<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n","comments":"","outputs":1,"x":2034.0118789672852,"y":1685.2856674194336,"z":"d0c367b0.d55ca8","wires":[["af5b63b8.507a5","961b37ec.64dc98"]]},{"id":"21898cbf.33f884","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.net-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n","comments":"","x":2439.58341217041,"y":1685.1667413711548,"z":"d0c367b0.d55ca8","wires":[]},{"id":"af5b63b8.507a5","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2247.58341217041,"y":1685.6667413711548,"z":"d0c367b0.d55ca8","wires":[["21898cbf.33f884"]]},{"id":"961b37ec.64dc98","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":2254.428813934326,"y":1732.1548833847046,"z":"d0c367b0.d55ca8","wires":[["21898cbf.33f884"]]},{"id":"2679c184.7566ce","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1798.3334045410156,"y":1639.4166507720947,"z":"d0c367b0.d55ca8","wires":[["13ee581e.78bb98","d1d5de27.6d65f"]]},{"id":"14c2ad0d.ae7c33","type":"comment","name":"Update prefix from INDEX TABLE","info":"","comments":"","x":1989.8334121704102,"y":1717.9166464805603,"z":"d0c367b0.d55ca8","wires":[]},{"id":"14f7ce44.68bc82","type":"set","name":"set tmp.rb.net-index = index-number - $db.grn.subset_length","xml":"<set>\n<parameter name='tmp.rb.net-index' \n\tvalue='`$db.grn.index-table.index-number - $db.grn.subset_length`' />\n","comments":"","x":1076.6666412353516,"y":1403.833288192749,"z":"d0c367b0.d55ca8","wires":[]},{"id":"2a3dc862.500858","type":"comment","name":"index_number == max index","info":"","comments":"","x":862.1666564941406,"y":1497.5833053588867,"z":"d0c367b0.d55ca8","wires":[]},{"id":"54f2328a.63d03c","type":"comment","name":"index_number == $db.grn.subset_length","info":"","comments":"","x":1489.6666564941406,"y":1415.0833053588867,"z":"d0c367b0.d55ca8","wires":[]},{"id":"5cd2e8b2.3aabf8","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1219.6666564941406,"y":1623.8333044052124,"z":"d0c367b0.d55ca8","wires":[["f7ec1a24.211fe8"]]},{"id":"f7ec1a24.211fe8","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1363.4166641235352,"y":1624.0833072662354,"z":"d0c367b0.d55ca8","wires":[[]]},{"id":"3dffc8c6.351eb8","type":"comment","name":"Change History","info":"iTrack SDNGC-10767\n- new DG to rollback generated-names","comments":"","x":642.5000076293945,"y":113.75000190734863,"z":"d0c367b0.d55ca8","wires":[]},{"id":"6b1751d3.9aae8","type":"set","name":"set tmp.rb.naming-index-table-name, index-table.prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' value='EIPAM_CLIENT_KEY_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnf_name_prefix' />\n","comments":"","x":1408.75,"y":425.75,"z":"d0c367b0.d55ca8","wires":[]},{"id":"1710e5d3.77dcfa","type":"outcome","name":"CLIENT_KEY","xml":"<outcome value='CLIENT_KEY'>","comments":"","outputs":1,"x":956.5000152587891,"y":425.35713958740234,"z":"d0c367b0.d55ca8","wires":[["6b1751d3.9aae8"]]},{"id":"170cdd4d.2b21a3","type":"outcome","name":"NETWORK_INSTANCE","xml":"<outcome value='NETWORK_INSTANCE'>","comments":"","outputs":1,"x":988.2777633666992,"y":475.61110496520996,"z":"d0c367b0.d55ca8","wires":[["5fa679c.78e5088"]]},{"id":"de873242.c7b5f","type":"outcome","name":"SERVICE_INSTANCE","xml":"<outcome value='SERVICE_INSTANCE'>","comments":"","outputs":1,"x":986.3889007568359,"y":524.6111211776733,"z":"d0c367b0.d55ca8","wires":[["82455610.85dad8"]]},{"id":"fc133415.70f288","type":"outcome","name":"VNF_INSTANCE","xml":"<outcome value='VNF_INSTANCE'>","comments":"","outputs":1,"x":970.2777633666992,"y":570.611120223999,"z":"d0c367b0.d55ca8","wires":[["8ec44038.4f2ac"]]},{"id":"5a4d6d80.b5bda4","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1310.7856979370117,"y":1936.4285354614258,"z":"d0c367b0.d55ca8","wires":[["d0e2990c.3467d8"]]},{"id":"d0e2990c.3467d8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>","comments":"","x":1480.2856979370117,"y":1936.4285354614258,"z":"d0c367b0.d55ca8","wires":[]},{"id":"3d2d0a92.8fb326","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1318.7856750488281,"y":1982.9285287857056,"z":"d0c367b0.d55ca8","wires":[["a9dae2af.d2f53"]]},{"id":"31297cf.fcd1684","type":"comment","name":"pfx = db.grn.prefix[]","info":"","comments":"","x":1044.0357131958008,"y":1973.9285526275635,"z":"d0c367b0.d55ca8","wires":[]},{"id":"37760911.be5b06","type":"get-resource","name":"GET GENERIC_RESOURCE_NAME  (prefix)","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type    \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.prefix[]'>","comments":"","outputs":1,"x":1023.0356903076172,"y":1936.1785564422607,"z":"d0c367b0.d55ca8","wires":[["5a4d6d80.b5bda4","3d2d0a92.8fb326","430381ee.4fc6b"]]},{"id":"430381ee.4fc6b","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1312.321434020996,"y":2125.892852783203,"z":"d0c367b0.d55ca8","wires":[["3f64846a.c8c06c"]]},{"id":"3f64846a.c8c06c","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1461.9643783569336,"y":2126.0356769561768,"z":"d0c367b0.d55ca8","wires":[["5b56358f.06720c","c6c2e25e.9582a"]]},{"id":"eb05862b.646188","type":"comment","name":"Clean up holes in INDEX TABLE","info":"","comments":"","x":781.0000152587891,"y":1880.0000286102295,"z":"d0c367b0.d55ca8","wires":[]},{"id":"761a02e4.28318c","type":"set","name":"set tmp.rb.sql for delete","xml":"<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t","comments":"","x":1719.7857360839844,"y":1982.9286041259766,"z":"d0c367b0.d55ca8","wires":[]},{"id":"e3b8fba6.d6a5d8","type":"get-resource","name":"DELETE from INDEX TABLE","xml":"<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n","comments":"","outputs":1,"x":1735.9642639160156,"y":2028.5476379394531,"z":"d0c367b0.d55ca8","wires":[["8a19c44d.2f7a68","83735701.520468"]]},{"id":"87b45267.a3082","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number`\" />\n\n","comments":"","x":2126.5357971191406,"y":2028.4287118911743,"z":"d0c367b0.d55ca8","wires":[]},{"id":"8a19c44d.2f7a68","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1953.5357971191406,"y":2028.9287118911743,"z":"d0c367b0.d55ca8","wires":[["87b45267.a3082"]]},{"id":"83735701.520468","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1960.3811988830566,"y":2075.416853904724,"z":"d0c367b0.d55ca8","wires":[["8dd77dea.9bf17"]]},{"id":"f0c8fc09.c807b","type":"comment","name":"Delete prefix from INDEX TABLE","info":"","comments":"","x":1990.035873413086,"y":1984.9286756515503,"z":"d0c367b0.d55ca8","wires":[]},{"id":"8771620a.4a45","type":"comment","name":"Silence SUCCESS","info":"","comments":"","x":2217.035804748535,"y":2086.9286193847656,"z":"d0c367b0.d55ca8","wires":[]},{"id":"8dd77dea.9bf17","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":2109.285800933838,"y":2075.1786212921143,"z":"d0c367b0.d55ca8","wires":[[]]},{"id":"a9dae2af.d2f53","type":"block","name":"block","xml":"<block>","atomic":"false","comments":"","outputs":1,"x":1466.5000228881836,"y":1983.2500286102295,"z":"d0c367b0.d55ca8","wires":[["761a02e4.28318c","e3b8fba6.d6a5d8"]]},{"id":"5b56358f.06720c","type":"set","name":"set tmp.rb.grn.last-max-index","xml":"<set>\n<parameter name='tmp.rb.grn.last-max-index' \n\tvalue='`$db.grn.prefix[$db.grn.prefix_length - 1].name-index`' />\n","comments":"","x":1685.0000228881836,"y":2126.2500324249268,"z":"d0c367b0.d55ca8","wires":[]},{"id":"c6c2e25e.9582a","type":"switchNode","name":"switch: index_number > last-max-index","xml":"<switch test=\"`$tmp.rb.net-index > $tmp.rb.grn.last-max-index`\">","comments":"","outputs":1,"x":1714.2500305175781,"y":2170.2500324249268,"z":"d0c367b0.d55ca8","wires":[["2a0f937.5be026c"]]},{"id":"2a0f937.5be026c","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":1954.25,"y":2169.75,"z":"d0c367b0.d55ca8","wires":[["6bcac8c3.2d4898"]]},{"id":"f6ae0895.c117f8","type":"set","name":"set tmp.rb.sql for update","xml":"<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.grn.last-max-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />","comments":"","x":2302.500030517578,"y":2169.7500324249268,"z":"d0c367b0.d55ca8","wires":[]},{"id":"877a352a.7a0348","type":"get-resource","name":"Update  INDEX TABLE","xml":"<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n","comments":"","outputs":1,"x":2298.6785583496094,"y":2214.3690662384033,"z":"d0c367b0.d55ca8","wires":[["5993fe93.97069","ba617526.0c8828"]]},{"id":"35689d99.980fa2","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.grn.last-max-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix`\" />\n\n","comments":"","x":2681.2500381469727,"y":2215.2502768039703,"z":"d0c367b0.d55ca8","wires":[]},{"id":"5993fe93.97069","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2508.2500915527344,"y":2214.7501401901245,"z":"d0c367b0.d55ca8","wires":[["35689d99.980fa2"]]},{"id":"ba617526.0c8828","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":2515.0954933166504,"y":2261.2382822036743,"z":"d0c367b0.d55ca8","wires":[["35689d99.980fa2"]]},{"id":"ab893117.4bf84","type":"comment","name":"Update prefix from INDEX TABLE","info":"","comments":"","x":2254.5000915527344,"y":2247.00004529953,"z":"d0c367b0.d55ca8","wires":[]},{"id":"6bcac8c3.2d4898","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":2103.75,"y":2170,"z":"d0c367b0.d55ca8","wires":[["f6ae0895.c117f8","877a352a.7a0348"]]},{"id":"7e2b366.e1ab2c8","type":"set","name":"set db.grn.distinct-prefix_length = 0","xml":"<set>\n<parameter name='db.grn.distinct-prefix_length' value='0' />\n","comments":"","x":1127.500015258789,"y":788.0000133514404,"z":"d0c367b0.d55ca8","wires":[]},{"id":"60ca91f4.f6268","type":"service-logic","name":"GENERIC-RESOURCE-API ${project.version}","module":"GENERIC-RESOURCE-API","version":"${project.version}","comments":"","xml":"<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>","outputs":1,"x":438.3333740234375,"y":68.33333587646484,"z":"d0c367b0.d55ca8","wires":[["468f67a9.c0fe68"]]},{"id":"8ec44038.4f2ac","type":"set","name":"set tmp.rb.naming-index-table-name and prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' value='VNF_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='vnf_name_prefix' />\n\n","comments":"","x":1390,"y":570.3333129882812,"z":"d0c367b0.d55ca8","wires":[]},{"id":"5fa679c.78e5088","type":"set","name":"set tmp.rb.naming-index-table-name and prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='NETWORK_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='network_instance_name_prefix' />\n\n","comments":"","x":1387,"y":475,"z":"d0c367b0.d55ca8","wires":[]},{"id":"82455610.85dad8","type":"set","name":"set tmp.rb.naming-index-table-name and prefix column, grn.type","xml":"<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='SERVICE_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='service_instance_name_prefix' />\n\n","comments":"","x":1387,"y":525,"z":"d0c367b0.d55ca8","wires":[]}]
\ No newline at end of file
+[\r
+    {\r
+        "id": "29cb883a.884228",\r
+        "type": "dgstart",\r
+        "name": "DGSTART",\r
+        "outputs": 1,\r
+        "x": 1334.4443359375,\r
+        "y": 20.416664123535156,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "888a84ae.33c888"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ed968adc.8ee998",\r
+        "type": "method",\r
+        "name": "method rollback-generated-names",\r
+        "xml": "<method rpc='rollback-generated-names' mode='sync'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1459.5157623291016,\r
+        "y": 91.84523582458496,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "75650b62.fb7214"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "75650b62.fb7214",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1458.7300567626953,\r
+        "y": 173.2738151550293,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "5556f19b.f5219",\r
+                "19ce5e74.e19aa2",\r
+                "d35c0a8.e055af8",\r
+                "37f63bc9.9d3f04",\r
+                "b6ebcdec.0165b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5556f19b.f5219",\r
+        "type": "switchNode",\r
+        "name": "switch rollback-generated-names-input.context-id",\r
+        "xml": "<switch test='`$rollback-generated-names-input.context-id`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1780.2776489257812,\r
+        "y": 172.33332443237305,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "49e2a20b.aa74ac"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "19ce5e74.e19aa2",\r
+        "type": "switchNode",\r
+        "name": "switch rollback-generated-names-input.naming-type",\r
+        "xml": "<switch test='`$rollback-generated-names-input.naming-type`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1787.444351196289,\r
+        "y": 232.16666793823242,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "19ba8656.ba40ea",\r
+                "fbafb911.c1a228",\r
+                "aaaeba77.eb1d38",\r
+                "c6b37ac7.e80618",\r
+                "1516480b.27b978",\r
+                "943b3579.515908",\r
+                "ffdb86fd.ed9ae8",\r
+                "f9d65524.73d078"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "49e2a20b.aa74ac",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2058.694351196289,\r
+        "y": 172.91666793823242,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "7ab1c055.bf769"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7ab1c055.bf769",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.context-id can not be null\" />\n",\r
+        "comments": "",\r
+        "x": 2225.3486518859863,\r
+        "y": 172.31190013885498,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "19ba8656.ba40ea",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2102.1943359375,\r
+        "y": 231.91666412353516,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "6acbae14.16e77"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6acbae14.16e77",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.naming-type can not be null\" />\n",\r
+        "comments": "",\r
+        "x": 2268.4443550109863,\r
+        "y": 231.91666793823242,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "fbafb911.c1a228",\r
+        "type": "outcome",\r
+        "name": "VM_INSTANCE",\r
+        "xml": "<outcome value='VM_INSTANCE'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2130.1943740844727,\r
+        "y": 279.52380752563477,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "14f5428c.d3dd3d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "aaaeba77.eb1d38",\r
+        "type": "outcome",\r
+        "name": "VNFC_INSTANCE",\r
+        "xml": "<outcome value='VNFC_INSTANCE'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2140.444366455078,\r
+        "y": 327.0238094329834,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "b191361f.e39258"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "14f5428c.d3dd3d",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VM_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vm_name_prefix' />\n",\r
+        "comments": "",\r
+        "x": 2551.694351196289,\r
+        "y": 279.66666984558105,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b191361f.e39258",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VNFC_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnfc_name_prefix' />\n\n",\r
+        "comments": "",\r
+        "x": 2553.944351196289,\r
+        "y": 326.9166717529297,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c6b37ac7.e80618",\r
+        "type": "outcome",\r
+        "name": "Other",\r
+        "xml": "<outcome value='Other'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2107.6943359375,\r
+        "y": 571.1666641235352,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "f1c08b0d.d43858"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f1c08b0d.d43858",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`'Unknown rollbck-generated-name-input.naming-type: ' + $rollback-generated-names-input.naming-type`\" />\n",\r
+        "comments": "",\r
+        "x": 2273.9443550109863,\r
+        "y": 571.1666679382324,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1f6886e.08cdb79",\r
+        "type": "set",\r
+        "name": "set tmp.rb.sql",\r
+        "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'SELECT * from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
+        "comments": "",\r
+        "x": 2301.110996246338,\r
+        "y": 1108.2499651908875,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9103eac2.da1f88",\r
+        "type": "get-resource",\r
+        "name": "GET INDEX TABLE.index_number",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\" pfx='db.grn.index-table'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2369.78946685791,\r
+        "y": 1156.1190004348755,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "4bac1a75.3bf994",\r
+                "9830d2f4.14e32"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "bf055860.21dff8",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic='true'>",\r
+        "atomic": "true",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2110.1109924316406,\r
+        "y": 1108.7499656677246,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "1f6886e.08cdb79",\r
+                "9103eac2.da1f88"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dba5c1eb.6b22f",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error reading the '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' table with ' + $rollback-generated-names.name-prefix-column\n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 2786.361000061035,\r
+        "y": 1157.0000743865967,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "aa4a319e.2aea6",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'No entries found in ' \n\t+ $rollback-generated-names.index-table-name \n\t+ ' with ' \n\t+ $rollback-generated-names.name-prefix-column \n\t+ ' = ' \n\t+ $tmp.rb.grn.prefix `\" />\n\n",\r
+        "comments": "",\r
+        "x": 2786.03946685791,\r
+        "y": 1202.7857494354248,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4bac1a75.3bf994",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2613.361000061035,\r
+        "y": 1156.5000743865967,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "dba5c1eb.6b22f"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9830d2f4.14e32",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2620.206401824951,\r
+        "y": 1202.9882164001465,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "aa4a319e.2aea6"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "37f63bc9.9d3f04",\r
+        "type": "get-resource",\r
+        "name": "GET GENERIC_RESOURCE_NAME distinct prefix",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT distinct prefix from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id'\n  pfx='db.grn.distinct-prefix[]'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1778.1109619140625,\r
+        "y": 692.9999885559082,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "6cb3df87.7e0ec",\r
+                "727c9c85.dfe244"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6cb3df87.7e0ec",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2057.8609619140625,\r
+        "y": 692.9999809265137,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "5c66740e.eb157c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5c66740e.eb157c",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table to retrieve distinct prefix\"/>",\r
+        "comments": "",\r
+        "x": 2227.3609619140625,\r
+        "y": 692.9999809265137,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "727c9c85.dfe244",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2065.860939025879,\r
+        "y": 739.4999742507935,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "1fa487d3.8ad6e8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "314b583f.7203e8",\r
+        "type": "comment",\r
+        "name": "pfx = db.grn.distinct-prefix[]",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1770.3610076904297,\r
+        "y": 730.4999885559082,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b6ebcdec.0165b",\r
+        "type": "for",\r
+        "name": "for each distinct prefix",\r
+        "xml": "<for index='prefix-index' start='0' end='`$db.grn.distinct-prefix_length`' >\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1682.6109924316406,\r
+        "y": 855.4999713897705,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "615652ba.fc923c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e5feeac4.d67ae8",\r
+        "type": "get-resource",\r
+        "name": "GET GENERIC_RESOURCE_NAME  (name_index)",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type   \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.subset[]'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2227.6109886169434,\r
+        "y": 995.2499618530273,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "3b74e0d1.8867b",\r
+                "cd385c50.732c1"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3b74e0d1.8867b",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2545.3609886169434,\r
+        "y": 995.2499542236328,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "de6cfc01.eec5b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "de6cfc01.eec5b",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>",\r
+        "comments": "",\r
+        "x": 2714.8609886169434,\r
+        "y": 995.2499542236328,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "cd385c50.732c1",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2553.3609657287598,\r
+        "y": 1041.7499475479126,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "92b03b04.367558"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "92b03b04.367558",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"`'No entry found in GENERIC_RESOURCE_NAME where context_id = ' + $rollback-generated-names-input.context-id + ' and type = ' + $rollback-generated-names-input.naming-type + ' and prefix = ' + $db.grn.distinct-prefix[$prefix-index].prefix`\"/>",\r
+        "comments": "",\r
+        "x": 2716.6110038757324,\r
+        "y": 1041.499963760376,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "aec883e2.d2ce2",\r
+        "type": "comment",\r
+        "name": "pfx = db.grn.subset[]",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2298.6110038757324,\r
+        "y": 1032.7499713897705,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "615652ba.fc923c",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic='true'>",\r
+        "atomic": "true",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1892.860984802246,\r
+        "y": 855.2499618530273,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "e5feeac4.d67ae8",\r
+                "d73de031.6f6f9",\r
+                "bf055860.21dff8",\r
+                "5b7f4beb.293b54",\r
+                "5bc6188.f631ce8",\r
+                "71d6da4f.c71d64",\r
+                "1bd95123.da921f",\r
+                "300df04b.286a1",\r
+                "c3fa064.1eee4f8",\r
+                "6647f1a8.2eba5",\r
+                "5693c8f8.d296b8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d73de031.6f6f9",\r
+        "type": "set",\r
+        "name": "set tmp.rb.grn.prefix",\r
+        "xml": "<set>\n<parameter name='tmp.rb.grn.prefix' value='`$db.grn.distinct-prefix[$prefix-index].prefix`' />\n",\r
+        "comments": "",\r
+        "x": 2130.1109733581543,\r
+        "y": 945.9999675750732,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6dc0d5b7.e8b79c",\r
+        "type": "switchNode",\r
+        "name": "switch: tmp.rb.net-index == 0",\r
+        "xml": "<switch test=\"`$tmp.rb.net-index == 0`\">",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2589.027786254883,\r
+        "y": 1406.0832901000977,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "ae547b4c.5ee188",\r
+                "de514521.1f6668"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ab812023.4d106",\r
+        "type": "comment",\r
+        "name": "pfx = db.grn.index-table",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2405.8609771728516,\r
+        "y": 1192.7499542236328,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5bc6188.f631ce8",\r
+        "type": "set",\r
+        "name": "set tmp.rb.grn.max-index",\r
+        "xml": "<set>\n<parameter name='tmp.rb.grn.max-index' \n\tvalue='`$db.grn.subset[$db.grn.subset_length - 1].name-index`' />\n",\r
+        "comments": "",\r
+        "x": 2138.6109924316406,\r
+        "y": 1262.7499685287476,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5b7f4beb.293b54",\r
+        "type": "set",\r
+        "name": "clear tmp.rb.",\r
+        "xml": "<set>\n<parameter name='tmp.rb.' value='' />\n",\r
+        "comments": "",\r
+        "x": 2105.1109580993652,\r
+        "y": 899.2499523162842,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d35c0a8.e055af8",\r
+        "type": "set",\r
+        "name": "clear db.grn.",\r
+        "xml": "<set>\n<parameter name='db.grn.' value='' />\n",\r
+        "comments": "",\r
+        "x": 1661.249885559082,\r
+        "y": 639.4444446563721,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "71d6da4f.c71d64",\r
+        "type": "set",\r
+        "name": "clear db.grn.subset.",\r
+        "xml": "<set>\n<parameter name='db.grn.subset.' value='' />\n",\r
+        "comments": "",\r
+        "x": 2126.1109924316406,\r
+        "y": 855.499960899353,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f019211a.03f21",\r
+        "type": "set",\r
+        "name": "set tmp.rb.sql for delete",\r
+        "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t",\r
+        "comments": "",\r
+        "x": 3201.777618408203,\r
+        "y": 1406.08327293396,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "28704354.57816c",\r
+        "type": "get-resource",\r
+        "name": "DELETE from INDEX TABLE",\r
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3217.9561462402344,\r
+        "y": 1451.7023067474365,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "2a3eafed.800b2",\r
+                "9929948e.80baa8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f41ba658.f134a8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 3626.5276794433594,\r
+        "y": 1451.5833806991577,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "2a3eafed.800b2",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3453.5276794433594,\r
+        "y": 1452.0833806991577,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "f41ba658.f134a8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9929948e.80baa8",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3460.3730812072754,\r
+        "y": 1498.5715227127075,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "ce9cb4be.d8f5e8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "138bb542.26235b",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic='true'>",\r
+        "atomic": "true",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2969.277671813965,\r
+        "y": 1405.8332901000977,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "f019211a.03f21",\r
+                "28704354.57816c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1bd95123.da921f",\r
+        "type": "set",\r
+        "name": "set tmp.rb.delta-index = index-number - max-index",\r
+        "xml": "<set>\n<parameter name='tmp.rb.delta-index' \n\tvalue='`$db.grn.index-table.index-number - $tmp.rb.grn.max-index`' />\n",\r
+        "comments": "",\r
+        "x": 2216.6109924316406,\r
+        "y": 1307.9999675750732,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ae547b4c.5ee188",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2802.7776489257812,\r
+        "y": 1406.0832710266113,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "138bb542.26235b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6647f1a8.2eba5",\r
+        "type": "get-resource",\r
+        "name": "DELETE from GENERIC_RESOURCE_NAME",\r
+        "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='DELETE from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2199.4562072753906,\r
+        "y": 1743.9523639678955,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "c5dfbac3.eb7ac8",\r
+                "d5e547a5.1eafc8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c240b414.e47518",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting GENERIC_RESOURCE_NAME WHERE type = '\n\t+ $rollback-generated-names-input.naming-type  \n\t+ ' AND context_id = ' + $rollback-generated-names-input.context-id \n\t+ ' AND prefix = '+ $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 2651.0277404785156,\r
+        "y": 1744.8334379196167,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c5dfbac3.eb7ac8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2478.0277404785156,\r
+        "y": 1744.3334379196167,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "c240b414.e47518"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d5e547a5.1eafc8",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2484.8730850219727,\r
+        "y": 1790.8216247558594,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "a4121e26.ea489"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c25429a5.1b65a8",\r
+        "type": "comment",\r
+        "name": "Delete prefix from INDEX TABLE",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3472.0277557373047,\r
+        "y": 1408.0833444595337,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4b654cba.5ced54",\r
+        "type": "comment",\r
+        "name": "Silence SUCCESS",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3717.027687072754,\r
+        "y": 1510.083288192749,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ce9cb4be.d8f5e8",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3609.2776832580566,\r
+        "y": 1498.3332901000977,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "de514521.1f6668",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2801.777732849121,\r
+        "y": 1591.3333129882812,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "e961bcf0.f03cb"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "666b02e.502d0fc",\r
+        "type": "comment",\r
+        "name": "index_number > $db.grn.subset_length; i.e hole in the middle. DO NOTHING",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2392.5277557373047,\r
+        "y": 1530.083345413208,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b133d8d2.574fa8",\r
+        "type": "comment",\r
+        "name": "Silence SUCCESS",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2741.027587890625,\r
+        "y": 1802.3333225250244,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "a4121e26.ea489",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2633.2775840759277,\r
+        "y": 1790.583324432373,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "300df04b.286a1",\r
+        "type": "switchNode",\r
+        "name": "switch: tmp.rb.delta-index == 0",\r
+        "xml": "<switch test=\"`$tmp.rb.delta-index == 0`\">",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2155.0276641845703,\r
+        "y": 1406.333288192749,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "ebc810ff.c3a11",\r
+                "cc537a09.f92948"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ebc810ff.c3a11",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2382.2776489257812,\r
+        "y": 1406.3332710266113,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "6dc0d5b7.e8b79c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9160dc95.b9431",\r
+        "type": "set",\r
+        "name": "set tmp.rb.sql for update",\r
+        "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.net-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
+        "comments": "",\r
+        "x": 3208.527687072754,\r
+        "y": 1591.3332977294922,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d2204951.3f5048",\r
+        "type": "get-resource",\r
+        "name": "Update INDEX TABLE",\r
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3204.706214904785,\r
+        "y": 1636.9523315429688,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "e86d1619.af6ed8",\r
+                "79602d4f.9dc9b4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3686c0ec.5662b",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.net-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 3610.27774810791,\r
+        "y": 1636.83340549469,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e86d1619.af6ed8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3418.27774810791,\r
+        "y": 1637.33340549469,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "3686c0ec.5662b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "79602d4f.9dc9b4",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3425.123149871826,\r
+        "y": 1683.8215475082397,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "3686c0ec.5662b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e961bcf0.f03cb",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic='true'>",\r
+        "atomic": "true",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2969.0277404785156,\r
+        "y": 1591.0833148956299,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "9160dc95.b9431",\r
+                "d2204951.3f5048"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d4cb9489.bfce78",\r
+        "type": "comment",\r
+        "name": "Update prefix from INDEX TABLE",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3160.52774810791,\r
+        "y": 1669.5833106040955,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c3fa064.1eee4f8",\r
+        "type": "set",\r
+        "name": "set tmp.rb.net-index = index-number - $db.grn.subset_length",\r
+        "xml": "<set>\n<parameter name='tmp.rb.net-index' \n\tvalue='`$db.grn.index-table.index-number - $db.grn.subset_length`' />\n",\r
+        "comments": "",\r
+        "x": 2247.3609771728516,\r
+        "y": 1355.4999523162842,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1fda938f.3dbb9c",\r
+        "type": "comment",\r
+        "name": "index_number == max index",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2032.8609924316406,\r
+        "y": 1449.2499694824219,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d76b3389.44a7f",\r
+        "type": "comment",\r
+        "name": "index_number == $db.grn.subset_length",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2660.3609924316406,\r
+        "y": 1366.7499694824219,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "cc537a09.f92948",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2390.3609924316406,\r
+        "y": 1575.4999685287476,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "a8f99767.daacf8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "a8f99767.daacf8",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2534.111000061035,\r
+        "y": 1575.7499713897705,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "2d578494.cd5f7c",\r
+        "type": "comment",\r
+        "name": "Change History",\r
+        "info": "iTrack SDNGC-10767\n- new DG to rollback generated-names",\r
+        "comments": "",\r
+        "x": 1813.1943435668945,\r
+        "y": 65.41666603088379,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "3d5fa372.a6850c",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name, index-table.prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='EIPAM_CLIENT_KEY_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnf_name_prefix' />\n",\r
+        "comments": "",\r
+        "x": 2579.4443359375,\r
+        "y": 377.41666412353516,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1516480b.27b978",\r
+        "type": "outcome",\r
+        "name": "CLIENT_KEY",\r
+        "xml": "<outcome value='CLIENT_KEY'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2127.194351196289,\r
+        "y": 377.0238037109375,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "3d5fa372.a6850c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "943b3579.515908",\r
+        "type": "outcome",\r
+        "name": "NETWORK_INSTANCE",\r
+        "xml": "<outcome value='NETWORK_INSTANCE'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2158.972099304199,\r
+        "y": 427.2777690887451,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "83af09d2.c65ec8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ffdb86fd.ed9ae8",\r
+        "type": "outcome",\r
+        "name": "SERVICE_INSTANCE",\r
+        "xml": "<outcome value='SERVICE_INSTANCE'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2157.083236694336,\r
+        "y": 476.2777853012085,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "1c77760e.ecb7ea"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f9d65524.73d078",\r
+        "type": "outcome",\r
+        "name": "VNF_INSTANCE",\r
+        "xml": "<outcome value='VNF_INSTANCE'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2140.972099304199,\r
+        "y": 522.2777843475342,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "e200beea.7beb8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2e594a51.7adc16",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2481.4800338745117,\r
+        "y": 1888.095199584961,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "dc507a17.e1ccd8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dc507a17.e1ccd8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>",\r
+        "comments": "",\r
+        "x": 2650.9800338745117,\r
+        "y": 1888.095199584961,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "72a18f01.deeb5",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2489.480010986328,\r
+        "y": 1934.5951929092407,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "43bd72cf.d1989c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5826c7ee.56a468",\r
+        "type": "comment",\r
+        "name": "pfx = db.grn.prefix[]",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2214.730049133301,\r
+        "y": 1925.5952167510986,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5693c8f8.d296b8",\r
+        "type": "get-resource",\r
+        "name": "GET GENERIC_RESOURCE_NAME  (prefix)",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type    \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.prefix[]'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2193.730026245117,\r
+        "y": 1887.845220565796,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "2e594a51.7adc16",\r
+                "72a18f01.deeb5",\r
+                "97a75732.8d1778"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "97a75732.8d1778",\r
+        "type": "success",\r
+        "name": "success",\r
+        "xml": "<outcome value='success'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2483.015769958496,\r
+        "y": 2077.5595169067383,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "af5d42dd.241e1"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "af5d42dd.241e1",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2632.6587142944336,\r
+        "y": 2077.702341079712,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "255e4edf.8d20f2",\r
+                "46080842.900648"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ad49ad2b.b9ff7",\r
+        "type": "comment",\r
+        "name": "Clean up holes in INDEX TABLE",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1951.694351196289,\r
+        "y": 1831.6666927337646,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f4c9b7ed.c5e8b8",\r
+        "type": "set",\r
+        "name": "set tmp.rb.sql for delete",\r
+        "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t",\r
+        "comments": "",\r
+        "x": 2890.4800720214844,\r
+        "y": 1934.5952682495117,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9004f393.79866",\r
+        "type": "get-resource",\r
+        "name": "DELETE from INDEX TABLE",\r
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2906.6585998535156,\r
+        "y": 1980.2143020629883,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "e6d51ffb.da5ef",\r
+                "e74e9d15.6e515"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8b317be0.6cea48",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number`\" />\n\n",\r
+        "comments": "",\r
+        "x": 3297.2301330566406,\r
+        "y": 1980.0953760147095,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e6d51ffb.da5ef",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3124.2301330566406,\r
+        "y": 1980.5953760147095,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "8b317be0.6cea48"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e74e9d15.6e515",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3131.0755348205566,\r
+        "y": 2027.0835180282593,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "9ba26a8.310e298"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "77aa82ec.ea575c",\r
+        "type": "comment",\r
+        "name": "Delete prefix from INDEX TABLE",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3160.730209350586,\r
+        "y": 1936.5953397750854,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "2d8ded7b.a5e7e2",\r
+        "type": "comment",\r
+        "name": "Silence SUCCESS",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3387.730140686035,\r
+        "y": 2038.5952835083008,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9ba26a8.310e298",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3279.980136871338,\r
+        "y": 2026.8452854156494,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "43bd72cf.d1989c",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2637.1943588256836,\r
+        "y": 1934.9166927337646,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "f4c9b7ed.c5e8b8",\r
+                "9004f393.79866"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "255e4edf.8d20f2",\r
+        "type": "set",\r
+        "name": "set tmp.rb.grn.last-max-index",\r
+        "xml": "<set>\n<parameter name='tmp.rb.grn.last-max-index' \n\tvalue='`$db.grn.prefix[$db.grn.prefix_length - 1].name-index`' />\n",\r
+        "comments": "",\r
+        "x": 2855.6943588256836,\r
+        "y": 2077.916696548462,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "46080842.900648",\r
+        "type": "switchNode",\r
+        "name": "switch: index_number > last-max-index",\r
+        "xml": "<switch test=\"`$tmp.rb.net-index > $tmp.rb.grn.last-max-index`\">",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2884.944366455078,\r
+        "y": 2121.916696548462,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "88ac47d8.6bb598"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "88ac47d8.6bb598",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3124.9443359375,\r
+        "y": 2121.416664123535,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "c1f045de.3e28c8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ee302e41.39dd1",\r
+        "type": "set",\r
+        "name": "set tmp.rb.sql for update",\r
+        "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.grn.last-max-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
+        "comments": "",\r
+        "x": 3473.194366455078,\r
+        "y": 2121.416696548462,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b61cd1a1.4af9b",\r
+        "type": "get-resource",\r
+        "name": "Update  INDEX TABLE",\r
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3469.3728942871094,\r
+        "y": 2166.0357303619385,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "5241d984.6b2458",\r
+                "19f1dadd.4da2c5"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2583f2fc.38be4e",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.grn.last-max-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix`\" />\n\n",\r
+        "comments": "",\r
+        "x": 3851.9443740844727,\r
+        "y": 2166.9169409275055,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5241d984.6b2458",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3678.9444274902344,\r
+        "y": 2166.4168043136597,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "2583f2fc.38be4e"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "19f1dadd.4da2c5",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3685.7898292541504,\r
+        "y": 2212.9049463272095,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "2583f2fc.38be4e"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "370184fa.2c436c",\r
+        "type": "comment",\r
+        "name": "Update prefix from INDEX TABLE",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 3425.1944274902344,\r
+        "y": 2198.666709423065,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c1f045de.3e28c8",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3274.4443359375,\r
+        "y": 2121.666664123535,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "ee302e41.39dd1",\r
+                "b61cd1a1.4af9b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1fa487d3.8ad6e8",\r
+        "type": "set",\r
+        "name": "set db.grn.distinct-prefix_length = 0",\r
+        "xml": "<set>\n<parameter name='db.grn.distinct-prefix_length' value='0' />\n",\r
+        "comments": "",\r
+        "x": 2298.194351196289,\r
+        "y": 739.6666774749756,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "888a84ae.33c888",\r
+        "type": "service-logic",\r
+        "name": "GENERIC-RESOURCE-API ${project.version}",\r
+        "module": "GENERIC-RESOURCE-API",\r
+        "version": "${project.version}",\r
+        "comments": "",\r
+        "xml": "<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>",\r
+        "outputs": 1,\r
+        "x": 1609.0277099609375,\r
+        "y": 20,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "ed968adc.8ee998"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e200beea.7beb8",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='VNF_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='vnf_name_prefix' />\n\n",\r
+        "comments": "",\r
+        "x": 2671.805435180664,\r
+        "y": 555.3333234786987,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "83af09d2.c65ec8",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='NETWORK_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='network_instance_name_prefix' />\n\n",\r
+        "comments": "",\r
+        "x": 2557.6943359375,\r
+        "y": 426.66666412353516,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "98dce5f3.4de788",\r
+        "type": "set",\r
+        "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
+        "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='SERVICE_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='service_instance_name_prefix' />\n\n",\r
+        "comments": "",\r
+        "x": 2741.027633666992,\r
+        "y": 474.4444389343262,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1c77760e.ecb7ea",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2356.6666666666665,\r
+        "y": 474.44444444444446,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            [\r
+                "98dce5f3.4de788",\r
+                "3647a166.a299ee"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3647a166.a299ee",\r
+        "type": "get-resource",\r
+        "name": "DELETE service instance name",\r
+        "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='DELETE from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id AND prefix IS NULL AND name_index IS NULL'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2582.2221870422363,\r
+        "y": 512.222222328186,\r
+        "z": "aa630329.50a53",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "7a0ecea1.020ae",\r
+        "type": "comment",\r
+        "name": "quick path to delete instance name",\r
+        "info": "If no prefix and name_index involved, it can be deleted now",\r
+        "comments": "",\r
+        "x": 2838.888832092285,\r
+        "y": 518.8889126777649,\r
+        "z": "aa630329.50a53",\r
+        "wires": []\r
+    }\r
+]
\ No newline at end of file