Hi All,
We’re updating from 25R1 SU13 to 26R1 SU3 and we’re proceeding as Delivery Continuity way. So we removed all the .cdb files and converted into .ddlsource files as IFS recommend. We have successfully created topic and sanity without any errors but in the delivery environment we’re getting following errors. Any one experienced this and know how to solve this? I have added part of my _ERROR_Install.log file below.
!!!Error deploying file invent/CVtlStatus.ddl at 22-SEP-26 16:06:04
!!!Error occurred while executing Plsql Block
BEGIN
IF Code_Registration_SYS.Is_Not_Registered('INVENT', 'CVtlStatus', 'M_DEEPSV04_10646_C_Vtl_Status_Table_Creation', 'DDL') THEN
DECLARE
BEGIN
--TABLE--
DECLARE
table_name_ VARCHAR2(34) := Database_SYS.Get_Or_Generate_Rtb_name#('C_VTL_STATUS_TAB');
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table#(columns_);
Database_SYS.Set_Table_Column#(columns_, 'VALUE_SOLL', 'VARCHAR2(10)', 'N');
Database_SYS.Set_Table_Column#(columns_, 'DESCRIPTION', 'VARCHAR2(100)', 'Y');
Database_SYS.Set_Table_Column#(columns_, 'PART_STATUS', 'VARCHAR2(1)', 'Y');
Database_SYS.Set_Table_Column#(columns_, 'ROWVERSION', 'DATE', 'N');
Database_SYS.Set_Table_Column#(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Create_Or_Extend_Real_Table#(table_name_, columns_, 'IFSAPP_DATA', NULL, TRUE);
END;
--INDEX--
DECLARE
index_name_ VARCHAR2(30) := 'C_VTL_STATUS_PK';
table_name_ VARCHAR2(34) := Database_SYS.Get_Or_Generate_Rtb_name#('C_VTL_STATUS_TAB');
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table#(columns_);
Database_SYS.Set_Table_Column#(columns_, 'VALUE_SOLL');
Database_SYS.Create_Constraint#(table_name_, index_name_, columns_, 'P', 'IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
DECLARE
index_name_ VARCHAR2(30) := 'C_VTL_STATUS_RK';
table_name_ VARCHAR2(34) := Database_SYS.Get_Or_Generate_Rtb_name#('C_VTL_STATUS_TAB');
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table#(columns_);
Database_SYS.Set_Table_Column#(columns_, 'ROWKEY');
Database_SYS.Create_Constraint#(table_name_, index_name_, columns_, 'U', 'IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
END;Code_Registration_SYS.Register('INVENT', 'CVtlStatus', 'M_DEEPSV04_10646_C_Vtl_Status_Table_Creation', 'DDL');
COMMIT;
END IF;
END;
ORA-20112: Create_Constraint#: Constraint C_VTL_STATUS_RK already exists for another table.
ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 11679
ORA-06512: at "IFSAPP.INSTALLATION_SYS", line 2353
ORA-06512: at "IFSAPP.DATABASE_SYS", line 2731
ORA-06512: at line 37
!!!Error deploying file invent/CVtlStatus.edv at 22-SEP-26 16:07:12
!!!Error creating VIEW C_VTL_STATUS_TAB
CREATE OR REPLACE EDITIONING VIEW C_VTL_STATUS_TAB AS
SELECT
value_soll,
description,
part_status,
rowversion,
rowkey
FROM c_vtl_status_rtb
ORA-00955: name is already used by an existing object