3 "id": "29cb883a.884228",
\r
7 "x": 1334.4443359375,
\r
8 "y": 20.416664123535156,
\r
9 "z": "aa630329.50a53",
\r
17 "id": "ed968adc.8ee998",
\r
19 "name": "method rollback-generated-names",
\r
20 "xml": "<method rpc='rollback-generated-names' mode='sync'>\n",
\r
23 "x": 1459.5157623291016,
\r
24 "y": 91.84523582458496,
\r
25 "z": "aa630329.50a53",
\r
33 "id": "75650b62.fb7214",
\r
35 "name": "block : atomic",
\r
36 "xml": "<block atomic=\"true\">",
\r
40 "x": 1458.7300567626953,
\r
41 "y": 173.2738151550293,
\r
42 "z": "aa630329.50a53",
\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
60 "x": 1780.2776489257812,
\r
61 "y": 172.33332443237305,
\r
62 "z": "aa630329.50a53",
\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
76 "x": 1787.444351196289,
\r
77 "y": 232.16666793823242,
\r
78 "z": "aa630329.50a53",
\r
93 "id": "49e2a20b.aa74ac",
\r
96 "xml": "<outcome value=''>",
\r
99 "x": 2058.694351196289,
\r
100 "y": 172.91666793823242,
\r
101 "z": "aa630329.50a53",
\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
114 "x": 2225.3486518859863,
\r
115 "y": 172.31190013885498,
\r
116 "z": "aa630329.50a53",
\r
120 "id": "19ba8656.ba40ea",
\r
123 "xml": "<outcome value=''>",
\r
126 "x": 2102.1943359375,
\r
127 "y": 231.91666412353516,
\r
128 "z": "aa630329.50a53",
\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
141 "x": 2268.4443550109863,
\r
142 "y": 231.91666793823242,
\r
143 "z": "aa630329.50a53",
\r
147 "id": "fbafb911.c1a228",
\r
149 "name": "VM_INSTANCE",
\r
150 "xml": "<outcome value='VM_INSTANCE'>",
\r
153 "x": 2130.1943740844727,
\r
154 "y": 279.52380752563477,
\r
155 "z": "aa630329.50a53",
\r
163 "id": "aaaeba77.eb1d38",
\r
165 "name": "VNFC_INSTANCE",
\r
166 "xml": "<outcome value='VNFC_INSTANCE'>",
\r
169 "x": 2140.444366455078,
\r
170 "y": 327.0238094329834,
\r
171 "z": "aa630329.50a53",
\r
179 "id": "14f5428c.d3dd3d",
\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
184 "x": 2551.694351196289,
\r
185 "y": 279.66666984558105,
\r
186 "z": "aa630329.50a53",
\r
190 "id": "b191361f.e39258",
\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
195 "x": 2553.944351196289,
\r
196 "y": 326.9166717529297,
\r
197 "z": "aa630329.50a53",
\r
201 "id": "c6b37ac7.e80618",
\r
204 "xml": "<outcome value='Other'>",
\r
207 "x": 2107.6943359375,
\r
208 "y": 571.1666641235352,
\r
209 "z": "aa630329.50a53",
\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
222 "x": 2273.9443550109863,
\r
223 "y": 571.1666679382324,
\r
224 "z": "aa630329.50a53",
\r
228 "id": "1f6886e.08cdb79",
\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
233 "x": 2301.110996246338,
\r
234 "y": 1108.2499651908875,
\r
235 "z": "aa630329.50a53",
\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
245 "x": 2369.78946685791,
\r
246 "y": 1156.1190004348755,
\r
247 "z": "aa630329.50a53",
\r
256 "id": "bf055860.21dff8",
\r
258 "name": "block : atomic",
\r
259 "xml": "<block atomic='true'>",
\r
263 "x": 2110.1109924316406,
\r
264 "y": 1108.7499656677246,
\r
265 "z": "aa630329.50a53",
\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
279 "x": 2786.361000061035,
\r
280 "y": 1157.0000743865967,
\r
281 "z": "aa630329.50a53",
\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
290 "x": 2786.03946685791,
\r
291 "y": 1202.7857494354248,
\r
292 "z": "aa630329.50a53",
\r
296 "id": "4bac1a75.3bf994",
\r
299 "xml": "<outcome value='failure'>\n",
\r
302 "x": 2613.361000061035,
\r
303 "y": 1156.5000743865967,
\r
304 "z": "aa630329.50a53",
\r
312 "id": "9830d2f4.14e32",
\r
313 "type": "not-found",
\r
314 "name": "not-found",
\r
315 "xml": "<outcome value='not-found'>\n",
\r
318 "x": 2620.206401824951,
\r
319 "y": 1202.9882164001465,
\r
320 "z": "aa630329.50a53",
\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
334 "x": 1778.1109619140625,
\r
335 "y": 692.9999885559082,
\r
336 "z": "aa630329.50a53",
\r
345 "id": "6cb3df87.7e0ec",
\r
348 "xml": "<outcome value='failure'>\n",
\r
351 "x": 2057.8609619140625,
\r
352 "y": 692.9999809265137,
\r
353 "z": "aa630329.50a53",
\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
366 "x": 2227.3609619140625,
\r
367 "y": 692.9999809265137,
\r
368 "z": "aa630329.50a53",
\r
372 "id": "727c9c85.dfe244",
\r
373 "type": "not-found",
\r
374 "name": "not-found",
\r
375 "xml": "<outcome value='not-found'>\n",
\r
378 "x": 2065.860939025879,
\r
379 "y": 739.4999742507935,
\r
380 "z": "aa630329.50a53",
\r
388 "id": "314b583f.7203e8",
\r
390 "name": "pfx = db.grn.distinct-prefix[]",
\r
393 "x": 1770.3610076904297,
\r
394 "y": 730.4999885559082,
\r
395 "z": "aa630329.50a53",
\r
399 "id": "b6ebcdec.0165b",
\r
401 "name": "for each distinct prefix",
\r
402 "xml": "<for index='prefix-index' start='0' end='`$db.grn.distinct-prefix_length`' >\n",
\r
405 "x": 1682.6109924316406,
\r
406 "y": 855.4999713897705,
\r
407 "z": "aa630329.50a53",
\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
421 "x": 2227.6109886169434,
\r
422 "y": 995.2499618530273,
\r
423 "z": "aa630329.50a53",
\r
432 "id": "3b74e0d1.8867b",
\r
435 "xml": "<outcome value='failure'>\n",
\r
438 "x": 2545.3609886169434,
\r
439 "y": 995.2499542236328,
\r
440 "z": "aa630329.50a53",
\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
453 "x": 2714.8609886169434,
\r
454 "y": 995.2499542236328,
\r
455 "z": "aa630329.50a53",
\r
459 "id": "cd385c50.732c1",
\r
460 "type": "not-found",
\r
461 "name": "not-found",
\r
462 "xml": "<outcome value='not-found'>\n",
\r
465 "x": 2553.3609657287598,
\r
466 "y": 1041.7499475479126,
\r
467 "z": "aa630329.50a53",
\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
480 "x": 2716.6110038757324,
\r
481 "y": 1041.499963760376,
\r
482 "z": "aa630329.50a53",
\r
486 "id": "aec883e2.d2ce2",
\r
488 "name": "pfx = db.grn.subset[]",
\r
491 "x": 2298.6110038757324,
\r
492 "y": 1032.7499713897705,
\r
493 "z": "aa630329.50a53",
\r
497 "id": "615652ba.fc923c",
\r
499 "name": "block : atomic",
\r
500 "xml": "<block atomic='true'>",
\r
504 "x": 1892.860984802246,
\r
505 "y": 855.2499618530273,
\r
506 "z": "aa630329.50a53",
\r
524 "id": "d73de031.6f6f9",
\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
529 "x": 2130.1109733581543,
\r
530 "y": 945.9999675750732,
\r
531 "z": "aa630329.50a53",
\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
541 "x": 2589.027786254883,
\r
542 "y": 1406.0832901000977,
\r
543 "z": "aa630329.50a53",
\r
552 "id": "ab812023.4d106",
\r
554 "name": "pfx = db.grn.index-table",
\r
557 "x": 2405.8609771728516,
\r
558 "y": 1192.7499542236328,
\r
559 "z": "aa630329.50a53",
\r
563 "id": "5bc6188.f631ce8",
\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
568 "x": 2138.6109924316406,
\r
569 "y": 1262.7499685287476,
\r
570 "z": "aa630329.50a53",
\r
574 "id": "5b7f4beb.293b54",
\r
576 "name": "clear tmp.rb.",
\r
577 "xml": "<set>\n<parameter name='tmp.rb.' value='' />\n",
\r
579 "x": 2105.1109580993652,
\r
580 "y": 899.2499523162842,
\r
581 "z": "aa630329.50a53",
\r
585 "id": "d35c0a8.e055af8",
\r
587 "name": "clear db.grn.",
\r
588 "xml": "<set>\n<parameter name='db.grn.' value='' />\n",
\r
590 "x": 1661.249885559082,
\r
591 "y": 639.4444446563721,
\r
592 "z": "aa630329.50a53",
\r
596 "id": "71d6da4f.c71d64",
\r
598 "name": "clear db.grn.subset.",
\r
599 "xml": "<set>\n<parameter name='db.grn.subset.' value='' />\n",
\r
601 "x": 2126.1109924316406,
\r
602 "y": 855.499960899353,
\r
603 "z": "aa630329.50a53",
\r
607 "id": "f019211a.03f21",
\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
612 "x": 3201.777618408203,
\r
613 "y": 1406.08327293396,
\r
614 "z": "aa630329.50a53",
\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
624 "x": 3217.9561462402344,
\r
625 "y": 1451.7023067474365,
\r
626 "z": "aa630329.50a53",
\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
640 "x": 3626.5276794433594,
\r
641 "y": 1451.5833806991577,
\r
642 "z": "aa630329.50a53",
\r
646 "id": "2a3eafed.800b2",
\r
649 "xml": "<outcome value='failure'>\n",
\r
652 "x": 3453.5276794433594,
\r
653 "y": 1452.0833806991577,
\r
654 "z": "aa630329.50a53",
\r
662 "id": "9929948e.80baa8",
\r
663 "type": "not-found",
\r
664 "name": "not-found",
\r
665 "xml": "<outcome value='not-found'>\n",
\r
668 "x": 3460.3730812072754,
\r
669 "y": 1498.5715227127075,
\r
670 "z": "aa630329.50a53",
\r
678 "id": "138bb542.26235b",
\r
680 "name": "block : atomic",
\r
681 "xml": "<block atomic='true'>",
\r
685 "x": 2969.277671813965,
\r
686 "y": 1405.8332901000977,
\r
687 "z": "aa630329.50a53",
\r
696 "id": "1bd95123.da921f",
\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
701 "x": 2216.6109924316406,
\r
702 "y": 1307.9999675750732,
\r
703 "z": "aa630329.50a53",
\r
707 "id": "ae547b4c.5ee188",
\r
708 "type": "outcomeTrue",
\r
710 "xml": "<outcome value='true'>\n",
\r
713 "x": 2802.7776489257812,
\r
714 "y": 1406.0832710266113,
\r
715 "z": "aa630329.50a53",
\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
729 "x": 2199.4562072753906,
\r
730 "y": 1743.9523639678955,
\r
731 "z": "aa630329.50a53",
\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
745 "x": 2651.0277404785156,
\r
746 "y": 1744.8334379196167,
\r
747 "z": "aa630329.50a53",
\r
751 "id": "c5dfbac3.eb7ac8",
\r
754 "xml": "<outcome value='failure'>\n",
\r
757 "x": 2478.0277404785156,
\r
758 "y": 1744.3334379196167,
\r
759 "z": "aa630329.50a53",
\r
767 "id": "d5e547a5.1eafc8",
\r
768 "type": "not-found",
\r
769 "name": "not-found",
\r
770 "xml": "<outcome value='not-found'>\n",
\r
773 "x": 2484.8730850219727,
\r
774 "y": 1790.8216247558594,
\r
775 "z": "aa630329.50a53",
\r
783 "id": "c25429a5.1b65a8",
\r
785 "name": "Delete prefix from INDEX TABLE",
\r
788 "x": 3472.0277557373047,
\r
789 "y": 1408.0833444595337,
\r
790 "z": "aa630329.50a53",
\r
794 "id": "4b654cba.5ced54",
\r
796 "name": "Silence SUCCESS",
\r
799 "x": 3717.027687072754,
\r
800 "y": 1510.083288192749,
\r
801 "z": "aa630329.50a53",
\r
805 "id": "ce9cb4be.d8f5e8",
\r
808 "xml": "<block>\n",
\r
812 "x": 3609.2776832580566,
\r
813 "y": 1498.3332901000977,
\r
814 "z": "aa630329.50a53",
\r
820 "id": "de514521.1f6668",
\r
821 "type": "outcomeFalse",
\r
823 "xml": "<outcome value='false'>\n",
\r
826 "x": 2801.777732849121,
\r
827 "y": 1591.3333129882812,
\r
828 "z": "aa630329.50a53",
\r
836 "id": "666b02e.502d0fc",
\r
838 "name": "index_number > $db.grn.subset_length; i.e hole in the middle. DO NOTHING",
\r
841 "x": 2392.5277557373047,
\r
842 "y": 1530.083345413208,
\r
843 "z": "aa630329.50a53",
\r
847 "id": "b133d8d2.574fa8",
\r
849 "name": "Silence SUCCESS",
\r
852 "x": 2741.027587890625,
\r
853 "y": 1802.3333225250244,
\r
854 "z": "aa630329.50a53",
\r
858 "id": "a4121e26.ea489",
\r
861 "xml": "<block>\n",
\r
865 "x": 2633.2775840759277,
\r
866 "y": 1790.583324432373,
\r
867 "z": "aa630329.50a53",
\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
879 "x": 2155.0276641845703,
\r
880 "y": 1406.333288192749,
\r
881 "z": "aa630329.50a53",
\r
890 "id": "ebc810ff.c3a11",
\r
891 "type": "outcomeTrue",
\r
893 "xml": "<outcome value='true'>\n",
\r
896 "x": 2382.2776489257812,
\r
897 "y": 1406.3332710266113,
\r
898 "z": "aa630329.50a53",
\r
906 "id": "9160dc95.b9431",
\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
911 "x": 3208.527687072754,
\r
912 "y": 1591.3332977294922,
\r
913 "z": "aa630329.50a53",
\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
923 "x": 3204.706214904785,
\r
924 "y": 1636.9523315429688,
\r
925 "z": "aa630329.50a53",
\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
939 "x": 3610.27774810791,
\r
940 "y": 1636.83340549469,
\r
941 "z": "aa630329.50a53",
\r
945 "id": "e86d1619.af6ed8",
\r
948 "xml": "<outcome value='failure'>\n",
\r
951 "x": 3418.27774810791,
\r
952 "y": 1637.33340549469,
\r
953 "z": "aa630329.50a53",
\r
961 "id": "79602d4f.9dc9b4",
\r
962 "type": "not-found",
\r
963 "name": "not-found",
\r
964 "xml": "<outcome value='not-found'>\n",
\r
967 "x": 3425.123149871826,
\r
968 "y": 1683.8215475082397,
\r
969 "z": "aa630329.50a53",
\r
977 "id": "e961bcf0.f03cb",
\r
979 "name": "block : atomic",
\r
980 "xml": "<block atomic='true'>",
\r
984 "x": 2969.0277404785156,
\r
985 "y": 1591.0833148956299,
\r
986 "z": "aa630329.50a53",
\r
995 "id": "d4cb9489.bfce78",
\r
997 "name": "Update prefix from INDEX TABLE",
\r
1000 "x": 3160.52774810791,
\r
1001 "y": 1669.5833106040955,
\r
1002 "z": "aa630329.50a53",
\r
1006 "id": "c3fa064.1eee4f8",
\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
1011 "x": 2247.3609771728516,
\r
1012 "y": 1355.4999523162842,
\r
1013 "z": "aa630329.50a53",
\r
1017 "id": "1fda938f.3dbb9c",
\r
1018 "type": "comment",
\r
1019 "name": "index_number == max index",
\r
1022 "x": 2032.8609924316406,
\r
1023 "y": 1449.2499694824219,
\r
1024 "z": "aa630329.50a53",
\r
1028 "id": "d76b3389.44a7f",
\r
1029 "type": "comment",
\r
1030 "name": "index_number == $db.grn.subset_length",
\r
1033 "x": 2660.3609924316406,
\r
1034 "y": 1366.7499694824219,
\r
1035 "z": "aa630329.50a53",
\r
1039 "id": "cc537a09.f92948",
\r
1040 "type": "outcomeFalse",
\r
1042 "xml": "<outcome value='false'>\n",
\r
1045 "x": 2390.3609924316406,
\r
1046 "y": 1575.4999685287476,
\r
1047 "z": "aa630329.50a53",
\r
1055 "id": "a8f99767.daacf8",
\r
1058 "xml": "<block>\n",
\r
1059 "atomic": "false",
\r
1062 "x": 2534.111000061035,
\r
1063 "y": 1575.7499713897705,
\r
1064 "z": "aa630329.50a53",
\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
1075 "x": 1813.1943435668945,
\r
1076 "y": 65.41666603088379,
\r
1077 "z": "aa630329.50a53",
\r
1081 "id": "3d5fa372.a6850c",
\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
1086 "x": 2579.4443359375,
\r
1087 "y": 377.41666412353516,
\r
1088 "z": "aa630329.50a53",
\r
1092 "id": "1516480b.27b978",
\r
1093 "type": "outcome",
\r
1094 "name": "CLIENT_KEY",
\r
1095 "xml": "<outcome value='CLIENT_KEY'>",
\r
1098 "x": 2127.194351196289,
\r
1099 "y": 377.0238037109375,
\r
1100 "z": "aa630329.50a53",
\r
1108 "id": "943b3579.515908",
\r
1109 "type": "outcome",
\r
1110 "name": "NETWORK_INSTANCE",
\r
1111 "xml": "<outcome value='NETWORK_INSTANCE'>",
\r
1114 "x": 2158.972099304199,
\r
1115 "y": 427.2777690887451,
\r
1116 "z": "aa630329.50a53",
\r
1124 "id": "ffdb86fd.ed9ae8",
\r
1125 "type": "outcome",
\r
1126 "name": "SERVICE_INSTANCE",
\r
1127 "xml": "<outcome value='SERVICE_INSTANCE'>",
\r
1130 "x": 2157.083236694336,
\r
1131 "y": 476.2777853012085,
\r
1132 "z": "aa630329.50a53",
\r
1140 "id": "f9d65524.73d078",
\r
1141 "type": "outcome",
\r
1142 "name": "VNF_INSTANCE",
\r
1143 "xml": "<outcome value='VNF_INSTANCE'>",
\r
1146 "x": 2140.972099304199,
\r
1147 "y": 522.2777843475342,
\r
1148 "z": "aa630329.50a53",
\r
1156 "id": "2e594a51.7adc16",
\r
1157 "type": "failure",
\r
1158 "name": "failure",
\r
1159 "xml": "<outcome value='failure'>\n",
\r
1162 "x": 2481.4800338745117,
\r
1163 "y": 1888.095199584961,
\r
1164 "z": "aa630329.50a53",
\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
1177 "x": 2650.9800338745117,
\r
1178 "y": 1888.095199584961,
\r
1179 "z": "aa630329.50a53",
\r
1183 "id": "72a18f01.deeb5",
\r
1184 "type": "not-found",
\r
1185 "name": "not-found",
\r
1186 "xml": "<outcome value='not-found'>\n",
\r
1189 "x": 2489.480010986328,
\r
1190 "y": 1934.5951929092407,
\r
1191 "z": "aa630329.50a53",
\r
1199 "id": "5826c7ee.56a468",
\r
1200 "type": "comment",
\r
1201 "name": "pfx = db.grn.prefix[]",
\r
1204 "x": 2214.730049133301,
\r
1205 "y": 1925.5952167510986,
\r
1206 "z": "aa630329.50a53",
\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
1216 "x": 2193.730026245117,
\r
1217 "y": 1887.845220565796,
\r
1218 "z": "aa630329.50a53",
\r
1221 "2e594a51.7adc16",
\r
1228 "id": "97a75732.8d1778",
\r
1229 "type": "success",
\r
1230 "name": "success",
\r
1231 "xml": "<outcome value='success'>\n",
\r
1234 "x": 2483.015769958496,
\r
1235 "y": 2077.5595169067383,
\r
1236 "z": "aa630329.50a53",
\r
1244 "id": "af5d42dd.241e1",
\r
1247 "xml": "<block>\n",
\r
1248 "atomic": "false",
\r
1251 "x": 2632.6587142944336,
\r
1252 "y": 2077.702341079712,
\r
1253 "z": "aa630329.50a53",
\r
1256 "255e4edf.8d20f2",
\r
1262 "id": "ad49ad2b.b9ff7",
\r
1263 "type": "comment",
\r
1264 "name": "Clean up holes in INDEX TABLE",
\r
1267 "x": 1951.694351196289,
\r
1268 "y": 1831.6666927337646,
\r
1269 "z": "aa630329.50a53",
\r
1273 "id": "f4c9b7ed.c5e8b8",
\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
1278 "x": 2890.4800720214844,
\r
1279 "y": 1934.5952682495117,
\r
1280 "z": "aa630329.50a53",
\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
1290 "x": 2906.6585998535156,
\r
1291 "y": 1980.2143020629883,
\r
1292 "z": "aa630329.50a53",
\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
1306 "x": 3297.2301330566406,
\r
1307 "y": 1980.0953760147095,
\r
1308 "z": "aa630329.50a53",
\r
1312 "id": "e6d51ffb.da5ef",
\r
1313 "type": "failure",
\r
1314 "name": "failure",
\r
1315 "xml": "<outcome value='failure'>\n",
\r
1318 "x": 3124.2301330566406,
\r
1319 "y": 1980.5953760147095,
\r
1320 "z": "aa630329.50a53",
\r
1328 "id": "e74e9d15.6e515",
\r
1329 "type": "not-found",
\r
1330 "name": "not-found",
\r
1331 "xml": "<outcome value='not-found'>\n",
\r
1334 "x": 3131.0755348205566,
\r
1335 "y": 2027.0835180282593,
\r
1336 "z": "aa630329.50a53",
\r
1344 "id": "77aa82ec.ea575c",
\r
1345 "type": "comment",
\r
1346 "name": "Delete prefix from INDEX TABLE",
\r
1349 "x": 3160.730209350586,
\r
1350 "y": 1936.5953397750854,
\r
1351 "z": "aa630329.50a53",
\r
1355 "id": "2d8ded7b.a5e7e2",
\r
1356 "type": "comment",
\r
1357 "name": "Silence SUCCESS",
\r
1360 "x": 3387.730140686035,
\r
1361 "y": 2038.5952835083008,
\r
1362 "z": "aa630329.50a53",
\r
1366 "id": "9ba26a8.310e298",
\r
1369 "xml": "<block>\n",
\r
1370 "atomic": "false",
\r
1373 "x": 3279.980136871338,
\r
1374 "y": 2026.8452854156494,
\r
1375 "z": "aa630329.50a53",
\r
1381 "id": "43bd72cf.d1989c",
\r
1385 "atomic": "false",
\r
1388 "x": 2637.1943588256836,
\r
1389 "y": 1934.9166927337646,
\r
1390 "z": "aa630329.50a53",
\r
1393 "f4c9b7ed.c5e8b8",
\r
1399 "id": "255e4edf.8d20f2",
\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
1404 "x": 2855.6943588256836,
\r
1405 "y": 2077.916696548462,
\r
1406 "z": "aa630329.50a53",
\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
1416 "x": 2884.944366455078,
\r
1417 "y": 2121.916696548462,
\r
1418 "z": "aa630329.50a53",
\r
1426 "id": "88ac47d8.6bb598",
\r
1427 "type": "outcomeTrue",
\r
1429 "xml": "<outcome value='true'>\n",
\r
1432 "x": 3124.9443359375,
\r
1433 "y": 2121.416664123535,
\r
1434 "z": "aa630329.50a53",
\r
1442 "id": "ee302e41.39dd1",
\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
1447 "x": 3473.194366455078,
\r
1448 "y": 2121.416696548462,
\r
1449 "z": "aa630329.50a53",
\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
1459 "x": 3469.3728942871094,
\r
1460 "y": 2166.0357303619385,
\r
1461 "z": "aa630329.50a53",
\r
1464 "5241d984.6b2458",
\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
1475 "x": 3851.9443740844727,
\r
1476 "y": 2166.9169409275055,
\r
1477 "z": "aa630329.50a53",
\r
1481 "id": "5241d984.6b2458",
\r
1482 "type": "failure",
\r
1483 "name": "failure",
\r
1484 "xml": "<outcome value='failure'>\n",
\r
1487 "x": 3678.9444274902344,
\r
1488 "y": 2166.4168043136597,
\r
1489 "z": "aa630329.50a53",
\r
1497 "id": "19f1dadd.4da2c5",
\r
1498 "type": "not-found",
\r
1499 "name": "not-found",
\r
1500 "xml": "<outcome value='not-found'>\n",
\r
1503 "x": 3685.7898292541504,
\r
1504 "y": 2212.9049463272095,
\r
1505 "z": "aa630329.50a53",
\r
1513 "id": "370184fa.2c436c",
\r
1514 "type": "comment",
\r
1515 "name": "Update prefix from INDEX TABLE",
\r
1518 "x": 3425.1944274902344,
\r
1519 "y": 2198.666709423065,
\r
1520 "z": "aa630329.50a53",
\r
1524 "id": "c1f045de.3e28c8",
\r
1527 "xml": "<block>\n",
\r
1528 "atomic": "false",
\r
1531 "x": 3274.4443359375,
\r
1532 "y": 2121.666664123535,
\r
1533 "z": "aa630329.50a53",
\r
1542 "id": "1fa487d3.8ad6e8",
\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
1547 "x": 2298.194351196289,
\r
1548 "y": 739.6666774749756,
\r
1549 "z": "aa630329.50a53",
\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
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
1561 "x": 1609.0277099609375,
\r
1563 "z": "aa630329.50a53",
\r
1571 "id": "e200beea.7beb8",
\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
1576 "x": 2671.805435180664,
\r
1577 "y": 555.3333234786987,
\r
1578 "z": "aa630329.50a53",
\r
1582 "id": "83af09d2.c65ec8",
\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
1587 "x": 2557.6943359375,
\r
1588 "y": 426.66666412353516,
\r
1589 "z": "aa630329.50a53",
\r
1593 "id": "98dce5f3.4de788",
\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
1598 "x": 2741.027633666992,
\r
1599 "y": 474.4444389343262,
\r
1600 "z": "aa630329.50a53",
\r
1604 "id": "1c77760e.ecb7ea",
\r
1607 "xml": "<block>\n",
\r
1608 "atomic": "false",
\r
1611 "x": 2356.6666666666665,
\r
1612 "y": 474.44444444444446,
\r
1613 "z": "aa630329.50a53",
\r
1616 "98dce5f3.4de788",
\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
1628 "x": 2582.2221870422363,
\r
1629 "y": 512.222222328186,
\r
1630 "z": "aa630329.50a53",
\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
1641 "x": 2838.888832092285,
\r
1642 "y": 518.8889126777649,
\r
1643 "z": "aa630329.50a53",
\r