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', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '10', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '11', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '12', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '13', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '14', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Service-Macro-Delete', '15', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
98 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
100 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
103 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
129 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
130 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
134 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
136 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
137 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
140 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
147 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
148 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
152 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
153 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
154 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
155 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
156 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
157 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
158 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
172 ('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')),
173 ('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')),
174 ('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')),
175 ('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')),
176 ('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')),
177 ('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')),
178 ('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')),
179 ('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')),
180 ('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')),
181 ('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')),
182 ('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')),
183 ('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')),
184 ('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')),
185 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
186 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
187 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
188 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
189 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
190 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
191 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
192 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
193 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
194 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
195 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
196 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
197 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
198 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
199 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
200 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
201 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
202 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
203 ('VNF-Config-Update', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
204 ('VNF-Config-Update', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
205 ('VNF-Config-Update', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
206 ('VNF-Config-Update', '4', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
207 ('VNF-Config-Update', '5', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
208 ('VNF-Config-Update', '6', 'VNFConfigModifyActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
209 ('VNF-Config-Update', '7', 'VNFHealthCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
210 ('VNF-Config-Update', '8', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT')),
211 ('VNF-Config-Update', '9', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Config-Update' and CLOUD_OWNER = 'DEFAULT'));
213 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
215 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
216 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
217 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
218 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
219 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
220 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
221 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
222 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
223 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
224 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
225 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
226 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
227 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
228 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
229 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
230 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
231 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
232 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
233 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
234 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
235 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
236 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
237 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
238 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
239 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
240 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
241 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
242 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
243 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
244 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
245 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
246 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
247 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
248 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
249 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
250 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
251 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
252 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
253 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
256 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
258 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
259 ('AssignVnfBB', 'VNF', 'ASSIGN'),
260 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
261 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
262 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
263 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
265 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
266 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
267 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
268 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
270 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
271 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
272 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
273 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
274 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
275 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
276 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
278 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
279 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
280 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
281 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
282 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
285 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
286 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
287 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
290 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
291 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
292 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
293 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
295 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
296 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
297 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
298 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
300 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
301 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
303 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
305 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
308 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
309 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
310 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
311 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
312 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
314 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
315 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
316 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
317 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
318 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
320 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
321 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
322 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
323 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
324 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
326 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
327 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
328 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
329 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
330 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
332 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
333 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
334 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
335 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
336 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
338 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
339 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
340 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
341 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
342 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
344 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
345 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
347 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
348 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
350 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
351 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
352 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
353 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
354 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
356 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
357 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
358 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
359 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
360 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
363 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
364 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
365 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
366 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
367 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
369 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
370 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
371 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
372 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
373 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
375 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
376 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
377 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
378 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
379 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
381 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
382 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
383 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
384 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
385 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
387 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
388 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
389 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
390 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
391 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
393 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
394 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
395 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
396 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
397 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
399 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
400 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
401 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
402 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
403 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
405 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
406 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
407 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
408 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
409 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
411 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
412 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
413 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
414 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
415 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
418 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
419 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
420 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
421 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
422 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
424 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
425 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
426 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
427 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
428 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
430 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
431 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
432 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
433 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
434 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
436 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
437 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
438 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
439 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
440 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
442 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
443 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
444 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
445 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
446 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
448 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
449 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
450 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
451 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
452 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
454 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
455 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
456 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
457 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
458 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
460 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
461 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
462 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
463 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
464 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
466 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
467 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
468 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
469 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
470 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
472 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
473 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
474 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
475 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
476 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
478 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
479 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
480 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
481 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
482 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
484 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
485 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
486 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
487 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
488 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
490 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
491 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
492 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
493 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
494 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
496 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
497 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
498 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
499 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
500 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
502 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
503 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
504 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
505 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
506 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
508 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
509 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
511 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
512 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
514 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
515 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
516 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
517 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
518 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
520 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
521 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
522 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
523 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
524 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
527 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
528 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
529 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
531 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
532 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
533 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
535 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
536 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
537 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
539 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
540 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
541 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
543 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
544 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
545 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
547 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
548 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
549 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
551 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
552 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
553 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
555 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
556 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
557 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
559 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
560 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
561 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
564 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
565 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
566 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
568 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
569 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
570 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
572 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
573 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
574 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
576 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
577 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
578 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
580 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
581 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
582 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
584 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
585 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
586 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
588 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
589 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
590 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
592 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
593 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
594 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
596 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
597 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
598 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
601 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
602 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
603 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
605 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
606 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
607 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
609 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
610 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
611 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
613 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
614 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
615 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
617 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
618 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
619 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
621 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
622 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
623 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
625 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
626 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
627 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
629 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
630 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
631 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
633 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
634 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
635 ('NETWORK', 'PENDING', 'DELETE', 'FAIL'),
637 ('VNF', 'CONFIGURED', 'ACTIVATE', 'CONTINUE'),
638 ('VNF', 'CONFIGURED', 'UNASSIGN', 'CONTINUE'),
639 ('VNF', 'CONFIGURED', 'DESACTIVATE', 'SILENT_SUCCESS'),
641 ('VNF', 'CONFIGURE', 'UNASSIGN', 'CONTINUE'),
642 ('VNF', 'CONFIGURE', 'DESACTIVATE', 'SILENT_SUCCESS'),
644 ('VNF', 'CONFIGASSIGNED', 'UNASSIGN', 'CONTINUE'),
645 ('VNF', 'CONFIGASSIGNED', 'DESACTIVATE', 'SILENT_SUCCESS');
647 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
649 UPDATE orchestration_flow_reference
650 SET FLOW_NAME = 'ActivateServiceInstanceBB'
651 WHERE FLOW_NAME = 'ActivateServiceInstance';
653 DELETE FROM orchestration_flow_reference
654 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
656 UPDATE orchestration_flow_reference
657 SET SEQ_NO = SEQ_NO - 1
658 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
660 UPDATE orchestration_flow_reference
661 SET SEQ_NO = SEQ_NO - 1
662 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
664 UPDATE building_block_detail
665 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
666 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
668 UPDATE building_block_detail
669 SET TARGET_ACTION = 'CHANGE_MODEL'
670 WHERE TARGET_ACTION = 'CHANGEMODEL';
672 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
674 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
675 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
676 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
677 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
678 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
679 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
680 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
681 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
682 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
683 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
685 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
687 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
688 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
689 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
690 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
691 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
692 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
693 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
694 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
695 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
697 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
698 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
700 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
701 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
702 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
704 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)
705 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
707 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
708 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
711 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
712 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
713 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
715 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
717 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
718 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
719 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
720 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
722 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
723 ('UpdateNetworkBB','NETWORK','UPDATE');
725 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
726 ('NETWORK','PRECREATED','UPDATE','FAIL'),
727 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
728 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
729 ('NETWORK','CREATED','UPDATE','FAIL'),
730 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
731 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
732 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
733 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
735 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
736 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
737 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
738 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
739 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
741 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
742 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
743 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
744 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
745 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
746 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
747 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
748 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
749 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
750 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
752 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
753 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
754 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
755 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
756 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
757 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
758 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
759 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
760 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
762 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
763 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
764 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
765 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
766 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
767 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
768 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
769 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
770 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
772 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
774 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
776 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
777 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
778 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
779 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
780 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
781 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
782 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
783 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
784 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
786 UPDATE orchestration_flow_reference
787 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
790 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
792 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
793 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
794 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
795 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
796 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
797 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
798 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
799 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
800 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
802 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
803 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
804 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
805 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
806 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
807 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
808 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
809 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
810 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
812 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
813 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
814 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
815 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
816 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
817 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
818 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
819 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
820 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL'),
821 ('VNF','CONFIGDEPLOYED','ACTIVATE','CONTINUE');
823 UPDATE orchestration_flow_reference
824 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
826 UPDATE orchestration_flow_reference
827 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
831 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
832 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
833 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
834 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
835 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
836 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
837 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
838 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
839 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
840 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
841 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
842 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
843 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
844 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
845 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
846 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
847 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
852 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
854 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
855 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
857 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
859 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
860 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
861 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
862 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
863 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
864 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
865 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
866 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
867 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
868 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
869 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
870 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
871 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
872 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
873 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
874 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
875 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
876 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
877 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
878 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
879 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
880 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
881 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
882 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM'),
883 ('VNFConfigModifyActivity', 'NO_VALIDATE', 'CUSTOM');
885 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
887 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
889 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
890 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM'),
891 ('ControllerExecutionBB', 'NO_VALIDATE', 'CUSTOM');
893 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
895 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
897 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
899 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
902 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
903 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
906 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
907 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'applyUpdatedConfig';
909 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)
911 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
912 ('VNFCheckInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
913 ('VNFSetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
914 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
915 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
916 ('VNFLockActivity','*','*','*','*','Manual','Abort','*', '*'),
917 ('VNFUpgradePreCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
918 ('VNFQuiesceTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
919 ('VNFStopActivity','*','*','*','*','Manual','Abort','*', '*'),
920 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
921 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
922 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
923 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
924 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
925 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
926 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
927 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
928 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
929 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');