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 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
29 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'DEFAULT', '*'),
30 ('VFModule-ScaleOut', 'scaleOut', 'VfModule', true, true, '7','7', 'DEFAULT', '*');
33 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
34 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
35 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'DEFAULT')),
36 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
37 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'DEFAULT')),
38 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
39 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
40 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
41 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
42 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
43 ('Service-Macro-Assign', '6', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'DEFAULT')),
44 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
45 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
46 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
47 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
48 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
49 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
50 ('Service-Macro-Activate', '7', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
51 ('Service-Macro-Activate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
52 ('Service-Macro-Activate', '9', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'DEFAULT')),
53 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
54 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
55 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
56 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
57 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'DEFAULT')),
58 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
59 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
60 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
61 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
62 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
63 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
64 ('Service-Macro-Create', '7', 'ConfigAssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
65 ('Service-Macro-Create', '8', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
66 ('Service-Macro-Create', '9', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
67 ('Service-Macro-Create', '10', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
68 ('Service-Macro-Create', '11', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
69 ('Service-Macro-Create', '12', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
70 ('Service-Macro-Create', '13', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
71 ('Service-Macro-Create', '14', 'ConfigDeployVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
72 ('Service-Macro-Create', '15', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
73 ('Service-Macro-Create', '16', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
74 ('Service-Macro-Create', '17', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
75 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
76 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
77 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
78 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
79 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
80 ('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
81 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
82 ('Service-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
83 ('Service-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
84 ('Service-Macro-Delete', '10', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
85 ('Service-Macro-Delete', '11', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
86 ('Service-Macro-Delete', '12', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
87 ('Service-Macro-Delete', '13', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
88 ('Service-Macro-Delete', '14', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
89 ('Service-Macro-Delete', '15', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
90 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
91 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
92 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'DEFAULT')),
93 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
94 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
95 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'DEFAULT')),
96 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
97 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'DEFAULT')),
98 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
99 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'DEFAULT')),
100 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
101 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
102 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
103 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
104 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
105 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
106 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
107 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
108 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
109 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'DEFAULT')),
110 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
111 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
112 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
113 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
114 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
115 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
116 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
117 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
118 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
119 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
120 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
121 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
122 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'DEFAULT')),
123 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
124 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
125 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'DEFAULT')),
126 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
127 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
128 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'DEFAULT')),
129 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
130 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
131 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'DEFAULT')),
132 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
133 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
134 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'DEFAULT')),
135 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
136 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
137 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
138 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
139 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'DEFAULT')),
140 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
141 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
142 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
143 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
144 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'DEFAULT')),
145 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
146 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
147 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
148 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
149 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT')),
150 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'DEFAULT'));
152 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
154 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
155 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
156 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
157 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
158 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
159 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
160 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
161 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
162 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
163 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
164 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
165 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
166 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
167 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
168 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
169 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
170 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
171 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
172 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
173 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
174 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
175 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
176 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
177 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
178 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
179 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
180 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
181 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
182 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
183 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
184 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
185 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
186 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
187 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
188 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
189 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
190 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
191 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort');
195 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
197 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
198 ('AssignVnfBB', 'VNF', 'ASSIGN'),
199 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
200 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
201 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
203 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
204 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
205 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
206 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
208 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
209 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
210 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
211 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
212 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
213 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
215 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
216 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
217 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
218 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
219 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
222 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
223 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
224 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
227 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
228 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
229 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
230 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
232 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
233 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
234 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
235 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
237 ('ConfigurationScaleOutBB', 'NO_VALIDATE', 'CUSTOM'),
238 ('GenericVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM');
240 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
243 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
244 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
245 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
246 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
247 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
249 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
250 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
251 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
252 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
253 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
255 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
256 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
257 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
258 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
259 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
261 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
262 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
263 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
264 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
265 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
267 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
268 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
269 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
270 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
271 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
273 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
274 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
275 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
276 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
277 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
279 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
280 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
281 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
282 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
283 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
285 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
286 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
287 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
288 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
289 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
291 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
292 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
293 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
294 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
295 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
298 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
299 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
300 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
301 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
302 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
304 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
305 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
306 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
307 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
308 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
310 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
311 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
312 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
313 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
314 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
316 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
317 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
318 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
319 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
320 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
322 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
323 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
324 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
325 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
326 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
328 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
329 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
330 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
331 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
332 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
334 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
335 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
336 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
337 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
338 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
340 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
341 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
342 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
343 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
344 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
346 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
347 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
348 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
349 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
350 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
353 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
354 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
355 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
356 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
357 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
359 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
360 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
361 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
362 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
363 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
365 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
366 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
367 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
368 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
369 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
371 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
372 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
373 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
374 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
375 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
377 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
378 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
379 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
380 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
381 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
383 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
384 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
385 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
386 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
387 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
389 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
390 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
391 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
392 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
393 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
395 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
396 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
397 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
398 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
399 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
401 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
402 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
403 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
404 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
405 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
407 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
408 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
409 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
410 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
411 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
413 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
414 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
415 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
416 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
417 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
419 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
420 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
421 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
422 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
423 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
425 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
426 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
427 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
428 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
429 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
431 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
432 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
433 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
434 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
435 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
437 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
438 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
439 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
440 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
441 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
443 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
444 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
445 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
446 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
447 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
449 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
450 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
451 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
452 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
453 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
455 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
456 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
457 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
458 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
459 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
462 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
463 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
464 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
466 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
467 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
468 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
470 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
471 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
472 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
474 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
475 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
476 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
478 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
479 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
480 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
482 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
483 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
484 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
486 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
487 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
488 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
490 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
491 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
492 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
494 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
495 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
496 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
499 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
500 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
501 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
503 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
504 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
505 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
507 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
508 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
509 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
511 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
512 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
513 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
515 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
516 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
517 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
519 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
520 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
521 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
523 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
524 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
525 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
527 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
528 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
529 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
531 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
532 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
533 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
536 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
537 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
538 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
540 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
541 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
542 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
544 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
545 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
546 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
548 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
549 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
550 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
552 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
553 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
554 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
556 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
557 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
558 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
560 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
561 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
562 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
564 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
565 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
566 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
568 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
569 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
570 ('NETWORK', 'PENDING', 'DELETE', 'FAIL');
572 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
574 UPDATE orchestration_flow_reference
575 SET FLOW_NAME = 'ActivateServiceInstanceBB'
576 WHERE FLOW_NAME = 'ActivateServiceInstance';
578 DELETE FROM orchestration_flow_reference
579 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
581 UPDATE orchestration_flow_reference
582 SET SEQ_NO = SEQ_NO - 1
583 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
585 UPDATE orchestration_flow_reference
586 SET SEQ_NO = SEQ_NO - 1
587 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
589 UPDATE building_block_detail
590 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
591 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
593 UPDATE building_block_detail
594 SET TARGET_ACTION = 'CHANGE_MODEL'
595 WHERE TARGET_ACTION = 'CHANGEMODEL';
597 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
599 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
600 ('SniroHoming', 'NO_VALIDATE', 'CUSTOM'),
601 ('DeactivateAndUnassignVpnBondingLinksBB', 'NO_VALIDATE', 'CUSTOM'),
602 ('DeactivateNetworkCollectionBB', 'NO_VALIDATE', 'CUSTOM'),
603 ('AAICheckVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
604 ('AAISetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
605 ('AAIUnsetVnfInMaintBB', 'NO_VALIDATE', 'CUSTOM'),
606 ('SDNOVnfHealthCheckBB', 'NO_VALIDATE', 'CUSTOM'),
607 ('VNF-Macro-Replace', 'NO_VALIDATE', 'CUSTOM'),
608 ('HomingBB', 'NO_VALIDATE', 'CUSTOM');
610 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
612 ('NO_VALIDATE', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
613 ('NO_VALIDATE', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
614 ('NO_VALIDATE', 'CREATED', 'CUSTOM', 'CONTINUE'),
615 ('NO_VALIDATE', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
616 ('NO_VALIDATE', 'PENDING', 'CUSTOM', 'CONTINUE'),
617 ('NO_VALIDATE', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
618 ('NO_VALIDATE', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
619 ('NO_VALIDATE', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
620 ('NO_VALIDATE', 'PRECREATED', 'CUSTOM', 'CONTINUE');
622 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
623 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'DEFAULT', '*');
625 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
626 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT')),
627 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'DEFAULT'));
629 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)
630 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'DEFAULT', '*');
632 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
633 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'DEFAULT'));
636 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
637 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
638 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
640 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
642 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
643 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'DEFAULT', '*');
644 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
645 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'DEFAULT'));
647 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
648 ('UpdateNetworkBB','NETWORK','UPDATE');
650 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
651 ('NETWORK','PRECREATED','UPDATE','FAIL'),
652 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
653 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
654 ('NETWORK','CREATED','UPDATE','FAIL'),
655 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
656 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
657 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
658 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
660 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
661 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
662 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
663 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
664 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
666 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
667 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
668 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
669 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
670 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
671 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
672 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
673 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
674 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
675 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
677 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
678 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
679 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
680 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
681 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
682 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
683 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
684 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
685 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
687 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
688 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
689 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
690 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
691 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
692 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
693 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
694 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
695 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
697 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
699 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
701 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
702 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
703 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
704 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
705 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
706 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
707 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
708 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
709 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
711 UPDATE orchestration_flow_reference
712 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
715 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
717 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
718 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
719 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
720 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
721 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
722 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
723 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
724 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
725 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
727 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
728 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
729 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
730 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
731 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
732 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
733 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
734 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
735 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
737 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
738 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
739 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
740 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
741 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
742 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
743 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
744 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
745 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL');
747 UPDATE orchestration_flow_reference
748 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
750 UPDATE orchestration_flow_reference
751 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
755 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
756 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
757 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
758 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
759 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
760 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
761 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
762 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
763 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
764 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
765 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
766 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
767 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
768 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
769 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
770 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
771 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
776 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
778 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
779 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');
781 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
783 ('VNFSetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
784 ('VNFCheckPserversLockedFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
785 ('VNFCheckInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
786 ('VNFCheckClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
787 ('VNFSetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
788 ('VNFUnsetClosedLoopDisabledFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
789 ('VNFLockActivity', 'NO_VALIDATE', 'CUSTOM'),
790 ('VNFUnlockActivity', 'NO_VALIDATE', 'CUSTOM'),
791 ('VNFStopActivity', 'NO_VALIDATE', 'CUSTOM'),
792 ('VNFStartActivity', 'NO_VALIDATE', 'CUSTOM'),
793 ('VNFSnapShotActivity', 'NO_VALIDATE', 'CUSTOM'),
794 ('FlowCompleteActivity', 'NO_VALIDATE', 'CUSTOM'),
795 ('PauseForManualTaskActivity', 'NO_VALIDATE', 'CUSTOM'),
796 ('DistributeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
797 ('DistributeTrafficCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
798 ('VNFHealthCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
799 ('VNFQuiesceTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
800 ('VNFResumeTrafficActivity', 'NO_VALIDATE', 'CUSTOM'),
801 ('VNFUnsetInMaintFlagActivity', 'NO_VALIDATE', 'CUSTOM'),
802 ('VNFUpgradeBackupActivity', 'NO_VALIDATE', 'CUSTOM'),
803 ('VNFUpgradePostCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
804 ('VNFUpgradePreCheckActivity', 'NO_VALIDATE', 'CUSTOM'),
805 ('VNFUpgradeSoftwareActivity', 'NO_VALIDATE', 'CUSTOM'),
806 ('VnfInPlaceSoftwareUpdate', 'NO_VALIDATE', 'CUSTOM');
808 UPDATE northbound_request_ref_lookup SET SERVICE_TYPE = '*' WHERE SERVICE_TYPE IS NULL;
810 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
812 ('ConfigAssignVnfBB', 'NO_VALIDATE', 'CUSTOM'),
813 ('ConfigDeployVnfBB', 'NO_VALIDATE', 'CUSTOM');