Knowledge base: Apia 
|
Language: English
|
History
|
 |
|
 |
|
|
|
|
[ AHF00129 ] Error when creating the alteration process
Summary
Error of invalid name of column when trying to create an instance of an alteration process.
It is applied to
Solution
The following SQL sentences must be executed in order to fix the error:Oracle: CREATE OR REPLACE VIEW VW_BUS_ENTITIES_INSTANCES_01 AS SELECT ei.*, e.bus_ent_admin_type, e.bus_ent_name, e.bus_ent_title, es.ent_sta_name, pi.pro_inst_id_auto, p.pro_name, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_1) as bus_ent_att_label_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_2) as bus_ent_att_label_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_3) as bus_ent_att_label_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_4) as bus_ent_att_label_4, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_5) as bus_ent_att_label_5, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_1) as bus_ent_att_label_num_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_2) as bus_ent_att_label_num_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_3) as bus_ent_att_label_num_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_1) as bus_ent_att_label_dte_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_2) as bus_ent_att_label_dte_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_3) as bus_ent_att_label_dte_3 FROM bus_ent_instance ei, bus_ent_status es, pro_instance pi, process p , bus_entity e WHERE ei.env_id = e.env_id and ei.env_id = es.env_id(+) and ei.ent_sta_id = es.ent_sta_id_auto(+) and ei.env_id = pi.env_id(+) and ei.bus_ent_inst_id_auto = pi.bus_ent_inst_id(+) and pi.pro_inst_status(+) = 'R' and pi.env_id = p.env_id(+) and pi.pro_id = p.pro_id_auto(+) and pi.pro_ver_id = p.pro_ver_id(+) and ei.bus_ent_id = e.bus_ent_id_auto and (pi.reg_status = 0 OR pi.reg_status IS NULL) ; SQLServer: ALTER VIEW VW_BUS_ENTITIES_INSTANCES_01 AS SELECT ei.*, e.bus_ent_admin_type, e.bus_ent_name, e.bus_ent_title, es.ent_sta_name, pi.pro_inst_id_auto, p.pro_name, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_1) as bus_ent_att_label_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_2) as bus_ent_att_label_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_3) as bus_ent_att_label_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_4) as bus_ent_att_label_4, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_5) as bus_ent_att_label_5, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_1) as bus_ent_att_label_num_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_2) as bus_ent_att_label_num_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_3) as bus_ent_att_label_num_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_1) as bus_ent_att_label_dte_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_2) as bus_ent_att_label_dte_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_3) as bus_ent_att_label_dte_3
FROM
Postgres: CREATE VIEW VW_BUS_ENTITIES_INSTANCES_01 AS SELECT ei.*, e.bus_ent_admin_type, e.bus_ent_name, e.bus_ent_title, es.ent_sta_name, pi.pro_inst_id_auto, p.pro_name, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_1) as bus_ent_att_label_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_2) as bus_ent_att_label_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_3) as bus_ent_att_label_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_4) as bus_ent_att_label_4, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_5) as bus_ent_att_label_5, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_1) as bus_ent_att_label_num_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_2) as bus_ent_att_label_num_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_num_3) as bus_ent_att_label_num_3, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_1) as bus_ent_att_label_dte_1, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_2) as bus_ent_att_label_dte_2, (select a.att_label from attribute a where a.env_id = e.env_id and a.att_id_auto = e.att_id_dte_3) as bus_ent_att_label_dte_3
FROM Suggested items
|
|
