Oracle WebCenter Sites Mirror Site Configuration issues : Error publishing Start Menu items

With Oracle WebCenter Sites , when you tried to Mirror Site Configurations from source to destination systems , you may face exceptions as given below 

Error publishing Start Menu items, -12044, [pagename=OpenMarket/Xcelerate/Admin/MirrorSitePost] Error: com.openmarket.xcelerate.commands.StartMenuDispatcher: Publish: com.openmarket.basic.interfaces.AssetException: Remote object save didn’t fire [error was -611]

You can find additional errors in both source futuretense.txt and target futuretense.txt

Theses exception could be similar to as given below

Exception on Source

 <!–FTCS|||result=failure|||reason=Failed to commit changes to catalog StartMenu|||err=-611|||command=committables|||params=|||–>

Exception on Target

[2014-02-10 16:05:09,308 EST] [ERROR] [.kernel.Default (self-tuning)’] [fatwire.logging.cs.db] SQLException executing query: insert into StartMenu (id,cs_name,cs_description,cs_assettype,cs_processform,cs_partform,cs_saform,cs_itemtype,cs_assetsubtype,fw_uid) select id,cs_name,cs_description,cs_assettype,cs_processform,cs_partform,cs_saform,cs_itemtype,cs_assetsubtype,fw_uid from tt1320480615775

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CSDBUSER1105.I1150985659977) violated

Possible Root Cause for Mirror Site Configuration Issue

When items are being mirrored with Mirror Site Configuration, they are deleted and recreated on the target tables, using the ID column as the key for deletion. If a record exists on target with the same name but different ID as one being published, then it will not be deleted on target, and when the one being mirrored tries to save, there is an error on target because of a unique constraint on the name.

How to resolve Mirror Site Configuration Issue

Try enabling the debug mode log levels on the source system then you can find additional information as given below in the source futuretense.txt . Try to find the relevant logs related the failed exception i.e according to the exception on the source

<!–FTCS|||result=failure|||reason=Failed to commit changes to catalog StartMenu|||err=-611|||command=committables|||params=|||–>

Failed table name is StartMenu, so look for debug information related to StartMenu items. Similarly if you observe exceotions related to CSElement look for CSElement related debug information and in the next step you would be looking for an entry in CSElement table instead of StartMenu table

Object Name: StartMenu

MirrorQueueEntry:

        keyName:id

        keyType:(integer)

        ->rows to be added/updated:

        Key=1159296432909 version=null

        Key=1159296432981 version=null

        Key=1159296432977 version=null

        ->rows to be deleted:

 

  1. Copy all these Key’s to a notepad
  2. Using Sites-Explorer, check in Start Menu table on the source for the ids noted above. (Not all ids will be present)
  3. Get the name of the asset corresponding to ID on the source system
  4.  Using Sites-Explorer, find the records in the on the target with the same name as on the source but with different ids.(Note down the assets which have same name in both target and source system but with different ID)
    • Use the Admin UI to remove or rename the items identified in step 4, or use Sites-Explorer to rename them. Don’t delete the records using Sites-Explorer as this may leave behind some orphan records in other tables.
  5.  Run Mirror Site Configuration again.
  6. Example : In the above debug message , get the key 1159296432981
    • Search in the source systems Start Menu table for the record 1159296432981
    • Assume if the name of the Start Menu is “Find Template”
    • Go to the Target system and search for “Find Template” Start Menu item
    • If the id of the Start Menu on target is different from source and Delete this “Find Template” Start Menu from Admin UI
    • If the ID is same or if the name of the Start Menu is not available, ignore the Start Menu
    • Similarly do these steps fro all the different keys