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 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) VALUES
232 ('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');
234 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
236 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
237 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
238 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
239 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
240 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
241 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
242 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
243 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
244 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
245 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
246 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
247 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
248 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
249 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
250 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
251 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
252 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
253 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
254 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
255 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
256 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
257 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
258 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
259 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
260 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
261 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
262 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
263 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
264 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
265 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
266 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
267 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
268 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
269 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
270 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
271 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
272 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
273 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
274 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
277 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
279 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
280 ('AssignVnfBB', 'VNF', 'ASSIGN'),
281 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
282 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
283 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
284 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
286 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
287 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
288 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
289 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
291 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
292 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
293 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
294 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
295 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
296 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
297 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
299 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
300 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
301 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
302 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
303 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
304 ('DeactivatePnfBB', 'NO_VALIDATE', 'DEACTIVATE'),
307 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
308 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
309 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
312 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
313 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
314 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
315 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
317 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
318 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
319 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
320 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
322 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
323 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
325 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
327 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
330 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
331 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
332 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
333 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
334 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
336 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
337 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
338 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
339 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
340 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
342 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
343 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
344 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
345 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
348 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
349 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
350 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
351 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
352 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
354 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
355 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
356 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
357 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
358 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
360 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
361 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
362 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
363 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
364 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
366 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
367 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
368 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
369 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
370 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
372 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
373 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
374 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
375 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
376 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
378 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
379 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
380 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
381 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
382 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
385 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
386 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
387 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
388 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
389 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
391 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
392 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
393 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
394 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
395 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
397 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
398 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
399 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
400 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
401 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
403 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
404 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
405 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
406 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
407 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
409 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
410 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
411 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
412 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
413 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
415 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
416 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
417 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
418 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
419 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
421 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
422 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
423 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
424 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
425 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
427 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
428 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
429 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
430 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
431 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
433 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
434 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
435 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
436 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
437 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
440 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
441 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
442 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
443 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
444 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
446 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
447 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
448 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
449 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
450 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
452 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
453 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
454 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
455 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
456 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
458 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
459 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
460 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
461 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
462 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
464 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
465 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
466 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
467 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
468 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
470 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
471 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
472 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
473 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
474 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
476 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
477 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
478 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
479 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
480 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
482 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
483 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
484 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
485 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
486 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
488 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
489 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
490 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
491 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
492 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
494 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
495 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
496 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
497 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
498 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
500 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
501 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
502 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
503 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
504 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
506 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
507 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
508 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
509 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
512 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
513 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
515 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
516 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
518 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
519 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
520 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
521 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
522 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
524 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
525 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
526 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
527 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
528 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
530 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
531 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
532 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
533 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
534 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
536 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
537 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
538 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
539 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
540 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
542 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
543 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
544 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
545 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
546 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
549 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
550 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
551 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
553 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
554 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
555 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
557 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
558 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
559 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
561 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
562 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
563 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
565 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
566 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
567 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
569 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
570 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
571 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
573 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
574 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
575 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
577 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
578 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
579 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
581 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
582 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
583 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
586 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
587 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
588 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
590 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
591 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
592 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
594 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
595 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
596 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
598 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
599 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
600 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
602 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
603 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
604 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
606 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
607 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
608 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
610 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
611 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
612 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
614 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
615 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
616 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
618 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
619 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
620 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
623 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
624 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
625 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
627 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
628 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
629 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
631 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
632 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
633 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
635 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
636 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
637 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
639 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
640 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
641 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
643 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
644 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
645 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
647 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
648 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
649 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
651 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
652 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
653 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
655 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
656 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
657 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
659 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
660 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
661 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
663 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
664 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
666 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
667 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
669 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
671 UPDATE orchestration_flow_reference
672 SET FLOW_NAME = 'ActivateServiceInstanceBB'
673 WHERE FLOW_NAME = 'ActivateServiceInstance';
675 DELETE FROM orchestration_flow_reference
676 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
678 UPDATE orchestration_flow_reference
679 SET SEQ_NO = SEQ_NO - 1
680 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
682 UPDATE orchestration_flow_reference
683 SET SEQ_NO = SEQ_NO - 1
684 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
686 UPDATE building_block_detail
687 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
688 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
690 UPDATE building_block_detail
691 SET TARGET_ACTION = 'CHANGE_MODEL'
692 WHERE TARGET_ACTION = 'CHANGEMODEL';
694 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
696 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
697 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
698 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
699 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
700 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
701 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
702 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
703 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
704 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
705 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
707 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
709 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
710 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
711 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
712 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
713 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
714 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
715 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
716 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
717 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
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 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
722 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
723 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
724 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
726 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)
727 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
729 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
730 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
733 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
734 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
735 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
737 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
739 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
740 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
741 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
742 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
744 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
745 ('UpdateNetworkBB','NETWORK','UPDATE');
747 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
748 ('NETWORK','PRECREATED','UPDATE','FAIL'),
749 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
750 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
751 ('NETWORK','CREATED','UPDATE','FAIL'),
752 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
753 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
754 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
755 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
757 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
758 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
759 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
760 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
761 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
763 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
764 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
765 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
766 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
767 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
768 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
771 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
772 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
774 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
775 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
776 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
777 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
778 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
779 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
780 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
781 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
782 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
784 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
785 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
786 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
787 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
788 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
789 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
790 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
791 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
792 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
794 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
796 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
798 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
799 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
800 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
801 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
802 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
803 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
804 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
805 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
806 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
808 UPDATE orchestration_flow_reference
809 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
812 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
814 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
815 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
816 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
817 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
818 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
819 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
820 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
821 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
822 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
824 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
825 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
826 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
827 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
828 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
829 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
830 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
831 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
832 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
834 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
835 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
836 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
837 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
838 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
839 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
840 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
841 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
842 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
843 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
845 UPDATE orchestration_flow_reference
846 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
848 UPDATE orchestration_flow_reference
849 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
853 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
854 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
855 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
856 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
857 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
858 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
859 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
860 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
861 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
862 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
863 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
864 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
865 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
866 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
867 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
868 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
869 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
874 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
876 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
877 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
879 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
881 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
882 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
884 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
885 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
886 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
887 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
888 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
889 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
890 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
891 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
892 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
893 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
894 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
895 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
896 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
897 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
898 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
899 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
900 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
901 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
902 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
903 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
904 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
905 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
907 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
909 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
911 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
912 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
913 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
915 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
917 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
919 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
921 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
924 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
925 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
928 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
929 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
931 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)
933 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
934 ('VNFCheckInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
935 ('VNFSetInMaintFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
936 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
937 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Rollback','Abort','*', '*'),
938 ('VNFLockActivity','*','*','*','*','Rollback','Abort','*', '*'),
939 ('VNFUpgradePreCheckActivity','*','*','*','*','Rollback','Abort','*', '*'),
940 ('VNFQuiesceTrafficActivity','*','*','*','*','Rollback','Abort','*', '*'),
941 ('VNFStopActivity','*','*','*','*','Rollback','Abort','*', '*'),
942 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
943 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
944 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
945 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
946 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
947 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
948 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
949 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
950 ('VNFHealthCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
951 ('VNFConfigModifyActivity','*','*','*','*','Manual','Abort','*', '*'),
952 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
953 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');