X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=platform-logic%2Foptical-service%2Fsrc%2Fmain%2Fjson%2Foptical-service_optical-service-delete.json;h=bdcecb61011bbd39d062c10bb74fd2de1e809244;hb=fbf997335b6cca38872e855ca168f20b18b286f5;hp=fbb368bf48fb9ea4e9ec3189d7becbbd197d45a7;hpb=ccdfcf82e4804febff7597cf87395be2a0b98a46;p=sdnc%2Foam.git

diff --git a/platform-logic/optical-service/src/main/json/optical-service_optical-service-delete.json b/platform-logic/optical-service/src/main/json/optical-service_optical-service-delete.json
index fbb368bf..bdcecb61 100644
--- a/platform-logic/optical-service/src/main/json/optical-service_optical-service-delete.json
+++ b/platform-logic/optical-service/src/main/json/optical-service_optical-service-delete.json
@@ -1,20 +1,20 @@
 [
     {
-        "id": "b65cdeae.8f7b08",
+        "id": "e0d62dfb.c4892",
         "type": "dgstart",
         "name": "DGSTART",
         "outputs": 1,
-        "x": 129,
-        "y": 129.88333129882812,
-        "z": "e2f7091c.1492b8",
+        "x": 171.67613220214844,
+        "y": 182.38332986831665,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "644f31e7.7234b8"
+                "ed0e245d.a59e08"
             ]
         ]
     },
     {
-        "id": "644f31e7.7234b8",
+        "id": "ed0e245d.a59e08",
         "type": "service-logic",
         "name": "optical-service ${project.version}",
         "module": "optical-service",
@@ -22,1454 +22,1206 @@
         "comments": "",
         "xml": "<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='optical-service' version='${project.version}'>",
         "outputs": 1,
-        "x": 237.5,
-        "y": 207.88333129882812,
-        "z": "e2f7091c.1492b8",
+        "x": 280.17613220214844,
+        "y": 260.38332986831665,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "168fe70c.0f8c41"
+                "5edee11.65d4d2"
             ]
         ]
     },
     {
-        "id": "168fe70c.0f8c41",
+        "id": "5edee11.65d4d2",
         "type": "method",
         "name": "method",
         "xml": "<method rpc='optical-service-delete' mode='sync'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 106,
-        "y": 298.8833312988281,
-        "z": "e2f7091c.1492b8",
+        "x": 148.67613220214844,
+        "y": 351.38332986831665,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "cfd0169c.a3cee"
+                "30cfbd8.db7ed42"
             ]
         ]
     },
     {
-        "id": "cfd0169c.a3cee",
+        "id": "30cfbd8.db7ed42",
         "type": "block",
         "name": "block : atomic",
         "xml": "<block atomic='true'>",
         "atomic": "true",
         "comments": "",
         "outputs": 1,
-        "x": 292,
-        "y": 294.8833312988281,
-        "z": "e2f7091c.1492b8",
+        "x": 343.00946044921875,
+        "y": 390.7166624069214,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "30cb33e3.b12a94",
-                "2e82bc92.4b93a4",
-                "5e98d3f6.94968c",
-                "cf17dc19.012ac",
-                "d4ebf687.1cccd8",
-                "cbe18d30.3b4198",
-                "840d7865.dda6b"
+                "5a0a00ba.7c221",
+                "21047af0.e45596",
+                "acfa1fdd.4f126",
+                "af71a4c0.67cbc8",
+                "15d56a2d.a7cc46",
+                "5666351c.3fed7c",
+                "1d36fe9a.5fdc81"
             ]
         ]
     },
     {
-        "id": "30cb33e3.b12a94",
+        "id": "5a0a00ba.7c221",
         "type": "execute",
         "name": "execute",
         "xml": "<execute plugin='org.onap.ccsdk.sli.plugins.prop.PropertiesNode' method='readProperties' >\n<parameter name='fileName' value='/opt/onap/sdnc/data/properties/optical-service-dg.properties' />\n<parameter name='contextPrefix' value='prop' />\n",
         "comments": "",
         "outputs": 1,
-        "x": 574.9999694824219,
+        "x": 605.1761093139648,
         "y": 20,
-        "z": "e2f7091c.1492b8",
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
     },
     {
-        "id": "2e82bc92.4b93a4",
+        "id": "21047af0.e45596",
         "type": "get-resource",
         "name": "get resources from DB -controller_id",
         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT *\nfrom REQUEST_DETAILS\nWHERE request_id = $optical-service-delete-input.request-id'\npfx='detail-db'>",
         "comments": "",
         "outputs": 1,
-        "x": 640.9999389648438,
-        "y": 71.8833236694336,
-        "z": "e2f7091c.1492b8",
+        "x": 718.6760635375977,
+        "y": 112.71665000915527,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "78b1b9eb.f0f1a8"
+                "63804231.b88b9c"
             ]
         ]
     },
     {
-        "id": "78b1b9eb.f0f1a8",
+        "id": "63804231.b88b9c",
         "type": "success",
         "name": "success",
         "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 881,
-        "y": 68.8833236694336,
-        "z": "e2f7091c.1492b8",
+        "x": 946.1761436462402,
+        "y": 106.38332414627075,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "b1511a3a.314df"
+                "e6431c0d.bb995"
             ]
         ]
     },
     {
-        "id": "b1511a3a.314df",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='domain-req' value='`$detail-db.domain-requests`' />\n\n\n\n\n\n\n\n\n\n\n",
-        "comments": "",
-        "x": 1046,
-        "y": 67.8833236694336,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "5e98d3f6.94968c",
+        "id": "acfa1fdd.4f126",
         "type": "set",
         "name": "set domain-services",
-        "xml": "<set>\n<parameter name='notification-url' value=\"http://167.254.204.152:31817/asyncNotification\" />\n<parameter name='domain-service1' value='`$param-prefix1[0]`' />\n<parameter name='domain-service2' value='`$param-prefix1[1]`' />",
+        "xml": "<set>\n<parameter name='notification-url' value=\"notificationUrl\" />\n<parameter name='access-status' value=\"success\" />\n",
         "comments": "",
-        "x": 589.9999389648438,
-        "y": 165.88333129882812,
-        "z": "e2f7091c.1492b8",
+        "x": 731.0093307495117,
+        "y": 228.3833179473877,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "cf17dc19.012ac",
+        "id": "af71a4c0.67cbc8",
         "type": "execute",
         "name": "split domain-requests for access services",
         "xml": "<execute plugin='org.onap.ccsdk.sli.core.slipluginutils.SliStringUtils' method='split' >\n<parameter name=\"original_string\" value='`$domain-req`'/>\n<parameter name=\"regex\" value=\",\"/>\n<parameter name=\"ctx_memory_result_key\" value=\"param-prefix1\"/>\n",
         "comments": "",
         "outputs": 1,
-        "x": 651.1166381835938,
-        "y": 115.99999237060547,
-        "z": "e2f7091c.1492b8",
+        "x": 763.7928161621094,
+        "y": 172.66664695739746,
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
     },
     {
-        "id": "d4ebf687.1cccd8",
+        "id": "15d56a2d.a7cc46",
         "type": "for",
         "name": "for",
         "xml": "<for index='ppx' start='0' end='`$param-prefix1_length`' >\n    \n    \n    \n\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 544,
-        "y": 289,
-        "z": "e2f7091c.1492b8",
+        "x": 591.6760711669922,
+        "y": 374.8332996368408,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "91896047.66eb7"
+                "85a69e7e.7e74e"
             ]
         ]
     },
     {
-        "id": "91896047.66eb7",
+        "id": "85a69e7e.7e74e",
         "type": "switchNode",
         "name": "switch",
-        "xml": "<switch test='`$param-prefix1_length`'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 698,
-        "y": 287,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "2c37340b.4002cc",
-                "7784419a.212fa"
-            ]
-        ]
-    },
-    {
-        "id": "2c37340b.4002cc",
-        "type": "outcome",
-        "name": "1",
-        "xml": "<outcome value='1'>\n",
+        "xml": "<switch test='`$param-prefix1_length == 1`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 881,
-        "y": 281,
-        "z": "e2f7091c.1492b8",
+        "x": 740.6761322021484,
+        "y": 339.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "be5c1afb.f2037"
+                "31b9f2de.b5872e",
+                "e0aaa8d0.545478"
             ]
         ]
     },
     {
-        "id": "be5c1afb.f2037",
+        "id": "caa8b5a3.b36418",
         "type": "block",
         "name": "block : atomic",
         "xml": "<block atomic='true'>",
         "atomic": "true",
         "comments": "",
         "outputs": 1,
-        "x": 1050,
-        "y": 281,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "7f6fcc65.18cb7c",
-                "3a1a70c6.408b8",
-                "795303c1.2dac44",
-                "3ab986c7.09e812"
-            ]
-        ]
-    },
-    {
-        "id": "7784419a.212fa",
-        "type": "outcome",
-        "name": "2",
-        "xml": "<outcome value='2'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 631,
-        "y": 718,
-        "z": "e2f7091c.1492b8",
+        "x": 1092.6761322021484,
+        "y": 333.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e41aac03.bbaa5"
+                "91ecfc44.f143a",
+                "719feef2.99781",
+                "238c69d1.2b6de6",
+                "c2baf636.474808"
             ]
         ]
     },
     {
-        "id": "3a1a70c6.408b8",
+        "id": "719feef2.99781",
         "type": "execute",
         "name": "split node-id a-end retrieved from DB",
         "xml": "<execute plugin='org.onap.ccsdk.sli.core.slipluginutils.SliStringUtils' method='split' >\n<parameter name=\"original_string\" value='`$controller-id1`'/>\n<parameter name=\"regex\" value=\"_\"/>\n<parameter name=\"ctx_memory_result_key\" value=\"param-prefix\"/>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1322,
-        "y": 286,
-        "z": "e2f7091c.1492b8",
+        "x": 1364.6761322021484,
+        "y": 338.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
     },
     {
-        "id": "7f6fcc65.18cb7c",
+        "id": "91ecfc44.f143a",
         "type": "get-resource",
         "name": "get resources from DB -controller_id",
-        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT controller_id\nfrom REQUEST_DETAILS\nWHERE request_id = $domain-service1'\npfx='detail-db1'>",
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT controller_id\nfrom REQUEST_DETAILS\nWHERE request_id = $param-prefix1[$ppx]'\npfx='detail-db1'>",
         "comments": "",
         "outputs": 1,
-        "x": 1326.11669921875,
-        "y": 246.11666870117188,
-        "z": "e2f7091c.1492b8",
+        "x": 1368.7925567626953,
+        "y": 288.6166639328003,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e2726a7c.0cf32"
+                "319883a4.a6298c"
             ]
         ]
     },
     {
-        "id": "e2726a7c.0cf32",
+        "id": "319883a4.a6298c",
         "type": "success",
         "name": "success",
         "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1571.11669921875,
-        "y": 245.11666870117188,
-        "z": "e2f7091c.1492b8",
+        "x": 1613.7928314208984,
+        "y": 297.6166672706604,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "70e7b1a6.2a20f"
+                "fa33f2b4.9586d"
             ]
         ]
     },
     {
-        "id": "70e7b1a6.2a20f",
+        "id": "fa33f2b4.9586d",
         "type": "set",
         "name": "set",
         "xml": "<set>\n<parameter name='controller-id1' value='`$detail-db1.controller-id`' />\n\n\n\n\n\n\n\n\n\n\n",
         "comments": "",
-        "x": 1719.11669921875,
-        "y": 247.11666870117188,
-        "z": "e2f7091c.1492b8",
+        "x": 1761.7928314208984,
+        "y": 299.6166672706604,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "795303c1.2dac44",
+        "id": "238c69d1.2b6de6",
         "type": "set",
         "name": "set domain-services",
-        "xml": "<set>\n<parameter name='domain-type' value='`$param-prefix[0]`' />\n<parameter name='controller-ip' value='`$param-prefix[1]`' />\n<parameter name='optical-service-delete-input.request-id' value=\"`$domain-service1`\" />\n<parameter name='optical-service-delete-input.payload.service-name' value=\"`$optical-service-delete-input.payload.param[0].value + '_MDONS-OTN'`\"/>",
+        "xml": "<set>\n<parameter name='domain-type' value='`$param-prefix[0]`' />\n<parameter name='controller-ip' value='`$param-prefix[1]`' />\n<parameter name='optical-service-delete-input.request-id' value=\"`$param-prefix1[$ppx]`\" />\n<parameter name='optical-service-delete-input.payload.service-name' value=\"`$optical-service-delete-input.payload.param[0].value + '_MDONS-OTN_'`\"/>\n<parameter name='domain-service1' value=\"`$param-prefix1[$ppx]`\" />\n",
         "comments": "",
-        "x": 1274.11669921875,
-        "y": 358.1166687011719,
-        "z": "e2f7091c.1492b8",
+        "x": 1311.7928314208984,
+        "y": 410.6166763305664,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "3ab986c7.09e812",
+        "id": "c2baf636.474808",
         "type": "switchNode",
         "name": "switch domain-type",
         "xml": "<switch test='`$domain-type`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1263,
-        "y": 493,
-        "z": "e2f7091c.1492b8",
+        "x": 1252.3428115844727,
+        "y": 543.8333339691162,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e04cd56f.45dfc8",
-                "2fc7713.599bf0e"
+                "c3c51e46.241cf",
+                "409a0484.8b3eec"
             ]
         ]
     },
     {
-        "id": "e04cd56f.45dfc8",
+        "id": "c3c51e46.241cf",
         "type": "outcome",
         "name": "MSA",
         "xml": "<outcome value='MSA'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1466,
-        "y": 404,
-        "z": "e2f7091c.1492b8",
+        "x": 1508.6761322021484,
+        "y": 456.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "5962de98.7a93e8"
+                "f8fc18f7.4d8af8"
             ]
         ]
     },
     {
-        "id": "2fc7713.599bf0e",
+        "id": "409a0484.8b3eec",
         "type": "outcome",
         "name": "TAPI",
         "xml": "<outcome value='TAPI'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1469,
-        "y": 584,
-        "z": "e2f7091c.1492b8",
+        "x": 1511.6761322021484,
+        "y": 636.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "c51e88be.9e544"
+                "cae5e210.d6395"
             ]
         ]
     },
     {
-        "id": "5962de98.7a93e8",
+        "id": "f8fc18f7.4d8af8",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1606,
-        "y": 401,
-        "z": "e2f7091c.1492b8",
+        "x": 1648.6761322021484,
+        "y": 453.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "314acdb7.afb7da"
+                "c176f2f2.5fee2"
             ]
         ]
     },
     {
-        "id": "314acdb7.afb7da",
+        "id": "c176f2f2.5fee2",
         "type": "call",
         "name": "call MSA DELETE DG",
         "xml": "<call module='optical-service' rpc='service-delete-msa' mode='sync' >\n",
         "comments": "",
         "outputs": 1,
-        "x": 1794,
-        "y": 402,
-        "z": "e2f7091c.1492b8",
+        "x": 1836.6761322021484,
+        "y": 454.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "af9224a8.a9533",
-                "3e7bdf94.045928"
+                "e405e5bb.3a20a8",
+                "4df16ad1.b6ecc4"
             ]
         ]
     },
     {
-        "id": "af9224a8.a9533",
+        "id": "e405e5bb.3a20a8",
         "type": "success",
         "name": "success",
         "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1979,
-        "y": 358,
-        "z": "e2f7091c.1492b8",
+        "x": 2021.6761322021484,
+        "y": 410.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "bbe67c9b.ae8e2"
+                "8dfeea48.8664a8"
             ]
         ]
     },
     {
-        "id": "3e7bdf94.045928",
+        "id": "4df16ad1.b6ecc4",
         "type": "failure",
         "name": "failure",
         "xml": "<outcome value='failure'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1981,
-        "y": 450,
-        "z": "e2f7091c.1492b8",
+        "x": 2023.6761322021484,
+        "y": 502.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "449903c8.0a6724"
+                "22cc809f.74d45"
             ]
         ]
     },
     {
-        "id": "bbe67c9b.ae8e2",
+        "id": "8dfeea48.8664a8",
         "type": "block",
         "name": "block : atomic",
         "xml": "<block atomic='true'>",
         "atomic": "true",
         "comments": "",
         "outputs": 1,
-        "x": 2150,
-        "y": 349,
-        "z": "e2f7091c.1492b8",
+        "x": 2192.6761322021484,
+        "y": 401.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "3a0958a9.5973c8"
+                "e0798c41.0c606"
             ]
         ]
     },
     {
-        "id": "3a0958a9.5973c8",
+        "id": "e0798c41.0c606",
         "type": "set",
         "name": "set",
         "xml": "<set>\n<parameter name='service1-status' value='`$final-response-code`' />\n",
         "comments": "",
-        "x": 2293,
-        "y": 324,
-        "z": "e2f7091c.1492b8",
+        "x": 2335.6761322021484,
+        "y": 376.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "449903c8.0a6724",
+        "id": "22cc809f.74d45",
         "type": "returnFailure",
         "name": "return failure",
         "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Failed to call MSA DG' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
         "comments": "",
-        "x": 2150,
-        "y": 480,
-        "z": "e2f7091c.1492b8",
+        "x": 2192.6761322021484,
+        "y": 532.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "c51e88be.9e544",
+        "id": "cae5e210.d6395",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1625,
-        "y": 586,
-        "z": "e2f7091c.1492b8",
+        "x": 1667.6761322021484,
+        "y": 638.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "a271ced2.6952d8"
+                "65305f1a.cd63"
             ]
         ]
     },
     {
-        "id": "a271ced2.6952d8",
+        "id": "65305f1a.cd63",
         "type": "call",
         "name": "call TAPI DELETE DG",
         "xml": "<call module='optical-service' rpc='service-delete-tapi' mode='sync' >\n",
         "comments": "",
         "outputs": 1,
-        "x": 1813,
-        "y": 587,
-        "z": "e2f7091c.1492b8",
+        "x": 1855.6761322021484,
+        "y": 639.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "3ea9b0c9.5ce928",
-                "3153866d.fe9922"
+                "10cb997f.2c1b67",
+                "e32d2f8.8429fd"
             ]
         ]
     },
     {
-        "id": "3ea9b0c9.5ce928",
+        "id": "10cb997f.2c1b67",
         "type": "success",
         "name": "success",
         "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1998,
-        "y": 543,
-        "z": "e2f7091c.1492b8",
+        "x": 2040.6761322021484,
+        "y": 595.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "4e515097.338e48"
+                "6c6dbee5.bd866"
             ]
         ]
     },
     {
-        "id": "3153866d.fe9922",
+        "id": "e32d2f8.8429fd",
         "type": "failure",
         "name": "failure",
         "xml": "<outcome value='failure'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 2000,
-        "y": 635,
-        "z": "e2f7091c.1492b8",
+        "x": 2042.6761322021484,
+        "y": 687.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e7c2b606.d88798"
+                "22c2bd5a.04a492"
             ]
         ]
     },
     {
-        "id": "4e515097.338e48",
+        "id": "6c6dbee5.bd866",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 2169,
-        "y": 534,
-        "z": "e2f7091c.1492b8",
+        "x": 2211.6761322021484,
+        "y": 586.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "128c0365.4d99ed",
-                "99a0a090.74b4e8"
+                "e23cf700.e51748",
+                "94cb4145.57c88"
             ]
         ]
     },
     {
-        "id": "128c0365.4d99ed",
+        "id": "e23cf700.e51748",
         "type": "set",
         "name": "set",
         "xml": "<set>\n<parameter name='service1-status' value='`$final-response-code`' />\n",
         "comments": "",
-        "x": 2312,
-        "y": 509,
-        "z": "e2f7091c.1492b8",
+        "x": 2354.6761322021484,
+        "y": 561.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "e7c2b606.d88798",
+        "id": "22c2bd5a.04a492",
         "type": "returnFailure",
         "name": "return failure",
         "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Failed to call MSA DG' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
         "comments": "",
-        "x": 2169,
-        "y": 665,
-        "z": "e2f7091c.1492b8",
+        "x": 2211.6761322021484,
+        "y": 717.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "71b9114.072a4f",
+        "id": "ffbaf9e.fb0fb08",
         "type": "call",
         "name": "call TAPI DELETE DG",
         "xml": "<call module='optical-service' rpc='service-delete-tapi' mode='sync' >\n",
         "comments": "",
         "outputs": 1,
-        "x": 1315,
-        "y": 891,
-        "z": "e2f7091c.1492b8",
+        "x": 1357.6761322021484,
+        "y": 943.4999985694885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "1978613e.4073f7",
-                "2736e495.752c04"
+                "d2fc4e32.19347"
             ]
         ]
     },
     {
-        "id": "63600e7b.0d9eb8",
+        "id": "fca311a3.3788e",
         "type": "set",
         "name": "set",
-        "xml": "<set>\n<parameter name='optical-service-delete-input.request-id' value=\"`$domain-service1`\" />\n<parameter name='optical-service-delete-input.payload.service-name' value=\"`$optical-service-delete-input.payload.param[0].value + '_MDONS-OTN-TAPI-1'`\"/>\n<parameter name='domain-type' value='`$domain1[0]`' />\n<parameter name='controller-ip' value='`$domain1[1]`' />\n",
+        "xml": "<set>\n<parameter name='optical-service-delete-input.request-id' value=\"`$param-prefix1[$ppx]`\" />\n<parameter name='optical-service-delete-input.payload.service-name' value=\"`$optical-service-delete-input.payload.param[0].value + '_MDONS-OTN_'`\"/>\n\n",
         "comments": "",
-        "x": 1296.11669921875,
-        "y": 815.1167602539062,
-        "z": "e2f7091c.1492b8",
+        "x": 1338.7928314208984,
+        "y": 867.6167588233948,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "e41aac03.bbaa5",
-        "type": "switchNode",
-        "name": "switch",
-        "xml": "<switch test='`$ppx`'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 771.1167602539062,
-        "y": 723.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "bc61c8e0.999178",
-                "d5fffe4f.796c18"
-            ]
-        ]
-    },
-    {
-        "id": "bc61c8e0.999178",
-        "type": "outcome",
-        "name": "0",
-        "xml": "<outcome value='0'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 951.1167602539062,
-        "y": 723.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "b7c6609b.2477c8"
-            ]
-        ]
-    },
-    {
-        "id": "d5fffe4f.796c18",
-        "type": "outcome",
-        "name": "1",
-        "xml": "<outcome value='1'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 899.1167602539062,
-        "y": 1097.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "a2b3475f.c55ff"
-            ]
-        ]
-    },
-    {
-        "id": "ab6f8311.54637",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='optical-service-delete-input.request-id' value=\"`$domain-service2`\" />\n<parameter name='optical-service-delete-input.payload.service-name' value=\"`$optical-service-delete-input.payload.param[0].value + '_MDONS-OTN-TAPI-2'`\"/>\n<parameter name='domain-type' value='`$domain2[0]`' />\n<parameter name='controller-ip' value='`$domain2[1]`' />\n\n\n",
-        "comments": "",
-        "x": 1294.11669921875,
-        "y": 1170.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "fc3b2634.80fb1",
-        "type": "call",
-        "name": "call TAPI DELETE DG",
-        "xml": "<call module='optical-service' rpc='service-delete-tapi' mode='sync' >\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 1301.11669921875,
-        "y": 1243.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "d0a61851.774d7",
-                "67e5500f.2b88c8"
-            ]
-        ]
-    },
-    {
-        "id": "b7c6609b.2477c8",
-        "type": "block",
-        "name": "block",
-        "xml": "<block>\n",
-        "atomic": "false",
-        "comments": "",
-        "outputs": 1,
-        "x": 1091.11669921875,
-        "y": 724.11669921875,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "63600e7b.0d9eb8",
-                "71b9114.072a4f",
-                "fb442d76.8c0b1",
-                "e8836a64.f81ae"
-            ]
-        ]
-    },
-    {
-        "id": "a2b3475f.c55ff",
+        "id": "64b9ab4c.add954",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1025.1167602539062,
-        "y": 1106.11669921875,
-        "z": "e2f7091c.1492b8",
+        "x": 1133.7928314208984,
+        "y": 776.6166977882385,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "ab6f8311.54637",
-                "fc3b2634.80fb1",
-                "4d169812.58b88",
-                "8f4e881d.558318"
+                "fca311a3.3788e",
+                "ffbaf9e.fb0fb08",
+                "7dcb69ce.f66178",
+                "ac94d58e.2025e8"
             ]
         ]
     },
     {
-        "id": "1978613e.4073f7",
+        "id": "d2fc4e32.19347",
         "type": "success",
         "name": "success",
         "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1576,
-        "y": 844,
-        "z": "e2f7091c.1492b8",
+        "x": 1557.009506225586,
+        "y": 939.8333444595337,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "b4b3ae50.b80768"
+                "b1d14962.f347a8"
             ]
         ]
     },
     {
-        "id": "2736e495.752c04",
-        "type": "failure",
-        "name": "failure",
-        "xml": "<outcome value='failure'>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 1560,
-        "y": 973,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "ecbd8135.fa342"
-            ]
-        ]
-    },
-    {
-        "id": "b4b3ae50.b80768",
+        "id": "b1d14962.f347a8",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1732,
-        "y": 851,
-        "z": "e2f7091c.1492b8",
+        "x": 1733.0094604492188,
+        "y": 940.1666679382324,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e387ae63.768b78",
-                "6a4932f.f7508cc"
+                "37bfc4a8.eaaf0c",
+                "3ecbb172.0c334e"
             ]
         ]
     },
     {
-        "id": "e387ae63.768b78",
+        "id": "37bfc4a8.eaaf0c",
         "type": "set",
         "name": "set",
-        "xml": "<set>\n<parameter name='service1-status' value='`$final-response-code`' />\n",
+        "xml": "<set>\n<parameter name='service-status' value='`$final-response-code`' />\n",
         "comments": "",
-        "x": 1898.9998779296875,
-        "y": 764,
-        "z": "e2f7091c.1492b8",
+        "x": 1861.6761283874512,
+        "y": 873.1666774749756,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "6a4932f.f7508cc",
+        "id": "3ecbb172.0c334e",
         "type": "switchNode",
         "name": "switch",
-        "xml": "<switch test='`$service1-status == 200`'>\n",
+        "xml": "<switch test='`$service-status == 200`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1887.9998779296875,
-        "y": 881,
-        "z": "e2f7091c.1492b8",
+        "x": 1860.6760368347168,
+        "y": 1001.8333568572998,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "f2ab530d.5d599",
-                "7ea5454b.c5d99c"
+                "421f5497.942c9c",
+                "686fcc2a.0dbf94"
             ]
         ]
     },
     {
-        "id": "f2ab530d.5d599",
+        "id": "421f5497.942c9c",
         "type": "outcomeTrue",
         "name": "true",
         "xml": "<outcome value='true'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 2029.9998779296875,
-        "y": 811,
-        "z": "e2f7091c.1492b8",
+        "x": 2021.0092849731445,
+        "y": 913.499981880188,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "896e220.db3996"
-            ]
+            []
         ]
     },
     {
-        "id": "7ea5454b.c5d99c",
+        "id": "686fcc2a.0dbf94",
         "type": "outcomeFalse",
         "name": "false",
         "xml": "<outcome value='false'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 2031,
-        "y": 929,
-        "z": "e2f7091c.1492b8",
+        "x": 2013.676040649414,
+        "y": 1063.1666793823242,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "251983ac.1c994c"
+                "f3e4a24a.52e36"
             ]
         ]
     },
     {
-        "id": "896e220.db3996",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='service1' value='success' />\n",
-        "comments": "",
-        "x": 2185,
-        "y": 817,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "251983ac.1c994c",
+        "id": "f3e4a24a.52e36",
         "type": "set",
         "name": "set",
-        "xml": "<set>\n<parameter name='service1' value='failure' />\n",
+        "xml": "<set>\n<parameter name='access-status' value='failure' />\n",
         "comments": "",
-        "x": 2198,
-        "y": 927,
-        "z": "e2f7091c.1492b8",
+        "x": 2197.3425827026367,
+        "y": 1064.4999742507935,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "ecbd8135.fa342",
-        "type": "returnFailure",
-        "name": "return failure",
-        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Main Delete Dg not available' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
-        "comments": "",
-        "x": 1732,
-        "y": 974,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "d0a61851.774d7",
-        "type": "success",
-        "name": "success",
-        "xml": "<outcome value='success'>\n",
+        "id": "94cb4145.57c88",
+        "type": "record",
+        "name": "record",
+        "xml": "<record plugin=\"org.onap.ccsdk.sli.core.sli.recording.FileRecorder\">\n<parameter name=\"file\" value=\"/opt/opendaylight/current/data/log/service-delete-tapi.log\" />\n<parameter name=\"level\" value=\"info\" />\n<parameter name=\"field1\" value=\"`$service1-status`\"/>\n\n\n\n\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 1543,
-        "y": 1167,
-        "z": "e2f7091c.1492b8",
+        "x": 2349.5262298583984,
+        "y": 636.349974155426,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "7ee5420a.dabadc"
-            ]
+            []
         ]
     },
     {
-        "id": "67e5500f.2b88c8",
-        "type": "failure",
-        "name": "failure",
-        "xml": "<outcome value='failure'>\n",
+        "id": "5666351c.3fed7c",
+        "type": "switchNode",
+        "name": "switch",
+        "xml": "<switch test='`$ppx == 0`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1550,
-        "y": 1306,
-        "z": "e2f7091c.1492b8",
+        "x": 408.20947647094727,
+        "y": 1499.1498394012451,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "dec65b83.66c9b"
+                "178292af.b017ad",
+                "791b18b2.1028c8"
             ]
         ]
     },
     {
-        "id": "7ee5420a.dabadc",
+        "id": "3314378c.27c9e8",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1698,
-        "y": 1175,
-        "z": "e2f7091c.1492b8",
+        "x": 783.0761566162109,
+        "y": 1405.8999619483948,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "11571d88.b80ba2",
-                "8e369286.a24f1"
+                "155d72bc.d68edd"
             ]
         ]
     },
     {
-        "id": "11571d88.b80ba2",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='service2-status' value='`$final-response-code`' />\n",
-        "comments": "",
-        "x": 1894,
-        "y": 1090,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "8e369286.a24f1",
+        "id": "155d72bc.d68edd",
         "type": "switchNode",
         "name": "switch",
-        "xml": "<switch test='`$service2-status == 200`'>\n",
+        "xml": "<switch test='`$service1-status`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1875,
-        "y": 1215,
-        "z": "e2f7091c.1492b8",
+        "x": 925.4261322021484,
+        "y": 1411.0999131202698,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "bc9b1c9e.2d7528",
-                "6e8a106a.b8a098"
+                "d2a2c499.44f5d8",
+                "7b86389e.6c7b68"
             ]
         ]
     },
     {
-        "id": "bc9b1c9e.2d7528",
-        "type": "outcomeTrue",
-        "name": "true",
-        "xml": "<outcome value='true'>\n",
+        "id": "b3c2e52b.63a388",
+        "type": "block",
+        "name": "block",
+        "xml": "<block>\n",
+        "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 2037,
-        "y": 1140,
-        "z": "e2f7091c.1492b8",
+        "x": 1260.4261322021484,
+        "y": 1353.2999863624573,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "88261b09.8da33"
+                "79f9a1bf.52d0f",
+                "e7d0e65b.efbea8"
             ]
         ]
     },
     {
-        "id": "6e8a106a.b8a098",
-        "type": "outcomeFalse",
-        "name": "false",
-        "xml": "<outcome value='false'>\n",
+        "id": "79f9a1bf.52d0f",
+        "type": "delete",
+        "name": "delete",
+        "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\n    resource=\"SQL\"\n    key=\"DELETE FROM REQUEST_DETAILS WHERE request_id = $access-id\"> ",
         "comments": "",
         "outputs": 1,
-        "x": 2043,
-        "y": 1262,
-        "z": "e2f7091c.1492b8",
+        "x": 1426.092716217041,
+        "y": 1348.6333484649658,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "e617e321.5b485"
-            ]
+            []
         ]
     },
     {
-        "id": "88261b09.8da33",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='service2' value='success' />\n",
+        "id": "e7d0e65b.efbea8",
+        "type": "returnSuccess",
+        "name": "return success",
+        "xml": "<return status='success'>\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"Service Deleted Successfully\" />\n<parameter name='ack-final-indicator' value='Y' />",
         "comments": "",
-        "x": 2192,
-        "y": 1143,
-        "z": "e2f7091c.1492b8",
+        "x": 1466.4261322021484,
+        "y": 1534.3001084327698,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "e617e321.5b485",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='service2' value='failure' />\n",
+        "id": "d2a2c499.44f5d8",
+        "type": "outcome",
+        "name": "200",
+        "xml": "<outcome value='200'>\n",
         "comments": "",
-        "x": 2205,
-        "y": 1265,
-        "z": "e2f7091c.1492b8",
-        "wires": []
+        "outputs": 1,
+        "x": 1098.8760833740234,
+        "y": 1360.7499375343323,
+        "z": "23113e64.4c4872",
+        "wires": [
+            [
+                "b3c2e52b.63a388"
+            ]
+        ]
     },
     {
-        "id": "dec65b83.66c9b",
-        "type": "returnFailure",
-        "name": "return failure",
-        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Main Delete Dg not available' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
+        "id": "7b86389e.6c7b68",
+        "type": "other",
+        "name": "other",
+        "xml": "<outcome value='Other'>\n",
         "comments": "",
-        "x": 1751,
-        "y": 1306,
-        "z": "e2f7091c.1492b8",
-        "wires": []
+        "outputs": 1,
+        "x": 1075.8760833740234,
+        "y": 1512.7499375343323,
+        "z": "23113e64.4c4872",
+        "wires": [
+            [
+                "c68df7b5.0b81e8"
+            ]
+        ]
     },
     {
-        "id": "cbe18d30.3b4198",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='access-id' value=\"`$optical-service-delete-input.request-id`\" />\n\n",
+        "id": "e0ffad7.48b955",
+        "type": "returnFailure",
+        "name": "return failure",
+        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Access service request entry cannot be deleted' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
         "comments": "",
-        "x": 548.8999938964844,
-        "y": 211.85000610351562,
-        "z": "e2f7091c.1492b8",
+        "x": 1254.1761322021484,
+        "y": 1524.8998398780823,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "99a0a090.74b4e8",
-        "type": "record",
-        "name": "record",
-        "xml": "<record plugin=\"org.onap.ccsdk.sli.core.sli.recording.FileRecorder\">\n<parameter name=\"file\" value=\"/opt/opendaylight/current/data/log/service-delete-tapi.log\" />\n<parameter name=\"level\" value=\"info\" />\n<parameter name=\"field1\" value=\"`$service1-status`\"/>\n\n\n\n\n\n",
+        "id": "7dcb69ce.f66178",
+        "type": "get-resource",
+        "name": "get resources from DB -controller_id",
+        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT controller_id\nfrom REQUEST_DETAILS\nWHERE request_id = $param-prefix1[$ppx]'\npfx='detail-db11'>",
         "comments": "",
         "outputs": 1,
-        "x": 2306.85009765625,
-        "y": 583.8499755859375,
-        "z": "e2f7091c.1492b8",
+        "x": 1420.342758178711,
+        "y": 733.166624546051,
+        "z": "23113e64.4c4872",
         "wires": [
-            []
+            [
+                "1aabb5e8.22157a"
+            ]
         ]
     },
     {
-        "id": "840d7865.dda6b",
-        "type": "switchNode",
-        "name": "switch",
-        "xml": "<switch test='`$ppx`'>\n",
+        "id": "1aabb5e8.22157a",
+        "type": "success",
+        "name": "success",
+        "xml": "<outcome value='success'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 362.20001220703125,
-        "y": 1446.64990234375,
-        "z": "e2f7091c.1492b8",
+        "x": 1666.342758178711,
+        "y": 737.166624546051,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "35bc7c0e.531f0c",
-                "647592de.7dc3ec"
+                "70d90830.02f658"
             ]
         ]
     },
     {
-        "id": "35bc7c0e.531f0c",
-        "type": "outcome",
-        "name": "0",
-        "xml": "<outcome value='0'>\n",
+        "id": "70d90830.02f658",
+        "type": "set",
+        "name": "set",
+        "xml": "<set>\n<parameter name='controller-id11' value='`$detail-db11.controller-id`' />\n\n\n\n\n\n\n\n\n\n\n",
+        "comments": "",
+        "x": 1834.342758178711,
+        "y": 739.166624546051,
+        "z": "23113e64.4c4872",
+        "wires": []
+    },
+    {
+        "id": "ac94d58e.2025e8",
+        "type": "execute",
+        "name": "split node-id a-end retrieved from DB",
+        "xml": "<execute plugin='org.onap.ccsdk.sli.core.slipluginutils.SliStringUtils' method='split' >\n<parameter name=\"original_string\" value='`$controller-id11`'/>\n<parameter name=\"regex\" value=\"_\"/>\n<parameter name=\"ctx_memory_result_key\" value=\"domain1\"/>\n",
         "comments": "",
         "outputs": 1,
-        "x": 598.4000549316406,
-        "y": 1349.3999633789062,
-        "z": "e2f7091c.1492b8",
+        "x": 1441.342758178711,
+        "y": 809.166624546051,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "362cac69.39ad1c"
-            ]
+            []
         ]
     },
     {
-        "id": "647592de.7dc3ec",
-        "type": "outcome",
-        "name": "1",
-        "xml": "<outcome value='1'>\n",
+        "id": "8fd18db8.4cb08",
+        "type": "update",
+        "name": "update",
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.aai.AAIService' \nforce='true'\nresource='logical-link'\nkey = 'pnf.pnf-name = $a-end-pnf-name\n      AND p-interface.interface-name = $optical-service-create-input.payload.service-aend.port-id'\n      local-only='false'>\n<parameter name='available-capacity' value='`$available-bandwidth-aend`' />\n\n\n\n<save plugin='org.onap.ccsdk.sli.adaptors.aai.AAIService' resource='logical-link'\nkey='logical-link.link-name = $tmp.link-id' >\n    <parameter name='link-name' value='`$tmp.link-id`' />\n    <parameter name='link-type' value='`$link.link-type`' />\n    <parameter name='in-maint' value='true' />\n    <parameter name='speed-value' value='100' />\n    <parameter name='speed-units' value='Gbps' />\n    <parameter name='operational-status' value='`$link.administrative-state`' />\n    <parameter name='available-capacity' value='100' />\n\n\n\n\n\n\n\n\n\n\n\n    \n    \n    \n    \n    \n    \n    \n    \n   \n    \n    \n    \n\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 589.4000549316406,
-        "y": 1522.39990234375,
-        "z": "e2f7091c.1492b8",
+        "x": 1461.3428039550781,
+        "y": 1438.1666703224182,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "96d3d87a.161f98"
-            ]
+            []
         ]
     },
     {
-        "id": "362cac69.39ad1c",
+        "id": "c68df7b5.0b81e8",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 740.4000244140625,
-        "y": 1353.3999633789062,
-        "z": "e2f7091c.1492b8",
+        "x": 1173.009506225586,
+        "y": 1465.8331894874573,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "827658b9.c24fd"
+                "e0ffad7.48b955"
             ]
         ]
     },
     {
-        "id": "827658b9.c24fd",
-        "type": "switchNode",
-        "name": "switch",
-        "xml": "<switch test='`$service1-status`'>\n",
+        "id": "e6431c0d.bb995",
+        "type": "set",
+        "name": "set",
+        "xml": "<set>\n<parameter name='domain-req' value='`$detail-db.domain-requests`' />\n<parameter name='delete-acc-svc-id' value='`$detail-db.service-instance-id`' />\n<parameter name='access-id' value='`$optical-service-delete-input.request-id`' />\n\n\n\n\n\n\n\n\n\n\n\n\n",
         "comments": "",
-        "outputs": 1,
-        "x": 882.75,
-        "y": 1358.5999145507812,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "30018cf9.344a24",
-                "7de52130.2c5fc"
-            ]
-        ]
+        "x": 1109.1761474609375,
+        "y": 119.88333177566528,
+        "z": "23113e64.4c4872",
+        "wires": []
     },
     {
-        "id": "f7b9ef6.7932f9",
-        "type": "block",
-        "name": "block",
-        "xml": "<block>\n",
-        "atomic": "false",
+        "id": "31b9f2de.b5872e",
+        "type": "outcomeTrue",
+        "name": "true",
+        "xml": "<outcome value='true'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1217.75,
-        "y": 1300.7999877929688,
-        "z": "e2f7091c.1492b8",
+        "x": 906.6761627197266,
+        "y": 324.85795402526855,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "2fd5efbb.db2cd8",
-                "a5309500.d76bc"
+                "caa8b5a3.b36418"
             ]
         ]
     },
     {
-        "id": "2fd5efbb.db2cd8",
-        "type": "delete",
-        "name": "delete",
-        "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\n    resource=\"SQL\"\n    key=\"DELETE FROM REQUEST_DETAILS WHERE request_id = $access-id\"> ",
+        "id": "e0aaa8d0.545478",
+        "type": "outcomeFalse",
+        "name": "false",
+        "xml": "<outcome value='false'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1381.75,
-        "y": 1297.8001098632812,
-        "z": "e2f7091c.1492b8",
+        "x": 853.3427200317383,
+        "y": 773.1913871765137,
+        "z": "23113e64.4c4872",
         "wires": [
-            []
+            [
+                "64b9ab4c.add954"
+            ]
         ]
     },
     {
-        "id": "a5309500.d76bc",
-        "type": "returnSuccess",
-        "name": "return success",
-        "xml": "<return status='success'>\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"Service Deleted Successfully\" />\n<parameter name='ack-final-indicator' value='Y' />",
-        "comments": "",
-        "x": 1423.75,
-        "y": 1481.8001098632812,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "30018cf9.344a24",
-        "type": "outcome",
-        "name": "200",
-        "xml": "<outcome value='200'>\n",
+        "id": "178292af.b017ad",
+        "type": "outcomeTrue",
+        "name": "true",
+        "xml": "<outcome value='true'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1056.199951171875,
-        "y": 1308.2499389648438,
-        "z": "e2f7091c.1492b8",
+        "x": 515.0094858805338,
+        "y": 1440.6155522664385,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "f7b9ef6.7932f9"
+                "3314378c.27c9e8"
             ]
         ]
     },
     {
-        "id": "7de52130.2c5fc",
-        "type": "other",
-        "name": "other",
-        "xml": "<outcome value='Other'>\n",
+        "id": "791b18b2.1028c8",
+        "type": "outcomeFalse",
+        "name": "false",
+        "xml": "<outcome value='false'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1033.199951171875,
-        "y": 1460.2499389648438,
-        "z": "e2f7091c.1492b8",
+        "x": 521.6761341094971,
+        "y": 1642.2822799682617,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "6461eb1d.8fedb4"
+                "ccbb9a05.8b09d8"
             ]
         ]
     },
     {
-        "id": "d7f1c2ce.8da74",
+        "id": "ccbb9a05.8b09d8",
         "type": "switchNode",
         "name": "switch",
-        "xml": "<switch test='`$service1-status == $service2-status == 200`'>\n",
+        "xml": "<switch test='`$access-status == success`'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 857.75,
-        "y": 1529.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 741.6760864257812,
+        "y": 1670.7669677734375,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "d0c11e44.eff1b8",
-                "ebfe8068.c9971"
+                "2c873361.6b8cec",
+                "29ad4b93.f97874"
             ]
         ]
     },
     {
-        "id": "d0c11e44.eff1b8",
+        "id": "2c873361.6b8cec",
         "type": "outcomeTrue",
         "name": "true",
         "xml": "<outcome value='true'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1015.75,
-        "y": 1538.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 898.3426628112793,
+        "y": 1609.4031372070312,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "505e7a53.be6c6c"
+                "abeb4b39.e29ad8"
             ]
         ]
     },
     {
-        "id": "505e7a53.be6c6c",
-        "type": "block",
-        "name": "block",
-        "xml": "<block>\n",
-        "atomic": "false",
+        "id": "29ad4b93.f97874",
+        "type": "outcomeFalse",
+        "name": "false",
+        "xml": "<outcome value='false'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1155.75,
-        "y": 1545.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 898.3426780700684,
+        "y": 1771.069803237915,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "2406e71c.d43e8",
-                "37282d8f.acde4a"
+                "b59bb9d9.ea7ce8"
             ]
         ]
     },
     {
-        "id": "2406e71c.d43e8",
+        "id": "6ec4d0d8.6e90a",
         "type": "delete",
         "name": "delete",
         "xml": "<delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\n    resource=\"SQL\"\n    key=\"DELETE FROM REQUEST_DETAILS WHERE request_id = $access-id\"> ",
         "comments": "",
         "outputs": 1,
-        "x": 1319.75,
-        "y": 1545.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 1174.5549240112305,
+        "y": 1607.4334983825684,
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
     },
     {
-        "id": "ebfe8068.c9971",
-        "type": "outcomeFalse",
-        "name": "false",
-        "xml": "<outcome value='false'>\n",
+        "id": "61f3204d.d33e2",
+        "type": "returnSuccess",
+        "name": "return success",
+        "xml": "<return status='success'>\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"Service Deleted Successfully\" />\n<parameter name='ack-final-indicator' value='Y' />",
         "comments": "",
-        "outputs": 1,
-        "x": 1003.75,
-        "y": 1670.599853515625,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "383c08d1.28a08"
-            ]
-        ]
+        "x": 1704.2214965820312,
+        "y": 1844.2668190002441,
+        "z": "23113e64.4c4872",
+        "wires": []
     },
     {
-        "id": "383c08d1.28a08",
-        "type": "block",
-        "name": "block",
-        "xml": "<block>\n",
-        "atomic": "false",
+        "id": "a47c2756.f32468",
+        "type": "get-resource",
+        "name": "Get service from AAI",
+        "xml": "<get-resource plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\"\nresource=\"service-instance\"\n key='customer.global-customer-id = $output.global-customer-id AND\n     service-subscription.service-type = $output.service-type AND\n     service-instance.service-instance-id = $delete-acc-svc-id' \npfx='acc-serv-dl'      local-only='false'>\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 1147.75,
-        "y": 1683.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 1212.971118927002,
+        "y": 1682.550464630127,
+        "z": "23113e64.4c4872",
         "wires": [
-            [
-                "495cad00.8d5f24"
-            ]
+            []
         ]
     },
     {
-        "id": "495cad00.8d5f24",
-        "type": "returnFailure",
-        "name": "return failure",
-        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Access service request entry cannot be deleted' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
-        "comments": "",
-        "x": 1322.75,
-        "y": 1676.599853515625,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "37282d8f.acde4a",
-        "type": "returnSuccess",
-        "name": "return success",
-        "xml": "<return status='success'>\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"Service Deleted Successfully\" />\n<parameter name='ack-final-indicator' value='Y' />",
+        "id": "9f2294b5.bcbfe8",
+        "type": "set",
+        "name": "set",
+        "xml": "<set>\n<parameter name='link-name' value='`$acc-serv-dl.relationship-list.relationship[$idl].relationship-data[0].relationship-value`' />\n",
         "comments": "",
-        "x": 1337.75,
-        "y": 1626.599853515625,
-        "z": "e2f7091c.1492b8",
+        "x": 1665.4713287353516,
+        "y": 1665.0501899719238,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "70ec6ec4.5ccf08",
-        "type": "returnFailure",
-        "name": "return failure",
-        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Access service request entry cannot be deleted' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
+        "id": "a80e8726.f84408",
+        "type": "update",
+        "name": "update logical-link-status AAI",
+        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.aai.AAIService' \nforce='true'\nresource='logical-link'\n     key='logical-link.link-name = $link-name '\n      local-only='false'>\n<parameter name='operational-status' value='up' />\n\n\n\n\n\n\n\n\n\n    \n    \n    \n    \n    \n    \n    \n    \n   \n    \n    \n    \n\n \n \n",
         "comments": "",
-        "x": 1211.5,
-        "y": 1472.3998413085938,
-        "z": "e2f7091c.1492b8",
-        "wires": []
+        "outputs": 1,
+        "x": 1768.8047256469727,
+        "y": 1759.2170295715332,
+        "z": "23113e64.4c4872",
+        "wires": [
+            []
+        ]
     },
     {
-        "id": "96d3d87a.161f98",
+        "id": "abeb4b39.e29ad8",
         "type": "block",
         "name": "block",
         "xml": "<block>\n",
         "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 736.4000244140625,
-        "y": 1523.39990234375,
-        "z": "e2f7091c.1492b8",
+        "x": 1022.8881912231445,
+        "y": 1610.7668838500977,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "d7f1c2ce.8da74"
+                "6ec4d0d8.6e90a",
+                "a47c2756.f32468",
+                "98787f37.a2ed6"
             ]
         ]
     },
     {
-        "id": "fb442d76.8c0b1",
-        "type": "get-resource",
-        "name": "get resources from DB -controller_id",
-        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT controller_id\nfrom REQUEST_DETAILS\nWHERE request_id = $domain-service1'\npfx='detail-db11'>",
+        "id": "98787f37.a2ed6",
+        "type": "for",
+        "name": "for",
+        "xml": "<for index='idl' start='0' end='`$acc-serv-dl.relationship-list.relationship_length`' >\n",
         "comments": "",
         "outputs": 1,
-        "x": 1377.6666259765625,
-        "y": 680.6666259765625,
-        "z": "e2f7091c.1492b8",
+        "x": 1112.8882637023926,
+        "y": 1737.4336795806885,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "84c6499.61865b8"
+                "e4e22bae.fd2a68"
             ]
         ]
     },
     {
-        "id": "84c6499.61865b8",
-        "type": "success",
-        "name": "success",
-        "xml": "<outcome value='success'>\n",
+        "id": "e4e22bae.fd2a68",
+        "type": "switchNode",
+        "name": "switch",
+        "xml": "<switch test=\"`$acc-serv-dl.relationship-list.relationship[$idl].related-to == 'logical-link'`\">\n",
         "comments": "",
         "outputs": 1,
-        "x": 1623.6666259765625,
-        "y": 684.6666259765625,
-        "z": "e2f7091c.1492b8",
+        "x": 1256.221492767334,
+        "y": 1730.6154251098633,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "4427d502.6c96cc"
+                "55e7e053.a52d9"
             ]
         ]
     },
     {
-        "id": "4427d502.6c96cc",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='controller-id11' value='`$detail-db11.controller-id`' />\n\n\n\n\n\n\n\n\n\n\n",
-        "comments": "",
-        "x": 1791.6666259765625,
-        "y": 686.6666259765625,
-        "z": "e2f7091c.1492b8",
-        "wires": []
-    },
-    {
-        "id": "e8836a64.f81ae",
-        "type": "execute",
-        "name": "split node-id a-end retrieved from DB",
-        "xml": "<execute plugin='org.onap.ccsdk.sli.core.slipluginutils.SliStringUtils' method='split' >\n<parameter name=\"original_string\" value='`$controller-id11`'/>\n<parameter name=\"regex\" value=\"_\"/>\n<parameter name=\"ctx_memory_result_key\" value=\"domain1\"/>\n",
-        "comments": "",
-        "outputs": 1,
-        "x": 1398.6666259765625,
-        "y": 756.6666259765625,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            []
-        ]
-    },
-    {
-        "id": "4d169812.58b88",
-        "type": "get-resource",
-        "name": "get resources from DB -controller_id",
-        "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\nkey='SELECT controller_id\nfrom REQUEST_DETAILS\nWHERE request_id = $domain-service2'\npfx='detail-db22'>",
+        "id": "55e7e053.a52d9",
+        "type": "outcomeTrue",
+        "name": "true",
+        "xml": "<outcome value='true'>\n",
         "comments": "",
         "outputs": 1,
-        "x": 1324.6666259765625,
-        "y": 1056.666748046875,
-        "z": "e2f7091c.1492b8",
+        "x": 1396.2214965820312,
+        "y": 1738.94873046875,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "e0ea4817.5936a"
+                "cac797c.4727a68"
             ]
         ]
     },
     {
-        "id": "e0ea4817.5936a",
-        "type": "success",
-        "name": "success",
-        "xml": "<outcome value='success'>\n",
+        "id": "cac797c.4727a68",
+        "type": "block",
+        "name": "block",
+        "xml": "<block>\n",
+        "atomic": "false",
         "comments": "",
         "outputs": 1,
-        "x": 1569.6666259765625,
-        "y": 1060.666748046875,
-        "z": "e2f7091c.1492b8",
+        "x": 1531.2214965820312,
+        "y": 1740.6153564453125,
+        "z": "23113e64.4c4872",
         "wires": [
             [
-                "9748df16.f21cf8"
+                "9f2294b5.bcbfe8",
+                "a80e8726.f84408",
+                "61f3204d.d33e2"
             ]
         ]
     },
     {
-        "id": "9748df16.f21cf8",
-        "type": "set",
-        "name": "set",
-        "xml": "<set>\n<parameter name='controller-id22' value='`$detail-db22.controller-id`' />\n\n\n\n\n\n\n\n\n\n\n",
+        "id": "b59bb9d9.ea7ce8",
+        "type": "returnFailure",
+        "name": "return failure",
+        "xml": "<return status='failure'>\n<parameter name='error-code' value='500' />\n<parameter name='error-message' value='Access service request entry cannot be deleted' />\n<parameter name='ack-final-indicator' value=\"Y\" />",
         "comments": "",
-        "x": 1718.6666259765625,
-        "y": 1064.666748046875,
-        "z": "e2f7091c.1492b8",
+        "x": 1071.2214965820312,
+        "y": 1808.7972412109375,
+        "z": "23113e64.4c4872",
         "wires": []
     },
     {
-        "id": "8f4e881d.558318",
-        "type": "execute",
-        "name": "split node-id a-end retrieved from DB",
-        "xml": "<execute plugin='org.onap.ccsdk.sli.core.slipluginutils.SliStringUtils' method='split' >\n<parameter name=\"original_string\" value='`$controller-id22`'/>\n<parameter name=\"regex\" value=\"_\"/>\n<parameter name=\"ctx_memory_result_key\" value=\"domain2\"/>\n",
+        "id": "1d36fe9a.5fdc81",
+        "type": "record",
+        "name": "record",
+        "xml": "<record plugin=\"org.onap.ccsdk.sli.core.sli.recording.FileRecorder\">\n<parameter name=\"file\" value=\"/opt/opendaylight/current/data/log/new.log\" />\n<parameter name=\"level\" value=\"info\" />\n<parameter name=\"field1\" value=\"`$domain-req`\"/>\n<parameter name=\"field2\" value=\"`$domain-service1`\"/>\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 1327.6666259765625,
-        "y": 1118.666748046875,
-        "z": "e2f7091c.1492b8",
+        "x": 705.1609497070312,
+        "y": 265.00946044921875,
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
     },
     {
-        "id": "9e23ba6e.b8b718",
-        "type": "update",
-        "name": "update",
-        "xml": "<update plugin='org.onap.ccsdk.sli.adaptors.aai.AAIService' \nforce='true'\nresource='logical-link'\nkey = 'pnf.pnf-name = $a-end-pnf-name\n      AND p-interface.interface-name = $optical-service-create-input.payload.service-aend.port-id'\n      local-only='false'>\n<parameter name='available-capacity' value='`$available-bandwidth-aend`' />\n\n\n\n<save plugin='org.onap.ccsdk.sli.adaptors.aai.AAIService' resource='logical-link'\nkey='logical-link.link-name = $tmp.link-id' >\n    <parameter name='link-name' value='`$tmp.link-id`' />\n    <parameter name='link-type' value='`$link.link-type`' />\n    <parameter name='in-maint' value='true' />\n    <parameter name='speed-value' value='100' />\n    <parameter name='speed-units' value='Gbps' />\n    <parameter name='operational-status' value='`$link.administrative-state`' />\n    <parameter name='available-capacity' value='100' />\n\n\n\n\n\n\n\n\n\n\n\n    \n    \n    \n    \n    \n    \n    \n    \n   \n    \n    \n    \n\n\n",
+        "id": "55028f82.4ab0c",
+        "type": "record",
+        "name": "record",
+        "xml": "<record plugin=\"org.onap.ccsdk.sli.core.sli.recording.FileRecorder\">\n<parameter name=\"file\" value=\"/opt/opendaylight/current/data/log/new.log\" />\n<parameter name=\"level\" value=\"info\" />\n<parameter name=\"field1\" value=\"Domain Details\"/>\n<parameter name=\"field2\" value=\"`$controller-ip`\"/>\n<parameter name=\"field3\" value=\"`$optical-service-delete-input.request-id`\"/>\n<parameter name=\"field4\" value=\"`$optical-service-delete-input.payload.service-name`\"/>\n\n",
         "comments": "",
         "outputs": 1,
-        "x": 1418.6666717529297,
-        "y": 1385.6666717529297,
-        "z": "e2f7091c.1492b8",
+        "x": 1251.070011138916,
+        "y": 486.6761064529419,
+        "z": "23113e64.4c4872",
         "wires": [
             []
         ]
-    },
-    {
-        "id": "6461eb1d.8fedb4",
-        "type": "block",
-        "name": "block",
-        "xml": "<block>\n",
-        "atomic": "false",
-        "comments": "",
-        "outputs": 1,
-        "x": 1130.3333740234375,
-        "y": 1413.3331909179688,
-        "z": "e2f7091c.1492b8",
-        "wires": [
-            [
-                "70ec6ec4.5ccf08"
-            ]
-        ]
     }
 ]
\ No newline at end of file