Oracle WebCenter Sites (MOSC)

MOSC Banner

Exception saving new Page asset, ASSETID already exists in AssetPublication table for different asse

edited Jul 3, 2015 10:05AM in Oracle WebCenter Sites (MOSC) 1 commentAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center