That was just an example of one of the steps who are failing.
The follwing steps are all failing
#3204 ‘Rename table ‘PROJECTS’ to ‘COMPONENTS’’ failed
#3307 ‘Remove column ‘resource_id’ in ‘group_roles’’ failed
#3310 ‘Remove column ‘resource_id’ in ‘user_roles’’ failed
#3311 ‘Remove column ‘id’ in ‘components’’ failed
#3492 ‘Drop primary key on ‘ID’ column of ‘PERM_TEMPLATES_GROUPS’ table’ failed
#3504 ‘Drop primary key on ‘ID’ column of ‘PERM_TEMPLATES_USERS’ table’ failed
#3573 ‘Drop primary key on ‘ID’ column of ‘PERMISSION_TEMPLATES’ table’ failed
#3679 ‘Drop column ‘templateId’ column for ‘RULES’’ failed
I tried to do this steps manually (drop coulm, drop prim-key and so on)
Sometime the Triggers had different names, and sometimes the Triggert didnt even exists in the Oracle Database.
Also on some steps i got the error that the specified index does not exist.
Sure i can try to fix all those problems manually.
But for me it looks like there are too many steps not working and it looks like our Database is broken. So is there a script or an SQL Command to check the consistency of this database?