2598782 - ERROR #1028 - Message from server: Message: 207 when bulk loading data at primary with a batch size of 10+ - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2598782 - ERROR #1028 - Message from server: Message: 207 when bulk loading data at primary with a batch size of 10+ - SRS

Symptom

BCP Test
bcp database..table out table.bcp -Sservername -U<username> -P<password> -c -Jcp850
delete from table

-- Test the 'BCP in' with batch size of 5. This works and data is replicated through to the replicate database
bcp database..table in table.bcp -Sservername -U<username> -P<password> -c -Jcp850 -b5

-- Test the 'BCP in' with batch size of 10. This puts the data into teh primary database but does not reach the replicate DB
bcp database..table in table.bcp -Sservername -U<username> -P<password> -c -Jcp850 -b10

connection is down
Replication errorlog shows the following:
ERROR #1028 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Message from server: Message: 195, State 0, Severity 15 -- '[[Message Iteration=1|Data Source Name=EDCA_AZURE_UAT|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'char_convert' is not a recognized SET option.]'.
ERROR #1028 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Message from server: Message: 207, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=EDCA_AZURE_UAT|SQLState=42S22|Native Error=207|Message=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'sysstat2'.[Message Iteration=2|SQLSt.
Open Client Client-Library error: Error: 16973838, Severity 0 -- 'blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.'.
ERROR #1027 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Open Client Client-Library error: Error: -99999, Severity 5 -- 'Failed to initialize bulk 'in' processing for table [table.]. blk_init failed'.
ERROR #5215 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(502)
The interface function 'RCIPrepare' returns FAIL for database 'RDS.rdb'. The errors are retryable. The DSI thread will restart automatically. See messages from the interface function for more information.


Read more...

Environment

SAP Replication Server (SRS) 15.7.1

Product

SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

ERROR #1028 Message 207 bulk loading data primary batch size bcp Invalid column name , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.