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 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
38 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
39 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
40 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
41 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
42 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
43 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
44 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '10', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '11', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '12', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '13', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '14', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '15', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '16', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '17', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '18', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '19', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Create', '20', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Delete', '6', 'DeactivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '7', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '8', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '9', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '10', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '11', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '12', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '13', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '14', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '15', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Service-Macro-Delete', '16', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
100 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
101 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
130 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
131 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
136 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
137 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
147 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
148 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
152 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
153 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
154 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
155 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
156 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
157 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
158 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
173 ('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')),
174 ('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')),
175 ('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')),
176 ('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')),
177 ('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')),
178 ('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')),
179 ('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')),
180 ('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')),
181 ('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')),
182 ('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')),
183 ('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')),
184 ('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')),
185 ('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')),
186 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
187 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
188 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
189 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
190 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
191 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
192 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
193 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
194 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
195 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
196 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
197 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
198 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
199 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
200 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
201 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
202 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
203 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
204 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
205 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
206 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
207 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
208 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
209 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
210 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
211 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
212 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
214 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
216 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
217 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
218 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
219 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
220 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
221 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
222 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
223 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
224 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
225 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
226 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
227 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
228 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
229 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
230 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
231 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
232 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
233 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
234 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
235 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
236 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
237 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
238 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
239 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
240 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
241 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
242 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
243 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
244 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
245 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
246 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
247 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
248 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
249 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
250 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
251 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
252 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
253 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
254 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
257 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
259 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
260 ('AssignVnfBB', 'VNF', 'ASSIGN'),
261 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
262 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
263 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
264 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
266 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
267 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
268 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
269 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
271 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
272 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
273 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
274 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
275 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
276 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
277 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
279 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
280 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
281 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
282 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
283 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
284 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
287 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
288 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
289 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
292 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
293 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
294 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
295 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
297 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
298 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
299 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
300 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
302 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
303 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
305 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
307 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
310 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
311 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
312 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
313 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
314 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
316 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
317 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
318 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
319 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
320 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
322 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
323 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
324 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
325 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
326 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
328 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
329 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
330 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
331 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
332 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
334 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
335 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
336 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
337 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
338 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
340 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
341 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
342 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
343 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
344 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
347 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
348 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
349 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
350 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
352 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
353 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
354 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
355 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
356 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
358 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
359 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
360 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
361 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
362 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
365 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
366 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
367 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
368 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
369 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
371 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
372 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
373 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
374 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
375 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
377 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
378 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
379 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
380 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
381 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
383 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
384 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
385 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
386 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
387 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
389 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
390 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
391 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
392 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
393 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
395 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
396 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
397 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
398 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
399 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
401 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
402 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
403 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
404 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
405 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
407 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
408 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
409 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
410 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
411 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
413 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
414 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
415 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
416 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
417 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
420 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
421 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
422 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
423 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
424 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
426 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
427 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
428 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
429 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
430 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
432 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
433 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
434 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
435 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
436 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
438 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
439 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
440 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
441 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
442 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
444 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
445 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
446 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
447 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
448 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
450 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
451 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
452 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
453 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
454 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
456 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
457 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
458 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
459 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
460 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
462 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
463 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
464 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
465 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
466 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
468 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
469 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
470 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
471 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
472 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
474 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
475 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
476 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
477 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
478 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
480 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
481 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
482 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
483 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
484 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
486 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
487 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
488 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
489 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
490 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
492 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
493 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
494 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
495 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
496 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
498 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
499 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
500 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
501 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
502 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
504 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
505 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
506 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
507 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
508 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
511 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
512 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
513 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
516 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
517 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
518 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
519 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
520 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
522 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
523 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
524 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
525 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
526 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
529 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
530 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
531 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
533 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
534 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
535 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
537 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
538 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
539 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
541 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
542 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
543 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
545 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
546 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
547 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
549 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
550 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
551 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
553 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
554 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
555 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
557 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
558 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
559 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
561 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
562 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
563 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
566 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
567 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
568 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
570 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
571 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
572 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
574 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
575 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
576 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
578 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
579 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
580 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
582 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
583 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
584 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
586 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
587 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
588 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
590 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
591 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
592 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
594 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
595 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
596 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
598 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
599 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
600 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
603 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
604 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
605 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
607 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
608 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
609 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
611 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
612 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
613 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
615 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
616 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
617 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
619 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
620 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
621 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
623 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
624 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
625 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
627 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
628 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
629 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
631 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
632 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
633 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
635 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
636 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
637 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
639 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
640 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
641 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
643 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
644 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
646 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
647 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
649 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
651 UPDATE orchestration_flow_reference
652 SET FLOW_NAME = 'ActivateServiceInstanceBB'
653 WHERE FLOW_NAME = 'ActivateServiceInstance';
655 DELETE FROM orchestration_flow_reference
656 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
658 UPDATE orchestration_flow_reference
659 SET SEQ_NO = SEQ_NO - 1
660 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
662 UPDATE orchestration_flow_reference
663 SET SEQ_NO = SEQ_NO - 1
664 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
666 UPDATE building_block_detail
667 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
668 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
670 UPDATE building_block_detail
671 SET TARGET_ACTION = 'CHANGE_MODEL'
672 WHERE TARGET_ACTION = 'CHANGEMODEL';
674 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
676 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
677 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
678 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
679 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
680 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
681 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
682 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
683 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
684 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
685 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
687 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
689 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
690 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
691 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
692 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
693 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
694 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
695 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
696 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
697 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
699 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
700 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
702 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
703 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
704 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
706 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)
707 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
709 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
710 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
713 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
714 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
715 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
717 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
719 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
720 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
721 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
722 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
724 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
725 ('UpdateNetworkBB','NETWORK','UPDATE');
727 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
728 ('NETWORK','PRECREATED','UPDATE','FAIL'),
729 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
730 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
731 ('NETWORK','CREATED','UPDATE','FAIL'),
732 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
733 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
734 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
735 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
737 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
738 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
739 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
740 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
741 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
743 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
744 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
745 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
746 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
747 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
748 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
749 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
750 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
751 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
752 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
754 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
755 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
756 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
757 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
758 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
759 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
760 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
761 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
762 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
764 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
765 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
766 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
767 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
768 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
771 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
772 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
774 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
776 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
778 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
779 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
780 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
781 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
782 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
783 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
784 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
785 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
786 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
788 UPDATE orchestration_flow_reference
789 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
792 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
794 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
795 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
796 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
797 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
798 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
799 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
800 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
801 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
802 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
804 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
805 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
806 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
807 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
808 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
809 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
810 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
811 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
812 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
814 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
815 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
816 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
817 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
818 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
819 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
820 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
821 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
822 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
823 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
825 UPDATE orchestration_flow_reference
826 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
828 UPDATE orchestration_flow_reference
829 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
833 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
834 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
835 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
836 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
837 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
838 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
839 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
840 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
841 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
842 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
843 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
844 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
845 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
846 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
847 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
848 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
849 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
854 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
856 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
857 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
859 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
861 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
862 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
863 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
864 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
865 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
866 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
867 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
868 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
869 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
870 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
871 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
872 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
873 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
874 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
875 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
876 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
877 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
878 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
879 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
880 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
881 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
882 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
884 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
885 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
887 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
889 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
891 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
892 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
893 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
895 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
897 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
899 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
901 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
904 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
905 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
908 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
909 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
911 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)
913 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
914 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
915 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
916 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
917 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
918 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
919 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
920 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
921 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
922 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
923 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
924 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
925 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
926 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
927 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
928 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
929 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
930 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
931 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
932 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
933 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');
935 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-assign' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigAssignVnfBB';
936 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='config-deploy' WHERE COMPOSITE_ACTION = 'Service-Macro-Create' and FLOW_NAME = 'ConfigDeployVnfBB';
937 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vnf', ACTION='HealthCheck' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
938 UPDATE orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', SCOPE='vfmodule', ACTION='ScaleOutReconfiguration' WHERE COMPOSITE_ACTION = 'VFModule-ScaleOut' and FLOW_NAME = 'GenericVnfHealthCheckBB';
940 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
941 ('VFModule-Delete', '1', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck"),
942 ('VFModule-Delete', '2', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vfmodule", "ScaleInReconfiguration"),
943 ('VFModule-Delete', '6', 'ControllerExecutionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT'), "vnf", "HealthCheck");