platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_rollback-generated-names.json

   1 [\r
   2     {\r
   3         "id": "29cb883a.884228",\r
   4         "type": "dgstart",\r
   5         "name": "DGSTART",\r
   6         "outputs": 1,\r
   7         "x": 1334.4443359375,\r
   8         "y": 20.416664123535156,\r
   9         "z": "aa630329.50a53",\r
  10         "wires": [\r
  11             [\r
  12                 "888a84ae.33c888"\r
  13             ]\r
  14         ]\r
  15     },\r
  16     {\r
  17         "id": "ed968adc.8ee998",\r
  18         "type": "method",\r
  19         "name": "method rollback-generated-names",\r
  20         "xml": "<method rpc='rollback-generated-names' mode='sync'>\n",\r
  21         "comments": "",\r
  22         "outputs": 1,\r
  23         "x": 1459.5157623291016,\r
  24         "y": 91.84523582458496,\r
  25         "z": "aa630329.50a53",\r
  26         "wires": [\r
  27             [\r
  28                 "75650b62.fb7214"\r
  29             ]\r
  30         ]\r
  31     },\r
  32     {\r
  33         "id": "75650b62.fb7214",\r
  34         "type": "block",\r
  35         "name": "block : atomic",\r
  36         "xml": "<block atomic=\"true\">",\r
  37         "atomic": "true",\r
  38         "comments": "",\r
  39         "outputs": 1,\r
  40         "x": 1458.7300567626953,\r
  41         "y": 173.2738151550293,\r
  42         "z": "aa630329.50a53",\r
  43         "wires": [\r
  44             [\r
  45                 "5556f19b.f5219",\r
  46                 "19ce5e74.e19aa2",\r
  47                 "d35c0a8.e055af8",\r
  48                 "37f63bc9.9d3f04",\r
  49                 "b6ebcdec.0165b"\r
  50             ]\r
  51         ]\r
  52     },\r
  53     {\r
  54         "id": "5556f19b.f5219",\r
  55         "type": "switchNode",\r
  56         "name": "switch rollback-generated-names-input.context-id",\r
  57         "xml": "<switch test='`$rollback-generated-names-input.context-id`'>\n",\r
  58         "comments": "",\r
  59         "outputs": 1,\r
  60         "x": 1780.2776489257812,\r
  61         "y": 172.33332443237305,\r
  62         "z": "aa630329.50a53",\r
  63         "wires": [\r
  64             [\r
  65                 "49e2a20b.aa74ac"\r
  66             ]\r
  67         ]\r
  68     },\r
  69     {\r
  70         "id": "19ce5e74.e19aa2",\r
  71         "type": "switchNode",\r
  72         "name": "switch rollback-generated-names-input.naming-type",\r
  73         "xml": "<switch test='`$rollback-generated-names-input.naming-type`'>\n",\r
  74         "comments": "",\r
  75         "outputs": 1,\r
  76         "x": 1787.444351196289,\r
  77         "y": 232.16666793823242,\r
  78         "z": "aa630329.50a53",\r
  79         "wires": [\r
  80             [\r
  81                 "19ba8656.ba40ea",\r
  82                 "fbafb911.c1a228",\r
  83                 "aaaeba77.eb1d38",\r
  84                 "c6b37ac7.e80618",\r
  85                 "1516480b.27b978",\r
  86                 "943b3579.515908",\r
  87                 "ffdb86fd.ed9ae8",\r
  88                 "f9d65524.73d078"\r
  89             ]\r
  90         ]\r
  91     },\r
  92     {\r
  93         "id": "49e2a20b.aa74ac",\r
  94         "type": "outcome",\r
  95         "name": "NULL",\r
  96         "xml": "<outcome value=''>",\r
  97         "comments": "",\r
  98         "outputs": 1,\r
  99         "x": 2058.694351196289,\r
 100         "y": 172.91666793823242,\r
 101         "z": "aa630329.50a53",\r
 102         "wires": [\r
 103             [\r
 104                 "7ab1c055.bf769"\r
 105             ]\r
 106         ]\r
 107     },\r
 108     {\r
 109         "id": "7ab1c055.bf769",\r
 110         "type": "returnFailure",\r
 111         "name": "return failure",\r
 112         "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.context-id can not be null\" />\n",\r
 113         "comments": "",\r
 114         "x": 2225.3486518859863,\r
 115         "y": 172.31190013885498,\r
 116         "z": "aa630329.50a53",\r
 117         "wires": []\r
 118     },\r
 119     {\r
 120         "id": "19ba8656.ba40ea",\r
 121         "type": "outcome",\r
 122         "name": "NULL",\r
 123         "xml": "<outcome value=''>",\r
 124         "comments": "",\r
 125         "outputs": 1,\r
 126         "x": 2102.1943359375,\r
 127         "y": 231.91666412353516,\r
 128         "z": "aa630329.50a53",\r
 129         "wires": [\r
 130             [\r
 131                 "6acbae14.16e77"\r
 132             ]\r
 133         ]\r
 134     },\r
 135     {\r
 136         "id": "6acbae14.16e77",\r
 137         "type": "returnFailure",\r
 138         "name": "return failure",\r
 139         "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"rollback-generated-names-input.naming-type can not be null\" />\n",\r
 140         "comments": "",\r
 141         "x": 2268.4443550109863,\r
 142         "y": 231.91666793823242,\r
 143         "z": "aa630329.50a53",\r
 144         "wires": []\r
 145     },\r
 146     {\r
 147         "id": "fbafb911.c1a228",\r
 148         "type": "outcome",\r
 149         "name": "VM_INSTANCE",\r
 150         "xml": "<outcome value='VM_INSTANCE'>",\r
 151         "comments": "",\r
 152         "outputs": 1,\r
 153         "x": 2130.1943740844727,\r
 154         "y": 279.52380752563477,\r
 155         "z": "aa630329.50a53",\r
 156         "wires": [\r
 157             [\r
 158                 "14f5428c.d3dd3d"\r
 159             ]\r
 160         ]\r
 161     },\r
 162     {\r
 163         "id": "aaaeba77.eb1d38",\r
 164         "type": "outcome",\r
 165         "name": "VNFC_INSTANCE",\r
 166         "xml": "<outcome value='VNFC_INSTANCE'>",\r
 167         "comments": "",\r
 168         "outputs": 1,\r
 169         "x": 2140.444366455078,\r
 170         "y": 327.0238094329834,\r
 171         "z": "aa630329.50a53",\r
 172         "wires": [\r
 173             [\r
 174                 "b191361f.e39258"\r
 175             ]\r
 176         ]\r
 177     },\r
 178     {\r
 179         "id": "14f5428c.d3dd3d",\r
 180         "type": "set",\r
 181         "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
 182         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VM_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vm_name_prefix' />\n",\r
 183         "comments": "",\r
 184         "x": 2551.694351196289,\r
 185         "y": 279.66666984558105,\r
 186         "z": "aa630329.50a53",\r
 187         "wires": []\r
 188     },\r
 189     {\r
 190         "id": "b191361f.e39258",\r
 191         "type": "set",\r
 192         "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
 193         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='NAMING_POLICY_VNFC_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnfc_name_prefix' />\n\n",\r
 194         "comments": "",\r
 195         "x": 2553.944351196289,\r
 196         "y": 326.9166717529297,\r
 197         "z": "aa630329.50a53",\r
 198         "wires": []\r
 199     },\r
 200     {\r
 201         "id": "c6b37ac7.e80618",\r
 202         "type": "outcome",\r
 203         "name": "Other",\r
 204         "xml": "<outcome value='Other'>",\r
 205         "comments": "",\r
 206         "outputs": 1,\r
 207         "x": 2107.6943359375,\r
 208         "y": 571.1666641235352,\r
 209         "z": "aa630329.50a53",\r
 210         "wires": [\r
 211             [\r
 212                 "f1c08b0d.d43858"\r
 213             ]\r
 214         ]\r
 215     },\r
 216     {\r
 217         "id": "f1c08b0d.d43858",\r
 218         "type": "returnFailure",\r
 219         "name": "return failure",\r
 220         "xml": "<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`'Unknown rollbck-generated-name-input.naming-type: ' + $rollback-generated-names-input.naming-type`\" />\n",\r
 221         "comments": "",\r
 222         "x": 2273.9443550109863,\r
 223         "y": 571.1666679382324,\r
 224         "z": "aa630329.50a53",\r
 225         "wires": []\r
 226     },\r
 227     {\r
 228         "id": "1f6886e.08cdb79",\r
 229         "type": "set",\r
 230         "name": "set tmp.rb.sql",\r
 231         "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'SELECT * from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
 232         "comments": "",\r
 233         "x": 2301.110996246338,\r
 234         "y": 1108.2499651908875,\r
 235         "z": "aa630329.50a53",\r
 236         "wires": []\r
 237     },\r
 238     {\r
 239         "id": "9103eac2.da1f88",\r
 240         "type": "get-resource",\r
 241         "name": "GET INDEX TABLE.index_number",\r
 242         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\" pfx='db.grn.index-table'>\n\n",\r
 243         "comments": "",\r
 244         "outputs": 1,\r
 245         "x": 2369.78946685791,\r
 246         "y": 1156.1190004348755,\r
 247         "z": "aa630329.50a53",\r
 248         "wires": [\r
 249             [\r
 250                 "4bac1a75.3bf994",\r
 251                 "9830d2f4.14e32"\r
 252             ]\r
 253         ]\r
 254     },\r
 255     {\r
 256         "id": "bf055860.21dff8",\r
 257         "type": "block",\r
 258         "name": "block : atomic",\r
 259         "xml": "<block atomic='true'>",\r
 260         "atomic": "true",\r
 261         "comments": "",\r
 262         "outputs": 1,\r
 263         "x": 2110.1109924316406,\r
 264         "y": 1108.7499656677246,\r
 265         "z": "aa630329.50a53",\r
 266         "wires": [\r
 267             [\r
 268                 "1f6886e.08cdb79",\r
 269                 "9103eac2.da1f88"\r
 270             ]\r
 271         ]\r
 272     },\r
 273     {\r
 274         "id": "dba5c1eb.6b22f",\r
 275         "type": "returnFailure",\r
 276         "name": "return failure",\r
 277         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error reading the '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' table with ' + $rollback-generated-names.name-prefix-column\n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
 278         "comments": "",\r
 279         "x": 2786.361000061035,\r
 280         "y": 1157.0000743865967,\r
 281         "z": "aa630329.50a53",\r
 282         "wires": []\r
 283     },\r
 284     {\r
 285         "id": "aa4a319e.2aea6",\r
 286         "type": "returnFailure",\r
 287         "name": "return failure",\r
 288         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'No entries found in ' \n\t+ $rollback-generated-names.index-table-name \n\t+ ' with ' \n\t+ $rollback-generated-names.name-prefix-column \n\t+ ' = ' \n\t+ $tmp.rb.grn.prefix `\" />\n\n",\r
 289         "comments": "",\r
 290         "x": 2786.03946685791,\r
 291         "y": 1202.7857494354248,\r
 292         "z": "aa630329.50a53",\r
 293         "wires": []\r
 294     },\r
 295     {\r
 296         "id": "4bac1a75.3bf994",\r
 297         "type": "failure",\r
 298         "name": "failure",\r
 299         "xml": "<outcome value='failure'>\n",\r
 300         "comments": "",\r
 301         "outputs": 1,\r
 302         "x": 2613.361000061035,\r
 303         "y": 1156.5000743865967,\r
 304         "z": "aa630329.50a53",\r
 305         "wires": [\r
 306             [\r
 307                 "dba5c1eb.6b22f"\r
 308             ]\r
 309         ]\r
 310     },\r
 311     {\r
 312         "id": "9830d2f4.14e32",\r
 313         "type": "not-found",\r
 314         "name": "not-found",\r
 315         "xml": "<outcome value='not-found'>\n",\r
 316         "comments": "",\r
 317         "outputs": 1,\r
 318         "x": 2620.206401824951,\r
 319         "y": 1202.9882164001465,\r
 320         "z": "aa630329.50a53",\r
 321         "wires": [\r
 322             [\r
 323                 "aa4a319e.2aea6"\r
 324             ]\r
 325         ]\r
 326     },\r
 327     {\r
 328         "id": "37f63bc9.9d3f04",\r
 329         "type": "get-resource",\r
 330         "name": "GET GENERIC_RESOURCE_NAME distinct prefix",\r
 331         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT distinct prefix from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id'\n  pfx='db.grn.distinct-prefix[]'>",\r
 332         "comments": "",\r
 333         "outputs": 1,\r
 334         "x": 1778.1109619140625,\r
 335         "y": 692.9999885559082,\r
 336         "z": "aa630329.50a53",\r
 337         "wires": [\r
 338             [\r
 339                 "6cb3df87.7e0ec",\r
 340                 "727c9c85.dfe244"\r
 341             ]\r
 342         ]\r
 343     },\r
 344     {\r
 345         "id": "6cb3df87.7e0ec",\r
 346         "type": "failure",\r
 347         "name": "failure",\r
 348         "xml": "<outcome value='failure'>\n",\r
 349         "comments": "",\r
 350         "outputs": 1,\r
 351         "x": 2057.8609619140625,\r
 352         "y": 692.9999809265137,\r
 353         "z": "aa630329.50a53",\r
 354         "wires": [\r
 355             [\r
 356                 "5c66740e.eb157c"\r
 357             ]\r
 358         ]\r
 359     },\r
 360     {\r
 361         "id": "5c66740e.eb157c",\r
 362         "type": "returnFailure",\r
 363         "name": "return failure",\r
 364         "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table to retrieve distinct prefix\"/>",\r
 365         "comments": "",\r
 366         "x": 2227.3609619140625,\r
 367         "y": 692.9999809265137,\r
 368         "z": "aa630329.50a53",\r
 369         "wires": []\r
 370     },\r
 371     {\r
 372         "id": "727c9c85.dfe244",\r
 373         "type": "not-found",\r
 374         "name": "not-found",\r
 375         "xml": "<outcome value='not-found'>\n",\r
 376         "comments": "",\r
 377         "outputs": 1,\r
 378         "x": 2065.860939025879,\r
 379         "y": 739.4999742507935,\r
 380         "z": "aa630329.50a53",\r
 381         "wires": [\r
 382             [\r
 383                 "1fa487d3.8ad6e8"\r
 384             ]\r
 385         ]\r
 386     },\r
 387     {\r
 388         "id": "314b583f.7203e8",\r
 389         "type": "comment",\r
 390         "name": "pfx = db.grn.distinct-prefix[]",\r
 391         "info": "",\r
 392         "comments": "",\r
 393         "x": 1770.3610076904297,\r
 394         "y": 730.4999885559082,\r
 395         "z": "aa630329.50a53",\r
 396         "wires": []\r
 397     },\r
 398     {\r
 399         "id": "b6ebcdec.0165b",\r
 400         "type": "for",\r
 401         "name": "for each distinct prefix",\r
 402         "xml": "<for index='prefix-index' start='0' end='`$db.grn.distinct-prefix_length`' >\n",\r
 403         "comments": "",\r
 404         "outputs": 1,\r
 405         "x": 1682.6109924316406,\r
 406         "y": 855.4999713897705,\r
 407         "z": "aa630329.50a53",\r
 408         "wires": [\r
 409             [\r
 410                 "615652ba.fc923c"\r
 411             ]\r
 412         ]\r
 413     },\r
 414     {\r
 415         "id": "e5feeac4.d67ae8",\r
 416         "type": "get-resource",\r
 417         "name": "GET GENERIC_RESOURCE_NAME  (name_index)",\r
 418         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type   \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.subset[]'>",\r
 419         "comments": "",\r
 420         "outputs": 1,\r
 421         "x": 2227.6109886169434,\r
 422         "y": 995.2499618530273,\r
 423         "z": "aa630329.50a53",\r
 424         "wires": [\r
 425             [\r
 426                 "3b74e0d1.8867b",\r
 427                 "cd385c50.732c1"\r
 428             ]\r
 429         ]\r
 430     },\r
 431     {\r
 432         "id": "3b74e0d1.8867b",\r
 433         "type": "failure",\r
 434         "name": "failure",\r
 435         "xml": "<outcome value='failure'>\n",\r
 436         "comments": "",\r
 437         "outputs": 1,\r
 438         "x": 2545.3609886169434,\r
 439         "y": 995.2499542236328,\r
 440         "z": "aa630329.50a53",\r
 441         "wires": [\r
 442             [\r
 443                 "de6cfc01.eec5b"\r
 444             ]\r
 445         ]\r
 446     },\r
 447     {\r
 448         "id": "de6cfc01.eec5b",\r
 449         "type": "returnFailure",\r
 450         "name": "return failure",\r
 451         "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>",\r
 452         "comments": "",\r
 453         "x": 2714.8609886169434,\r
 454         "y": 995.2499542236328,\r
 455         "z": "aa630329.50a53",\r
 456         "wires": []\r
 457     },\r
 458     {\r
 459         "id": "cd385c50.732c1",\r
 460         "type": "not-found",\r
 461         "name": "not-found",\r
 462         "xml": "<outcome value='not-found'>\n",\r
 463         "comments": "",\r
 464         "outputs": 1,\r
 465         "x": 2553.3609657287598,\r
 466         "y": 1041.7499475479126,\r
 467         "z": "aa630329.50a53",\r
 468         "wires": [\r
 469             [\r
 470                 "92b03b04.367558"\r
 471             ]\r
 472         ]\r
 473     },\r
 474     {\r
 475         "id": "92b03b04.367558",\r
 476         "type": "returnFailure",\r
 477         "name": "return failure",\r
 478         "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"`'No entry found in GENERIC_RESOURCE_NAME where context_id = ' + $rollback-generated-names-input.context-id + ' and type = ' + $rollback-generated-names-input.naming-type + ' and prefix = ' + $db.grn.distinct-prefix[$prefix-index].prefix`\"/>",\r
 479         "comments": "",\r
 480         "x": 2716.6110038757324,\r
 481         "y": 1041.499963760376,\r
 482         "z": "aa630329.50a53",\r
 483         "wires": []\r
 484     },\r
 485     {\r
 486         "id": "aec883e2.d2ce2",\r
 487         "type": "comment",\r
 488         "name": "pfx = db.grn.subset[]",\r
 489         "info": "",\r
 490         "comments": "",\r
 491         "x": 2298.6110038757324,\r
 492         "y": 1032.7499713897705,\r
 493         "z": "aa630329.50a53",\r
 494         "wires": []\r
 495     },\r
 496     {\r
 497         "id": "615652ba.fc923c",\r
 498         "type": "block",\r
 499         "name": "block : atomic",\r
 500         "xml": "<block atomic='true'>",\r
 501         "atomic": "true",\r
 502         "comments": "",\r
 503         "outputs": 1,\r
 504         "x": 1892.860984802246,\r
 505         "y": 855.2499618530273,\r
 506         "z": "aa630329.50a53",\r
 507         "wires": [\r
 508             [\r
 509                 "e5feeac4.d67ae8",\r
 510                 "d73de031.6f6f9",\r
 511                 "bf055860.21dff8",\r
 512                 "5b7f4beb.293b54",\r
 513                 "5bc6188.f631ce8",\r
 514                 "71d6da4f.c71d64",\r
 515                 "1bd95123.da921f",\r
 516                 "300df04b.286a1",\r
 517                 "c3fa064.1eee4f8",\r
 518                 "6647f1a8.2eba5",\r
 519                 "5693c8f8.d296b8"\r
 520             ]\r
 521         ]\r
 522     },\r
 523     {\r
 524         "id": "d73de031.6f6f9",\r
 525         "type": "set",\r
 526         "name": "set tmp.rb.grn.prefix",\r
 527         "xml": "<set>\n<parameter name='tmp.rb.grn.prefix' value='`$db.grn.distinct-prefix[$prefix-index].prefix`' />\n",\r
 528         "comments": "",\r
 529         "x": 2130.1109733581543,\r
 530         "y": 945.9999675750732,\r
 531         "z": "aa630329.50a53",\r
 532         "wires": []\r
 533     },\r
 534     {\r
 535         "id": "6dc0d5b7.e8b79c",\r
 536         "type": "switchNode",\r
 537         "name": "switch: tmp.rb.net-index == 0",\r
 538         "xml": "<switch test=\"`$tmp.rb.net-index == 0`\">",\r
 539         "comments": "",\r
 540         "outputs": 1,\r
 541         "x": 2589.027786254883,\r
 542         "y": 1406.0832901000977,\r
 543         "z": "aa630329.50a53",\r
 544         "wires": [\r
 545             [\r
 546                 "ae547b4c.5ee188",\r
 547                 "de514521.1f6668"\r
 548             ]\r
 549         ]\r
 550     },\r
 551     {\r
 552         "id": "ab812023.4d106",\r
 553         "type": "comment",\r
 554         "name": "pfx = db.grn.index-table",\r
 555         "info": "",\r
 556         "comments": "",\r
 557         "x": 2405.8609771728516,\r
 558         "y": 1192.7499542236328,\r
 559         "z": "aa630329.50a53",\r
 560         "wires": []\r
 561     },\r
 562     {\r
 563         "id": "5bc6188.f631ce8",\r
 564         "type": "set",\r
 565         "name": "set tmp.rb.grn.max-index",\r
 566         "xml": "<set>\n<parameter name='tmp.rb.grn.max-index' \n\tvalue='`$db.grn.subset[$db.grn.subset_length - 1].name-index`' />\n",\r
 567         "comments": "",\r
 568         "x": 2138.6109924316406,\r
 569         "y": 1262.7499685287476,\r
 570         "z": "aa630329.50a53",\r
 571         "wires": []\r
 572     },\r
 573     {\r
 574         "id": "5b7f4beb.293b54",\r
 575         "type": "set",\r
 576         "name": "clear tmp.rb.",\r
 577         "xml": "<set>\n<parameter name='tmp.rb.' value='' />\n",\r
 578         "comments": "",\r
 579         "x": 2105.1109580993652,\r
 580         "y": 899.2499523162842,\r
 581         "z": "aa630329.50a53",\r
 582         "wires": []\r
 583     },\r
 584     {\r
 585         "id": "d35c0a8.e055af8",\r
 586         "type": "set",\r
 587         "name": "clear db.grn.",\r
 588         "xml": "<set>\n<parameter name='db.grn.' value='' />\n",\r
 589         "comments": "",\r
 590         "x": 1661.249885559082,\r
 591         "y": 639.4444446563721,\r
 592         "z": "aa630329.50a53",\r
 593         "wires": []\r
 594     },\r
 595     {\r
 596         "id": "71d6da4f.c71d64",\r
 597         "type": "set",\r
 598         "name": "clear db.grn.subset.",\r
 599         "xml": "<set>\n<parameter name='db.grn.subset.' value='' />\n",\r
 600         "comments": "",\r
 601         "x": 2126.1109924316406,\r
 602         "y": 855.499960899353,\r
 603         "z": "aa630329.50a53",\r
 604         "wires": []\r
 605     },\r
 606     {\r
 607         "id": "f019211a.03f21",\r
 608         "type": "set",\r
 609         "name": "set tmp.rb.sql for delete",\r
 610         "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t",\r
 611         "comments": "",\r
 612         "x": 3201.777618408203,\r
 613         "y": 1406.08327293396,\r
 614         "z": "aa630329.50a53",\r
 615         "wires": []\r
 616     },\r
 617     {\r
 618         "id": "28704354.57816c",\r
 619         "type": "get-resource",\r
 620         "name": "DELETE from INDEX TABLE",\r
 621         "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
 622         "comments": "",\r
 623         "outputs": 1,\r
 624         "x": 3217.9561462402344,\r
 625         "y": 1451.7023067474365,\r
 626         "z": "aa630329.50a53",\r
 627         "wires": [\r
 628             [\r
 629                 "2a3eafed.800b2",\r
 630                 "9929948e.80baa8"\r
 631             ]\r
 632         ]\r
 633     },\r
 634     {\r
 635         "id": "f41ba658.f134a8",\r
 636         "type": "returnFailure",\r
 637         "name": "return failure",\r
 638         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
 639         "comments": "",\r
 640         "x": 3626.5276794433594,\r
 641         "y": 1451.5833806991577,\r
 642         "z": "aa630329.50a53",\r
 643         "wires": []\r
 644     },\r
 645     {\r
 646         "id": "2a3eafed.800b2",\r
 647         "type": "failure",\r
 648         "name": "failure",\r
 649         "xml": "<outcome value='failure'>\n",\r
 650         "comments": "",\r
 651         "outputs": 1,\r
 652         "x": 3453.5276794433594,\r
 653         "y": 1452.0833806991577,\r
 654         "z": "aa630329.50a53",\r
 655         "wires": [\r
 656             [\r
 657                 "f41ba658.f134a8"\r
 658             ]\r
 659         ]\r
 660     },\r
 661     {\r
 662         "id": "9929948e.80baa8",\r
 663         "type": "not-found",\r
 664         "name": "not-found",\r
 665         "xml": "<outcome value='not-found'>\n",\r
 666         "comments": "",\r
 667         "outputs": 1,\r
 668         "x": 3460.3730812072754,\r
 669         "y": 1498.5715227127075,\r
 670         "z": "aa630329.50a53",\r
 671         "wires": [\r
 672             [\r
 673                 "ce9cb4be.d8f5e8"\r
 674             ]\r
 675         ]\r
 676     },\r
 677     {\r
 678         "id": "138bb542.26235b",\r
 679         "type": "block",\r
 680         "name": "block : atomic",\r
 681         "xml": "<block atomic='true'>",\r
 682         "atomic": "true",\r
 683         "comments": "",\r
 684         "outputs": 1,\r
 685         "x": 2969.277671813965,\r
 686         "y": 1405.8332901000977,\r
 687         "z": "aa630329.50a53",\r
 688         "wires": [\r
 689             [\r
 690                 "f019211a.03f21",\r
 691                 "28704354.57816c"\r
 692             ]\r
 693         ]\r
 694     },\r
 695     {\r
 696         "id": "1bd95123.da921f",\r
 697         "type": "set",\r
 698         "name": "set tmp.rb.delta-index = index-number - max-index",\r
 699         "xml": "<set>\n<parameter name='tmp.rb.delta-index' \n\tvalue='`$db.grn.index-table.index-number - $tmp.rb.grn.max-index`' />\n",\r
 700         "comments": "",\r
 701         "x": 2216.6109924316406,\r
 702         "y": 1307.9999675750732,\r
 703         "z": "aa630329.50a53",\r
 704         "wires": []\r
 705     },\r
 706     {\r
 707         "id": "ae547b4c.5ee188",\r
 708         "type": "outcomeTrue",\r
 709         "name": "true",\r
 710         "xml": "<outcome value='true'>\n",\r
 711         "comments": "",\r
 712         "outputs": 1,\r
 713         "x": 2802.7776489257812,\r
 714         "y": 1406.0832710266113,\r
 715         "z": "aa630329.50a53",\r
 716         "wires": [\r
 717             [\r
 718                 "138bb542.26235b"\r
 719             ]\r
 720         ]\r
 721     },\r
 722     {\r
 723         "id": "6647f1a8.2eba5",\r
 724         "type": "get-resource",\r
 725         "name": "DELETE from GENERIC_RESOURCE_NAME",\r
 726         "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='DELETE from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id \n\t\tAND prefix = $tmp.rb.grn.prefix'>\n",\r
 727         "comments": "",\r
 728         "outputs": 1,\r
 729         "x": 2199.4562072753906,\r
 730         "y": 1743.9523639678955,\r
 731         "z": "aa630329.50a53",\r
 732         "wires": [\r
 733             [\r
 734                 "c5dfbac3.eb7ac8",\r
 735                 "d5e547a5.1eafc8"\r
 736             ]\r
 737         ]\r
 738     },\r
 739     {\r
 740         "id": "c240b414.e47518",\r
 741         "type": "returnFailure",\r
 742         "name": "return failure",\r
 743         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting GENERIC_RESOURCE_NAME WHERE type = '\n\t+ $rollback-generated-names-input.naming-type  \n\t+ ' AND context_id = ' + $rollback-generated-names-input.context-id \n\t+ ' AND prefix = '+ $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
 744         "comments": "",\r
 745         "x": 2651.0277404785156,\r
 746         "y": 1744.8334379196167,\r
 747         "z": "aa630329.50a53",\r
 748         "wires": []\r
 749     },\r
 750     {\r
 751         "id": "c5dfbac3.eb7ac8",\r
 752         "type": "failure",\r
 753         "name": "failure",\r
 754         "xml": "<outcome value='failure'>\n",\r
 755         "comments": "",\r
 756         "outputs": 1,\r
 757         "x": 2478.0277404785156,\r
 758         "y": 1744.3334379196167,\r
 759         "z": "aa630329.50a53",\r
 760         "wires": [\r
 761             [\r
 762                 "c240b414.e47518"\r
 763             ]\r
 764         ]\r
 765     },\r
 766     {\r
 767         "id": "d5e547a5.1eafc8",\r
 768         "type": "not-found",\r
 769         "name": "not-found",\r
 770         "xml": "<outcome value='not-found'>\n",\r
 771         "comments": "",\r
 772         "outputs": 1,\r
 773         "x": 2484.8730850219727,\r
 774         "y": 1790.8216247558594,\r
 775         "z": "aa630329.50a53",\r
 776         "wires": [\r
 777             [\r
 778                 "a4121e26.ea489"\r
 779             ]\r
 780         ]\r
 781     },\r
 782     {\r
 783         "id": "c25429a5.1b65a8",\r
 784         "type": "comment",\r
 785         "name": "Delete prefix from INDEX TABLE",\r
 786         "info": "",\r
 787         "comments": "",\r
 788         "x": 3472.0277557373047,\r
 789         "y": 1408.0833444595337,\r
 790         "z": "aa630329.50a53",\r
 791         "wires": []\r
 792     },\r
 793     {\r
 794         "id": "4b654cba.5ced54",\r
 795         "type": "comment",\r
 796         "name": "Silence SUCCESS",\r
 797         "info": "",\r
 798         "comments": "",\r
 799         "x": 3717.027687072754,\r
 800         "y": 1510.083288192749,\r
 801         "z": "aa630329.50a53",\r
 802         "wires": []\r
 803     },\r
 804     {\r
 805         "id": "ce9cb4be.d8f5e8",\r
 806         "type": "block",\r
 807         "name": "block",\r
 808         "xml": "<block>\n",\r
 809         "atomic": "false",\r
 810         "comments": "",\r
 811         "outputs": 1,\r
 812         "x": 3609.2776832580566,\r
 813         "y": 1498.3332901000977,\r
 814         "z": "aa630329.50a53",\r
 815         "wires": [\r
 816             []\r
 817         ]\r
 818     },\r
 819     {\r
 820         "id": "de514521.1f6668",\r
 821         "type": "outcomeFalse",\r
 822         "name": "false",\r
 823         "xml": "<outcome value='false'>\n",\r
 824         "comments": "",\r
 825         "outputs": 1,\r
 826         "x": 2801.777732849121,\r
 827         "y": 1591.3333129882812,\r
 828         "z": "aa630329.50a53",\r
 829         "wires": [\r
 830             [\r
 831                 "e961bcf0.f03cb"\r
 832             ]\r
 833         ]\r
 834     },\r
 835     {\r
 836         "id": "666b02e.502d0fc",\r
 837         "type": "comment",\r
 838         "name": "index_number > $db.grn.subset_length; i.e hole in the middle. DO NOTHING",\r
 839         "info": "",\r
 840         "comments": "",\r
 841         "x": 2392.5277557373047,\r
 842         "y": 1530.083345413208,\r
 843         "z": "aa630329.50a53",\r
 844         "wires": []\r
 845     },\r
 846     {\r
 847         "id": "b133d8d2.574fa8",\r
 848         "type": "comment",\r
 849         "name": "Silence SUCCESS",\r
 850         "info": "",\r
 851         "comments": "",\r
 852         "x": 2741.027587890625,\r
 853         "y": 1802.3333225250244,\r
 854         "z": "aa630329.50a53",\r
 855         "wires": []\r
 856     },\r
 857     {\r
 858         "id": "a4121e26.ea489",\r
 859         "type": "block",\r
 860         "name": "block",\r
 861         "xml": "<block>\n",\r
 862         "atomic": "false",\r
 863         "comments": "",\r
 864         "outputs": 1,\r
 865         "x": 2633.2775840759277,\r
 866         "y": 1790.583324432373,\r
 867         "z": "aa630329.50a53",\r
 868         "wires": [\r
 869             []\r
 870         ]\r
 871     },\r
 872     {\r
 873         "id": "300df04b.286a1",\r
 874         "type": "switchNode",\r
 875         "name": "switch: tmp.rb.delta-index == 0",\r
 876         "xml": "<switch test=\"`$tmp.rb.delta-index == 0`\">",\r
 877         "comments": "",\r
 878         "outputs": 1,\r
 879         "x": 2155.0276641845703,\r
 880         "y": 1406.333288192749,\r
 881         "z": "aa630329.50a53",\r
 882         "wires": [\r
 883             [\r
 884                 "ebc810ff.c3a11",\r
 885                 "cc537a09.f92948"\r
 886             ]\r
 887         ]\r
 888     },\r
 889     {\r
 890         "id": "ebc810ff.c3a11",\r
 891         "type": "outcomeTrue",\r
 892         "name": "true",\r
 893         "xml": "<outcome value='true'>\n",\r
 894         "comments": "",\r
 895         "outputs": 1,\r
 896         "x": 2382.2776489257812,\r
 897         "y": 1406.3332710266113,\r
 898         "z": "aa630329.50a53",\r
 899         "wires": [\r
 900             [\r
 901                 "6dc0d5b7.e8b79c"\r
 902             ]\r
 903         ]\r
 904     },\r
 905     {\r
 906         "id": "9160dc95.b9431",\r
 907         "type": "set",\r
 908         "name": "set tmp.rb.sql for update",\r
 909         "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.net-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
 910         "comments": "",\r
 911         "x": 3208.527687072754,\r
 912         "y": 1591.3332977294922,\r
 913         "z": "aa630329.50a53",\r
 914         "wires": []\r
 915     },\r
 916     {\r
 917         "id": "d2204951.3f5048",\r
 918         "type": "get-resource",\r
 919         "name": "Update INDEX TABLE",\r
 920         "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
 921         "comments": "",\r
 922         "outputs": 1,\r
 923         "x": 3204.706214904785,\r
 924         "y": 1636.9523315429688,\r
 925         "z": "aa630329.50a53",\r
 926         "wires": [\r
 927             [\r
 928                 "e86d1619.af6ed8",\r
 929                 "79602d4f.9dc9b4"\r
 930             ]\r
 931         ]\r
 932     },\r
 933     {\r
 934         "id": "3686c0ec.5662b",\r
 935         "type": "returnFailure",\r
 936         "name": "return failure",\r
 937         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.net-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix\n\t+ '. MANUAL clean up is required!'`\" />\n\n",\r
 938         "comments": "",\r
 939         "x": 3610.27774810791,\r
 940         "y": 1636.83340549469,\r
 941         "z": "aa630329.50a53",\r
 942         "wires": []\r
 943     },\r
 944     {\r
 945         "id": "e86d1619.af6ed8",\r
 946         "type": "failure",\r
 947         "name": "failure",\r
 948         "xml": "<outcome value='failure'>\n",\r
 949         "comments": "",\r
 950         "outputs": 1,\r
 951         "x": 3418.27774810791,\r
 952         "y": 1637.33340549469,\r
 953         "z": "aa630329.50a53",\r
 954         "wires": [\r
 955             [\r
 956                 "3686c0ec.5662b"\r
 957             ]\r
 958         ]\r
 959     },\r
 960     {\r
 961         "id": "79602d4f.9dc9b4",\r
 962         "type": "not-found",\r
 963         "name": "not-found",\r
 964         "xml": "<outcome value='not-found'>\n",\r
 965         "comments": "",\r
 966         "outputs": 1,\r
 967         "x": 3425.123149871826,\r
 968         "y": 1683.8215475082397,\r
 969         "z": "aa630329.50a53",\r
 970         "wires": [\r
 971             [\r
 972                 "3686c0ec.5662b"\r
 973             ]\r
 974         ]\r
 975     },\r
 976     {\r
 977         "id": "e961bcf0.f03cb",\r
 978         "type": "block",\r
 979         "name": "block : atomic",\r
 980         "xml": "<block atomic='true'>",\r
 981         "atomic": "true",\r
 982         "comments": "",\r
 983         "outputs": 1,\r
 984         "x": 2969.0277404785156,\r
 985         "y": 1591.0833148956299,\r
 986         "z": "aa630329.50a53",\r
 987         "wires": [\r
 988             [\r
 989                 "9160dc95.b9431",\r
 990                 "d2204951.3f5048"\r
 991             ]\r
 992         ]\r
 993     },\r
 994     {\r
 995         "id": "d4cb9489.bfce78",\r
 996         "type": "comment",\r
 997         "name": "Update prefix from INDEX TABLE",\r
 998         "info": "",\r
 999         "comments": "",\r
1000         "x": 3160.52774810791,\r
1001         "y": 1669.5833106040955,\r
1002         "z": "aa630329.50a53",\r
1003         "wires": []\r
1004     },\r
1005     {\r
1006         "id": "c3fa064.1eee4f8",\r
1007         "type": "set",\r
1008         "name": "set tmp.rb.net-index = index-number - $db.grn.subset_length",\r
1009         "xml": "<set>\n<parameter name='tmp.rb.net-index' \n\tvalue='`$db.grn.index-table.index-number - $db.grn.subset_length`' />\n",\r
1010         "comments": "",\r
1011         "x": 2247.3609771728516,\r
1012         "y": 1355.4999523162842,\r
1013         "z": "aa630329.50a53",\r
1014         "wires": []\r
1015     },\r
1016     {\r
1017         "id": "1fda938f.3dbb9c",\r
1018         "type": "comment",\r
1019         "name": "index_number == max index",\r
1020         "info": "",\r
1021         "comments": "",\r
1022         "x": 2032.8609924316406,\r
1023         "y": 1449.2499694824219,\r
1024         "z": "aa630329.50a53",\r
1025         "wires": []\r
1026     },\r
1027     {\r
1028         "id": "d76b3389.44a7f",\r
1029         "type": "comment",\r
1030         "name": "index_number == $db.grn.subset_length",\r
1031         "info": "",\r
1032         "comments": "",\r
1033         "x": 2660.3609924316406,\r
1034         "y": 1366.7499694824219,\r
1035         "z": "aa630329.50a53",\r
1036         "wires": []\r
1037     },\r
1038     {\r
1039         "id": "cc537a09.f92948",\r
1040         "type": "outcomeFalse",\r
1041         "name": "false",\r
1042         "xml": "<outcome value='false'>\n",\r
1043         "comments": "",\r
1044         "outputs": 1,\r
1045         "x": 2390.3609924316406,\r
1046         "y": 1575.4999685287476,\r
1047         "z": "aa630329.50a53",\r
1048         "wires": [\r
1049             [\r
1050                 "a8f99767.daacf8"\r
1051             ]\r
1052         ]\r
1053     },\r
1054     {\r
1055         "id": "a8f99767.daacf8",\r
1056         "type": "block",\r
1057         "name": "block",\r
1058         "xml": "<block>\n",\r
1059         "atomic": "false",\r
1060         "comments": "",\r
1061         "outputs": 1,\r
1062         "x": 2534.111000061035,\r
1063         "y": 1575.7499713897705,\r
1064         "z": "aa630329.50a53",\r
1065         "wires": [\r
1066             []\r
1067         ]\r
1068     },\r
1069     {\r
1070         "id": "2d578494.cd5f7c",\r
1071         "type": "comment",\r
1072         "name": "Change History",\r
1073         "info": "iTrack SDNGC-10767\n- new DG to rollback generated-names",\r
1074         "comments": "",\r
1075         "x": 1813.1943435668945,\r
1076         "y": 65.41666603088379,\r
1077         "z": "aa630329.50a53",\r
1078         "wires": []\r
1079     },\r
1080     {\r
1081         "id": "3d5fa372.a6850c",\r
1082         "type": "set",\r
1083         "name": "set tmp.rb.naming-index-table-name, index-table.prefix column, grn.type",\r
1084         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='EIPAM_CLIENT_KEY_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' value='vnf_name_prefix' />\n",\r
1085         "comments": "",\r
1086         "x": 2579.4443359375,\r
1087         "y": 377.41666412353516,\r
1088         "z": "aa630329.50a53",\r
1089         "wires": []\r
1090     },\r
1091     {\r
1092         "id": "1516480b.27b978",\r
1093         "type": "outcome",\r
1094         "name": "CLIENT_KEY",\r
1095         "xml": "<outcome value='CLIENT_KEY'>",\r
1096         "comments": "",\r
1097         "outputs": 1,\r
1098         "x": 2127.194351196289,\r
1099         "y": 377.0238037109375,\r
1100         "z": "aa630329.50a53",\r
1101         "wires": [\r
1102             [\r
1103                 "3d5fa372.a6850c"\r
1104             ]\r
1105         ]\r
1106     },\r
1107     {\r
1108         "id": "943b3579.515908",\r
1109         "type": "outcome",\r
1110         "name": "NETWORK_INSTANCE",\r
1111         "xml": "<outcome value='NETWORK_INSTANCE'>",\r
1112         "comments": "",\r
1113         "outputs": 1,\r
1114         "x": 2158.972099304199,\r
1115         "y": 427.2777690887451,\r
1116         "z": "aa630329.50a53",\r
1117         "wires": [\r
1118             [\r
1119                 "83af09d2.c65ec8"\r
1120             ]\r
1121         ]\r
1122     },\r
1123     {\r
1124         "id": "ffdb86fd.ed9ae8",\r
1125         "type": "outcome",\r
1126         "name": "SERVICE_INSTANCE",\r
1127         "xml": "<outcome value='SERVICE_INSTANCE'>",\r
1128         "comments": "",\r
1129         "outputs": 1,\r
1130         "x": 2157.083236694336,\r
1131         "y": 476.2777853012085,\r
1132         "z": "aa630329.50a53",\r
1133         "wires": [\r
1134             [\r
1135                 "1c77760e.ecb7ea"\r
1136             ]\r
1137         ]\r
1138     },\r
1139     {\r
1140         "id": "f9d65524.73d078",\r
1141         "type": "outcome",\r
1142         "name": "VNF_INSTANCE",\r
1143         "xml": "<outcome value='VNF_INSTANCE'>",\r
1144         "comments": "",\r
1145         "outputs": 1,\r
1146         "x": 2140.972099304199,\r
1147         "y": 522.2777843475342,\r
1148         "z": "aa630329.50a53",\r
1149         "wires": [\r
1150             [\r
1151                 "e200beea.7beb8"\r
1152             ]\r
1153         ]\r
1154     },\r
1155     {\r
1156         "id": "2e594a51.7adc16",\r
1157         "type": "failure",\r
1158         "name": "failure",\r
1159         "xml": "<outcome value='failure'>\n",\r
1160         "comments": "",\r
1161         "outputs": 1,\r
1162         "x": 2481.4800338745117,\r
1163         "y": 1888.095199584961,\r
1164         "z": "aa630329.50a53",\r
1165         "wires": [\r
1166             [\r
1167                 "dc507a17.e1ccd8"\r
1168             ]\r
1169         ]\r
1170     },\r
1171     {\r
1172         "id": "dc507a17.e1ccd8",\r
1173         "type": "returnFailure",\r
1174         "name": "return failure",\r
1175         "xml": "<return status='failure'>\n\t<parameter name='error-code' value='500'/>\n\t<parameter name='error-message' value=\"Encountered error reading GENERIC_RESOURCE_NAME table\"/>",\r
1176         "comments": "",\r
1177         "x": 2650.9800338745117,\r
1178         "y": 1888.095199584961,\r
1179         "z": "aa630329.50a53",\r
1180         "wires": []\r
1181     },\r
1182     {\r
1183         "id": "72a18f01.deeb5",\r
1184         "type": "not-found",\r
1185         "name": "not-found",\r
1186         "xml": "<outcome value='not-found'>\n",\r
1187         "comments": "",\r
1188         "outputs": 1,\r
1189         "x": 2489.480010986328,\r
1190         "y": 1934.5951929092407,\r
1191         "z": "aa630329.50a53",\r
1192         "wires": [\r
1193             [\r
1194                 "43bd72cf.d1989c"\r
1195             ]\r
1196         ]\r
1197     },\r
1198     {\r
1199         "id": "5826c7ee.56a468",\r
1200         "type": "comment",\r
1201         "name": "pfx = db.grn.prefix[]",\r
1202         "info": "",\r
1203         "comments": "",\r
1204         "x": 2214.730049133301,\r
1205         "y": 1925.5952167510986,\r
1206         "z": "aa630329.50a53",\r
1207         "wires": []\r
1208     },\r
1209     {\r
1210         "id": "5693c8f8.d296b8",\r
1211         "type": "get-resource",\r
1212         "name": "GET GENERIC_RESOURCE_NAME  (prefix)",\r
1213         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='SELECT * from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type    \n\t\tAND prefix = $tmp.rb.grn.prefix order by name_index'\n  pfx='db.grn.prefix[]'>",\r
1214         "comments": "",\r
1215         "outputs": 1,\r
1216         "x": 2193.730026245117,\r
1217         "y": 1887.845220565796,\r
1218         "z": "aa630329.50a53",\r
1219         "wires": [\r
1220             [\r
1221                 "2e594a51.7adc16",\r
1222                 "72a18f01.deeb5",\r
1223                 "97a75732.8d1778"\r
1224             ]\r
1225         ]\r
1226     },\r
1227     {\r
1228         "id": "97a75732.8d1778",\r
1229         "type": "success",\r
1230         "name": "success",\r
1231         "xml": "<outcome value='success'>\n",\r
1232         "comments": "",\r
1233         "outputs": 1,\r
1234         "x": 2483.015769958496,\r
1235         "y": 2077.5595169067383,\r
1236         "z": "aa630329.50a53",\r
1237         "wires": [\r
1238             [\r
1239                 "af5d42dd.241e1"\r
1240             ]\r
1241         ]\r
1242     },\r
1243     {\r
1244         "id": "af5d42dd.241e1",\r
1245         "type": "block",\r
1246         "name": "block",\r
1247         "xml": "<block>\n",\r
1248         "atomic": "false",\r
1249         "comments": "",\r
1250         "outputs": 1,\r
1251         "x": 2632.6587142944336,\r
1252         "y": 2077.702341079712,\r
1253         "z": "aa630329.50a53",\r
1254         "wires": [\r
1255             [\r
1256                 "255e4edf.8d20f2",\r
1257                 "46080842.900648"\r
1258             ]\r
1259         ]\r
1260     },\r
1261     {\r
1262         "id": "ad49ad2b.b9ff7",\r
1263         "type": "comment",\r
1264         "name": "Clean up holes in INDEX TABLE",\r
1265         "info": "",\r
1266         "comments": "",\r
1267         "x": 1951.694351196289,\r
1268         "y": 1831.6666927337646,\r
1269         "z": "aa630329.50a53",\r
1270         "wires": []\r
1271     },\r
1272     {\r
1273         "id": "f4c9b7ed.c5e8b8",\r
1274         "type": "set",\r
1275         "name": "set tmp.rb.sql for delete",\r
1276         "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'DELETE from ' + $rollback-generated-names.index-table-name \n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />\n\t\t\n<!--\n+ ' = $tmp.rb.grn.prefix AND index_number = $db.grn.index-table.index-number'`\" />\n-->\t\t\t\t",\r
1277         "comments": "",\r
1278         "x": 2890.4800720214844,\r
1279         "y": 1934.5952682495117,\r
1280         "z": "aa630329.50a53",\r
1281         "wires": []\r
1282     },\r
1283     {\r
1284         "id": "9004f393.79866",\r
1285         "type": "get-resource",\r
1286         "name": "DELETE from INDEX TABLE",\r
1287         "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
1288         "comments": "",\r
1289         "outputs": 1,\r
1290         "x": 2906.6585998535156,\r
1291         "y": 1980.2143020629883,\r
1292         "z": "aa630329.50a53",\r
1293         "wires": [\r
1294             [\r
1295                 "e6d51ffb.da5ef",\r
1296                 "e74e9d15.6e515"\r
1297             ]\r
1298         ]\r
1299     },\r
1300     {\r
1301         "id": "8b317be0.6cea48",\r
1302         "type": "returnFailure",\r
1303         "name": "return failure",\r
1304         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error deleting '\n\t+ $rollback-generated-names.index-table-name \n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix \n\t+ ' AND index_number = ' + $db.index-table.index-number`\" />\n\n",\r
1305         "comments": "",\r
1306         "x": 3297.2301330566406,\r
1307         "y": 1980.0953760147095,\r
1308         "z": "aa630329.50a53",\r
1309         "wires": []\r
1310     },\r
1311     {\r
1312         "id": "e6d51ffb.da5ef",\r
1313         "type": "failure",\r
1314         "name": "failure",\r
1315         "xml": "<outcome value='failure'>\n",\r
1316         "comments": "",\r
1317         "outputs": 1,\r
1318         "x": 3124.2301330566406,\r
1319         "y": 1980.5953760147095,\r
1320         "z": "aa630329.50a53",\r
1321         "wires": [\r
1322             [\r
1323                 "8b317be0.6cea48"\r
1324             ]\r
1325         ]\r
1326     },\r
1327     {\r
1328         "id": "e74e9d15.6e515",\r
1329         "type": "not-found",\r
1330         "name": "not-found",\r
1331         "xml": "<outcome value='not-found'>\n",\r
1332         "comments": "",\r
1333         "outputs": 1,\r
1334         "x": 3131.0755348205566,\r
1335         "y": 2027.0835180282593,\r
1336         "z": "aa630329.50a53",\r
1337         "wires": [\r
1338             [\r
1339                 "9ba26a8.310e298"\r
1340             ]\r
1341         ]\r
1342     },\r
1343     {\r
1344         "id": "77aa82ec.ea575c",\r
1345         "type": "comment",\r
1346         "name": "Delete prefix from INDEX TABLE",\r
1347         "info": "",\r
1348         "comments": "",\r
1349         "x": 3160.730209350586,\r
1350         "y": 1936.5953397750854,\r
1351         "z": "aa630329.50a53",\r
1352         "wires": []\r
1353     },\r
1354     {\r
1355         "id": "2d8ded7b.a5e7e2",\r
1356         "type": "comment",\r
1357         "name": "Silence SUCCESS",\r
1358         "info": "",\r
1359         "comments": "",\r
1360         "x": 3387.730140686035,\r
1361         "y": 2038.5952835083008,\r
1362         "z": "aa630329.50a53",\r
1363         "wires": []\r
1364     },\r
1365     {\r
1366         "id": "9ba26a8.310e298",\r
1367         "type": "block",\r
1368         "name": "block",\r
1369         "xml": "<block>\n",\r
1370         "atomic": "false",\r
1371         "comments": "",\r
1372         "outputs": 1,\r
1373         "x": 3279.980136871338,\r
1374         "y": 2026.8452854156494,\r
1375         "z": "aa630329.50a53",\r
1376         "wires": [\r
1377             []\r
1378         ]\r
1379     },\r
1380     {\r
1381         "id": "43bd72cf.d1989c",\r
1382         "type": "block",\r
1383         "name": "block",\r
1384         "xml": "<block>",\r
1385         "atomic": "false",\r
1386         "comments": "",\r
1387         "outputs": 1,\r
1388         "x": 2637.1943588256836,\r
1389         "y": 1934.9166927337646,\r
1390         "z": "aa630329.50a53",\r
1391         "wires": [\r
1392             [\r
1393                 "f4c9b7ed.c5e8b8",\r
1394                 "9004f393.79866"\r
1395             ]\r
1396         ]\r
1397     },\r
1398     {\r
1399         "id": "255e4edf.8d20f2",\r
1400         "type": "set",\r
1401         "name": "set tmp.rb.grn.last-max-index",\r
1402         "xml": "<set>\n<parameter name='tmp.rb.grn.last-max-index' \n\tvalue='`$db.grn.prefix[$db.grn.prefix_length - 1].name-index`' />\n",\r
1403         "comments": "",\r
1404         "x": 2855.6943588256836,\r
1405         "y": 2077.916696548462,\r
1406         "z": "aa630329.50a53",\r
1407         "wires": []\r
1408     },\r
1409     {\r
1410         "id": "46080842.900648",\r
1411         "type": "switchNode",\r
1412         "name": "switch: index_number > last-max-index",\r
1413         "xml": "<switch test=\"`$tmp.rb.net-index > $tmp.rb.grn.last-max-index`\">",\r
1414         "comments": "",\r
1415         "outputs": 1,\r
1416         "x": 2884.944366455078,\r
1417         "y": 2121.916696548462,\r
1418         "z": "aa630329.50a53",\r
1419         "wires": [\r
1420             [\r
1421                 "88ac47d8.6bb598"\r
1422             ]\r
1423         ]\r
1424     },\r
1425     {\r
1426         "id": "88ac47d8.6bb598",\r
1427         "type": "outcomeTrue",\r
1428         "name": "true",\r
1429         "xml": "<outcome value='true'>\n",\r
1430         "comments": "",\r
1431         "outputs": 1,\r
1432         "x": 3124.9443359375,\r
1433         "y": 2121.416664123535,\r
1434         "z": "aa630329.50a53",\r
1435         "wires": [\r
1436             [\r
1437                 "c1f045de.3e28c8"\r
1438             ]\r
1439         ]\r
1440     },\r
1441     {\r
1442         "id": "ee302e41.39dd1",\r
1443         "type": "set",\r
1444         "name": "set tmp.rb.sql for update",\r
1445         "xml": "<set>\n<parameter name='tmp.rb.sql' \n\tvalue=\"`'UPDATE ' + $rollback-generated-names.index-table-name \n\t\t+ ' set index_number = ' + $tmp.rb.grn.last-max-index\n\t\t+ ' WHERE ' + $rollback-generated-names.index-table.name-prefix-column \n\t\t+ ' = $tmp.rb.grn.prefix'`\" />",\r
1446         "comments": "",\r
1447         "x": 3473.194366455078,\r
1448         "y": 2121.416696548462,\r
1449         "z": "aa630329.50a53",\r
1450         "wires": []\r
1451     },\r
1452     {\r
1453         "id": "b61cd1a1.4af9b",\r
1454         "type": "get-resource",\r
1455         "name": "Update  INDEX TABLE",\r
1456         "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.rb.sql`\">\n\n",\r
1457         "comments": "",\r
1458         "outputs": 1,\r
1459         "x": 3469.3728942871094,\r
1460         "y": 2166.0357303619385,\r
1461         "z": "aa630329.50a53",\r
1462         "wires": [\r
1463             [\r
1464                 "5241d984.6b2458",\r
1465                 "19f1dadd.4da2c5"\r
1466             ]\r
1467         ]\r
1468     },\r
1469     {\r
1470         "id": "2583f2fc.38be4e",\r
1471         "type": "returnFailure",\r
1472         "name": "return failure",\r
1473         "xml": "<return status='failure'>\n<parameter name='error-message' value=\"`'Error updating  '\n\t+ $rollback-generated-names.index-table-name + '.index_number = ' \n\t+ $tmp.rb.grn.last-max-index\n\t+ ' WHERE ' + $rollback-generated-names.name-prefix-column \n\t+ ' = ' + $tmp.rb.grn.prefix`\" />\n\n",\r
1474         "comments": "",\r
1475         "x": 3851.9443740844727,\r
1476         "y": 2166.9169409275055,\r
1477         "z": "aa630329.50a53",\r
1478         "wires": []\r
1479     },\r
1480     {\r
1481         "id": "5241d984.6b2458",\r
1482         "type": "failure",\r
1483         "name": "failure",\r
1484         "xml": "<outcome value='failure'>\n",\r
1485         "comments": "",\r
1486         "outputs": 1,\r
1487         "x": 3678.9444274902344,\r
1488         "y": 2166.4168043136597,\r
1489         "z": "aa630329.50a53",\r
1490         "wires": [\r
1491             [\r
1492                 "2583f2fc.38be4e"\r
1493             ]\r
1494         ]\r
1495     },\r
1496     {\r
1497         "id": "19f1dadd.4da2c5",\r
1498         "type": "not-found",\r
1499         "name": "not-found",\r
1500         "xml": "<outcome value='not-found'>\n",\r
1501         "comments": "",\r
1502         "outputs": 1,\r
1503         "x": 3685.7898292541504,\r
1504         "y": 2212.9049463272095,\r
1505         "z": "aa630329.50a53",\r
1506         "wires": [\r
1507             [\r
1508                 "2583f2fc.38be4e"\r
1509             ]\r
1510         ]\r
1511     },\r
1512     {\r
1513         "id": "370184fa.2c436c",\r
1514         "type": "comment",\r
1515         "name": "Update prefix from INDEX TABLE",\r
1516         "info": "",\r
1517         "comments": "",\r
1518         "x": 3425.1944274902344,\r
1519         "y": 2198.666709423065,\r
1520         "z": "aa630329.50a53",\r
1521         "wires": []\r
1522     },\r
1523     {\r
1524         "id": "c1f045de.3e28c8",\r
1525         "type": "block",\r
1526         "name": "block",\r
1527         "xml": "<block>\n",\r
1528         "atomic": "false",\r
1529         "comments": "",\r
1530         "outputs": 1,\r
1531         "x": 3274.4443359375,\r
1532         "y": 2121.666664123535,\r
1533         "z": "aa630329.50a53",\r
1534         "wires": [\r
1535             [\r
1536                 "ee302e41.39dd1",\r
1537                 "b61cd1a1.4af9b"\r
1538             ]\r
1539         ]\r
1540     },\r
1541     {\r
1542         "id": "1fa487d3.8ad6e8",\r
1543         "type": "set",\r
1544         "name": "set db.grn.distinct-prefix_length = 0",\r
1545         "xml": "<set>\n<parameter name='db.grn.distinct-prefix_length' value='0' />\n",\r
1546         "comments": "",\r
1547         "x": 2298.194351196289,\r
1548         "y": 739.6666774749756,\r
1549         "z": "aa630329.50a53",\r
1550         "wires": []\r
1551     },\r
1552     {\r
1553         "id": "888a84ae.33c888",\r
1554         "type": "service-logic",\r
1555         "name": "GENERIC-RESOURCE-API ${project.version}",\r
1556         "module": "GENERIC-RESOURCE-API",\r
1557         "version": "${project.version}",\r
1558         "comments": "",\r
1559         "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
1560         "outputs": 1,\r
1561         "x": 1609.0277099609375,\r
1562         "y": 20,\r
1563         "z": "aa630329.50a53",\r
1564         "wires": [\r
1565             [\r
1566                 "ed968adc.8ee998"\r
1567             ]\r
1568         ]\r
1569     },\r
1570     {\r
1571         "id": "e200beea.7beb8",\r
1572         "type": "set",\r
1573         "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
1574         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' value='VNF_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='vnf_name_prefix' />\n\n",\r
1575         "comments": "",\r
1576         "x": 2671.805435180664,\r
1577         "y": 555.3333234786987,\r
1578         "z": "aa630329.50a53",\r
1579         "wires": []\r
1580     },\r
1581     {\r
1582         "id": "83af09d2.c65ec8",\r
1583         "type": "set",\r
1584         "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
1585         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='NETWORK_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='network_instance_name_prefix' />\n\n",\r
1586         "comments": "",\r
1587         "x": 2557.6943359375,\r
1588         "y": 426.66666412353516,\r
1589         "z": "aa630329.50a53",\r
1590         "wires": []\r
1591     },\r
1592     {\r
1593         "id": "98dce5f3.4de788",\r
1594         "type": "set",\r
1595         "name": "set tmp.rb.naming-index-table-name and prefix column, grn.type",\r
1596         "xml": "<set>\n<parameter name='rollback-generated-names.index-table-name' \n\tvalue='SERVICE_INSTANCE_NAME_INDEX' />\n<parameter name='rollback-generated-names.index-table.name-prefix-column' \n\tvalue='service_instance_name_prefix' />\n\n",\r
1597         "comments": "",\r
1598         "x": 2741.027633666992,\r
1599         "y": 474.4444389343262,\r
1600         "z": "aa630329.50a53",\r
1601         "wires": []\r
1602     },\r
1603     {\r
1604         "id": "1c77760e.ecb7ea",\r
1605         "type": "block",\r
1606         "name": "block",\r
1607         "xml": "<block>\n",\r
1608         "atomic": "false",\r
1609         "comments": "",\r
1610         "outputs": 1,\r
1611         "x": 2356.6666666666665,\r
1612         "y": 474.44444444444446,\r
1613         "z": "aa630329.50a53",\r
1614         "wires": [\r
1615             [\r
1616                 "98dce5f3.4de788",\r
1617                 "3647a166.a299ee"\r
1618             ]\r
1619         ]\r
1620     },\r
1621     {\r
1622         "id": "3647a166.a299ee",\r
1623         "type": "get-resource",\r
1624         "name": "DELETE service instance name",\r
1625         "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n\tkey='DELETE from GENERIC_RESOURCE_NAME WHERE type = $rollback-generated-names-input.naming-type  \n\t\tAND context_id = $rollback-generated-names-input.context-id AND prefix IS NULL AND name_index IS NULL'>",\r
1626         "comments": "",\r
1627         "outputs": 1,\r
1628         "x": 2582.2221870422363,\r
1629         "y": 512.222222328186,\r
1630         "z": "aa630329.50a53",\r
1631         "wires": [\r
1632             []\r
1633         ]\r
1634     },\r
1635     {\r
1636         "id": "7a0ecea1.020ae",\r
1637         "type": "comment",\r
1638         "name": "quick path to delete instance name",\r
1639         "info": "If no prefix and name_index involved, it can be deleted now",\r
1640         "comments": "",\r
1641         "x": 2838.888832092285,\r
1642         "y": 518.8889126777649,\r
1643         "z": "aa630329.50a53",\r
1644         "wires": []\r
1645     }\r
1646 ]