Main Site and Partner Site both running version 11.0.4202 (MR4-MP2)
After initiating a replication from the main-site I receive an error on the partner-site, while trying to replicate.
20 August 2009 14:42:36: Replication from remote site NEIT Central SEPM to local site Torbay Primary School finished unsuccessfully [Site: Torbay Primary School] [Server: tpfp01]
20 August 2009 14:42:35: Unable to fetch changed data from remote site [NEIT Central SEPM]: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: ASA Error -193: Primary key for table 'COMMAND' is not unique [Site: Torbay Primary School] [Server: tpfp01]
20 August 2009 14:42:07: Replication data from remote site NEIT Central SEPM is received by local site Torbay Primary School [Site: Torbay Primary School] [Server: tpfp01]
20 August 2009 14:39:22: Replication from remote site NEIT Central SEPM to local site Torbay Primary School being initiated [Site: Torbay Primary School] [Server: tpfp01]
20 August 2009 14:39:22: Replication from remote site NEIT Central SEPM to local site Torbay Primary School finished unsuccessfully [Site: Torbay Primary School] [Server: tpfp01]
scm-server-0.log on partner site:
2009-08-20 14:42:35.781 SEVERE: Unknown Exception in: com.sygate.scm.server.replication.ReplicationTask
com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: ASA Error -193: Primary key for table 'COMMAND' is not unique
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseBatchUpdateException(ErrorMessage.java:991)
at com.sybase.jdbc2.jdbc.SybStatement.batchLoop(SybStatement.java:1424)
at com.sybase.jdbc2.jdbc.SybStatement.sendBatch(SybStatement.java:1227)
at com.sybase.jdbc2.jdbc.SybStatement.executeBatch(SybStatement.java:1185)
at com.sybase.jdbc2.jdbc.SybStatement.executeBatch(SybStatement.java:1101)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeBatch(SybPreparedStatement.java:951)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at com.sygate.scm.server.replication.table.DefaultTableReplicator.batchExecute(DefaultTableReplicator.java:165)
at com.sygate.scm.server.replication.table.DefaultTableReplicator.replicateTable(DefaultTableReplicator.java:148)
at com.sygate.scm.server.replication.table.DefaultTableReplicator.replicateTable(DefaultTableReplicator.java:201)
at com.sygate.scm.server.replication.ReplicationTask.replicateTableData(ReplicationTask.java:1290)
at com.sygate.scm.server.replication.ReplicationTask.replicateTableData(ReplicationTask.java:1249)
at com.sygate.scm.server.replication.ReplicationTask.processRelicationData(ReplicationTask.java:3065)
at com.sygate.scm.server.replication.ReplicationTask.replicate(ReplicationTask.java:313)
at com.sygate.scm.server.replication.ReplicationTask.run(ReplicationTask.java:248)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
I have tried re-creating the partners on both sites, and deleting and reestablishing the partner-site database.
Also clearing out the inbox/outbox in the Replication folder on both servers.
It appears to replicate ok, viewing the clients and policies, however it takes much longer than the other sites.
According to this document, it was suppose to bre resolved in this version:
http://service1.symantec.com/support/ent-security.nsf/854fa02b4f5013678825731a007d06af/abcecc7098eced118825750d000f8cce?OpenDocument
In the release notes:
http://service1.symantec.com/support/ent-security.nsf/854fa02b4f5013678825731a007d06af/2c62c4ee0e697aae882573b000034ded?OpenDocument
Symantec Endpoint Protection Manager replication fails with ASA error 193: "Primary Key for Table 'COMMAND' is not unique" when using an embedded database
Fix ID: 1533903
Symptom: Replication fails when the HARDWARE key is NULL.
Solution: Made changes to the query that finds the data.
I have two existing partners with my Main site which replicate without issue.