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', '*');
35 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
36 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
37 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
38 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
39 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
40 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
41 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
42 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
43 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
44 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Create', '8', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '9', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '10', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '11', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '12', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '13', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '14', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '15', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Create', '16', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Create', '17', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Delete', '10', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Delete', '11', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '12', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '13', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Service-Macro-Delete', '14', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
91 ('Service-Macro-Delete', '15', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
92 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
93 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
94 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
95 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
97 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
98 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
99 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
100 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
101 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
102 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
103 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
124 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
125 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
126 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
127 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
128 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
129 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
130 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
131 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
133 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
134 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
136 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
137 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
141 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
142 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
145 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
146 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
147 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
148 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
149 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
150 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
151 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
152 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
153 ('VFModule-Replace', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
154 ('VFModule-Replace', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
155 ('VFModule-Replace', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
156 ('VFModule-Replace', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
157 ('VFModule-Replace', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
158 ('VFModule-Replace', '6', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
159 ('VFModule-Replace', '7', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
160 ('VFModule-Replace', '8', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
161 ('VFModule-Replace', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
162 ('VFModule-Replace', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
163 ('VFModule-Replace', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
164 ('VFModule-Replace', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
165 ('VFModule-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
166 ('VFModule-Replace', '14', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Replace' and CLOUD_OWNER = 'DEFAULT')),
167 ('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')),
168 ('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')),
169 ('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')),
170 ('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')),
171 ('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')),
172 ('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')),
173 ('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')),
174 ('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')),
175 ('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')),
176 ('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')),
177 ('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')),
178 ('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')),
179 ('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'));
182 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
184 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
185 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
186 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
187 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
188 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
189 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
190 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
191 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
192 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
193 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
194 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
195 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
196 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
197 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
198 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
199 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
200 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
201 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
202 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
203 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
204 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
205 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
206 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
207 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
208 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
209 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
210 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
211 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
212 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
213 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
214 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
215 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
216 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
217 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
218 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
219 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
220 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
221 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
222 ('ConfigDeployVnfBB', '*', '*', '*', '*' , 'Retry');
225 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
227 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
228 ('AssignVnfBB', 'VNF', 'ASSIGN'),
229 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
230 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
231 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
233 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
234 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
235 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
236 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
238 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
239 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
240 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
241 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
242 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
243 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
245 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
246 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
247 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
248 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
249 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
252 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
253 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
254 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
257 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
258 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
259 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
260 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
262 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
263 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
264 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
265 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
267 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
268 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM');
270 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
273 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
274 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
275 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
276 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
277 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
279 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
280 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
281 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
282 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
283 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
285 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
286 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
287 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
288 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
289 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
291 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
292 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
293 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
294 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
295 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
297 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
298 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
299 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
300 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
301 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
303 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
304 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
305 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
306 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
307 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
309 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
310 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
311 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
312 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
313 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
315 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
316 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
317 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
318 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
319 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
321 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
322 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
323 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
324 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
325 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
328 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
329 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
330 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
331 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
332 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
334 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
335 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
336 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
337 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
338 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
340 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
341 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
342 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
343 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
344 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
346 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
347 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
348 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
349 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
350 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
352 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
353 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
354 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
355 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
356 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
358 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
359 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
360 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
361 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
362 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
364 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
365 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
366 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
367 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
368 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
370 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
371 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
372 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
373 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
374 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
376 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
377 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
378 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
379 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
380 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
383 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
384 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
385 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
386 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
387 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
389 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
390 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
391 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
392 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
393 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
395 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
396 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
397 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
398 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
399 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
401 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
402 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
403 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
404 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
405 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
407 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
408 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
409 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
410 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
411 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
413 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
414 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
415 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
416 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
417 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
419 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
420 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
421 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
422 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
423 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
425 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
426 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
427 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
428 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
429 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
431 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
432 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
433 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
434 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
435 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
437 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
438 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
439 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
440 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
441 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
443 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
444 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
445 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
446 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
447 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
449 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
450 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
451 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
452 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
453 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
455 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
456 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
457 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
458 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
459 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
461 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
462 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
463 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
464 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
465 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
467 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
468 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
469 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
470 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
471 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
473 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
474 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
475 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
476 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
477 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
479 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
480 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
481 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
482 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
483 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
485 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
486 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
487 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
488 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
489 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
492 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
493 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
494 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
496 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
497 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
498 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
500 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
501 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
502 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
504 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
505 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
506 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
508 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
509 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
510 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
512 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
513 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
514 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
516 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
517 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
518 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
520 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
521 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
522 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
524 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
525 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
526 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
529 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
530 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
531 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
533 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
534 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
535 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
537 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
538 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
539 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
541 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
542 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
543 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
545 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
546 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
547 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
549 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
550 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
551 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
553 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
554 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
555 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
557 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
558 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
559 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
561 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
562 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
563 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
566 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
567 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
568 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
570 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
571 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
572 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
574 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
575 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
576 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
578 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
579 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
580 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
582 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
583 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
584 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
586 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
587 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
588 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
590 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
591 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
592 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
594 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
595 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
596 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
598 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
599 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
600 ('NETWORK', 'PENDING', 'DELETE', 'FAIL');
602 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
604 UPDATE orchestration_flow_reference
605 SET FLOW_NAME = 'ActivateServiceInstanceBB'
606 WHERE FLOW_NAME = 'ActivateServiceInstance';
608 DELETE FROM orchestration_flow_reference
609 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
611 UPDATE orchestration_flow_reference
612 SET SEQ_NO = SEQ_NO - 1
613 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
615 UPDATE orchestration_flow_reference
616 SET SEQ_NO = SEQ_NO - 1
617 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
619 UPDATE building_block_detail
620 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
621 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
623 UPDATE building_block_detail
624 SET TARGET_ACTION = 'CHANGE_MODEL'
625 WHERE TARGET_ACTION = 'CHANGEMODEL';
627 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
629 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
630 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
631 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
632 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
633 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
634 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
635 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
636 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
637 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
638 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
640 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
642 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
643 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
644 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
645 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
646 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
647 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
648 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
649 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
650 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
652 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
653 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
655 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
656 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
657 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
659 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)
660 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
662 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
663 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
666 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
667 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
668 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
670 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
672 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
673 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
674 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
675 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
677 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
678 ('UpdateNetworkBB','NETWORK','UPDATE');
680 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
681 ('NETWORK','PRECREATED','UPDATE','FAIL'),
682 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
683 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
684 ('NETWORK','CREATED','UPDATE','FAIL'),
685 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
686 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
687 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
688 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
690 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
691 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
692 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
693 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
694 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
696 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
697 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
698 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
699 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
700 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
701 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
702 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
703 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
704 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
705 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
707 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
708 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
709 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
710 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
711 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
712 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
713 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
714 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
715 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
717 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
718 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
719 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
720 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
721 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
722 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
723 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
724 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
725 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
727 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
729 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
731 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
732 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
733 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
734 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
735 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
736 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
737 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
738 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
739 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
741 UPDATE orchestration_flow_reference
742 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
745 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
747 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
748 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
749 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
750 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
751 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
752 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
753 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
754 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
755 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
757 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
758 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
759 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
760 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
761 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
762 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
763 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
764 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
765 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
767 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
768 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
769 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
770 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
771 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
772 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
773 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
774 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
775 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL');
777 UPDATE orchestration_flow_reference
778 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
780 UPDATE orchestration_flow_reference
781 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
785 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
786 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
787 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
788 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
789 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
790 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
791 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
792 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
793 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
794 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
795 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
796 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
797 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
798 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
799 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
800 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
801 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
806 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
808 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
809 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
811 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
813 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
814 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
815 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
816 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
817 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
818 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
819 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
820 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
821 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
822 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
823 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
824 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
825 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
826 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
827 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
828 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
829 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
830 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
831 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
832 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
833 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
834 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
835 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
836 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM');
838 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
840 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
842 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
843 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM');
845 UPDATE rainy_day_handler_macro SET reg_ex_error_message = '*' WHERE reg_ex_error_message IS null;
847 UPDATE rainy_day_handler_macro SET SERVICE_ROLE = '*' WHERE SERVICE_ROLE IS null;
849 INSERT INTO vnf_components_recipe (VNF_TYPE, VNF_COMPONENT_TYPE, ACTION, VERSION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
851 (NULL, 'vfModule', 'replaceInstanceRetainAssignments', '1', '/mso/async/services/WorkflowActionBB', 180);