3 DELETE FROM northbound_request_ref_lookup;
4 DELETE FROM orchestration_flow_reference;
5 DELETE FROM rainy_day_handler_macro;
6 DELETE FROM building_block_detail;
7 DELETE FROM orchestration_status_state_transition_directive;
10 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE,IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION, CLOUD_OWNER, SERVICE_TYPE) VALUES
11 ('Service-Create', 'createInstance', 'Service', true,true, '7','7', 'DEFAULT', '*'),
12 ('Service-Delete', 'deleteInstance', 'Service', true,true, '7','7', 'DEFAULT', '*'),
13 ('Service-Macro-Assign', 'assignInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
14 ('Service-Macro-Activate', 'activateInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
15 ('Service-Macro-Unassign', 'unassignInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
16 ('Service-Macro-Create', 'createInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
17 ('Service-Macro-Delete', 'deleteInstance', 'Service', false,true, '7','7', 'DEFAULT', '*'),
18 ('Network-Create', 'createInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
19 ('Network-Delete', 'deleteInstance', 'Network', true,true, '7','7', 'DEFAULT', '*'),
20 ('VNF-Macro-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
21 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'DEFAULT', '*'),
22 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
23 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'DEFAULT', '*'),
24 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
25 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'DEFAULT', '*'),
26 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
27 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
28 ('VFModule-Replace', 'replaceInstance', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
29 ('VFModule-Replace-Retain-Assignments', 'replaceInstanceRetainAssignments', 'VfModule', true,true, '7','7', 'DEFAULT', '*'),
30 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
31 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
32 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*'),
33 ('VNF-InPlaceUpdate', 'inPlaceSoftwareUpdate', 'Vnf', true, true, '7','7', 'DEFAULT', '*'),
34 ('VNF-Config-Update', 'applyUpdatedConfig', 'Vnf', true, true, '7','7', 'DEFAULT', '*');
37 -- northbound_request_ref_lookup for updateInstance (Macro Flow)
39 INSERT INTO northbound_request_ref_lookup(ID, REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE)
40 VALUES (500, 'Vnf', 'VNF-Macro-Modify', 'updateInstance', 0, 7, 7, 1, 'k8scloudowner4', '*');
43 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
44 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '11', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '12', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '13', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '14', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '15', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '16', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '17', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '18', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '19', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '20', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '21', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
99 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
105 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
106 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
107 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
108 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
109 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
131 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
132 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
133 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
134 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
135 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
136 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
137 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
148 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
150 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
151 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
152 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
153 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
154 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
155 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
156 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
157 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
158 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
173 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
174 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
175 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
176 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
177 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
178 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
179 ('VFModule-Replace-Retain-Assignments', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
180 ('VFModule-Replace-Retain-Assignments', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
181 ('VFModule-Replace-Retain-Assignments', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
182 ('VFModule-Replace-Retain-Assignments', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
183 ('VFModule-Replace-Retain-Assignments', '5', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
184 ('VFModule-Replace-Retain-Assignments', '6', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
185 ('VFModule-Replace-Retain-Assignments', '7', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
186 ('VFModule-Replace-Retain-Assignments', '8', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
187 ('VFModule-Replace-Retain-Assignments', '9', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
188 ('VFModule-Replace-Retain-Assignments', '10', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
189 ('VFModule-Replace-Retain-Assignments', '11', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
190 ('VFModule-Replace-Retain-Assignments', '12', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
191 ('VFModule-Replace-Retain-Assignments', '13', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace-Retain-Assignments' and CLOUD_OWNER = 'DEFAULT')),
192 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
193 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
194 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
195 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
196 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
197 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
198 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
199 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
200 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
201 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
202 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
203 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
204 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
205 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
206 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
207 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
208 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
209 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
210 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
211 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
212 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
213 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
214 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
215 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
216 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
217 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
218 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
221 -- orchestration_flow_reference for updateInstance (Macro Flow)
223 insert into orchestration_flow_reference (id,COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,SCOPE,ACTION)
224 values (901, 'VNF-Macro-Modify',1,'ControllerExecutionBB',1,500,'vnf','config-assign');
225 insert into orchestration_flow_reference (id,COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,SCOPE,ACTION)
226 values (902, 'VNF-Macro-Modify',2,'ControllerExecutionBB',1,500,'vnf','config-deploy');
229 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
230 ('Service-Macro-Create', '10', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT'), 'pnf', 'config-assign');
232 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
234 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
235 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
236 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
237 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
238 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
239 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
240 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
241 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
242 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
243 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
244 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
245 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
246 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
247 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
248 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
249 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
250 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
251 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
252 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
253 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
254 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
255 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
256 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
257 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
258 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
259 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
260 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
261 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
262 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
263 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
264 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
265 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
266 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
267 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
268 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
269 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
270 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
271 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
272 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
275 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
277 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
278 ('AssignVnfBB', 'VNF', 'ASSIGN'),
279 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
280 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
281 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
282 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
284 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
285 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
286 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
287 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
289 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
290 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
291 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
292 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
293 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
294 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
295 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
297 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
298 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
299 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
300 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
301 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
302 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
305 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
306 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
307 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
310 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
311 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
312 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
313 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
315 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
316 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
317 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
318 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
320 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
321 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
323 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
325 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
328 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
329 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
330 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
331 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
332 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
334 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
335 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
336 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
337 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
338 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
340 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
341 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
342 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
343 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
344 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
347 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
348 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
349 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
350 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
352 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
353 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
354 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
355 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
356 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
358 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
359 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
360 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
361 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
362 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
364 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
365 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
366 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
367 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
368 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
370 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
371 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
372 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
373 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
374 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
376 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
377 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
378 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
379 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
380 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
383 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
384 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
385 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
386 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
387 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
389 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
390 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
391 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
392 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
393 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
395 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
396 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
397 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
398 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
399 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
401 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
402 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
403 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
404 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
405 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
407 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
408 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
409 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
410 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
411 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
413 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
414 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
415 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
416 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
417 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
419 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
420 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
421 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
422 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
423 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
425 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
426 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
427 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
428 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
429 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
431 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
432 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
433 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
434 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
435 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
438 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
439 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
440 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
441 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
442 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
444 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
445 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
446 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
447 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
448 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
450 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
451 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
452 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
453 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
454 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
456 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
457 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
458 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
459 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
460 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
462 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
463 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
464 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
465 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
466 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
468 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
469 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
470 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
471 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
472 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
474 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
475 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
476 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
477 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
478 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
480 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
481 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
482 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
483 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
484 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
486 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
487 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
488 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
489 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
490 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
492 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
493 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
494 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
495 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
496 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
498 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
499 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
500 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
501 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
502 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
504 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
505 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
506 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
507 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
508 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
511 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
512 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
513 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
516 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
517 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
518 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
519 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
520 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
522 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
523 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
524 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
525 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
526 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
528 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
529 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
530 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
531 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
532 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
534 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
535 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
536 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
537 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
538 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
540 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
541 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
542 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
543 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
544 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
547 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
548 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
549 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
551 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
552 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
553 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
555 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
556 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
557 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
559 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
560 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
561 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
563 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
564 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
565 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
567 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
568 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
569 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
571 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
572 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
573 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
575 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
576 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
577 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
579 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
580 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
581 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
584 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
585 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
586 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
588 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
589 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
590 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
592 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
593 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
594 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
596 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
597 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
598 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
600 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
601 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
602 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
604 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
605 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
606 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
608 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
609 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
610 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
612 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
613 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
614 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
616 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
617 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
618 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
621 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
622 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
623 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
625 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
626 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
627 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
629 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
630 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
631 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
633 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
634 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
635 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
637 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
638 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
639 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
641 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
642 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
643 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
645 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
646 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
647 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
649 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
650 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
651 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
653 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
654 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
655 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
657 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
658 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
659 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
661 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
662 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
664 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
665 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
667 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
669 UPDATE orchestration_flow_reference
670 SET FLOW_NAME = 'ActivateServiceInstanceBB'
671 WHERE FLOW_NAME = 'ActivateServiceInstance';
673 DELETE FROM orchestration_flow_reference
674 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
676 UPDATE orchestration_flow_reference
677 SET SEQ_NO = SEQ_NO - 1
678 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
680 UPDATE orchestration_flow_reference
681 SET SEQ_NO = SEQ_NO - 1
682 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
684 UPDATE building_block_detail
685 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
686 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
688 UPDATE building_block_detail
689 SET TARGET_ACTION = 'CHANGE_MODEL'
690 WHERE TARGET_ACTION = 'CHANGEMODEL';
692 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
694 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
695 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
696 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
697 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
698 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
699 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
700 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
701 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
702 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
703 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
705 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
707 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
708 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
709 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
710 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
711 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
712 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
713 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
714 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
715 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
717 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
718 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
720 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
721 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
722 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
724 INSERT INTO northbound_request_ref_lookup (REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE)
725 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
727 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
728 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
731 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
732 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
733 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
735 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
737 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
738 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
739 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
740 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
742 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
743 ('UpdateNetworkBB','NETWORK','UPDATE');
745 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
746 ('NETWORK','PRECREATED','UPDATE','FAIL'),
747 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
748 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
749 ('NETWORK','CREATED','UPDATE','FAIL'),
750 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
751 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
752 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
753 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
755 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
756 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
757 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
758 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
759 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
761 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
762 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
763 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
764 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
765 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
766 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
767 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
768 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
772 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
773 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
774 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
775 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
776 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
777 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
778 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
779 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
780 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
782 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
783 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
784 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
785 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
786 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
787 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
788 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
789 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
790 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
792 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
794 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
796 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
797 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
798 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
799 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
800 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
801 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
802 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
803 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
804 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
806 UPDATE orchestration_flow_reference
807 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
810 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
812 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
813 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
814 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
815 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
816 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
817 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
818 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
819 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
820 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
822 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
823 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
824 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
825 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
826 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
827 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
828 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
829 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
830 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
832 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
833 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
834 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
835 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
836 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
837 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
838 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
839 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
840 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
841 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
843 UPDATE orchestration_flow_reference
844 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
846 UPDATE orchestration_flow_reference
847 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
851 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
852 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
853 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
854 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
855 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
856 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
857 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
858 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
859 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
860 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
861 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
862 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
863 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
864 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
865 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
866 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
867 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
872 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
874 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
875 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
877 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
879 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
880 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
881 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
882 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
884 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
885 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
886 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
887 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
888 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
889 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
890 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
891 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
892 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
893 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
894 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
895 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
896 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
897 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
898 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
899 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
900 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
901 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
902 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
903 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
905 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
907 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
909 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
910 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
911 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
913 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
915 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
917 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
919 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
922 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
923 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
926 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
927 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
929 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY, SECONDARY_POLICY, REG_EX_ERROR_MESSAGE, SERVICE_ROLE)
931 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
932 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
933 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
934 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
935 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
936 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
937 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
938 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
939 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
940 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
941 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
942 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
943 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
944 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
945 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
946 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
947 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
948 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
949 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
950 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
951 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
953 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
954 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
955 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
956 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
958 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
959 ('VFModule-Delete', '1', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck"),
960 ('VFModule-Delete', '2', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vfmodule", "ScaleInReconfiguration"),
961 ('VFModule-Delete', '6', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck");