Exception saving new Page asset, ASSETID already exists in AssetPublication table for different asse
Hello,
I'm using Oracle WebCenter Sites 11g, 11.1.1.8.0, Patch 6.
Creating a new Page asset and saving it throws the below exception
[2015-06-24 09:43:28,082 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO AssetPublication (ID,PUBID,ASSETTYPE,ASSETID) VALUES (?,?,?,?) ID = 1500000254528 PUBID = 1500000025152 ASSETTYPE = Page ASSETID = 1500000028441 java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CSDBUSER.I1403009565531) violated
After checking the DB, there is actually an asset of different type and that same asset ID.
I can't create and save new pages now, how can I solve this issue ?