Errors occur in Symantec Endpoint Protection Manager (SEPM) logs after initial replication.
SEPM site replication not working properly.
ReplicationLocal-0.log:
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file
<timestamp> THREAD 278 WARNING: ReplicationTask>> replicate: Exception...
<timestamp> THREAD 278 WARNING: java.sql.SQLException: Failed to load data. If packet size is not too large, please modify it by scm.bcp.packet.size. Detailed message
: SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file
at com.sygate.scm.server.db.util.SqlDbHelper.handleBulkInsertResult(SqlDbHelper.java:522)
at com.sygate.scm.server.db.util.SqlDbHelper.exportFormatFile(SqlDbHelper.java:426)
at com.sygate.scm.server.db.util.SqlDbHelper.generateFormatFile(SqlDbHelper.java:328)
at com.sygate.scm.server.db.util.SqlDbHelper.bulkRestore(SqlDbHelper.java:248)
at com.sygate.scm.server.db.util.SqlDbHelper.bulkRestoreReplication(SqlDbHelper.java:303)
at com.sygate.scm.server.replication.table.TableMergerReplicator.restoreData(TableMergerReplicator.java:790)
at com.sygate.scm.server.replication.table.TableMergerReplicator.tableMerger(TableMergerReplicator.java:220)
at com.sygate.scm.server.replication.table.TableMergerReplicator.replicateTable(TableMergerReplicator.java:129)
at com.sygate.scm.server.replication.ReplicationTask.replicateClientTables_opt(ReplicationTask.java:1153)
at com.sygate.scm.server.replication.ReplicationTask.processReplicationData(ReplicationTask.java:3270)
at com.sygate.scm.server.replication.ReplicationTask.replicate(ReplicationTask.java:1310)
at com.sygate.scm.server.replication.ReplicationTask.execute(ReplicationTask.java:504)
at com.sygate.scm.server.task.MonitoredTimerTask.run(MonitoredTimerTask.java:41)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
<timestamp> THREAD 278 WARNING: ReplicationTask>> replicate: Unable to fetch changed data from remote site [Site XYZ]: Failed to load data. If packet size is not too large, please modify it by scm.bcp.packet.size. Detailed message
: SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-file
BCP is not able to handle the data size that the manager is replicating and the size limitations needs to be increased.
Increase the BCP packet size in the conf.properties file located on the replicating Symantec Endpoint Protection Manager.