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', '*');
36 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
37 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
38 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
39 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
40 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
41 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
42 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
43 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
44 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '8', 'AssignPnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '9', 'WaitForPnfReadyBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '10', 'ActivatePnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '11', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '12', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '13', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '14', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '15', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '16', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Create', '17', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Create', '18', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Create', '19', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Create', '20', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '10', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '11', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Service-Macro-Delete', '12', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
93 ('Service-Macro-Delete', '13', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Service-Macro-Delete', '14', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Service-Macro-Delete', '15', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
97 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
98 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
103 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
126 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
127 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
128 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
129 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
130 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
133 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
134 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
136 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
137 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
139 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
140 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
142 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
145 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
146 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
148 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
149 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
150 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
151 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
152 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
153 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
154 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
155 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
156 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
157 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
158 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
168 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
169 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
170 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
171 ('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')),
172 ('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')),
173 ('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')),
174 ('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')),
175 ('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')),
176 ('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')),
177 ('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')),
178 ('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')),
179 ('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')),
180 ('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')),
181 ('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')),
182 ('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')),
183 ('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')),
184 ('VNF-InPlaceUpdate', '1', 'VNFCheckPserversLockedFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
185 ('VNF-InPlaceUpdate', '2', 'VNFCheckInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
186 ('VNF-InPlaceUpdate', '3', 'VNFSetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
187 ('VNF-InPlaceUpdate', '4', 'VNFCheckClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
188 ('VNF-InPlaceUpdate', '5', 'VNFSetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
189 ('VNF-InPlaceUpdate', '6', 'VNFLockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
190 ('VNF-InPlaceUpdate', '7', 'VNFUpgradePreCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
191 ('VNF-InPlaceUpdate', '8', 'VNFQuiesceTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
192 ('VNF-InPlaceUpdate', '9', 'VNFStopActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
193 ('VNF-InPlaceUpdate', '10', 'VNFSnapShotActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
194 ('VNF-InPlaceUpdate', '11', 'VNFStartActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
195 ('VNF-InPlaceUpdate', '12', 'VNFUpgradeBackupActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
196 ('VNF-InPlaceUpdate', '13', 'VNFUpgradeSoftwareActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
197 ('VNF-InPlaceUpdate', '14', 'VNFUpgradePostCheckActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
198 ('VNF-InPlaceUpdate', '15', 'VNFResumeTrafficActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
199 ('VNF-InPlaceUpdate', '16', 'VNFUnlockActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
200 ('VNF-InPlaceUpdate', '17', 'VNFUnsetInMaintFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT')),
201 ('VNF-InPlaceUpdate', '18', 'VNFUnsetClosedLoopDisabledFlagActivity', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-InPlaceUpdate' and CLOUD_OWNER = 'DEFAULT'));
205 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
207 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
208 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
209 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
210 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
211 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
212 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
213 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
214 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
215 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
216 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
217 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
218 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
219 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
220 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
221 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
222 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
223 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
224 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
225 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
226 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
227 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
228 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
229 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
230 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
231 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
232 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
233 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
234 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
235 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
236 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
237 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
238 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
239 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
240 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
241 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
242 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
243 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
244 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
245 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
248 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
250 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
251 ('AssignVnfBB', 'VNF', 'ASSIGN'),
252 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
253 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
254 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
255 ('AssignPnfBB', 'NO_VALIDATE', 'ASSIGN'),
257 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
258 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
259 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
260 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
262 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
263 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
264 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
265 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
266 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
267 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
268 ('ActivatePnfBB', 'NO_VALIDATE', 'ACTIVATE'),
270 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
271 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
272 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
273 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
274 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
277 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
278 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
279 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
282 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
283 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
284 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
285 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
287 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
288 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
289 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
290 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
292 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
293 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
295 ('WaitForPnfReadyBB', 'NO_VALIDATE', 'CUSTOM');
297 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
300 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
301 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
302 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
303 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
304 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
306 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
307 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
308 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
309 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
310 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
312 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
313 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
314 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
315 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
316 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
318 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
319 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
320 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
321 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
322 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
324 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
325 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
326 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
327 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
328 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
330 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
331 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
332 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
333 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
334 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
336 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
337 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
338 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
339 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
340 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
342 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
343 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
344 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
345 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
346 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
348 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
349 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
350 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
351 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
352 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
355 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
356 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
357 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
358 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
359 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
361 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
362 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
363 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
364 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
365 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
367 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
368 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
369 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
370 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
371 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
373 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
374 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
375 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
376 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
377 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
379 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
380 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
381 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
382 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
383 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
385 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
386 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
387 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
388 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
389 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
391 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
392 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
393 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
394 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
395 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
397 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
398 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
399 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
400 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
401 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
403 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
404 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
405 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
406 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
407 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
410 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
411 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
412 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
413 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
414 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
416 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
417 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
418 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
419 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
420 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
422 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
423 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
424 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
425 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
426 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
428 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
429 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
430 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
431 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
432 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
434 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
435 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
436 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
437 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
438 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
440 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
441 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
442 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
443 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
444 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
446 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
447 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
448 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
449 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
450 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
452 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
453 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
454 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
455 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
456 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
458 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
459 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
460 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
461 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
462 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
464 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
465 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
466 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
467 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
468 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
470 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
471 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
472 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
473 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
474 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
476 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
477 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
478 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
479 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
480 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
482 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
483 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
484 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
485 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
486 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
488 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
489 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
490 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
491 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
492 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
494 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
495 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
496 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
497 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
498 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
500 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
501 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
502 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
503 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
504 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
506 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
507 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
508 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
509 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
510 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
512 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
513 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
514 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
515 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
516 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
519 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
520 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
521 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
523 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
524 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
525 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
527 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
528 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
529 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
531 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
532 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
533 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
535 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
536 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
537 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
539 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
540 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
541 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
543 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
544 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
545 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
547 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
548 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
549 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
551 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
552 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
553 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
556 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
557 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
558 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
560 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
561 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
562 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
564 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
565 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
566 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
568 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
569 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
570 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
572 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
573 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
574 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
576 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
577 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
578 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
580 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
581 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
582 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
584 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
585 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
586 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
588 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
589 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
590 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
593 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
594 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
595 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
597 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
598 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
599 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
601 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
602 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
603 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
605 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
606 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
607 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
609 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
610 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
611 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
613 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
614 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
615 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
617 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
618 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
619 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
621 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
622 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
623 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
625 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
626 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
627 ('NETWORK', 'PENDING', 'DELETE', 'FAIL');
629 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
631 UPDATE orchestration_flow_reference
632 SET FLOW_NAME = 'ActivateServiceInstanceBB'
633 WHERE FLOW_NAME = 'ActivateServiceInstance';
635 DELETE FROM orchestration_flow_reference
636 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
638 UPDATE orchestration_flow_reference
639 SET SEQ_NO = SEQ_NO - 1
640 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
642 UPDATE orchestration_flow_reference
643 SET SEQ_NO = SEQ_NO - 1
644 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
646 UPDATE building_block_detail
647 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
648 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
650 UPDATE building_block_detail
651 SET TARGET_ACTION = 'CHANGE_MODEL'
652 WHERE TARGET_ACTION = 'CHANGEMODEL';
654 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
656 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
657 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
658 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
659 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
660 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
661 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
662 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
663 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
664 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
665 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
667 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
669 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
670 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
671 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
672 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
673 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
674 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
675 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
676 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
677 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
679 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
680 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
682 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
683 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
684 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
686 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)
687 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
689 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
690 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
693 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
694 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
695 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
697 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
699 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER, SERVICE_TYPE) VALUES
700 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
701 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
702 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
704 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
705 ('UpdateNetworkBB','NETWORK','UPDATE');
707 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
708 ('NETWORK','PRECREATED','UPDATE','FAIL'),
709 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
710 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
711 ('NETWORK','CREATED','UPDATE','FAIL'),
712 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
713 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
714 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
715 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
717 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
718 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
719 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
720 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
721 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
723 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
724 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
725 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
726 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
727 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
728 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
729 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
730 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
731 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
732 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
734 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
735 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
736 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
737 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
738 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
739 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
740 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
741 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
742 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
744 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
745 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
746 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
747 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
748 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
749 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
750 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
751 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
752 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
754 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
756 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
758 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
759 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
760 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
761 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
762 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
763 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
764 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
765 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
766 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
768 UPDATE orchestration_flow_reference
769 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
772 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
774 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
775 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
776 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
777 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
778 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
779 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
780 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
781 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
782 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
784 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
785 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
786 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
787 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
788 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
789 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
790 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
791 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
792 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
794 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
795 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
796 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
797 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
798 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
799 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
800 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
801 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
802 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL');
804 UPDATE orchestration_flow_reference
805 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
807 UPDATE orchestration_flow_reference
808 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
812 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
813 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
814 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
815 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
816 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
817 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
818 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
819 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
820 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
821 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
822 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
823 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
824 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
825 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
826 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
827 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
828 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
833 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
835 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
836 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
838 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
840 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
841 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
842 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
843 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
844 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
845 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
846 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
847 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
848 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
849 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
850 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
851 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
852 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
853 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
854 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
855 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
856 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
857 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
858 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
859 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
860 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
861 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
862 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
863 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM');
865 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
867 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
869 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
870 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM');
872 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
874 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
876 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
878 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);
881 SET ORCHESTRATION_URI = '/mso/async/services/WorkflowActionBB'
882 WHERE NF_ROLE = 'GR-API-DEFAULT' AND ACTION = 'inPlaceSoftwareUpdate';
884 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)
886 ('VNFCheckPserversLockedFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
887 ('VNFCheckInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
888 ('VNFSetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
889 ('VNFCheckClosedLoopDisabledFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
890 ('VNFSetClosedLoopDisabledFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
891 ('VNFLockActivity','*','*','*','*','Manual','Abort','*', '*'),
892 ('VNFUpgradePreCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
893 ('VNFQuiesceTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
894 ('VNFStopActivity','*','*','*','*','Manual','Abort','*', '*'),
895 ('VNFSnapShotActivity','*','*','*','*','Manual','Abort','*', '*'),
896 ('VNFStartActivity','*','*','*','*','Manual','Abort','*', '*'),
897 ('VNFUpgradeBackupActivity','*','*','*','*','Manual','Abort','*', '*'),
898 ('VNFUpgradeSoftwareActivity','*','*','*','*','Manual','Abort','*', '*'),
899 ('VNFUpgradePostCheckActivity','*','*','*','*','Manual','Abort','*', '*'),
900 ('VNFResumeTrafficActivity','*','*','*','*','Manual','Abort','*', '*'),
901 ('VNFUnlockActivity','*','*','*','*','Manual','Abort','*', '*'),
902 ('SDNOVnfHealthCheckBB','*','*','*','*','Manual','Abort','*', '*'),
903 ('VNFUnsetInMaintFlagActivity','*','*','*','*','Manual','Abort','*', '*'),
904 ('VNFUnsetClosedLoopDisabledActivity','*','*','*','*','Manual','Abort','*', '*');