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', '12', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '13', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '14', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '15', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '16', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Create', '17', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Create', '18', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Create', '19', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Create', '20', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Create', '21', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Create', '22', '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');
231 -- change to test the pnf regitsration works with the gating...
232 --INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
233 --('Service-Macro-Create', '11', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = --'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT'), 'pnf', 'config-deploy');
235 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
237 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
238 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
239 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
240 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
241 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
242 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
243 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
244 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
245 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
246 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
247 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
248 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
249 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
250 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
251 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
252 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
253 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
254 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
255 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
256 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
257 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
258 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
259 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
260 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
261 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
262 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
263 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
264 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
265 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
266 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
267 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
268 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
269 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
270 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
271 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
272 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
273 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
274 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
275 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
278 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
280 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
281 ('AssignVnfBB', 'VNF', 'ASSIGN'),
282 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
283 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
284 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
285 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
287 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
288 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
289 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
290 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
292 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
293 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
294 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
295 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
296 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
297 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
298 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
300 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
301 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
302 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
303 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
304 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
305 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
308 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
309 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
310 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
313 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
314 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
315 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
316 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
318 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
319 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
320 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
321 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
323 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
324 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
326 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
328 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
331 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
332 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
333 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
334 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
335 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
337 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
338 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
339 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
340 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
341 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
343 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
344 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
345 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
347 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
349 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
350 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
351 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
352 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
353 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
355 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
356 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
357 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
358 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
359 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
361 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
362 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
363 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
364 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
365 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
367 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
368 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
369 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
370 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
371 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
373 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
374 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
375 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
376 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
377 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
379 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
380 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
381 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
382 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
383 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
386 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
387 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
388 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
389 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
390 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
392 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
393 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
394 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
395 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
396 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
398 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
399 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
400 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
401 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
402 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
404 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
405 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
406 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
407 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
408 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
410 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
411 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
412 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
413 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
414 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
416 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
417 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
418 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
419 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
420 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
422 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
423 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
424 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
425 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
426 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
428 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
429 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
430 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
431 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
432 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
434 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
435 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
436 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
437 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
438 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
441 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
442 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
443 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
444 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
445 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
447 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
448 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
449 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
450 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
451 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
453 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
454 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
455 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
456 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
457 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
459 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
460 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
461 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
462 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
463 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
465 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
466 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
467 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
468 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
469 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
471 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
472 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
473 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
474 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
475 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
477 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
478 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
479 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
480 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
481 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
483 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
484 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
485 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
486 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
487 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
489 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
490 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
491 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
492 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
493 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
495 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
496 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
497 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
498 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
499 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
501 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
502 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
503 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
504 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
505 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
507 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
508 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
509 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
511 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
513 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
515 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
516 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
517 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
519 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
520 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
521 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
522 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
523 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
525 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
526 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
527 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
528 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
529 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
531 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
532 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
533 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
534 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
535 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
537 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
538 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
539 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
540 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
541 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
543 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
544 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
545 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
546 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
547 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
550 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
551 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
552 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
554 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
555 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
556 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
558 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
559 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
560 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
562 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
563 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
564 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
566 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
567 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
568 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
570 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
571 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
572 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
574 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
575 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
576 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
578 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
579 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
580 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
582 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
583 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
584 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
587 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
588 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
589 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
591 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
592 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
593 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
595 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
596 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
597 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
599 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
600 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
601 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
603 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
604 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
605 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
607 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
608 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
609 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
611 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
612 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
613 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
615 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
616 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
617 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
619 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
620 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
621 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
624 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
625 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
626 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
628 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
629 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
630 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
632 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
633 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
634 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
636 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
637 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
638 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
640 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
641 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
642 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
644 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
645 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
646 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
648 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
649 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
650 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
652 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
653 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
654 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
656 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
657 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
658 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
660 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
661 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
662 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
664 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
665 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
667 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
668 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
670 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
672 UPDATE orchestration_flow_reference
673 SET FLOW_NAME = 'ActivateServiceInstanceBB'
674 WHERE FLOW_NAME = 'ActivateServiceInstance';
676 DELETE FROM orchestration_flow_reference
677 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
679 UPDATE orchestration_flow_reference
680 SET SEQ_NO = SEQ_NO - 1
681 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
683 UPDATE orchestration_flow_reference
684 SET SEQ_NO = SEQ_NO - 1
685 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
687 UPDATE building_block_detail
688 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
689 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
691 UPDATE building_block_detail
692 SET TARGET_ACTION = 'CHANGE_MODEL'
693 WHERE TARGET_ACTION = 'CHANGEMODEL';
695 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
697 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
698 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
699 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
700 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
701 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
702 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
703 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
704 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
705 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
706 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
708 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
710 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
711 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
712 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
713 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
714 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
715 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
716 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
717 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
718 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
720 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
721 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
723 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
724 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
725 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
727 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)
728 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
730 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
731 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
734 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
735 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
736 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
738 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
740 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
741 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
742 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
743 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
745 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
746 ('UpdateNetworkBB','NETWORK','UPDATE');
748 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
749 ('NETWORK','PRECREATED','UPDATE','FAIL'),
750 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
751 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
752 ('NETWORK','CREATED','UPDATE','FAIL'),
753 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
754 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
755 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
756 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
758 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
759 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
760 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
761 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
762 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
764 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
765 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
766 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
767 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
768 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
771 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
772 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
773 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
775 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
776 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
777 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
778 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
779 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
780 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
781 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
782 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
783 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
785 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
786 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
787 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
788 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
789 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
790 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
791 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
792 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
793 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
795 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
797 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
799 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
800 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
801 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
802 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
803 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
804 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
805 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
806 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
807 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
809 UPDATE orchestration_flow_reference
810 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
813 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
815 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
816 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
817 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
818 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
819 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
820 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
821 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
822 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
823 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
825 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
826 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
827 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
828 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
829 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
830 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
831 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
832 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
833 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
835 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
836 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
837 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
838 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
839 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
840 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
841 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
842 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
843 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
844 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
846 UPDATE orchestration_flow_reference
847 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
849 UPDATE orchestration_flow_reference
850 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
854 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
855 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
856 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
857 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
858 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
859 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
860 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
861 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
862 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
863 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
864 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
865 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
866 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
867 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
868 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
869 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
870 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
875 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
877 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
878 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
880 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
882 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
884 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
885 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
886 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
887 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
888 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
889 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
890 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
891 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
892 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
893 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
894 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
895 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
896 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
897 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
898 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
899 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
900 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
901 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
902 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
903 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
904 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
905 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
906 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
908 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
910 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
912 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
913 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
914 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
916 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
918 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
920 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
922 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
925 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
926 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
929 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
930 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
932 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)
934 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
935 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
936 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
937 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
938 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
939 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
940 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
941 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
942 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
943 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
944 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
945 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
946 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
947 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
948 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
949 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
950 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
951 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
952 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
953 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
954 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
956 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
957 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
958 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
959 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';