Endpoint Protection Manager replication fails with error "Unable to open BCP host data-file"

Products

• Endpoint Protection

Issue/Introduction

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

Environment

• Windows 2012 R2
• SQL databases located on remote servers

Cause

BCP is not able to handle the data size that the manager is replicating and the size limitations needs to be increased.

Resolution

Increase the BCP packet size in the conf.properties file located on the replicating Symantec Endpoint Protection Manager.

1. Open conf.properties located in C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\etc
2. Add the line: scm.bcp.packet.size=65535
3. Add the line: scm.replication.tablemergerbatch.enabled=0
4. Save the file.
5. Restart the Symantec Endpoint Protection Manager services.
6. Manually initiate a replication.