Errors -12044 and -611 During Mirror Site Configuration (Doc ID 1401839.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 6.3.0 and later
Information in this document applies to any platform.

Symptoms

When performing a Mirror Site configuration for a destination, an error is given in the UI:

Error publishing {component} -12044, [pagename=OpenMarket/Xcelerate/Admin/MirrorSitePost] Error:  com.openmarket.xcelerate.commands.{class name}: Publish:  com.openmarket.basic.interfaces.AssetException: Remote object save didn't fire  [error was -611].

The source server's sites.log contains errors:

[2013-07-12 16:46:47,572] [ERROR] [http-bio-18080-exec-129] [logging.cs.xcelerate.publish] sendRows:
Mirror failed, errno=-611Created temporary table tt1346751456129
Added row: id = 11300000023921
Created temporary table tt1346751456130
Added row: id = 11300000024006
Failed to commit changes to catalog {table name}

<!--FTCS|||result=failure|||reason=Failed to commit changes to catalog {table name}|||err=-611|||
command=committables|||params=|||-->

The target server's sites.log contains errors:

[2013-07-12 16:46:47,547] [ERROR] [http-28080-21] [fatwire.logging.cs.db] SQLException executing
query: insert into {table name} ({column names}) select
{column names} from tt1346751456129
java.sql.SQLException: Violation of unique index {index name}: duplicate value(s) for column(s)
{index columns}

Note: these errors can happen for multiple components of Mirror Site Configuration. As such the table names, class names, etc can have different values, as listed in the table below.

 

componentclass nametable nameSection in Mirror Site Configuration
Association items AssocNamedManagerDispatcher AssocNamed Corresponds with the check-box "Asset Associations for selected asset types" under Asset Types.
Sites Desktop ExternalClientsManagerDispatcher externalclients Corresponds with the check-box "Sites Desktop configuration for selected asset types" under Asset Types. 
Sites DocLink ExternalClientsManagerDispatcher externalclients Corresponds with the check-box "Sites DocLink configuration for selected asset types" under section Asset Types. 
Start Menu StartMenuDispatcher StartMenu Section "Start Menu Items"
Workflow Processes WorkflowEngineDispatcher Workflow Section "Workflow Processes"
Workflow States WorkflowEngineDispatcher WorkflowStatusCode Corresponds with the check-box "Workflow States used by selected workflow processes" under section Workflow Processes. 
Workflow Assignment Actions WorkflowEngineDispatcher WorkflowAsgActions

Each of these corresponds with the check-box "All Workflow Actions" under section Workflow Processes. The items themselves are found in the Admin tab under Workflow Actions, and correspond to the sub-nodes as follows:

Workflow Assignment Actions - Timed Actions

Workflow Deadlock Actions - Deadlock Actions

Workflow Delegate Actions - Delegate Actions

Workflow Step Actions - Step Actions

Workflow Deadlock Actions WorkflowEngineDispatcher WorkflowDlkActions
Workflow Delegate Actions WorkflowEngineDispatcher WorkflowDlgActions
Workflow Step Actions WorkflowEngineDispatcher WorkflowStpActions
Workflow Conditions WorkflowEngineDispatcher WorkflowConditions Corresponds with the check-box "All Workflow Conditions" under section Workflow Processes.
Workflow Groups  WorkflowEngineDispatcher WorkflowGroups  Section "Workflow Groups"
Workflow Group Actions WorkflowEngineDispatcher WorkflowGrpActions Corresponds with the check-box "Workflow Group Actions" under section Workflow Groups.
Tree Tabs TreeTabManagerDispatcher TreeTabs Section "Tree Tabs"
saved searches SaveSearchManagerDispatcher SaveSearch Section "Saved Searches"

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms