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

book

Article ID: 170981

calendar_today

Updated On:

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

Cause

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

Environment

  • Windows 2012 R2
  • SQL databases located on remote servers

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.