-[{"id":"e6f39633.471c48","type":"dgstart","name":"DGSTART","outputs":1,"x":258.5714416503906,"y":97.14286041259766,"z":"10870127.4386af","wires":[["d6249e04.66f74"]]},{"id":"d6249e04.66f74","type":"service-logic","name":"GENERIC-RESOURCE-API ${project.version}","module":"GENERIC-RESOURCE-API","version":"${project.version}","comments":"","xml":"<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>","outputs":1,"x":333.8571472167969,"y":137.38097190856934,"z":"10870127.4386af","wires":[["6c9006ff.722f08"]]},{"id":"6c9006ff.722f08","type":"method","name":"network-topology-operation-activate","xml":"<method rpc='network-topology-operation-activate' mode='sync'>\n","comments":"","outputs":1,"x":375.2500762939453,"y":180.89285469055176,"z":"10870127.4386af","wires":[["913b7a05.ce48c8"]]},{"id":"913b7a05.ce48c8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":374.57147216796875,"y":275.58634185791016,"z":"10870127.4386af","wires":[["483fa189.e48fa","4a952ce4.1e15f4","dd05a3dc.3a557","abcbde1a.155d9","4323ba0.5293848","64b80dfc.ef3a34","9e1fc71.9223838","c9ccd6fd.b061c8"]]},{"id":"4f6e01d6.e961e","type":"not-found","name":"not found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":894.5714416503906,"y":271.14286041259766,"z":"10870127.4386af","wires":[["a48d6330.48ebc"]]},{"id":"a48d6330.48ebc","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name=\"error-code\" value=\"404\" />\n\t<parameter name=\"error-message\" value=\"network-id not found in AAI\" />","comments":"","x":1057.7658386230469,"y":271.2540817260742,"z":"10870127.4386af","wires":[]},{"id":"483fa189.e48fa","type":"get-resource","name":"get AnAI - l3-network by network-id","xml":"<get-resource plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"l3-network\" \n\t\tkey=\"l3-network.network-id = $network-topology-operation-input.network-information.network-id\" \n\t\tlocal-only=\"false\" \n\t\tpfx=\"aai.l3-network\">\n","comments":"","outputs":1,"x":659.2935485839844,"y":275.6274642944336,"z":"10870127.4386af","wires":[["4f6e01d6.e961e","f7be2e5e.033bb"]]},{"id":"f7be2e5e.033bb","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":887.2935485839844,"y":309.6274642944336,"z":"10870127.4386af","wires":[["54a3713d.2b9d5"]]},{"id":"54a3713d.2b9d5","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name=\"error-code\" value=\"500\" />\n\t<parameter name=\"error-message\" value=\"'Error retrieving l3-network with network-id=' + $network-topology-operation-input.network-request-information.network-id + 'from AnAI'\" />","comments":"","x":1039.4046325683594,"y":309.84969329833984,"z":"10870127.4386af","wires":[]},{"id":"e6d2c8f2.14a568","type":"set","name":"set entity-id and plan-name","xml":"<set>\n\t<parameter name=\"eipam-ip-block.entity-id\" value=\"`$aai.l3-network.subnets.subnet[$sidx].subnet-id`\"/>\n\t<parameter name=\"eipam-ip-block.plans[0].plan-name\" value=\"`$tmp.eipam-subnet-row.plan-name`\"/>\n","comments":"","x":1087.6509094238281,"y":824.222297668457,"z":"10870127.4386af","wires":[]},{"id":"9db53dfb.ded5f","type":"for","name":"for 0..subnet_length","xml":"<for index='sidx' start='0' end='`$aai.l3-network.subnets.subnet_length`' >\n","comments":"","outputs":1,"x":703.9365539550781,"y":465.3651809692383,"z":"10870127.4386af","wires":[["6df15d6b.7d45e4"]]},{"id":"6df15d6b.7d45e4","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":907.9365539550781,"y":465.5080032348633,"z":"10870127.4386af","wires":[["34e2f4cb.2f293c"]]},{"id":"34e2f4cb.2f293c","type":"get-resource","name":"get eipam-ip-subnet by subnet-id","xml":"<get-resource\n plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\n resource='SQL'\n key=\"SELECT * from EIPAM_IP_SUBNETS where entity_id = $aai.l3-network.subnets.subnet[$sidx].subnet-id ; \"\n pfx='tmp.eipam-subnet-row'>\n\n","comments":"","outputs":1,"x":863.0794677734375,"y":593.3651103973389,"z":"10870127.4386af","wires":[["5d8dc2c.3d6613c","4a3e4daf.fbea34","159507a4.d55848"]]},{"id":"d270ebed.73a6d8","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Query to DB table EIPAM_IP_SUBNETS failed to find subnet matching aai subnet.\" />\n\t","comments":"","x":1271.2222290039062,"y":541.0793916881084,"z":"10870127.4386af","wires":[]},{"id":"5d8dc2c.3d6613c","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1121.7938232421875,"y":609.0793621242046,"z":"10870127.4386af","wires":[["9a4c8eed.e5e32"]]},{"id":"4a3e4daf.fbea34","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1122.0841064453125,"y":543.0793916881084,"z":"10870127.4386af","wires":[["d270ebed.73a6d8"]]},{"id":"159507a4.d55848","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1122.9412155151367,"y":577.3651123046875,"z":"10870127.4386af","wires":[["3bd47e7c.2eb412"]]},{"id":"9a4c8eed.e5e32","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1274.507911682129,"y":610.5079824626446,"z":"10870127.4386af","wires":[["e6d2c8f2.14a568","d1f1dda7.2a7f","743c8d64.6209d4"]]},{"id":"3bd47e7c.2eb412","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Subnet not found in EIPAM_IP_SUBNETS - activate failed.\" />\n\t","comments":"","x":1270.222068786621,"y":573.3651428222656,"z":"10870127.4386af","wires":[]},{"id":"d1f1dda7.2a7f","type":"execute","name":"execute EIPAM activateSubnet","xml":"<execute plugin=\"com.att.sdnctl.sli.plugin.eipam.EIPAMPlugin\" method=\"activateSubnet\">\n","comments":"subnet and subnet_keys are deleted in the EIPAMPlugin","outputs":1,"x":1100.5079498291016,"y":867.0793867111206,"z":"10870127.4386af","wires":[["14296d10.9a71c3"]]},{"id":"14296d10.9a71c3","type":"failure","name":"failure","xml":"<outcome value='failure'>","outputs":1,"x":1310.5079803466797,"y":868.4697523117065,"z":"10870127.4386af","wires":[["14bf629f.48693d"]]},{"id":"14bf629f.48693d","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while activating subnet in EIPAM.\" />\n\t","comments":"","x":1474.5079612731934,"y":867.1840448379517,"z":"10870127.4386af","wires":[]},{"id":"743c8d64.6209d4","type":"save","name":"Update subnet to Active in DB","xml":"<save \n\tplugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' \n\tresource='SQL'\n\tkey=\"UPDATE EIPAM_IP_SUBNETS\n SET status = 'ACTIVE'\n WHERE entity_id = $eipam-ip-block.entity-id ; \"\n force='true'\n pfx='pfx.eipam-subnet-row'>\n","comments":"","outputs":1,"x":1099.0794525146484,"y":907.0793333053589,"z":"10870127.4386af","wires":[["b0892e3c.001c2","81c9d2da.4de6d","6955b5ef.93cc7c"]]},{"id":"d709d6dc.cc91a8","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while updating subnet to active in mysql.\" />\n\t","comments":"","x":1467.6508331298828,"y":914.2222089767456,"z":"10870127.4386af","wires":[]},{"id":"6955b5ef.93cc7c","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1318.222427368164,"y":982.2221794128418,"z":"10870127.4386af","wires":[["6d0338bb.0ea688"]]},{"id":"b0892e3c.001c2","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1318.512710571289,"y":916.2222089767456,"z":"10870127.4386af","wires":[["d709d6dc.cc91a8"]]},{"id":"81c9d2da.4de6d","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1319.3698196411133,"y":950.5079295933247,"z":"10870127.4386af","wires":[["a647d288.410a9"]]},{"id":"6d0338bb.0ea688","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1470.9365158081055,"y":983.6507997512817,"z":"10870127.4386af","wires":[["9c0c90cf.0e24"]]},{"id":"a647d288.410a9","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while updating subnet to active in mysql.\" />\n\t","comments":"","x":1466.6506729125977,"y":946.5079601109028,"z":"10870127.4386af","wires":[]},{"id":"9c0c90cf.0e24","type":"save","name":"update AnAI - subnet","xml":"<update plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"subnet\" \n\t\tkey=\"l3-network.network-id = $aai.l3-network.network-id \n\t\t\tAND subnet.subnet-id = $eipam-ip-block.entity-id\" >\n<parameter name=\"orchestration-status\" value=\"Created\" />\n\t\t","comments":"","outputs":1,"x":1696.22216796875,"y":984.3809642791748,"z":"10870127.4386af","wires":[["e6f35141.0faae","64a1bcb5.b701b4"]]},{"id":"1a14322d.73a58e","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet.\" />\n\t","comments":"","x":2087.9683380126953,"y":974.2222089767456,"z":"10870127.4386af","wires":[]},{"id":"e2c902b5.a3806","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1938.5399322509766,"y":1042.2221794128418,"z":"10870127.4386af","wires":[["958ef34e.7f381"]]},{"id":"e6f35141.0faae","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1927.4015789031982,"y":980.5079393386841,"z":"10870127.4386af","wires":[["1a14322d.73a58e"]]},{"id":"64a1bcb5.b701b4","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1939.6873245239258,"y":1010.5079295933247,"z":"10870127.4386af","wires":[["434dd028.03aa2"]]},{"id":"958ef34e.7f381","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":2091.254020690918,"y":1043.6507997512817,"z":"10870127.4386af","wires":[[]]},{"id":"434dd028.03aa2","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet. Subnet not found.\" />\n\t","comments":"","x":2086.96817779541,"y":1006.5079601109028,"z":"10870127.4386af","wires":[]},{"id":"abcbde1a.155d9","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n<parameter name=\"ack-final-indicator\" value=\"Y\" />\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"`$error-message`\" />\n","comments":"","x":667.3651161193848,"y":1390.507939338684,"z":"10870127.4386af","wires":[]},{"id":"64b80dfc.ef3a34","type":"set","name":"set object-path","xml":"<set>\n<parameter name='network-object-path' value=\"`'restconf/config/GENERIC-RESOURCE-API:services/service/'\n + $network-topology-operation-input.service-information.service-instance-id\n + '/service-data/networks/network/'\n + $networkId\n + '/network-data/network-topology/'` \" />\n \n","comments":"","x":667.3690605163574,"y":1310.7019815444946,"z":"10870127.4386af","wires":[]},{"id":"4a952ce4.1e15f4","type":"set","name":"set networkId","xml":"<set>\n<parameter name='networkId' value='`$network-topology-operation-input.network-information.network-id`' />\n","comments":"","x":661.6546936035156,"y":1273.5590896606445,"z":"10870127.4386af","wires":[]},{"id":"dd05a3dc.3a557","type":"set","name":"set network-level-oper-status","xml":"<set>\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.order-status' value='Created' />\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.last-rpc-action' value='`$network-topology-operation-input.sdnc-request-header.svc-action`' />\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.last-action' value='`$network-topology-operation-input.request-information.request-action`' />\n","comments":"","x":709.6547546386719,"y":1356.1304550170898,"z":"10870127.4386af","wires":[]},{"id":"4323ba0.5293848","type":"switchNode","name":"switch $aai.l3-network.subnets.subnet_length","xml":"<switch test='`$aai.l3-network.subnets.subnet_length`'>\n","comments":"","outputs":1,"x":692.5714416503906,"y":369.1428909301758,"z":"10870127.4386af","wires":[["24ed13fa.fd22fc","87c32ead.5792"]]},{"id":"24ed13fa.fd22fc","type":"other","name":"outcome Null","xml":"<outcome value=''>\n","comments":"","outputs":1,"x":1012.5714416503906,"y":369.1428909301758,"z":"10870127.4386af","wires":[["55d6b99e.dc48b8"]]},{"id":"55d6b99e.dc48b8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n <parameter name=\"error-message\" value=\"no networks found\" />\n","comments":"","x":1234.3489685058594,"y":367.03186798095703,"z":"10870127.4386af","wires":[]},{"id":"87c32ead.5792","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":888.5714416503906,"y":409.1428909301758,"z":"10870127.4386af","wires":[["9db53dfb.ded5f"]]},{"id":"9e1fc71.9223838","type":"save","name":"update AnAI - network","xml":"<update plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"l3-network\" \n\t\tkey=\"l3-network.network-id = $aai.l3-network.network-id\" >\n<parameter name=\"orchestration-status\" value=\"Active\" />\t","comments":"","outputs":1,"x":699.2381057739258,"y":1153.476107597351,"z":"10870127.4386af","wires":[["503fe113.27f6d","728bfb7d.f2fb44"]]},{"id":"f1272b1f.5a1378","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for l3-network\" />\n\t","comments":"","x":1112.317611694336,"y":1138.9840593338013,"z":"10870127.4386af","wires":[]},{"id":"9d9f3cda.c470f","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":962.8892059326172,"y":1206.9840297698975,"z":"10870127.4386af","wires":[["ef2d84a7.0876f8"]]},{"id":"503fe113.27f6d","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":951.7508525848389,"y":1145.2697896957397,"z":"10870127.4386af","wires":[["f1272b1f.5a1378"]]},{"id":"728bfb7d.f2fb44","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":964.0365982055664,"y":1175.2697799503803,"z":"10870127.4386af","wires":[["3ba7e47e.1480bc"]]},{"id":"ef2d84a7.0876f8","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1115.6032943725586,"y":1208.4126501083374,"z":"10870127.4386af","wires":[[]]},{"id":"3ba7e47e.1480bc","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for l3-network. Network not found.\" />\n\t","comments":"","x":1111.3174514770508,"y":1171.2698104679585,"z":"10870127.4386af","wires":[]},{"id":"c9ccd6fd.b061c8","type":"set","name":"copy input to service-data","xml":"<set>\n<parameter name='service-data.networks.network[$nidx].network-data.sdnc-request-header.' value='`$network-topology-operation-input.sdnc-request-header.`' />\n<parameter name='service-data.networks.network[$nidx].network-data.request-information.' value='`$network-topology-operation-input.request-information.`' />\n","comments":"","x":703.0832290649414,"y":1233.5590562820435,"z":"10870127.4386af","wires":[]}]
+[{"id":"aad8b671.6c92a8","type":"dgstart","name":"DGSTART","outputs":1,"x":171.75,"y":129.5,"z":"31276fa5.74ef8","wires":[["fc1afe3.c14518"]]},{"id":"fc1afe3.c14518","type":"service-logic","name":"GENERIC-RESOURCE-API ${project.version}","module":"GENERIC-RESOURCE-API","version":"${project.version}","comments":"","xml":"<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>","outputs":1,"x":247.03570556640625,"y":169.73811149597168,"z":"31276fa5.74ef8","wires":[["8bb44f8f.960958"]]},{"id":"8bb44f8f.960958","type":"method","name":"network-topology-operation-activate","xml":"<method rpc='network-topology-operation-activate' mode='sync'>\n","comments":"","outputs":1,"x":288.4286346435547,"y":213.2499942779541,"z":"31276fa5.74ef8","wires":[["6a980331.36ce2c"]]},{"id":"6a980331.36ce2c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":287.7500305175781,"y":307.9434814453125,"z":"31276fa5.74ef8","wires":[["347a2bc6.901ffc","7c8b3998.1a0b68","70e85b23.8d3054","4a68fc12.7927f4","280acaa8.006566","afca1cc9.37ef2","f95d52a7.cfe038","1dc0ccd9.62a26b"]]},{"id":"f8ffe16f.6d2ce8","type":"not-found","name":"not found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":818.75,"y":301.50001525878906,"z":"31276fa5.74ef8","wires":[["e493f260.987388"]]},{"id":"e493f260.987388","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name=\"error-code\" value=\"404\" />\n\t<parameter name=\"error-message\" value=\"network-id not found in AAI\" />","comments":"","x":981.9443969726562,"y":301.6112365722656,"z":"31276fa5.74ef8","wires":[]},{"id":"347a2bc6.901ffc","type":"get-resource","name":"get AnAI - l3-network by network-id","xml":"<get-resource plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"l3-network\" \n\t\tkey=\"l3-network.network-id = $network-topology-operation-input.network-information.network-id AND \n depth = 'all'\" \n\t\tlocal-only=\"false\" \n\t\tpfx=\"aai.l3-network\">\n","comments":"","outputs":1,"x":583.4721069335938,"y":305.984619140625,"z":"31276fa5.74ef8","wires":[["f8ffe16f.6d2ce8","7fd1cc43.5cbeac"]]},{"id":"7fd1cc43.5cbeac","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":811.4721069335938,"y":339.984619140625,"z":"31276fa5.74ef8","wires":[["695fe527.9c94ac"]]},{"id":"695fe527.9c94ac","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name=\"error-code\" value=\"500\" />\n\t<parameter name=\"error-message\" value=\"'Error retrieving l3-network with network-id=' + $network-topology-operation-input.network-request-information.network-id + 'from AnAI'\" />","comments":"","x":963.5831909179688,"y":340.20684814453125,"z":"31276fa5.74ef8","wires":[]},{"id":"ca70884c.912a78","type":"set","name":"set entity-id and plan-name","xml":"<set>\n\t<parameter name=\"eipam-ip-block.entity-id\" value=\"`$aai.l3-network.subnets.subnet[$sidx].subnet-id`\"/>\n\t<parameter name=\"eipam-ip-block.plans[0].plan-name\" value=\"`$tmp.eipam-subnet-row.plan-name`\"/>\n","comments":"","x":1016.8294677734375,"y":1121.5794067382812,"z":"31276fa5.74ef8","wires":[]},{"id":"e4a7e0a0.e6b8a8","type":"for","name":"for 0..subnet_length","xml":"<for index='sidx' start='0' end='`$aai.l3-network.subnets.subnet_length`' >\n","comments":"","outputs":1,"x":954.1151123046875,"y":836.7222900390625,"z":"31276fa5.74ef8","wires":[["ffba001b.9779c"]]},{"id":"ffba001b.9779c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1158.1151123046875,"y":835.8651123046875,"z":"31276fa5.74ef8","wires":[["caf9a917.b8b4b"]]},{"id":"caf9a917.b8b4b","type":"get-resource","name":"get eipam-ip-subnet by subnet-id","xml":"<get-resource\n plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\n resource='SQL'\n key=\"SELECT * from EIPAM_IP_SUBNETS where entity_id = $aai.l3-network.subnets.subnet[$sidx].subnet-id ; \"\n pfx='tmp.eipam-subnet-row'>\n\n","comments":"","outputs":1,"x":1113.2580261230469,"y":973.7222194671631,"z":"31276fa5.74ef8","wires":[["82c93d87.3c4cd8","8afed5a1.3d3c5","4c63e33f.93a614"]]},{"id":"b9d0e076.a549f","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Query to DB table EIPAM_IP_SUBNETS failed to find subnet matching aai subnet.\" />\n\t","comments":"","x":1521.4007873535156,"y":921.4365007579327,"z":"31276fa5.74ef8","wires":[]},{"id":"82c93d87.3c4cd8","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1371.9723815917969,"y":989.4364711940289,"z":"31276fa5.74ef8","wires":[["9227ef6b.5a4c5"]]},{"id":"8afed5a1.3d3c5","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1372.2626647949219,"y":923.4365007579327,"z":"31276fa5.74ef8","wires":[["b9d0e076.a549f"]]},{"id":"4c63e33f.93a614","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1373.119773864746,"y":957.7222213745117,"z":"31276fa5.74ef8","wires":[["a33338bb.a90c68"]]},{"id":"9227ef6b.5a4c5","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1524.6864700317383,"y":990.8650915324688,"z":"31276fa5.74ef8","wires":[["ca70884c.912a78","e84c68d7.f3801","56f420bb.33bc5"]]},{"id":"a33338bb.a90c68","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Subnet not found in EIPAM_IP_SUBNETS - activate failed.\" />\n\t","comments":"","x":1520.4006271362305,"y":953.7222518920898,"z":"31276fa5.74ef8","wires":[]},{"id":"e84c68d7.f3801","type":"execute","name":"execute EIPAM activateSubnet","xml":"<execute plugin=\"com.att.sdnctl.sli.plugin.eipam.EIPAMPlugin\" method=\"activateSubnet\">\n","comments":"subnet and subnet_keys are deleted in the EIPAMPlugin","outputs":1,"x":1029.686508178711,"y":1164.4364957809448,"z":"31276fa5.74ef8","wires":[["a48dd3e1.d2aa28"]]},{"id":"a48dd3e1.d2aa28","type":"failure","name":"failure","xml":"<outcome value='failure'>","outputs":1,"x":1239.686538696289,"y":1165.8268613815308,"z":"31276fa5.74ef8","wires":[["9055635.fe4ed2"]]},{"id":"9055635.fe4ed2","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while activating subnet in EIPAM.\" />\n\t","comments":"","x":1403.6865196228027,"y":1164.5411539077759,"z":"31276fa5.74ef8","wires":[]},{"id":"56f420bb.33bc5","type":"save","name":"Update subnet to Active in DB","xml":"<save \n\tplugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' \n\tresource='SQL'\n\tkey=\"UPDATE EIPAM_IP_SUBNETS\n SET status = 'ACTIVE'\n WHERE entity_id = $eipam-ip-block.entity-id ; \"\n force='true'\n pfx='pfx.eipam-subnet-row'>\n","comments":"","outputs":1,"x":1028.2580108642578,"y":1204.436442375183,"z":"31276fa5.74ef8","wires":[["10829540.6646b3","5cb79e38.5ce198","f0c9957e.af2a88"]]},{"id":"e78db626.6538f8","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while updating subnet to active in mysql.\" />\n\t","comments":"","x":1396.8293914794922,"y":1211.5793180465698,"z":"31276fa5.74ef8","wires":[]},{"id":"f0c9957e.af2a88","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1247.4009857177734,"y":1279.579288482666,"z":"31276fa5.74ef8","wires":[["ea1492ee.0f56a"]]},{"id":"10829540.6646b3","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1247.6912689208984,"y":1213.5793180465698,"z":"31276fa5.74ef8","wires":[["e78db626.6538f8"]]},{"id":"5cb79e38.5ce198","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1248.5483779907227,"y":1247.8650386631489,"z":"31276fa5.74ef8","wires":[["6bd5881a.8cae5"]]},{"id":"ea1492ee.0f56a","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1400.1150741577148,"y":1281.007908821106,"z":"31276fa5.74ef8","wires":[["71f89e7.9397de"]]},{"id":"6bd5881a.8cae5","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"An error occured while updating subnet to active in mysql.\" />\n\t","comments":"","x":1395.829231262207,"y":1243.865069180727,"z":"31276fa5.74ef8","wires":[]},{"id":"71f89e7.9397de","type":"save","name":"update AnAI - subnet","xml":"<update plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"subnet\" \n\t\tkey=\"l3-network.network-id = $aai.l3-network.network-id \n\t\t\tAND subnet.subnet-id = $eipam-ip-block.entity-id\" >\n<parameter name=\"orchestration-status\" value=\"Active\" />\n\t\t","comments":"","outputs":1,"x":1625.4007263183594,"y":1281.738073348999,"z":"31276fa5.74ef8","wires":[["dd793cd5.2b12d","3fbf7056.3305c8"]]},{"id":"7d340cb2.4be154","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet.\" />\n\t","comments":"","x":2000.1469802856445,"y":1274.5793916881084,"z":"31276fa5.74ef8","wires":[]},{"id":"8130f435.f558f8","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1850.7185745239258,"y":1342.5793621242046,"z":"31276fa5.74ef8","wires":[["f3e4ac3e.a58ab8"]]},{"id":"dd793cd5.2b12d","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1839.5802211761475,"y":1280.865122050047,"z":"31276fa5.74ef8","wires":[["7d340cb2.4be154"]]},{"id":"3fbf7056.3305c8","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1851.865966796875,"y":1310.8651123046875,"z":"31276fa5.74ef8","wires":[["9e49b5c9.859b6"]]},{"id":"f3e4ac3e.a58ab8","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":2003.4326629638672,"y":1344.0079824626446,"z":"31276fa5.74ef8","wires":[[]]},{"id":"9e49b5c9.859b6","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet. Subnet not found.\" />\n\t","comments":"","x":1999.1468200683594,"y":1306.8651428222656,"z":"31276fa5.74ef8","wires":[]},{"id":"4a68fc12.7927f4","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n<parameter name=\"ack-final-indicator\" value=\"Y\" />\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"`$error-message`\" />\n","comments":"","x":585.5436668395996,"y":1596.8650207519531,"z":"31276fa5.74ef8","wires":[]},{"id":"afca1cc9.37ef2","type":"set","name":"set object-path","xml":"<set>\n<parameter name='network-object-path' value=\"`'restconf/config/GENERIC-RESOURCE-API:services/service/'\n + $network-topology-operation-input.service-information.service-instance-id\n + '/service-data/networks/network/'\n + $networkId\n + '/network-data/network-topology/'` \" />\n \n","comments":"","x":585.5476112365723,"y":1517.0590629577637,"z":"31276fa5.74ef8","wires":[]},{"id":"7c8b3998.1a0b68","type":"set","name":"set networkId","xml":"<set>\n<parameter name='networkId' value='`$network-topology-operation-input.network-information.network-id`' />\n","comments":"","x":579.8332443237305,"y":1479.9161710739136,"z":"31276fa5.74ef8","wires":[]},{"id":"70e85b23.8d3054","type":"set","name":"set network-level-oper-status","xml":"<set>\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.order-status' value='Created' />\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.last-rpc-action' value='`$network-topology-operation-input.sdnc-request-header.svc-action`' />\n<parameter name='service-data.networks.network[$tmp.nidx].network-data.network-level-oper-status.last-action' value='`$network-topology-operation-input.request-information.request-action`' />\n","comments":"","x":627.8333053588867,"y":1562.487536430359,"z":"31276fa5.74ef8","wires":[]},{"id":"280acaa8.006566","type":"switchNode","name":"switch $aai.l3-network.subnets.subnet_length","xml":"<switch test='`$aai.l3-network.subnets.subnet_length`'>\n","comments":"","outputs":1,"x":612.75,"y":393.5,"z":"31276fa5.74ef8","wires":[["8347d939.5620b8","f2abfa4c.005c3"]]},{"id":"8347d939.5620b8","type":"other","name":"outcome Null","xml":"<outcome value=''>\n","comments":"","outputs":1,"x":932.75,"y":393.5,"z":"31276fa5.74ef8","wires":[["b1e0408b.8fcf88"]]},{"id":"b1e0408b.8fcf88","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n <parameter name=\"error-message\" value=\"no networks found\" />\n","comments":"","x":1154.5275268554688,"y":391.38897705078125,"z":"31276fa5.74ef8","wires":[]},{"id":"f2abfa4c.005c3","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":914.75,"y":427.5,"z":"31276fa5.74ef8","wires":[["a4f63900.f19bf"]]},{"id":"f95d52a7.cfe038","type":"save","name":"update AnAI - network","xml":"<update plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"l3-network\" \n\t\tkey=\"l3-network.network-id = $aai.l3-network.network-id\" >\n<parameter name=\"orchestration-status\" value=\"Active\" />\t","comments":"","outputs":1,"x":617.4166564941406,"y":1359.8331890106201,"z":"31276fa5.74ef8","wires":[["e1f780e.72e668","a6992d57.d1b588"]]},{"id":"f0cbc86c.4834d","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for l3-network\" />\n\t","comments":"","x":1030.4961624145508,"y":1345.3411407470703,"z":"31276fa5.74ef8","wires":[]},{"id":"c5f332ba.4d0fc8","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":881.067756652832,"y":1413.3411111831665,"z":"31276fa5.74ef8","wires":[["a30e496c.388428"]]},{"id":"e1f780e.72e668","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":869.9294033050537,"y":1351.6268711090088,"z":"31276fa5.74ef8","wires":[["f0cbc86c.4834d"]]},{"id":"a6992d57.d1b588","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":882.2151489257812,"y":1381.6268613636494,"z":"31276fa5.74ef8","wires":[["89e9fe8c.80a52"]]},{"id":"a30e496c.388428","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1033.7818450927734,"y":1414.7697315216064,"z":"31276fa5.74ef8","wires":[[]]},{"id":"89e9fe8c.80a52","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for l3-network. Network not found.\" />\n\t","comments":"","x":1029.4960021972656,"y":1377.6268918812275,"z":"31276fa5.74ef8","wires":[]},{"id":"1dc0ccd9.62a26b","type":"set","name":"copy input to service-data","xml":"<set>\n<parameter name='service-data.networks.network[$nidx].network-data.sdnc-request-header.' value='`$network-topology-operation-input.sdnc-request-header.`' />\n<parameter name='service-data.networks.network[$nidx].network-data.request-information.' value='`$network-topology-operation-input.request-information.`' />\n","comments":"","x":621.2617797851562,"y":1439.9161376953125,"z":"31276fa5.74ef8","wires":[]},{"id":"e7f076b.7293d08","type":"switchNode","name":"switch from-preload","xml":"<switch test='`$service-data.networks.network[$nidx].network-data.network-information.from-preload`'>\n","comments":"","outputs":1,"x":550.49609375,"y":701.74609375,"z":"31276fa5.74ef8","wires":[["5be403fb.f6e604","935c32f2.5c477"]]},{"id":"5be403fb.f6e604","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":538.49609375,"y":780.24609375,"z":"31276fa5.74ef8","wires":[["a5d42667.baffc"]]},{"id":"935c32f2.5c477","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":526.49609375,"y":837.24609375,"z":"31276fa5.74ef8","wires":[["7e645dee.196a5c"]]},{"id":"354a953d.970fea","type":"for","name":"for 0..subnet_length","xml":"<for index='sidx' start='0' end='`$aai.l3-network.subnets.subnet_length`' >\n","comments":"","outputs":1,"x":930.49609375,"y":779.24609375,"z":"31276fa5.74ef8","wires":[["1834de34.aa66ca"]]},{"id":"1834de34.aa66ca","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1130.49609375,"y":779.388916015625,"z":"31276fa5.74ef8","wires":[["4e5f455.9e01cbc"]]},{"id":"4e5f455.9e01cbc","type":"save","name":"update AnAI - subnet","xml":"<update plugin=\"org.onap.ccsdk.sli.adaptors.aai.AAIService\" \n\tresource=\"subnet\" \n\t\tkey=\"l3-network.network-id = $aai.l3-network.network-id \n\t\t\tAND subnet.subnet-id = $aai.l3-network.subnets.subnet[$sidx].subnet-id\" >\n<parameter name=\"orchestration-status\" value=\"Active\" />\n\t\t","comments":"","outputs":1,"x":1351.74609375,"y":778.74609375,"z":"31276fa5.74ef8","wires":[["ea2ce0fa.cbaf78","e5c37082.c5e4a"]]},{"id":"ca81daa8.aa2b88","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet.\" />\n\t","comments":"","x":1736.492317199707,"y":772.5873872935772,"z":"31276fa5.74ef8","wires":[]},{"id":"186b63eb.ee1064","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1587.0639114379883,"y":840.5873577296734,"z":"31276fa5.74ef8","wires":[["7fc8a15e.ded2e"]]},{"id":"ea2ce0fa.cbaf78","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1575.92555809021,"y":778.8731176555157,"z":"31276fa5.74ef8","wires":[["ca81daa8.aa2b88"]]},{"id":"e5c37082.c5e4a","type":"not-found","name":"not-found","xml":"<outcome value=\"not-found\">","comments":"","outputs":1,"x":1588.2113037109375,"y":808.8731079101562,"z":"31276fa5.74ef8","wires":[["591f495d.08622"]]},{"id":"7fc8a15e.ded2e","type":"block","name":"block : atomic","xml":"<block atomic='true'>","atomic":"true","comments":"","outputs":1,"x":1739.7779998779297,"y":842.0159780681133,"z":"31276fa5.74ef8","wires":[[]]},{"id":"591f495d.08622","type":"returnFailure","name":"return failure","xml":"<return status=\"failure\">\n\t<parameter name=\"error-code\" value=\"500\"/>\n\t<parameter name=\"error-message\" value=\"Failure updating orchestration-status in AAI for subnet. Subnet not found.\" />\n\t","comments":"","x":1735.4921569824219,"y":804.8731384277344,"z":"31276fa5.74ef8","wires":[]},{"id":"a5d42667.baffc","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":724.74609375,"y":781.24609375,"z":"31276fa5.74ef8","wires":[["354a953d.970fea"]]},{"id":"7e645dee.196a5c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":738.74609375,"y":837.24609375,"z":"31276fa5.74ef8","wires":[["e4a7e0a0.e6b8a8"]]},{"id":"a4f63900.f19bf","type":"switchNode","name":"switch network-instance-group-id","xml":"<switch test='`$network-data.network-topology.network-topology-identifier-structure.network-instance-group-id`'>\n","comments":"","outputs":1,"x":581.49609375,"y":507.24609375,"z":"31276fa5.74ef8","wires":[["37463523.271202","1363245c.95b004"]]},{"id":"37463523.271202","type":"other","name":"outcome Null","xml":"<outcome value=''>\n","comments":"","outputs":1,"x":874.49609375,"y":505.74609375,"z":"31276fa5.74ef8","wires":[["e7f076b.7293d08"]]},{"id":"1363245c.95b004","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":865.49609375,"y":536.74609375,"z":"31276fa5.74ef8","wires":[["3f8c9bce.2fbecc"]]},{"id":"3f8c9bce.2fbecc","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1060.49609375,"y":535.74609375,"z":"31276fa5.74ef8","wires":[["7ba3c6f1.8a0f7"]]},{"id":"7ba3c6f1.8a0f7","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n <parameter name=\"error-message\" value=\"network collection activate failed\" />\n","comments":"","x":1261.49609375,"y":530.74609375,"z":"31276fa5.74ef8","wires":[]},{"id":"54e043ce.c9819c","type":"comment","name":"need to implement this","info":"","comments":"","x":1291.49609375,"y":499.24609375,"z":"31276fa5.74ef8","wires":[]}]
\ No newline at end of file
Code Review / sdnc / oam.git / blobdiff