The Oracle database seed dump in the repository, contains some wrong constraints i.e.: M_INVENTORYLINEMA_KEY M_INOUTLINEMA_KEY
I think there are an errors in migration script: 201310141246_IDEMPIERE-386.sql i.e. there is this ALTER TABLE M_InOutLineMA DROP CONSTRAINT m_inoutlinema_key instead of DROP INDEX M_INOUTLINEMA_KEY;
Thanks , committed a version with direct DROP because in my tests with syncApplied it didn't work the pl/sql version.
Dirk Niemeyer July 28, 2016 at 3:02 PM
Edited
I have encountered the same problem.
If I understand correct Oracle is creating also an index when you create a primary key constraint. When you drop the constraint, the index is not droped automatically.
I have attached a migration for Oracle which takes care and works even if you had already manually droped the index.
I think for the future people have just to remember this and take care that besides the constraint they also drop a related index.
The Oracle database seed dump in the repository, contains some wrong constraints i.e.:
M_INVENTORYLINEMA_KEY
M_INOUTLINEMA_KEY
I think there are an errors in migration script: 201310141246_IDEMPIERE-386.sql
i.e. there is this
ALTER TABLE M_InOutLineMA DROP CONSTRAINT m_inoutlinema_key
instead of
DROP INDEX M_INOUTLINEMA_KEY;
Best regards