Fix reuse InstanceName when re-creating a service
[sdnc/oam.git] / platform-logic / generic-resource-api / src / main / json / GENERIC-RESOURCE-API_generate-unique-name.json
index db31408..ee76ebc 100755 (executable)
@@ -1 +1,3695 @@
-[{"id":"67de88fb.8c7938","type":"comment","name":"Validation of required data","info":"","comments":"","x":1057.142822265625,"y":515.5803684507098,"z":"90110745.0f08b8","wires":[]},{"id":"94850767.18cb88","type":"dgstart","name":"DGSTART","outputs":1,"x":102.17857578822532,"y":85.27079963684082,"z":"90110745.0f08b8","wires":[["9515dbaf.7cfdd8"]]},{"id":"9515dbaf.7cfdd8","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":217.46428680419922,"y":126.5089168548584,"z":"90110745.0f08b8","wires":[["e2f684c5.eb7ee8"]]},{"id":"e2f684c5.eb7ee8","type":"method","name":"method generate-unique-name","xml":"<method rpc='generate-unique-name' mode='sync'>\n","comments":"","outputs":1,"x":173.5238800048828,"y":168.1874546323504,"z":"90110745.0f08b8","wires":[["68aae923.1b9ef8"]]},{"id":"2c60d5c7.2f6a4a","type":"comment","name":"generate-unique-name","info":"Input arguments:\ngenerate-unique-name-input.index-table-name - name of INDEX table\ngenerate-unique-name-input.index-table-prefix-column - name of prefix column in above table\ngenerate-unique-name-input.name-table-name - name of table holding all generated names\ngenerate-unique-name-input.index-length - non-null digit if index should be fixed length\n\nOutput arguments:\ngenerate-unique-name-output.generated-name - generated name (null if error)\ngenerate-unique-name-output.error-message - error message (non-null if error)\n","comments":"","x":496.52343205043235,"y":32.85714340209961,"z":"90110745.0f08b8","wires":[]},{"id":"c38467.17e88b98","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":552.0595245361328,"y":1462.4405617032733,"z":"90110745.0f08b8","wires":[["e07193e1.224fa","db37eadb.3a3d08","f2d5b5.74cefa48","e4e1fe0e.7ce86","536fad15.81aec4","54f8ebb1.fbd3a4","56d20088.dca34","a0df1e14.0a77c","2db87246.6ac1ae","a9e87bf7.6d8b68","4e23a92d.e2e488"]]},{"id":"e07193e1.224fa","type":"switchNode","name":"switch generate-unique-name-input.index-table-name","xml":"<switch test='`$generate-unique-name-input.index-table-name`'>\n","comments":"","outputs":1,"x":993.7262115478516,"y":561.1905063901629,"z":"90110745.0f08b8","wires":[["18433a18.3228e6"]]},{"id":"18433a18.3228e6","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1323.726131439209,"y":561.1904958997454,"z":"90110745.0f08b8","wires":[["631b8d51.8c1104"]]},{"id":"631b8d51.8c1104","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-name not supplied' />\n","comments":"","x":1497.0594520568848,"y":561.1904873166766,"z":"90110745.0f08b8","wires":[]},{"id":"db37eadb.3a3d08","type":"switchNode","name":"switch generate-unique-name-input.index-table-prefix-column","xml":"<switch test='`$generate-unique-name-input.index-table-prefix-column`'>\n","comments":"","outputs":1,"x":1018.7261810302734,"y":604.5238422666278,"z":"90110745.0f08b8","wires":[["1d937744.b083a9"]]},{"id":"1d937744.b083a9","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1322.0594444274902,"y":604.5238212857928,"z":"90110745.0f08b8","wires":[["545cc85f.e1dd58"]]},{"id":"545cc85f.e1dd58","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-prefix-column not supplied' />\n","comments":"","x":1495.3927612304688,"y":604.8571647916522,"z":"90110745.0f08b8","wires":[]},{"id":"f2d5b5.74cefa48","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"<switch test='`$generate-unique-name-input.name-table-type`'>\n","comments":"","outputs":1,"x":989.726188659668,"y":649.5238346372332,"z":"90110745.0f08b8","wires":[["c3a054c.71adaa8"]]},{"id":"c3a054c.71adaa8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1322.0593852996826,"y":649.5238441739764,"z":"90110745.0f08b8","wires":[["a9d236bd.19e0f8"]]},{"id":"a9d236bd.19e0f8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n","comments":"","x":1493.726161956787,"y":649.8571476255145,"z":"90110745.0f08b8","wires":[]},{"id":"56d20088.dca34","type":"get-resource","name":"get-resource current name index","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.prefixdb'>\n\n","comments":"","outputs":1,"x":921.3927917480469,"y":1090.2855362210955,"z":"90110745.0f08b8","wires":[["145a06ca.15e939","b91db4d1.5863b8","c98722cf.dc1a3"]]},{"id":"145a06ca.15e939","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1146.5832595825195,"y":1168.8094429288592,"z":"90110745.0f08b8","wires":[["5ade3940.140eb8"]]},{"id":"5ade3940.140eb8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Error reading the ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":1309.2023811340332,"y":1170.238171032497,"z":"90110745.0f08b8","wires":[]},{"id":"43b733f4.e9302c","type":"for","name":"for idx from current index to list-end","xml":"<for index='tmp.gun.idx' start='`$tmp.gun.index-number`' end='`$tmp.gun.list-end`' >\n","comments":"","outputs":1,"x":1073.7261962890625,"y":1492.8571519851685,"z":"90110745.0f08b8","wires":[["91d927f9.353948"]]},{"id":"e4e1fe0e.7ce86","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":836.3451919555664,"y":1492.8571171079363,"z":"90110745.0f08b8","wires":[["43b733f4.e9302c","c322ca3a.666808"]]},{"id":"c322ca3a.666808","type":"returnSuccess","name":"CATCH BREAK","xml":"<return status='success'>\n\n","comments":"","x":1024.6786041259766,"y":2067.857247761318,"z":"90110745.0f08b8","wires":[]},{"id":"536fad15.81aec4","type":"switchNode","name":"switch generate-unique-name-input.prefix","xml":"<switch test='`$generate-unique-name-input.prefix`'>\n","comments":"","outputs":1,"x":955.3928298950195,"y":694.5238136563983,"z":"90110745.0f08b8","wires":[["82c1a7dd.32a6a8"]]},{"id":"82c1a7dd.32a6a8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1322.7260189056396,"y":694.5238384519305,"z":"90110745.0f08b8","wires":[["db83eab5.1248c8"]]},{"id":"db83eab5.1248c8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n","comments":"","x":1495.3927955627441,"y":694.8571419034686,"z":"90110745.0f08b8","wires":[]},{"id":"54f8ebb1.fbd3a4","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":978.7261962890625,"y":829.523755482265,"z":"90110745.0f08b8","wires":[["f7c6d6ff.541f78","ce184e71.86be8","4c11c2f5.d535ac","d88178cc.f88d98","febff3b8.f5c6e"]]},{"id":"f7c6d6ff.541f78","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1322.0595092773438,"y":737.8571419034686,"z":"90110745.0f08b8","wires":[["5b517f27.498b7"]]},{"id":"febff3b8.f5c6e","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1319.3928985595703,"y":914.5238022123065,"z":"90110745.0f08b8","wires":[["2531a549.b793aa"]]},{"id":"ce184e71.86be8","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":1320.3928565979004,"y":782.8571819577899,"z":"90110745.0f08b8","wires":[["31a1c558.a77dba"]]},{"id":"4c11c2f5.d535ac","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":1320.3928413391113,"y":827.8571724210467,"z":"90110745.0f08b8","wires":[["510f4c1a.709e14"]]},{"id":"d88178cc.f88d98","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":1318.7261772155762,"y":871.1905082975115,"z":"90110745.0f08b8","wires":[["9efb14fc.5f68e8"]]},{"id":"31a1c558.a77dba","type":"set","name":"set list-end = 10","xml":"<set>\n<parameter name='tmp.gun.list-end' value='10' />\n","comments":"","x":1503.0595932006836,"y":782.8571705136981,"z":"90110745.0f08b8","wires":[]},{"id":"510f4c1a.709e14","type":"set","name":"set list-end = 100","xml":"<set>\n<parameter name='tmp.gun.list-end' value='100' />\n","comments":"","x":1506.392822265625,"y":827.8571724210467,"z":"90110745.0f08b8","wires":[]},{"id":"9efb14fc.5f68e8","type":"set","name":"set list-end = 1000","xml":"<set>\n<parameter name='tmp.gun.list-end' value='1000' />\n","comments":"","x":1508.392822265625,"y":871.190485409328,"z":"90110745.0f08b8","wires":[]},{"id":"2531a549.b793aa","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n","comments":"","x":1490.392822265625,"y":913.8571724210467,"z":"90110745.0f08b8","wires":[]},{"id":"70192d95.678c34","type":"set","name":"set new index number to 1","xml":"<set>\n<parameter name='tmp.gun.index-number' value='1' />\n","comments":"","x":1481.8216018676758,"y":1113.4288276944842,"z":"90110745.0f08b8","wires":[]},{"id":"5b517f27.498b7","type":"set","name":"set list-end = 10000 (infinity basically)","xml":"<set>\n<parameter name='tmp.gun.list-end' value='10000' />\n","comments":"","x":1571.0594482421875,"y":738.190485409328,"z":"90110745.0f08b8","wires":[]},{"id":"314df997.3fe296","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":1635.3927764892578,"y":1419.5237907682147,"z":"90110745.0f08b8","wires":[["d05e660d.be4cd8","c3985438.571b88","b03a2186.83945","f88e445.6bd78b8"]]},{"id":"d05e660d.be4cd8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1915.3927764892578,"y":1349.523851803371,"z":"90110745.0f08b8","wires":[["4bdac272.02882c"]]},{"id":"c3985438.571b88","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":1913.7261238098145,"y":1394.5238918576922,"z":"90110745.0f08b8","wires":[["4bdac272.02882c"]]},{"id":"b03a2186.83945","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":1913.7262115478516,"y":1447.8572391782488,"z":"90110745.0f08b8","wires":[["aa9d44e3.177b58"]]},{"id":"f88e445.6bd78b8","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":1913.726089477539,"y":1544.5239719663348,"z":"90110745.0f08b8","wires":[["9cdd86f.ae52778"]]},{"id":"4bdac272.02882c","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2100.392925262451,"y":1367.8571953092303,"z":"90110745.0f08b8","wires":[]},{"id":"aa9d44e3.177b58","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2080.3928413391113,"y":1447.857137135097,"z":"90110745.0f08b8","wires":[["db28baee.042fe8","31a49c00.cbd4c4"]]},{"id":"db28baee.042fe8","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2242.0594749450684,"y":1421.1905102048602,"z":"90110745.0f08b8","wires":[["1f2e15a5.5c898a"]]},{"id":"31a49c00.cbd4c4","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2242.0594329833984,"y":1469.523846081325,"z":"90110745.0f08b8","wires":[["5fd3a71c.4e8c88"]]},{"id":"1f2e15a5.5c898a","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2433.726234436035,"y":1420.523737362453,"z":"90110745.0f08b8","wires":[]},{"id":"5fd3a71c.4e8c88","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2417.05948638916,"y":1469.1904529844012,"z":"90110745.0f08b8","wires":[]},{"id":"9cdd86f.ae52778","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2082.059425354004,"y":1542.8570999417987,"z":"90110745.0f08b8","wires":[["4dff528e.5fe12c","e36c83c7.3522d"]]},{"id":"4dff528e.5fe12c","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2242.0594024658203,"y":1516.1904777799334,"z":"90110745.0f08b8","wires":[["3d8d515c.20155e"]]},{"id":"e36c83c7.3522d","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2243.726058959961,"y":1591.1904358182635,"z":"90110745.0f08b8","wires":[["5210620f.f035ac"]]},{"id":"3d8d515c.20155e","type":"set","name":"set index-string to '00' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n","comments":"","x":2437.0594940185547,"y":1516.1903686523438,"z":"90110745.0f08b8","wires":[]},{"id":"5210620f.f035ac","type":"switchNode","name":"switch idx < 100","xml":"<switch test='`$tmp.gun.idx &lt; 100`'>\n","comments":"","outputs":1,"x":2400.059440612793,"y":1589.5237964902606,"z":"90110745.0f08b8","wires":[["bb2d2969.5be9a8","f8c44cdb.e372f"]]},{"id":"bb2d2969.5be9a8","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2557.0594177246094,"y":1562.8571743283953,"z":"90110745.0f08b8","wires":[["7621b36e.37c05c"]]},{"id":"f8c44cdb.e372f","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2557.0593757629395,"y":1611.1905102048602,"z":"90110745.0f08b8","wires":[["c1d12981.5578f8"]]},{"id":"7621b36e.37c05c","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2749.726203918457,"y":1562.5238289151873,"z":"90110745.0f08b8","wires":[]},{"id":"c1d12981.5578f8","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2733.726188659668,"y":1610.8571323667254,"z":"90110745.0f08b8","wires":[]},{"id":"630383d6.9584cc","type":"set","name":"set generated-name to prefix + index-string","xml":"<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n","comments":"","x":1619.3928680419922,"y":1696.1904396329608,"z":"90110745.0f08b8","wires":[]},{"id":"e52dd26e.0f4e","type":"set","name":"increment index number","xml":"<set>\n<parameter name='tmp.gun.index-number' value='`$tmp.gun.prefixdb.index-number + 1`' />\n","comments":"","x":1473.7261962890625,"y":1023.4761659417834,"z":"90110745.0f08b8","wires":[]},{"id":"73c9dbdb.c05d54","type":"comment","name":"First check from the current index to the max index","info":"","comments":"","x":1037.0595397949219,"y":1431.1905206952777,"z":"90110745.0f08b8","wires":[]},{"id":"1b12fce7.736083","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":1616.1073913574219,"y":1780.4765853881836,"z":"90110745.0f08b8","wires":[]},{"id":"60c15f95.e82e1","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1723.7261924743652,"y":1857.8573679242816,"z":"90110745.0f08b8","wires":[["d699e5de.1c2618"]]},{"id":"38122015.0cd4f","type":"set","name":"set generate-unique-name-output.error-message","xml":"<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n","comments":"","x":2169.6784439086914,"y":1831.4287008558001,"z":"90110745.0f08b8","wires":[]},{"id":"9f978d91.b34da","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2034.916690826416,"y":1876.4287885938372,"z":"90110745.0f08b8","wires":[]},{"id":"48493fbe.6eb1a","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2037.7737121582031,"y":1971.33347933633,"z":"90110745.0f08b8","wires":[]},{"id":"ff71e11.cb7392","type":"comment","name":"found one we can use","info":"","comments":"","x":1855.6311683654785,"y":1902.3814014707293,"z":"90110745.0f08b8","wires":[]},{"id":"a0df1e14.0a77c","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"<switch test='`$generate-unique-name-output.error-message`'>\n","comments":"","outputs":1,"x":987.8928833007812,"y":2185.7143883023946,"z":"90110745.0f08b8","wires":[["47956a10.f7f354","822e2233.58978"]]},{"id":"47956a10.f7f354","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1261.2262916564941,"y":2159.0476402555196,"z":"90110745.0f08b8","wires":[["9fcbb9ed.6b3558"]]},{"id":"9fcbb9ed.6b3558","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1396.2262916564941,"y":2159.0476402555196,"z":"90110745.0f08b8","wires":[[]]},{"id":"822e2233.58978","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1261.2262573242188,"y":2209.0476612363545,"z":"90110745.0f08b8","wires":[["d471ec21.e29e1"]]},{"id":"d471ec21.e29e1","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n","comments":"","x":1411.2262573242188,"y":2209.0476612363545,"z":"90110745.0f08b8","wires":[]},{"id":"2db87246.6ac1ae","type":"switchNode","name":"switch found-flag","xml":"<switch test='`$tmp.gun.found-flag`'>\n","comments":"","outputs":1,"x":859.6071929931641,"y":2468.5715078626363,"z":"90110745.0f08b8","wires":[["1afe7988.3e2406","382ec618.a7ddba"]]},{"id":"1afe7988.3e2406","type":"outcome","name":"true","xml":"<outcome value='true'>","comments":"","outputs":1,"x":1033.9405326843262,"y":2468.5715088163106,"z":"90110745.0f08b8","wires":[["3d2939f2.411d96"]]},{"id":"97761528.22f748","type":"set","name":"set generate-unique-name-output.generated-name","xml":"<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n","comments":"","x":1504.6071472167969,"y":2313.5717949186055,"z":"90110745.0f08b8","wires":[]},{"id":"eda538a7.a89168","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n","comments":"","x":1386.6547164916992,"y":2650.952589443752,"z":"90110745.0f08b8","wires":[]},{"id":"3d2939f2.411d96","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1185.607162475586,"y":2467.9049228940694,"z":"90110745.0f08b8","wires":[["97761528.22f748","8aabfd4d.0ee5a","b24cce42.caeba","eda538a7.a89168","76d2de9f.d1d72"]]},{"id":"77a666ae.651d38","type":"set","name":"set index-exists flag to false","xml":"<set>\n<parameter name='tmp.gun.index-exists' value='false' />\n","comments":"","x":1485.8689880371094,"y":1067.142887524196,"z":"90110745.0f08b8","wires":[]},{"id":"21842051.8fdc8","type":"set","name":"set index-exists flag to true","xml":"<set>\n<parameter name='tmp.gun.index-exists' value='true' />\n","comments":"","x":1482.0120010375977,"y":978.571439913341,"z":"90110745.0f08b8","wires":[]},{"id":"4cecef4a.45b81","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1288.7262725830078,"y":1000.0000459466662,"z":"90110745.0f08b8","wires":[["21842051.8fdc8","e52dd26e.0f4e"]]},{"id":"8aabfd4d.0ee5a","type":"switchNode","name":"switch index-exists","xml":"<switch test='`$tmp.gun.index-exists`'>\n","comments":"","outputs":1,"x":1400.369155883789,"y":2445.714796475002,"z":"90110745.0f08b8","wires":[["346f0424.17228c","2db882f9.07b2be"]]},{"id":"346f0424.17228c","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":1578.9405212402344,"y":2421.429064205715,"z":"90110745.0f08b8","wires":[["46d7a7fe.5f3bf8"]]},{"id":"2db882f9.07b2be","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1578.9405364990234,"y":2468.571989468166,"z":"90110745.0f08b8","wires":[["a296a95c.85f908"]]},{"id":"783bc8f9.d13d28","type":"save","name":"save (update) name index","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1974.6548461914062,"y":2422.857480457851,"z":"90110745.0f08b8","wires":[["67762a25.ef1984"]]},{"id":"c608a7c.ab02058","type":"save","name":"save (insert) name index","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1967.5118255615234,"y":2517.1429485593526,"z":"90110745.0f08b8","wires":[["396de0c3.36e29"]]},{"id":"67762a25.ef1984","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2167.512046813965,"y":2422.8574995313375,"z":"90110745.0f08b8","wires":[["77e2ebe5.4aacd4"]]},{"id":"396de0c3.36e29","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2164.6546173095703,"y":2515.71446459634,"z":"90110745.0f08b8","wires":[["a64a1c5c.548e1"]]},{"id":"b24cce42.caeba","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1434.797752380371,"y":2604.2857708249776,"z":"90110745.0f08b8","wires":[["6e840dcf.98d2c4"]]},{"id":"6e840dcf.98d2c4","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1644.7976837158203,"y":2604.2858223233907,"z":"90110745.0f08b8","wires":[["14711303.85363d"]]},{"id":"14711303.85363d","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":1799.0834999084473,"y":2604.285841396877,"z":"90110745.0f08b8","wires":[]},{"id":"a9e87bf7.6d8b68","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from ' + $generate-unique-name-input.index-table-name\n+ ' WHERE ' + $generate-unique-name-input.index-table-prefix-column + ' = '\n+ '$generate-unique-name-input.prefix'`\" />\n","comments":"","x":877.2976760864258,"y":958.5715393338885,"z":"90110745.0f08b8","wires":[]},{"id":"91d927f9.353948","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1315.8690567016602,"y":1491.428631237575,"z":"90110745.0f08b8","wires":[["314df997.3fe296","630383d6.9584cc","3e27b62f.f1d58a","880d7037.87ac9"]]},{"id":"d699e5de.1c2618","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1876.1071891784668,"y":1857.3812870298113,"z":"90110745.0f08b8","wires":[["38122015.0cd4f","9f978d91.b34da"]]},{"id":"46d7a7fe.5f3bf8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1756.226333618164,"y":2398.5715927396504,"z":"90110745.0f08b8","wires":[["d44f050d.8c0008","783bc8f9.d13d28"]]},{"id":"a296a95c.85f908","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1753.3691864013672,"y":2494.285911015102,"z":"90110745.0f08b8","wires":[["c608a7c.ab02058","462aa6c7.448d08"]]},{"id":"d44f050d.8c0008","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n","comments":"","x":1944.7976150512695,"y":2374.285564354488,"z":"90110745.0f08b8","wires":[]},{"id":"462aa6c7.448d08","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n","comments":"","x":1943.3691635131836,"y":2468.571381023952,"z":"90110745.0f08b8","wires":[]},{"id":"bbed7686.7c8a78","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1730.3929290771484,"y":1948.8097633634295,"z":"90110745.0f08b8","wires":[["193702b8.5c51ed"]]},{"id":"6d5c7c0e.2718a4","type":"for","name":"for idx from 1 to current index","xml":"<for index='tmp.gun.idx' start='1' end='`$tmp.gun.index-number`' >\n","comments":"","outputs":1,"x":1580.1787033081055,"y":3060.5239128385274,"z":"90110745.0f08b8","wires":[["c87de081.2b7b6"]]},{"id":"1185013a.772fcf","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1348.5119857788086,"y":3060.5239137922017,"z":"90110745.0f08b8","wires":[["6d5c7c0e.2718a4","bf365e0a.2dfca"]]},{"id":"bf365e0a.2dfca","type":"returnSuccess","name":"CATCH BREAK","xml":"<return status='success'>\n\n","comments":"","x":1531.1310958862305,"y":3635.5240434919087,"z":"90110745.0f08b8","wires":[]},{"id":"9144f7d0.dfe548","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":2141.8452682495117,"y":2987.1905864988057,"z":"90110745.0f08b8","wires":[["644f5421.41381c","e5c0619b.7a065","e0c68335.db7ab","41de4558.401f8c"]]},{"id":"644f5421.41381c","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":2421.8452682495117,"y":2917.190647533962,"z":"90110745.0f08b8","wires":[["fb2ee76c.834068"]]},{"id":"e5c0619b.7a065","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":2420.1786155700684,"y":2962.1906875882833,"z":"90110745.0f08b8","wires":[["fb2ee76c.834068"]]},{"id":"e0c68335.db7ab","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":2420.1787033081055,"y":3015.52403490884,"z":"90110745.0f08b8","wires":[["21e6c935.f093a6"]]},{"id":"41de4558.401f8c","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":2420.178581237793,"y":3112.190767696926,"z":"90110745.0f08b8","wires":[["ae67a8d.0fd0d58"]]},{"id":"fb2ee76c.834068","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2606.845417022705,"y":2935.5239910398213,"z":"90110745.0f08b8","wires":[]},{"id":"21e6c935.f093a6","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2586.8453330993652,"y":3015.523932865688,"z":"90110745.0f08b8","wires":[["c00eb747.c971c8","7a0fee3a.c8155"]]},{"id":"c00eb747.c971c8","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2748.5119667053223,"y":2988.857305935451,"z":"90110745.0f08b8","wires":[["c515b54.3569d48"]]},{"id":"7a0fee3a.c8155","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2748.5119247436523,"y":3037.190641811916,"z":"90110745.0f08b8","wires":[["de2fc71d.e11088"]]},{"id":"c515b54.3569d48","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2940.178726196289,"y":2988.190533093044,"z":"90110745.0f08b8","wires":[]},{"id":"de2fc71d.e11088","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2923.511978149414,"y":3036.8572487149922,"z":"90110745.0f08b8","wires":[]},{"id":"ae67a8d.0fd0d58","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2588.511917114258,"y":3110.5238956723897,"z":"90110745.0f08b8","wires":[["c8925f4d.077c6","12f4b493.683e8b"]]},{"id":"c8925f4d.077c6","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2748.511894226074,"y":3083.8572735105245,"z":"90110745.0f08b8","wires":[["c22d1aeb.d63b48"]]},{"id":"12f4b493.683e8b","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2750.178550720215,"y":3158.8572315488545,"z":"90110745.0f08b8","wires":[["90f5c134.3ca9"]]},{"id":"c22d1aeb.d63b48","type":"set","name":"set index-string to '00' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n","comments":"","x":2943.511978149414,"y":3083.8572487149922,"z":"90110745.0f08b8","wires":[]},{"id":"90f5c134.3ca9","type":"switchNode","name":"switch idx < 100","xml":"<switch test='`$tmp.gun.idx &lt; 100`'>\n","comments":"","outputs":1,"x":2906.511932373047,"y":3157.1905922208516,"z":"90110745.0f08b8","wires":[["87f17e57.81d71","f8e50bff.aaa1f8"]]},{"id":"87f17e57.81d71","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":3063.5119094848633,"y":3130.5239700589864,"z":"90110745.0f08b8","wires":[["caf5e13b.23238"]]},{"id":"f8e50bff.aaa1f8","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":3063.5118675231934,"y":3178.857305935451,"z":"90110745.0f08b8","wires":[["2e72859.272837a"]]},{"id":"caf5e13b.23238","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":3256.178695678711,"y":3130.1906246457784,"z":"90110745.0f08b8","wires":[]},{"id":"2e72859.272837a","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":3240.178680419922,"y":3178.5239280973165,"z":"90110745.0f08b8","wires":[]},{"id":"9775d1bd.a31a5","type":"set","name":"set generated-name to prefix + index-string","xml":"<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n","comments":"","x":2125.845359802246,"y":3263.857235363552,"z":"90110745.0f08b8","wires":[]},{"id":"35bc5497.2d892c","type":"comment","name":"Wrapping around - now check from 1 to the original index","info":"","comments":"","x":1553.5120162963867,"y":2946.000319889614,"z":"90110745.0f08b8","wires":[]},{"id":"ccb5f6ab.ef5478","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":2112.5598068237305,"y":3378.8575090680806,"z":"90110745.0f08b8","wires":[]},{"id":"e74cf3af.ae8e8","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":2050.178623199463,"y":3519.571578979492,"z":"90110745.0f08b8","wires":[["2f478f3e.e0607","398f430e.7a743c"]]},{"id":"2f478f3e.e0607","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2228.5120162963867,"y":3473.8574156079976,"z":"90110745.0f08b8","wires":[["c9df5194.5868"]]},{"id":"9ffe2099.9294f","type":"set","name":"set generate-unique-name-output.error-message","xml":"<set>\n<parameter name='generate-unique-name-output.error-message' value=\"Error reading the GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2674.464267730713,"y":3447.428748539516,"z":"90110745.0f08b8","wires":[]},{"id":"745383f6.b6740c","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2539.7025146484375,"y":3492.4288362775533,"z":"90110745.0f08b8","wires":[]},{"id":"cd5abdec.20e31","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"<switch test='`$generate-unique-name-output.error-message`'>\n","comments":"","outputs":1,"x":1512.5595932006836,"y":3743.381119183132,"z":"90110745.0f08b8","wires":[["8a7bb59.e987548","ec85a0b6.70f26"]]},{"id":"8a7bb59.e987548","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1785.8930015563965,"y":3716.714371136257,"z":"90110745.0f08b8","wires":[["13932aab.cff7c5"]]},{"id":"13932aab.cff7c5","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1920.8930015563965,"y":3716.714371136257,"z":"90110745.0f08b8","wires":[[]]},{"id":"ec85a0b6.70f26","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1785.892967224121,"y":3766.714392117092,"z":"90110745.0f08b8","wires":[["a496c9cc.3afe48"]]},{"id":"a496c9cc.3afe48","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n","comments":"","x":1935.892967224121,"y":3766.714392117092,"z":"90110745.0f08b8","wires":[]},{"id":"e38bddb.6889c2","type":"switchNode","name":"switch found-flag","xml":"<switch test='`$tmp.gun.found-flag`'>\n","comments":"","outputs":1,"x":1394.2738723754883,"y":3922.905027798244,"z":"90110745.0f08b8","wires":[["d6f25ad7.1e9978"]]},{"id":"70380c05.64b0a4","type":"comment","name":"if db name is null we found an index we can use","info":"","comments":"","x":1560.9882125854492,"y":3872.428802898952,"z":"90110745.0f08b8","wires":[]},{"id":"d6f25ad7.1e9978","type":"outcome","name":"true","xml":"<outcome value='true'>","comments":"","outputs":1,"x":1553.607192993164,"y":3922.9049848829,"z":"90110745.0f08b8","wires":[["e5da090c.731d68"]]},{"id":"feb55f31.73e7a","type":"set","name":"set generate-unique-name-output.generated-name","xml":"<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n","comments":"","x":2029.2738571166992,"y":3871.238525799343,"z":"90110745.0f08b8","wires":[]},{"id":"89e6e738.067dc8","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n\n","comments":"","x":1912.7499084472656,"y":4210.047996929714,"z":"90110745.0f08b8","wires":[]},{"id":"e5da090c.731d68","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1720.2738876342773,"y":3921.238203457424,"z":"90110745.0f08b8","wires":[["feb55f31.73e7a","4da56fe5.e07a7","e153c7a4.007a58","89e6e738.067dc8","9ece7ac0.84e2b8"]]},{"id":"4da56fe5.e07a7","type":"switchNode","name":"switch index-exists","xml":"<switch test='`$tmp.gun.index-exists`'>\n","comments":"","outputs":1,"x":1925.0358657836914,"y":4003.3815273557393,"z":"90110745.0f08b8","wires":[["a21cdd7a.49ed","31ea122e.79dede"]]},{"id":"a21cdd7a.49ed","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2103.6072311401367,"y":3979.095795086452,"z":"90110745.0f08b8","wires":[["63c24c47.93cb44"]]},{"id":"31ea122e.79dede","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2103.607246398926,"y":4026.2387203489034,"z":"90110745.0f08b8","wires":[["a5ce5bde.1b0538"]]},{"id":"c6f53c8c.15009","type":"save","name":"save (update) name index","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":2499.3215560913086,"y":3980.5242113385884,"z":"90110745.0f08b8","wires":[["5f753ea1.c860f"]]},{"id":"93519bfb.b8ef58","type":"save","name":"save (insert) name index","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":2492.178535461426,"y":4074.80967944009,"z":"90110745.0f08b8","wires":[["cb6afb42.e26668"]]},{"id":"5f753ea1.c860f","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2692.178756713867,"y":3980.5242304120748,"z":"90110745.0f08b8","wires":[["87791e94.3a263"]]},{"id":"87791e94.3a263","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2846.464572906494,"y":3980.524249485561,"z":"90110745.0f08b8","wires":[]},{"id":"cb6afb42.e26668","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2689.3213272094727,"y":4073.381195477077,"z":"90110745.0f08b8","wires":[["7e817d75.e13cb4"]]},{"id":"7e817d75.e13cb4","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2843.6071434020996,"y":4073.3812145505635,"z":"90110745.0f08b8","wires":[]},{"id":"e153c7a4.007a58","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1959.4644622802734,"y":4161.952501705715,"z":"90110745.0f08b8","wires":[["3737e1de.1f275e"]]},{"id":"3737e1de.1f275e","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2169.4643936157227,"y":4161.952553204128,"z":"90110745.0f08b8","wires":[["c41eb84f.1afce8"]]},{"id":"c41eb84f.1afce8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2323.7502098083496,"y":4161.952572277614,"z":"90110745.0f08b8","wires":[]},{"id":"c87de081.2b7b6","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1822.321548461914,"y":3059.095426968166,"z":"90110745.0f08b8","wires":[["9144f7d0.dfe548","9775d1bd.a31a5","e74cf3af.ae8e8","49a5595e.684d18","30eb1a83.c57be6"]]},{"id":"c9df5194.5868","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2380.8930130004883,"y":3473.3813347135274,"z":"90110745.0f08b8","wires":[["9ffe2099.9294f","745383f6.b6740c"]]},{"id":"63c24c47.93cb44","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2280.8930435180664,"y":3956.2383236203877,"z":"90110745.0f08b8","wires":[["9f7397b5.b8e698","c6f53c8c.15009"]]},{"id":"a5ce5bde.1b0538","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2278.0358963012695,"y":4051.9526418958394,"z":"90110745.0f08b8","wires":[["93519bfb.b8ef58","2396ee2e.6296a2"]]},{"id":"9f7397b5.b8e698","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n","comments":"","x":2469.464324951172,"y":3931.9522952352254,"z":"90110745.0f08b8","wires":[]},{"id":"2396ee2e.6296a2","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n","comments":"","x":2468.035873413086,"y":4026.2381119046895,"z":"90110745.0f08b8","wires":[]},{"id":"398f430e.7a743c","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":2235.17875289917,"y":3564.8098110471456,"z":"90110745.0f08b8","wires":[["efb43154.90976"]]},{"id":"49a5595e.684d18","type":"set","name":"clear namedb.name","xml":"<set>\n<parameter name='tmp.gun.namedb.name' value='' />\n","comments":"","x":2050.892936706543,"y":3314.8097442899434,"z":"90110745.0f08b8","wires":[]},{"id":"4c9e63b6.428eec","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":1497.1786651611328,"y":2807.190584591457,"z":"90110745.0f08b8","wires":[["a88c76d2.c57508"]]},{"id":"a88c76d2.c57508","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1752.8929977416992,"y":2808.095493725368,"z":"90110745.0f08b8","wires":[["7d718b44.ba6f14"]]},{"id":"7d718b44.ba6f14","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n","comments":"","x":1910.0358810424805,"y":2808.095493725368,"z":"90110745.0f08b8","wires":[]},{"id":"15057783.9b13f8","type":"comment","name":"if we get here when there is no index length, then we have used up all 1000","info":"","comments":"","x":1628.6072616577148,"y":2763.8098081861226,"z":"90110745.0f08b8","wires":[]},{"id":"48f231a0.1295b","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n","comments":"","x":1388.6072807312012,"y":4323.095478466579,"z":"90110745.0f08b8","wires":[]},{"id":"4e23a92d.e2e488","type":"set","name":"set found-flag=false","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='false' />\n","comments":"","x":883.0119400024414,"y":1234.2857422147479,"z":"90110745.0f08b8","wires":[]},{"id":"90ee10e.7fdccf","type":"set","name":"set found-flag=true","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n","comments":"","x":2074.6786308288574,"y":1923.0953316007342,"z":"90110745.0f08b8","wires":[]},{"id":"193702b8.5c51ed","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1881.8214530944824,"y":1949.2382759366717,"z":"90110745.0f08b8","wires":[["90ee10e.7fdccf","48493fbe.6eb1a"]]},{"id":"e2c9737b.99e7f","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2540.035732269287,"y":3585.952526501247,"z":"90110745.0f08b8","wires":[]},{"id":"be7d48f6.6006d8","type":"comment","name":"found one we can use","info":"","comments":"","x":2357.8931884765625,"y":3517.0004486356465,"z":"90110745.0f08b8","wires":[]},{"id":"66fa06ee.f98f28","type":"set","name":"set found-flag=true","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n","comments":"","x":2576.9406509399414,"y":3537.7143787656514,"z":"90110745.0f08b8","wires":[]},{"id":"efb43154.90976","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2384.0834732055664,"y":3563.857323101589,"z":"90110745.0f08b8","wires":[["66fa06ee.f98f28","e2c9737b.99e7f"]]},{"id":"583423a0.c77f8c","type":"switchNode","name":"switch generate-unique-name-input.supplied-name","xml":"<switch test='`$generate-unique-name-input.supplied-name`'>\n","comments":"","outputs":1,"x":434.79754638671875,"y":340.7143215451922,"z":"90110745.0f08b8","wires":[["86bad139.04091","9dd1d0d8.1bd5f"]]},{"id":"86bad139.04091","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":693.3690452575684,"y":367.85711710793635,"z":"90110745.0f08b8","wires":[["c38467.17e88b98"]]},{"id":"9dd1d0d8.1bd5f","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":693.3690223693848,"y":310.7142872129168,"z":"90110745.0f08b8","wires":[["f19bef1d.3057b"]]},{"id":"1f92ba68.4441e6","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"<switch test='`$generate-unique-name-input.name-table-type`'>\n","comments":"","outputs":1,"x":1162.6546936035156,"y":246.42856829507014,"z":"90110745.0f08b8","wires":[["3cf36f75.3d9c6"]]},{"id":"3cf36f75.3d9c6","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1495.9878902435303,"y":246.4285778318133,"z":"90110745.0f08b8","wires":[["c20913bc.b8956"]]},{"id":"c20913bc.b8956","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n","comments":"","x":1667.6546669006348,"y":246.76188128335139,"z":"90110745.0f08b8","wires":[]},{"id":"f19bef1d.3057b","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":847.6547470092773,"y":309.28571741921564,"z":"90110745.0f08b8","wires":[["1f92ba68.4441e6","a5541836.ef0a18","f1e52879.fa9cb8"]]},{"id":"f1e52879.fa9cb8","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":1056.2261581420898,"y":339.2857326780047,"z":"90110745.0f08b8","wires":[["324fd762.c67938","5bbbc00e.34e41","85249bc8.1ea708"]]},{"id":"324fd762.c67938","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1238.8452072143555,"y":326.42862837655207,"z":"90110745.0f08b8","wires":[["bf63fff2.0717"]]},{"id":"a5541836.ef0a18","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $generate-unique-name-input.supplied-name'`\" />\n","comments":"","x":1049.7977104187012,"y":291.66675036294123,"z":"90110745.0f08b8","wires":[]},{"id":"5bbbc00e.34e41","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1246.9405632019043,"y":371.66673891884943,"z":"90110745.0f08b8","wires":[["2dce07c3.4cdde8"]]},{"id":"bf63fff2.0717","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the ' + $generate-unique-name-input.name-table-index + ' table'`\" />\n\n","comments":"","x":1394.7976303100586,"y":326.00003378731867,"z":"90110745.0f08b8","wires":[]},{"id":"85249bc8.1ea708","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1239.0833320617676,"y":413.57143252236506,"z":"90110745.0f08b8","wires":[["b470dc23.972cf"]]},{"id":"b470dc23.972cf","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'The name ' + $generate-unique-name-input.supplied-name + ' has already been used'`\" />\n\n","comments":"","x":1394.7975692749023,"y":412.99999659402033,"z":"90110745.0f08b8","wires":[]},{"id":"beb8c925.e74138","type":"comment","name":"Caller supplied name - make sure it's not already used","info":"","comments":"","x":1192.5119018554688,"y":199.85713999611994,"z":"90110745.0f08b8","wires":[]},{"id":"2dce07c3.4cdde8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1396.2262573242188,"y":372.1428455625262,"z":"90110745.0f08b8","wires":[["8c2318a2.ecf138","2d4f1679.5fff5a"]]},{"id":"2d4f1679.5fff5a","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1636.2262573242188,"y":396.42858164651057,"z":"90110745.0f08b8","wires":[["e58686f1.2a8ec8"]]},{"id":"e58686f1.2a8ec8","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1846.226188659668,"y":396.42863314492365,"z":"90110745.0f08b8","wires":[["c3a9c01e.0e1a8"]]},{"id":"c3a9c01e.0e1a8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2000.512004852295,"y":396.42865221841,"z":"90110745.0f08b8","wires":[]},{"id":"8c2318a2.ecf138","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name )'`\" />\n\n","comments":"","x":1596.226188659668,"y":346.4287590299334,"z":"90110745.0f08b8","wires":[]},{"id":"76d2de9f.d1d72","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`\" />\n\n","comments":"","x":1396.2262115478516,"y":2557.8571314130513,"z":"90110745.0f08b8","wires":[]},{"id":"30eb1a83.c57be6","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n","comments":"","x":2044.3215103149414,"y":3430.238300732204,"z":"90110745.0f08b8","wires":[]},{"id":"9ece7ac0.84e2b8","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`\" />\n\n","comments":"","x":1920.0357055664062,"y":4114.523828915188,"z":"90110745.0f08b8","wires":[]},{"id":"77e2ebe5.4aacd4","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2319.083396911621,"y":2422.1428484235494,"z":"90110745.0f08b8","wires":[]},{"id":"a64a1c5c.548e1","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2316.2260093688965,"y":2515.4286293302266,"z":"90110745.0f08b8","wires":[]},{"id":"382ec618.a7ddba","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1032.178508758545,"y":2752.8571705136983,"z":"90110745.0f08b8","wires":[["75ff300b.6f6dc"]]},{"id":"75ff300b.6f6dc","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1183.0119171142578,"y":3364.523694447109,"z":"90110745.0f08b8","wires":[["4c9e63b6.428eec","1185013a.772fcf","cd5abdec.20e31","e38bddb.6889c2","48f231a0.1295b"]]},{"id":"c98722cf.dc1a3","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1149.65482711792,"y":999.2857116971697,"z":"90110745.0f08b8","wires":[["4cecef4a.45b81"]]},{"id":"b91db4d1.5863b8","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1156.2262916564941,"y":1088.4285854612078,"z":"90110745.0f08b8","wires":[["2195c896.9afd38"]]},{"id":"2195c896.9afd38","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1287.654842376709,"y":1087.857191494533,"z":"90110745.0f08b8","wires":[["77a666ae.651d38","70192d95.678c34"]]},{"id":"880d7037.87ac9","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n","comments":"","x":1540.0000267028809,"y":1821.4285945892334,"z":"90110745.0f08b8","wires":[]},{"id":"3e27b62f.f1d58a","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":1541.4286346435547,"y":1908.571517944336,"z":"90110745.0f08b8","wires":[["60c15f95.e82e1","bbed7686.7c8a78"]]},{"id":"68aae923.1b9ef8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":133.75,"y":315.0000047683716,"z":"90110745.0f08b8","wires":[["583423a0.c77f8c","f553193.f9377e8"]]},{"id":"f553193.f9377e8","type":"set","name":"clear variables","xml":"<set>\n<parameter name='generate-unique-name-output.error-message' value='' />\n<parameter name='generate-unique-name-output.generated-name' value='' />\n","comments":"","x":322.50000381469727,"y":290.00000381469727,"z":"90110745.0f08b8","wires":[]}]
+[\r
+    {\r
+        "id": "15040625.d5f40a",\r
+        "type": "comment",\r
+        "name": "Validation of required data",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1362.22216796875,\r
+        "y": 421.29468727111816,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "11c017ed.c4cc98",\r
+        "type": "dgstart",\r
+        "name": "DGSTART",\r
+        "outputs": 1,\r
+        "x": 432.9722709655762,\r
+        "y": 26.69937038421631,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "9f71976e.e5c5f8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "4eedc095.04b8b",\r
+        "type": "method",\r
+        "name": "method generate-unique-name",\r
+        "xml": "<method rpc='generate-unique-name' mode='sync'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 565.8889999389648,\r
+        "y": 99.044602394104,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "360fc793.866bf8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "23286af8.e7fb96",\r
+        "type": "comment",\r
+        "name": "generate-unique-name",\r
+        "info": "Input arguments:\ngenerate-unique-name-input.index-table-name - name of INDEX table\ngenerate-unique-name-input.index-table-prefix-column - name of prefix column in above table\ngenerate-unique-name-input.name-table-name - name of table holding all generated names\ngenerate-unique-name-input.index-length - non-null digit if index should be fixed length\n\nOutput arguments:\ngenerate-unique-name-output.generated-name - generated name (null if error)\ngenerate-unique-name-output.error-message - error message (non-null if error)\n",\r
+        "comments": "",\r
+        "x": 1120.5314331054688,\r
+        "y": 20,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d51fb171.df3c3",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 849.9960746765137,\r
+        "y": 1412.440560749599,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "aeb040b1.610fe",\r
+                "d5c2022c.eb55c",\r
+                "6937019b.7d45d",\r
+                "bcb4efa7.8fb4d",\r
+                "4d3aaea2.1682c",\r
+                "6c67d02f.17bf4",\r
+                "c51e026f.e6689",\r
+                "2d26f683.ab135a",\r
+                "f849cb78.2321f8",\r
+                "59510b56.12c9f4",\r
+                "3e63e2e.8d66c1e",\r
+                "c2125c33.cdb9e"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "aeb040b1.610fe",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-table-name",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-table-name`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1298.8055572509766,\r
+        "y": 466.9048252105713,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1286f8.7a830909"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1286f8.7a830909",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1628.805477142334,\r
+        "y": 466.9048147201538,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c3b06eda.624f2"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c3b06eda.624f2",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-name not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1802.1387977600098,\r
+        "y": 466.90480613708496,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d5c2022c.eb55c",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-table-prefix-column",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-table-prefix-column`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1323.8055267333984,\r
+        "y": 510.23816108703613,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "8b8a2d3c.650b5"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8b8a2d3c.650b5",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1627.1387901306152,\r
+        "y": 510.2381401062012,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2fce40e3.dcb3a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2fce40e3.dcb3a",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-prefix-column not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1800.4721069335938,\r
+        "y": 510.57148361206055,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6937019b.7d45d",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.name-table-type",\r
+        "xml": "<switch test='`$generate-unique-name-input.name-table-type`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1294.805534362793,\r
+        "y": 555.2381534576416,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "fe8ebb70.f12418"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "fe8ebb70.f12418",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1627.1387310028076,\r
+        "y": 555.2381629943848,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c450338.ed9f6d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c450338.ed9f6d",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1798.805507659912,\r
+        "y": 555.5714664459229,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c51e026f.e6689",\r
+        "type": "get-resource",\r
+        "name": "get-resource current name index",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.prefixdb'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1216.829387664795,\r
+        "y": 1114.0355405807495,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2161e5d1.539e3a",\r
+                "b88e0290.6b67d",\r
+                "a98b0c69.c8ff5"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2161e5d1.539e3a",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1444.5198192596436,\r
+        "y": 1200.0594501495361,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d996887b.f8a558"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d996887b.f8a558",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Error reading the ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
+        "comments": "",\r
+        "x": 1607.1389408111572,\r
+        "y": 1201.4881782531738,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b684649d.306688",\r
+        "type": "for",\r
+        "name": "for idx from current index to list-end",\r
+        "xml": "<for index='tmp.gun.idx' start='`$tmp.gun.index-number`' end='`$tmp.gun.list-end`' >\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1371.6627464294434,\r
+        "y": 1442.8571510314941,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c4de9305.e3b5f"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "bcb4efa7.8fb4d",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1134.2817420959473,\r
+        "y": 1442.857116154262,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "b684649d.306688",\r
+                "a13f9156.7cff2",\r
+                "187251ba.f9a6ce"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "a13f9156.7cff2",\r
+        "type": "returnSuccess",\r
+        "name": "CATCH BREAK",\r
+        "xml": "<return status='success'>\n\n",\r
+        "comments": "",\r
+        "x": 1327.472242627825,\r
+        "y": 2467.2858533859253,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4d3aaea2.1682c",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.prefix",\r
+        "xml": "<switch test='`$generate-unique-name-input.prefix`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1260.4721755981445,\r
+        "y": 600.2381324768066,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d42fa470.81ab78"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d42fa470.81ab78",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1627.8053646087646,\r
+        "y": 600.2381572723389,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "af0a5a6c.8f2da8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "af0a5a6c.8f2da8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1800.4721412658691,\r
+        "y": 600.571460723877,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6c67d02f.17bf4",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1283.8055419921875,\r
+        "y": 735.2380743026733,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "185b25b7.55418a",\r
+                "208a685c.353108",\r
+                "d9e7f7d8.523f68",\r
+                "7ee1530f.9a7ebc",\r
+                "157b96c3.7936e9",\r
+                "26eda43b.2c3b5c",\r
+                "59274ef2.cf994"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "185b25b7.55418a",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1627.1388549804688,\r
+        "y": 643.571460723877,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d94c4d3c.5f17d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "157b96c3.7936e9",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1625.9007606506348,\r
+        "y": 918.809588432312,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c70900c9.1665f"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "208a685c.353108",\r
+        "type": "outcome",\r
+        "name": "1",\r
+        "xml": "<outcome value='1'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1624.0436630249023,\r
+        "y": 734.2857999801636,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "923d6c6a.e4f8d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d9e7f7d8.523f68",\r
+        "type": "outcome",\r
+        "name": "2",\r
+        "xml": "<outcome value='2'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1624.0436477661133,\r
+        "y": 779.2857904434204,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d39e047e.b0fc98"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7ee1530f.9a7ebc",\r
+        "type": "outcome",\r
+        "name": "3",\r
+        "xml": "<outcome value='3'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1622.3769836425781,\r
+        "y": 822.6191263198853,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "70f9e263.445b3c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "923d6c6a.e4f8d",\r
+        "type": "set",\r
+        "name": "set list-end = 10",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='10' />\n",\r
+        "comments": "",\r
+        "x": 1806.7103996276855,\r
+        "y": 734.2857885360718,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d39e047e.b0fc98",\r
+        "type": "set",\r
+        "name": "set list-end = 100",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='100' />\n",\r
+        "comments": "",\r
+        "x": 1810.043628692627,\r
+        "y": 779.2857904434204,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "70f9e263.445b3c",\r
+        "type": "set",\r
+        "name": "set list-end = 1000",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='1000' />\n",\r
+        "comments": "",\r
+        "x": 1812.043628692627,\r
+        "y": 822.6191034317017,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c70900c9.1665f",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1796.9006843566895,\r
+        "y": 918.1429586410522,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "80595c6f.d370b",\r
+        "type": "set",\r
+        "name": "set new index number to 1",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-number' value='1' />\n",\r
+        "comments": "",\r
+        "x": 2311.0082054138184,\r
+        "y": 1163.4288799762726,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d94c4d3c.5f17d",\r
+        "type": "set",\r
+        "name": "set list-end = 100000 (infinity basically)",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='100000' />\n",\r
+        "comments": "",\r
+        "x": 1876.1387939453125,\r
+        "y": 643.9048042297363,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "651d8bf.8378c74",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1933.3293266296387,\r
+        "y": 1369.5237898145404,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "485a952f.4683ac",\r
+                "929353b9.9ddf2",\r
+                "fdae624e.d1e4d",\r
+                "f1fa6f3d.9cd86",\r
+                "c12d0b68.b45788"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "485a952f.4683ac",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2217.6150703430176,\r
+        "y": 1220.9523973464966,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "93103f3e.f5587"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "929353b9.9ddf2",\r
+        "type": "outcome",\r
+        "name": "1",\r
+        "xml": "<outcome value='1'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2215.948417663574,\r
+        "y": 1265.9524374008179,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "93103f3e.f5587"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "fdae624e.d1e4d",\r
+        "type": "outcome",\r
+        "name": "2",\r
+        "xml": "<outcome value='2'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2215.948402404785,\r
+        "y": 1315.0000638961792,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "fe2daf39.916f2"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f1fa6f3d.9cd86",\r
+        "type": "outcome",\r
+        "name": "3",\r
+        "xml": "<outcome value='3'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2217.3770751953125,\r
+        "y": 1417.381145477295,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "9b7d9fc5.77d19"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "93103f3e.f5587",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 2402.615219116211,\r
+        "y": 1239.285740852356,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "fe2daf39.916f2",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 10",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2382.615032196045,\r
+        "y": 1314.9999618530273,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1e14c0e7.34b7bf",\r
+                "837fdec7.0a022"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1e14c0e7.34b7bf",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2544.281665802002,\r
+        "y": 1288.3333349227905,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3fe02145.d703be"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "837fdec7.0a022",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2544.281623840332,\r
+        "y": 1336.6666707992554,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "461425f5.d0f43c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3fe02145.d703be",\r
+        "type": "set",\r
+        "name": "set index-string to '0' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 2735.9484252929688,\r
+        "y": 1287.6665620803833,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "461425f5.d0f43c",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 2719.2816772460938,\r
+        "y": 1336.3332777023315,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9b7d9fc5.77d19",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 10",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2385.7104110717773,\r
+        "y": 1415.7142734527588,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "e219ec7e.fe57c",\r
+                "ad55e1a8.b6075"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e219ec7e.fe57c",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2545.7103881835938,\r
+        "y": 1389.0476512908936,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "22b4d6dc.cf442a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ad55e1a8.b6075",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2550.2340087890625,\r
+        "y": 1465.4762334823608,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "dbe69aa8.33eda8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "22b4d6dc.cf442a",\r
+        "type": "set",\r
+        "name": "set index-string to '00' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 2740.710479736328,\r
+        "y": 1389.047542163304,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "dbe69aa8.33eda8",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 100",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2706.5673904418945,\r
+        "y": 1463.809594154358,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f7ffce1d.63fe1",\r
+                "67fc8e98.639b9"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f7ffce1d.63fe1",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2863.567367553711,\r
+        "y": 1437.1429719924927,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1c294f19.3865c1"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "67fc8e98.639b9",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2863.567325592041,\r
+        "y": 1485.4763078689575,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3ab4c683.87c0fa"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1c294f19.3865c1",\r
+        "type": "set",\r
+        "name": "set index-string to '0' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3056.2341537475586,\r
+        "y": 1436.8096265792847,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "3ab4c683.87c0fa",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 3040.2341384887695,\r
+        "y": 1485.1429300308228,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c81549dd.4990b8",\r
+        "type": "set",\r
+        "name": "set generated-name to prefix + index-string",\r
+        "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n",\r
+        "comments": "",\r
+        "x": 1917.329418182373,\r
+        "y": 1646.1904386792864,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "27f2f9ab.7e2c26",\r
+        "type": "comment",\r
+        "name": "First check from the current index to the max index",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1334.9960899353027,\r
+        "y": 1381.1905197416033,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4eb7a743.5209e8",\r
+        "type": "comment",\r
+        "name": "check if we've used this name before",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1914.0439414978027,\r
+        "y": 1730.4765844345093,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "be62e7ae.90b8f8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2021.662742614746,\r
+        "y": 1807.8573669706072,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "dfb2aa84.9b4598"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1d6bb1a2.44855e",\r
+        "type": "set",\r
+        "name": "set generate-unique-name-output.error-message",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n",\r
+        "comments": "",\r
+        "x": 2467.6149940490723,\r
+        "y": 1781.4286999021258,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "a5f867db.9d9558",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2332.853240966797,\r
+        "y": 1826.428787640163,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ad173e2b.5c512",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2335.710262298584,\r
+        "y": 1921.3334783826556,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c15de393.a41e9",\r
+        "type": "comment",\r
+        "name": "found one we can use",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2153.5677185058594,\r
+        "y": 1852.381400517055,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "2d26f683.ab135a",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-output.error-message",\r
+        "xml": "<switch test='`$generate-unique-name-output.error-message`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1209.5437147957937,\r
+        "y": 2679.2858324050903,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "77705736.9ef7c8",\r
+                "68085745.a74d48"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "77705736.9ef7c8",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1482.8771231515066,\r
+        "y": 2652.6190843582153,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "bdffcfcf.9486c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "bdffcfcf.9486c",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1617.8771231515066,\r
+        "y": 2652.6190843582153,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "68085745.a74d48",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1482.8770888192312,\r
+        "y": 2702.6191053390503,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2c4c0bf4.4ba724"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2c4c0bf4.4ba724",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 1632.8770888192312,\r
+        "y": 2702.6191053390503,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f849cb78.2321f8",\r
+        "type": "switchNode",\r
+        "name": "switch found-flag",\r
+        "xml": "<switch test='`$tmp.gun.found-flag`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1101.5437605721609,\r
+        "y": 3033.571455001831,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f2e8b24d.e7494",\r
+                "c4268ba7.916128"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f2e8b24d.e7494",\r
+        "type": "outcome",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1275.877100263323,\r
+        "y": 3033.5714559555054,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "db1278f8.147038"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "b4aa117c.62303",\r
+        "type": "set",\r
+        "name": "set generate-unique-name-output.generated-name",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n",\r
+        "comments": "",\r
+        "x": 1746.5437147957937,\r
+        "y": 2878.5717420578003,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "144ff8a5.06a137",\r
+        "type": "returnSuccess",\r
+        "name": "return success",\r
+        "xml": "<return status='success'>\n",\r
+        "comments": "",\r
+        "x": 1628.591284070696,\r
+        "y": 3215.952536582947,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "db1278f8.147038",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1427.5437300545827,\r
+        "y": 3032.904870033264,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "b4aa117c.62303",\r
+                "58767fb5.799f",\r
+                "7332878a.b6d298",\r
+                "144ff8a5.06a137",\r
+                "b3a55875.754e68"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3d4b23e4.f03d2c",\r
+        "type": "set",\r
+        "name": "set index-exists flag to false",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-exists' value='false' />\n",\r
+        "comments": "",\r
+        "x": 1778.8055992126465,\r
+        "y": 1080.8929452896118,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "7b63453a.f976cc",\r
+        "type": "set",\r
+        "name": "set index-exists flag to true",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-exists' value='true' />\n",\r
+        "comments": "",\r
+        "x": 1777.448543548584,\r
+        "y": 984.8214712142944,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f97c717e.aeece",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1584.1628150939941,\r
+        "y": 1006.2500772476196,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "7b63453a.f976cc",\r
+                "dc9a064f.20c918"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "58767fb5.799f",\r
+        "type": "switchNode",\r
+        "name": "switch index-exists",\r
+        "xml": "<switch test='`$tmp.gun.index-exists`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1642.3057234627859,\r
+        "y": 3010.714743614197,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "6a0af996.974498",\r
+                "6c8e2cbe.78d944"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6a0af996.974498",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1820.8770888192312,\r
+        "y": 2986.4290113449097,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "87bbd73a.280a98"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6c8e2cbe.78d944",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1820.8771040780202,\r
+        "y": 3033.571936607361,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "784e1241.16399c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9bc6db3a.e853b8",\r
+        "type": "save",\r
+        "name": "save (update) name index",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2216.591413770403,\r
+        "y": 2987.857427597046,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3aaf9849.6999f8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "853b68e5.628e58",\r
+        "type": "save",\r
+        "name": "save (insert) name index",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2209.4483931405202,\r
+        "y": 3082.1428956985474,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "8c884666.ad49c8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3aaf9849.6999f8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2409.4486143929616,\r
+        "y": 2987.857446670532,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "b2adf596.b14dc8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8c884666.ad49c8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2406.591184888567,\r
+        "y": 3080.7144117355347,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "a521b607.e28cf8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7332878a.b6d298",\r
+        "type": "save",\r
+        "name": "save (insert) generated name",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1676.734319959368,\r
+        "y": 3169.2857179641724,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ecbc8e26.1fa38"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ecbc8e26.1fa38",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1886.734251294817,\r
+        "y": 3169.2857694625854,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1f5bf102.8c12af"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "1f5bf102.8c12af",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
+        "comments": "",\r
+        "x": 2041.020067487444,\r
+        "y": 3169.285788536072,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "59510b56.12c9f4",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from ' + $generate-unique-name-input.index-table-name\n+ ' WHERE ' + $generate-unique-name-input.index-table-prefix-column + ' = '\n+ '$generate-unique-name-input.prefix'`\" />\n",\r
+        "comments": "",\r
+        "x": 1172.734218597412,\r
+        "y": 964.8215706348419,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c4de9305.e3b5f",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1613.805606842041,\r
+        "y": 1442.4286302839007,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "651d8bf.8378c74",\r
+                "c81549dd.4990b8",\r
+                "5cfa637b.4338bc",\r
+                "a3abe6b2.a53fb8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dfb2aa84.9b4598",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2174.0437393188477,\r
+        "y": 1807.381286076137,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1d6bb1a2.44855e",\r
+                "a5f867db.9d9558"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "87bbd73a.280a98",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1998.1629011971609,\r
+        "y": 2963.571539878845,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "5830bf50.31dae",\r
+                "9bc6db3a.e853b8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "784e1241.16399c",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1995.305753980364,\r
+        "y": 3059.285858154297,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "853b68e5.628e58",\r
+                "88572550.cad9b8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5830bf50.31dae",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n",\r
+        "comments": "",\r
+        "x": 2186.7341826302663,\r
+        "y": 2939.285511493683,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "88572550.cad9b8",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 2185.3057310921804,\r
+        "y": 3033.571328163147,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "96f6c88d.8b7e38",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2028.3294792175293,\r
+        "y": 1898.8097624097552,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "41d904c1.515ddc"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "bf503344.2453a",\r
+        "type": "for",\r
+        "name": "for idx from 1 to current index",\r
+        "xml": "<for index='tmp.gun.idx' start='1' end='`$tmp.gun.index-number`' >\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1828.1153014046804,\r
+        "y": 3705.5238943099976,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d892995.bb30f68"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7c854eaa.cabde",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1614.4485479082377,\r
+        "y": 3705.523872920445,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "bf503344.2453a",\r
+                "9ffe82b8.b73ec"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9ffe82b8.b73ec",\r
+        "type": "returnSuccess",\r
+        "name": "CATCH BREAK",\r
+        "xml": "<return status='success'>\n\n",\r
+        "comments": "",\r
+        "x": 1779.0676939828054,\r
+        "y": 4280.524024963379,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "94f9f0ef.6fa0d",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2375.781873975481,\r
+        "y": 3660.1906385421753,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "266ce65b.b0b66a",\r
+                "97bab24a.c840c",\r
+                "3d984119.5f033e",\r
+                "3e3c8d28.fe1a32"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "266ce65b.b0b66a",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2655.781873975481,\r
+        "y": 3590.1906995773315,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "dfbbc1b8.5e5ce"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "97bab24a.c840c",\r
+        "type": "outcome",\r
+        "name": "1",\r
+        "xml": "<outcome value='1'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2654.115221296038,\r
+        "y": 3635.190739631653,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "dfbbc1b8.5e5ce"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3d984119.5f033e",\r
+        "type": "outcome",\r
+        "name": "2",\r
+        "xml": "<outcome value='2'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2654.115309034075,\r
+        "y": 3688.5240869522095,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "deb2ba7e.8c5978"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3e3c8d28.fe1a32",\r
+        "type": "outcome",\r
+        "name": "3",\r
+        "xml": "<outcome value='3'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2654.1151869637624,\r
+        "y": 3785.1908197402954,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "eb7b9bc3.3d21f8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dfbbc1b8.5e5ce",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 2840.7820227486745,\r
+        "y": 3608.524043083191,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "deb2ba7e.8c5978",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 10",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2820.7819388253347,\r
+        "y": 3688.5239849090576,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "937abb25.5405e8",\r
+                "5f465025.bda92"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "937abb25.5405e8",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2982.4485724312917,\r
+        "y": 3661.857357978821,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "b0abf2f9.7e53f"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5f465025.bda92",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2982.448530469622,\r
+        "y": 3710.1906938552856,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ba4422ab.99ab3"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "b0abf2f9.7e53f",\r
+        "type": "set",\r
+        "name": "set index-string to '0' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3174.1153319222585,\r
+        "y": 3661.1905851364136,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ba4422ab.99ab3",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 3157.4485838753835,\r
+        "y": 3709.857300758362,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "eb7b9bc3.3d21f8",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 10",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2822.4485228402273,\r
+        "y": 3783.5239477157593,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "14d2288c.c6a057",\r
+                "d8edd84e.af3bc8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "14d2288c.c6a057",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2982.4484999520437,\r
+        "y": 3756.857325553894,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "62627b5d.5978e4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d8edd84e.af3bc8",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2984.1151564461843,\r
+        "y": 3831.857283592224,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "30bfdb15.2f8ad4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "62627b5d.5978e4",\r
+        "type": "set",\r
+        "name": "set index-string to '00' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3177.4485838753835,\r
+        "y": 3756.857300758362,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "30bfdb15.2f8ad4",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 100",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3140.4485380990163,\r
+        "y": 3830.190644264221,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "440bf02e.68e61",\r
+                "b8862f98.abf7a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "440bf02e.68e61",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3297.4485152108327,\r
+        "y": 3803.524022102356,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ba35148d.b73588"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "b8862f98.abf7a",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3297.448473249163,\r
+        "y": 3851.857357978821,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "e6bfcbc8.332388"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ba35148d.b73588",\r
+        "type": "set",\r
+        "name": "set index-string to '0' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3490.1153014046804,\r
+        "y": 3803.190676689148,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e6bfcbc8.332388",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 3474.1152861458913,\r
+        "y": 3851.523980140686,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "360242d5.db658e",\r
+        "type": "set",\r
+        "name": "set generated-name to prefix + index-string",\r
+        "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n",\r
+        "comments": "",\r
+        "x": 2373.781957898821,\r
+        "y": 3908.857216835022,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b69ff8cc.8d9308",\r
+        "type": "comment",\r
+        "name": "Wrapping around - now check from 1 to the original index",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1805.4486220223562,\r
+        "y": 3635.0002088546753,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "47e5b18f.a8b23",\r
+        "type": "comment",\r
+        "name": "check if we've used this name before",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2360.4964049203054,\r
+        "y": 4023.857490539551,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ef79ae3c.17c5f",\r
+        "type": "get-resource",\r
+        "name": "get-resource name",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2298.115221296038,\r
+        "y": 4164.571560450962,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "5a089be5.cf97a4",\r
+                "66a1cd31.360d64"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5a089be5.cf97a4",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2476.4486143929616,\r
+        "y": 4118.857397079468,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c2df42b8.3c5f6"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "abf5ee3d.5d0ca",\r
+        "type": "set",\r
+        "name": "set generate-unique-name-output.error-message",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"Error reading the GENERIC_RESOURCE_NAME table\" />\n",\r
+        "comments": "",\r
+        "x": 2922.400865827288,\r
+        "y": 4092.4287300109863,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ee79f6f.5d57b08",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2787.6391127450124,\r
+        "y": 4137.428817749023,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "cbbbd754.515278",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-output.error-message",\r
+        "xml": "<switch test='`$generate-unique-name-output.error-message`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1760.4961912972585,\r
+        "y": 4388.381100654602,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "73a8a16e.756ef",\r
+                "4bea28c3.456028"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "73a8a16e.756ef",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2033.8295996529714,\r
+        "y": 4361.714352607727,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "590a39c2.d91d98"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "590a39c2.d91d98",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2168.8295996529714,\r
+        "y": 4361.714352607727,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            []\r
+        ]\r
+    },\r
+    {\r
+        "id": "4bea28c3.456028",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2033.829565320696,\r
+        "y": 4411.714373588562,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "8722b32b.fe33e"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8722b32b.fe33e",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2183.829565320696,\r
+        "y": 4411.714373588562,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "8da20e83.48444",\r
+        "type": "switchNode",\r
+        "name": "switch found-flag",\r
+        "xml": "<switch test='`$tmp.gun.found-flag`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1642.2104704720632,\r
+        "y": 4567.905009269714,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f9025718.d4df88"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f8c693e4.938fc",\r
+        "type": "comment",\r
+        "name": "if db name is null we found an index we can use",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1808.9248106820241,\r
+        "y": 4517.428784370422,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f9025718.d4df88",\r
+        "type": "outcome",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1801.543791089739,\r
+        "y": 4567.90496635437,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "9c3c38a7.e59808"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8210dd08.26216",\r
+        "type": "set",\r
+        "name": "set generate-unique-name-output.generated-name",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n",\r
+        "comments": "",\r
+        "x": 2277.210455213274,\r
+        "y": 4516.238507270813,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4dec686e.afd348",\r
+        "type": "returnSuccess",\r
+        "name": "return success",\r
+        "xml": "<return status='success'>\n\n",\r
+        "comments": "",\r
+        "x": 2160.6865065438406,\r
+        "y": 4855.047978401184,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9c3c38a7.e59808",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1968.2104857308523,\r
+        "y": 4566.238184928894,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "8210dd08.26216",\r
+                "9338bb2.be33d48",\r
+                "b455fb93.d28c68",\r
+                "4dec686e.afd348",\r
+                "144fc795.5db808"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9338bb2.be33d48",\r
+        "type": "switchNode",\r
+        "name": "switch index-exists",\r
+        "xml": "<switch test='`$tmp.gun.index-exists`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2172.9724638802663,\r
+        "y": 4648.3815088272095,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "530cf58c.b30b3c",\r
+                "997dbf86.ec5ba"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "530cf58c.b30b3c",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2351.5438292367116,\r
+        "y": 4624.095776557922,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "88dfc88f.8aa898"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "997dbf86.ec5ba",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2351.5438444955007,\r
+        "y": 4671.2387018203735,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ae410bc8.d50898"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "66b73d5a.256d54",\r
+        "type": "save",\r
+        "name": "save (update) name index",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2747.2581541878835,\r
+        "y": 4625.524192810059,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d51a3ac.e56a6c8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "be1fac83.ec839",\r
+        "type": "save",\r
+        "name": "save (insert) name index",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2740.1151335580007,\r
+        "y": 4719.80966091156,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "414271a5.32692"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d51a3ac.e56a6c8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2940.115354810442,\r
+        "y": 4625.524211883545,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "9e2a4e5b.2a075"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9e2a4e5b.2a075",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
+        "comments": "",\r
+        "x": 3094.401171003069,\r
+        "y": 4625.524230957031,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "414271a5.32692",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2937.2579253060476,\r
+        "y": 4718.381176948547,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3cd4c5c8.3c566a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3cd4c5c8.3c566a",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
+        "comments": "",\r
+        "x": 3091.5437414986745,\r
+        "y": 4718.381196022034,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b455fb93.d28c68",\r
+        "type": "save",\r
+        "name": "save (insert) generated name",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2207.4010603768484,\r
+        "y": 4806.952483177185,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "5344afb8.38666"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5344afb8.38666",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2417.4009917122976,\r
+        "y": 4806.952534675598,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "94a9b8e7.dc94f8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "94a9b8e7.dc94f8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
+        "comments": "",\r
+        "x": 2571.6868079049245,\r
+        "y": 4806.9525537490845,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d892995.bb30f68",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2070.258146558489,\r
+        "y": 3704.0954084396362,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "94f9f0ef.6fa0d",\r
+                "360242d5.db658e",\r
+                "ef79ae3c.17c5f",\r
+                "72aa4efd.c0c88",\r
+                "6dd3f32a.b9635c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c2df42b8.3c5f6",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2628.829611097063,\r
+        "y": 4118.381316184998,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "abf5ee3d.5d0ca",\r
+                "ee79f6f.5d57b08"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "88dfc88f.8aa898",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2528.8296416146413,\r
+        "y": 4601.238305091858,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "947dd966.3194a8",\r
+                "66b73d5a.256d54"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ae410bc8.d50898",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2525.9724943978445,\r
+        "y": 4696.95262336731,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "be1fac83.ec839",\r
+                "6a923ca1.f35424"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "947dd966.3194a8",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n",\r
+        "comments": "",\r
+        "x": 2717.400923047747,\r
+        "y": 4576.952276706696,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6a923ca1.f35424",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 2715.972471509661,\r
+        "y": 4671.23809337616,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "66a1cd31.360d64",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2483.115350995745,\r
+        "y": 4209.809792518616,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "8688c71d.6f6348"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "72aa4efd.c0c88",\r
+        "type": "set",\r
+        "name": "clear namedb.name",\r
+        "xml": "<set>\n<parameter name='tmp.gun.namedb.name' value='' />\n",\r
+        "comments": "",\r
+        "x": 2298.829534803118,\r
+        "y": 3959.8097257614136,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "f36b5bce.ce38d8",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1743.1152479989187,\r
+        "y": 3538.1906385421753,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "81e22e00.c515a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "81e22e00.c515a",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1998.829580579485,\r
+        "y": 3539.0955476760864,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "76724a0a.7f9af4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "76724a0a.7f9af4",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n",\r
+        "comments": "",\r
+        "x": 2155.9724638802663,\r
+        "y": 3539.0955476760864,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9b5b9cd9.fbaa6",\r
+        "type": "comment",\r
+        "name": "if we get here when there is no index length, then we have used up all 1000",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1874.5438444955007,\r
+        "y": 3494.809862136841,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "8e750ec7.2ae83",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n",\r
+        "comments": "",\r
+        "x": 1636.543878827776,\r
+        "y": 4968.095459938049,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "3e63e2e.8d66c1e",\r
+        "type": "set",\r
+        "name": "set found-flag=false",\r
+        "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='false' />\n",\r
+        "comments": "",\r
+        "x": 1178.4484672546387,\r
+        "y": 1258.0357694625854,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "2276b160.a9183e",\r
+        "type": "set",\r
+        "name": "set found-flag=true",\r
+        "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
+        "comments": "",\r
+        "x": 2372.6151809692383,\r
+        "y": 1873.0953306470599,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "41d904c1.515ddc",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2179.7580032348633,\r
+        "y": 1899.2382749829974,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2276b160.a9183e",\r
+                "ad173e2b.5c512"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "19972ef5.57be21",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2787.972330365862,\r
+        "y": 4230.952507972717,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e21c1774.c206a8",\r
+        "type": "comment",\r
+        "name": "found one we can use",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2605.8297865731374,\r
+        "y": 4162.000430107117,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "eaee2222.dfde9",\r
+        "type": "set",\r
+        "name": "set found-flag=true",\r
+        "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
+        "comments": "",\r
+        "x": 2824.8772490365163,\r
+        "y": 4182.714360237122,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "8688c71d.6f6348",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2632.0200713021413,\r
+        "y": 4208.857304573059,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "eaee2222.dfde9",\r
+                "19972ef5.57be21"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3e4250a5.0ac4c",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.supplied-name",\r
+        "xml": "<switch test='`$generate-unique-name-input.supplied-name`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 732.7340965270996,\r
+        "y": 290.7143205915179,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d25a80d5.4e3b8",\r
+                "b7f46cb8.21a18"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "d25a80d5.4e3b8",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 991.3055953979492,\r
+        "y": 317.85711615426203,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d51fb171.df3c3"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "b7f46cb8.21a18",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 991.3055725097656,\r
+        "y": 259.7142862592425,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "12ab5681.ce04d9"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "130234ee.46d2ab",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.name-table-type",\r
+        "xml": "<switch test='`$generate-unique-name-input.name-table-type`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1460.5912437438965,\r
+        "y": 196.42856734139582,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "15992563.c8c55b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "15992563.c8c55b",\r
+        "type": "outcome",\r
+        "name": "NULL",\r
+        "xml": "<outcome value=''>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1793.9244403839111,\r
+        "y": 196.42857687813898,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "47420284.6ade7c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "47420284.6ade7c",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n",\r
+        "comments": "",\r
+        "x": 1965.5912170410156,\r
+        "y": 196.76188032967707,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "12ab5681.ce04d9",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1145.5912971496582,\r
+        "y": 259.2857164655413,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "130234ee.46d2ab",\r
+                "aabd4d90.16dd8",\r
+                "23a0ac.95990f54"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "23a0ac.95990f54",\r
+        "type": "get-resource",\r
+        "name": "get-resource name",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1354.1627082824707,\r
+        "y": 289.2857317243304,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "6d7e1700.805508",\r
+                "5e3c9b34.a10a74",\r
+                "65ca162d.6df4c8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6d7e1700.805508",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1536.7817573547363,\r
+        "y": 276.42862742287775,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2d9f6bb3.0fef44"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "aabd4d90.16dd8",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $generate-unique-name-input.supplied-name'`\" />\n",\r
+        "comments": "",\r
+        "x": 1347.734260559082,\r
+        "y": 241.6667494092669,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5e3c9b34.a10a74",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1544.8771133422852,\r
+        "y": 321.6667379651751,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ef3f7999.12f238"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2d9f6bb3.0fef44",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the ' + $generate-unique-name-input.name-table-index + ' table'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 1692.7341804504395,\r
+        "y": 276.00003283364435,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "65ca162d.6df4c8",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1537.0198822021484,\r
+        "y": 363.57143156869074,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "4d68280b.2d7b18"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "4d68280b.2d7b18",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'The name ' + $generate-unique-name-input.supplied-name + ' has already been used'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 1692.7341194152832,\r
+        "y": 362.999995640346,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6ed6588d.7a0f78",\r
+        "type": "comment",\r
+        "name": "Caller supplied name - make sure it's not already used",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1387.7699127197266,\r
+        "y": 154.1428575515747,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ef3f7999.12f238",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1694.1628074645996,\r
+        "y": 322.1428446088519,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "553234b3.8d5a7c",\r
+                "be029280.19e4b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "be029280.19e4b",\r
+        "type": "save",\r
+        "name": "save (insert) generated name",\r
+        "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1934.1628074645996,\r
+        "y": 346.42858069283625,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "94aa6f8b.9aaf4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "94aa6f8b.9aaf4",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2144.162738800049,\r
+        "y": 346.42863219124933,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "98e91b64.eafea8"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "98e91b64.eafea8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n<parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
+        "comments": "",\r
+        "x": 2298.448554992676,\r
+        "y": 346.42865126473566,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "553234b3.8d5a7c",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name , null , null, $generate-unique-name-input.service-instance-id )'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 1894.1627388000488,\r
+        "y": 296.4287580762591,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b3a55875.754e68",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' \n\tvalue=\"`'insert into GENERIC_RESOURCE_NAME values ( $generate-unique-name-input.name-table-type , $tmp.gun.generated-name , $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ' , $tmp.gun.transient )'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 1638.1627791268484,\r
+        "y": 3122.857078552246,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6dd3f32a.b9635c",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
+        "comments": "",\r
+        "x": 2292.2581084115163,\r
+        "y": 4075.2382822036743,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "144fc795.5db808",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' \n\tvalue=\"`'insert into GENERIC_RESOURCE_NAME values ( $generate-unique-name-input.name-table-type , $tmp.gun.generated-name , $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ' , $tmp.gun.transient )'`\" />\n\n",\r
+        "comments": "",\r
+        "x": 2167.972303662981,\r
+        "y": 4759.523810386658,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b2adf596.b14dc8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
+        "comments": "",\r
+        "x": 2561.019964490618,\r
+        "y": 2987.142795562744,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "a521b607.e28cf8",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
+        "comments": "",\r
+        "x": 2558.1625769478933,\r
+        "y": 3080.4285764694214,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c4268ba7.916128",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1280.1151068551198,\r
+        "y": 3397.8571519851685,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "59148c70.cdee34"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "59148c70.cdee34",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1430.9485152108327,\r
+        "y": 4009.523675918579,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f36b5bce.ce38d8",\r
+                "7c854eaa.cabde",\r
+                "cbbbd754.515278",\r
+                "8da20e83.48444",\r
+                "8e750ec7.2ae83",\r
+                "974e3eea.a57fc"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "a98b0c69.c8ff5",\r
+        "type": "success",\r
+        "name": "success",\r
+        "xml": "<outcome value='success'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1445.0913696289062,\r
+        "y": 1005.5357429981232,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f97c717e.aeece"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "b88e0290.6b67d",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1451.6628875732422,\r
+        "y": 1112.1785898208618,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "4201eca6.c7d3f4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "4201eca6.c7d3f4",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1583.091438293457,\r
+        "y": 1111.607195854187,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3d4b23e4.f03d2c",\r
+                "e19f8c74.cb7de"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "a3abe6b2.a53fb8",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
+        "comments": "",\r
+        "x": 1837.9365768432617,\r
+        "y": 1771.428593635559,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "5cfa637b.4338bc",\r
+        "type": "get-resource",\r
+        "name": "get-resource name",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1839.3651847839355,\r
+        "y": 1858.5715169906616,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "be62e7ae.90b8f8",\r
+                "96f6c88d.8b7e38"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "360fc793.866bf8",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 431.68655014038086,\r
+        "y": 265.00000381469727,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "3e4250a5.0ac4c",\r
+                "dcbeacf.6f2ab5"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dcbeacf.6f2ab5",\r
+        "type": "set",\r
+        "name": "clear variables",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value='' />\n<parameter name='generate-unique-name-output.generated-name' value='' />\n",\r
+        "comments": "",\r
+        "x": 619.0079803466797,\r
+        "y": 242.8571424484253,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "26eda43b.2c3b5c",\r
+        "type": "outcome",\r
+        "name": "0",\r
+        "xml": "<outcome value='0'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1624.1148872375488,\r
+        "y": 690.3571691513062,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "e3969b91.7deb58"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e3969b91.7deb58",\r
+        "type": "set",\r
+        "name": "set list-end = 0",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='0' />\n",\r
+        "comments": "",\r
+        "x": 1813.7815322875977,\r
+        "y": 690.3571462631226,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "187251ba.f9a6ce",\r
+        "type": "switchNode",\r
+        "name": "switch tmp.gun.noindex-flag",\r
+        "xml": "<switch test='`$tmp.gun.noindex-flag`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1388.6150038582937,\r
+        "y": 2054.000086784363,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "47d30b82.5fa434"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "dc9a064f.20c918",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1844.9008140563965,\r
+        "y": 1030.4285879135132,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "35b6590.63450a8",\r
+                "7a0d894c.1efd48"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "35b6590.63450a8",\r
+        "type": "outcome",\r
+        "name": "0",\r
+        "xml": "<outcome value='0'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2111.1508140563965,\r
+        "y": 1058.6785898208618,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ca199039.4ea94"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7a0d894c.1efd48",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2112.650810241699,\r
+        "y": 998.6785879135132,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "5e88e850.5de788"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5e88e850.5de788",\r
+        "type": "set",\r
+        "name": "increment index number",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-number' value='`$tmp.gun.prefixdb.index-number + 1`' />\n",\r
+        "comments": "",\r
+        "x": 2305.150810241699,\r
+        "y": 998.4285879135132,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "85418744.04a698",\r
+        "type": "set",\r
+        "name": "set  index number to 0",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-number' value='0' />\n",\r
+        "comments": "",\r
+        "x": 2449.1510581970215,\r
+        "y": 1060.4285879135132,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e19f8c74.cb7de",\r
+        "type": "switchNode",\r
+        "name": "switch generate-unique-name-input.index-length",\r
+        "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1842.4008140563965,\r
+        "y": 1141.4285898208618,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "9925306e.7b5d6",\r
+                "4fb0aa57.8d75b4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "4fb0aa57.8d75b4",\r
+        "type": "other",\r
+        "name": "other",\r
+        "xml": "<outcome value='Other'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2112.400810241699,\r
+        "y": 1163.4285898208618,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "80595c6f.d370b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "9925306e.7b5d6",\r
+        "type": "outcome",\r
+        "name": "0",\r
+        "xml": "<outcome value='0'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2112.400833129883,\r
+        "y": 1107.1785457134247,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "ca199039.4ea94"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "ca199039.4ea94",\r
+        "type": "block",\r
+        "name": "block",\r
+        "xml": "<block>\n",\r
+        "atomic": "false",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2261.150806427002,\r
+        "y": 1085.9285879135132,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "85418744.04a698",\r
+                "c639252a.452078"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c639252a.452078",\r
+        "type": "set",\r
+        "name": "set noindex-flag=true",\r
+        "xml": "<set>\n<parameter name='tmp.gun.noindex-flag' value='true' />\n",\r
+        "comments": "",\r
+        "x": 2448.650775909424,\r
+        "y": 1109.4285726547241,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "4139d69a.f19178",\r
+        "type": "set",\r
+        "name": "set generated-name to prefix",\r
+        "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix`' />\n",\r
+        "comments": "",\r
+        "x": 1991.650854383196,\r
+        "y": 2105.428624153137,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "47d30b82.5fa434",\r
+        "type": "outcome",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1585.936540876116,\r
+        "y": 2054.000069618225,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "6400bec6.70c0b"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6400bec6.70c0b",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 1737.3648970467702,\r
+        "y": 2054.0001916885376,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1d2241eb.be7a9e",\r
+                "8c4f455f.ad7488",\r
+                "4139d69a.f19178",\r
+                "e298800b.28418"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "8c4f455f.ad7488",\r
+        "type": "set",\r
+        "name": "set sql statement",\r
+        "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
+        "comments": "",\r
+        "x": 1958.6389601571218,\r
+        "y": 2148.286027908325,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1d2241eb.be7a9e",\r
+        "type": "get-resource",\r
+        "name": "get-resource name",\r
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1965.3533537728445,\r
+        "y": 2192.4287090301514,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "c3e26aa5.5a6ad8",\r
+                "f20ea659.abb5d8",\r
+                "ddda4cb5.69a3c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c3e26aa5.5a6ad8",\r
+        "type": "failure",\r
+        "name": "failure",\r
+        "xml": "<outcome value='failure'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2157.6509650094167,\r
+        "y": 2191.7145656858174,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "e6b7e26f.94d48"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f20ea659.abb5d8",\r
+        "type": "not-found",\r
+        "name": "not-found",\r
+        "xml": "<outcome value='not-found'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2164.3177016122,\r
+        "y": 2282.6669611249654,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f1cf4980.556c18"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "f1cf4980.556c18",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2347.1746297563823,\r
+        "y": 2282.0954637527466,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "825e78.6ae53188",\r
+                "caf8b992.a7b668"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "caf8b992.a7b668",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2503.126888820103,\r
+        "y": 2304.190667152405,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "825e78.6ae53188",\r
+        "type": "set",\r
+        "name": "set found-flag=true",\r
+        "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
+        "comments": "",\r
+        "x": 2540.0318074907573,\r
+        "y": 2255.952519416809,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "63ab1b54.3f87f4",\r
+        "type": "returnFailure",\r
+        "name": "BREAK",\r
+        "xml": "<return status='failure'>\n",\r
+        "comments": "",\r
+        "x": 2468.8414633614675,\r
+        "y": 2210.285986355373,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "b2a157a3.5da4b8",\r
+        "type": "set",\r
+        "name": "set generate-unique-name-output.error-message",\r
+        "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n",\r
+        "comments": "",\r
+        "x": 2603.603216443743,\r
+        "y": 2165.285898617336,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e6b7e26f.94d48",\r
+        "type": "block",\r
+        "name": "block : atomic",\r
+        "xml": "<block atomic=\"true\">",\r
+        "atomic": "true",\r
+        "outputs": 1,\r
+        "x": 2310.0319617135183,\r
+        "y": 2191.238484791347,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "b2a157a3.5da4b8",\r
+                "63ab1b54.3f87f4"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c261792d.2d6c28",\r
+        "type": "comment",\r
+        "name": "found one we can use",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 2320.9843450273784,\r
+        "y": 2235.238589286804,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "412400cc.a3efa",\r
+        "type": "comment",\r
+        "name": "NEW",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1517.9363158089773,\r
+        "y": 697.1428834370204,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9e0fc23a.f7e51",\r
+        "type": "comment",\r
+        "name": "NEW",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1387.3651237487793,\r
+        "y": 2019.7142505645752,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e7d53672.156128",\r
+        "type": "comment",\r
+        "name": "NEW",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1987.9365043640137,\r
+        "y": 997.1428213119507,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c8a8f3.23f8271",\r
+        "type": "comment",\r
+        "name": "NEW",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1980.7937278747559,\r
+        "y": 1111.4285726547241,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "e298800b.28418",\r
+        "type": "set",\r
+        "name": "set index-string to 0",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='0' />\n",\r
+        "comments": "",\r
+        "x": 1975.9364073617116,\r
+        "y": 2054.285785675049,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "974e3eea.a57fc",\r
+        "type": "switchNode",\r
+        "name": "switch tmp.gun.noindex-flag",\r
+        "xml": "<switch test='`$tmp.gun.noindex-flag`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1679.3651259286062,\r
+        "y": 3421.2859582901,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "7a90c21f.11fb9c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "7a90c21f.11fb9c",\r
+        "type": "outcome",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1885.0794051034109,\r
+        "y": 3421.285864830017,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "fde97220.7206d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "fde97220.7206d",\r
+        "type": "returnFailure",\r
+        "name": "return failure",\r
+        "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"naming exhausted for input with index-length = 0\" />\n",\r
+        "comments": "",\r
+        "x": 2049.3652479989187,\r
+        "y": 3419.8571424484253,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "ddda4cb5.69a3c",\r
+        "type": "success",\r
+        "name": "success",\r
+        "xml": "<outcome value='success'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2159.8293882097514,\r
+        "y": 2338.14271068573,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "f1cf4980.556c18"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "59274ef2.cf994",\r
+        "type": "outcome",\r
+        "name": "4",\r
+        "xml": "<outcome value='4'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 1623.650779724121,\r
+        "y": 871.4285898208618,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "2c30bd52.6fca32"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "2c30bd52.6fca32",\r
+        "type": "set",\r
+        "name": "set list-end = 10000",\r
+        "xml": "<set>\n<parameter name='tmp.gun.list-end' value='10000' />\n",\r
+        "comments": "",\r
+        "x": 1813.31742477417,\r
+        "y": 871.4285669326782,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "c12d0b68.b45788",\r
+        "type": "outcome",\r
+        "name": "4",\r
+        "xml": "<outcome value='4'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2207.9363975524902,\r
+        "y": 1584.2856855392456,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "6a0e3f0e.bdf0d"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "6a0e3f0e.bdf0d",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 10",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2376.269733428955,\r
+        "y": 1582.6188135147095,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "e077a096.c90b5",\r
+                "3ba27764.7bb978"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e077a096.c90b5",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2544.8410606384277,\r
+        "y": 1535.5236520767212,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "6f52ffca.5f968"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "3ba27764.7bb978",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2557.936367034912,\r
+        "y": 1660.9521493911743,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "532853bc.fe84cc"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "c2125c33.cdb9e",\r
+        "type": "set",\r
+        "name": "set noindex-flag=false",\r
+        "xml": "<set>\n<parameter name='tmp.gun.noindex-flag' value='false' />\n",\r
+        "comments": "",\r
+        "x": 1190.7936058044434,\r
+        "y": 874.2857313156128,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1a8e79c7.61ce76",\r
+        "type": "set",\r
+        "name": "set index-string to '00' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3100.793617248535,\r
+        "y": 1616.4285522188459,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "1afc6185.a5540e",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 1000",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 1000`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3063.7935638427734,\r
+        "y": 1695.7619800567627,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "a4f34d49.5db71",\r
+                "751b1f96.b3bdc"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "a4f34d49.5db71",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3220.79354095459,\r
+        "y": 1669.0953578948975,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "5d36ed1a.607764"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "751b1f96.b3bdc",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 3220.79349899292,\r
+        "y": 1717.4286937713623,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "d68323fd.8707c"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "5d36ed1a.607764",\r
+        "type": "set",\r
+        "name": "set index-string to '0' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 3413.4603271484375,\r
+        "y": 1668.7620124816895,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "d68323fd.8707c",\r
+        "type": "set",\r
+        "name": "set index-string to idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
+        "comments": "",\r
+        "x": 3397.4603118896484,\r
+        "y": 1717.0953159332275,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "6f52ffca.5f968",\r
+        "type": "set",\r
+        "name": "set index-string to '000' + idx",\r
+        "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '000' + $tmp.gun.idx`\" />\n",\r
+        "comments": "",\r
+        "x": 2752.2221069335938,\r
+        "y": 1535.142939567566,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "532853bc.fe84cc",\r
+        "type": "switchNode",\r
+        "name": "switch idx < 100",\r
+        "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2726.650703430176,\r
+        "y": 1660.9049066816058,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "26118820.193aa8",\r
+                "e9a76d39.5370a"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "26118820.193aa8",\r
+        "type": "outcomeTrue",\r
+        "name": "true",\r
+        "xml": "<outcome value='true'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2883.650680541992,\r
+        "y": 1616.2382845197405,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1a8e79c7.61ce76"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "e9a76d39.5370a",\r
+        "type": "outcomeFalse",\r
+        "name": "false",\r
+        "xml": "<outcome value='false'>\n",\r
+        "comments": "",\r
+        "outputs": 1,\r
+        "x": 2883.6506385803223,\r
+        "y": 1696.5716203962054,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "1afc6185.a5540e"\r
+            ]\r
+        ]\r
+    },\r
+    {\r
+        "id": "909034be.bcdcb8",\r
+        "type": "comment",\r
+        "name": "Change History",\r
+        "info": "iTrack 10767\n- insert new column (index, prefix, info)\niTrack 11252\n- use tmp.gun.index-string as opposed to tmp.gun.idx as prefix for GENERIC_RESOURCE_NAME insert",\r
+        "comments": "",\r
+        "x": 463.65077209472656,\r
+        "y": 401.4285840988159,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "895c17e1.4d8998",\r
+        "type": "comment",\r
+        "name": "iTrack 10767",\r
+        "info": "",\r
+        "comments": "",\r
+        "x": 1766.507999420166,\r
+        "y": 3105.714337348938,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "a16f0f71.a4d2c",\r
+        "type": "set",\r
+        "name": "set tmp.gun.transient",\r
+        "xml": "<set>\n<parameter name='tmp.gun.transient' value='TRANSIENT' />\n",\r
+        "comments": "",\r
+        "x": 1112.2221374511719,\r
+        "y": 2779.999990940094,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": []\r
+    },\r
+    {\r
+        "id": "9f71976e.e5c5f8",\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": 720.8888549804688,\r
+        "y": 26.66666889190674,\r
+        "z": "f2af2445.16fe78",\r
+        "wires": [\r
+            [\r
+                "4eedc095.04b8b"\r
+            ]\r
+        ]\r
+    }\r
+]
\ No newline at end of file